metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax_phylum = "Arthropoda"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26694318	26694318	PRJNA312107_P_NODE_17261_length_176_cov_0.937008_g17095_i0	PRJNA312107	17261	176	0.937008	1.64913408	Meganyctiphanes norvegica	48144	Arthropoda	Arthropoda	53.1	2.78e-6	NR	CAL4240656.1	48144	g17095	i0	59.1	1.60227272727273	44	18	75	0	173	42	3	46	CAL4240656.1 unnamed protein product, partial [Meganyctiphanes norvegica]	diamond	282	53.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Euphausiacea	Euphausiidae	Meganyctiphanes	Meganyctiphanes norvegica
27105683	27105683	PRJNA312107_P_NODE_18842_length_169_cov_0.866667_g18676_i0	PRJNA312107	18842	169	0.866667	1.46466723	Diaphorina citri	121845	Arthropoda	Arthropoda	41.6	0.036	NR	KAI5702344.1	121845	g18676	i0	48.6	5.59171597633136	35	18	62.1	0	108	4	53	87	KAI5702344.1 hypothetical protein M8J77_016943 [Diaphorina citri]	diamond	945	41.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Psyllidae	Diaphorina	Diaphorina citri
27958655	27958655	PRJNA312107_P_NODE_9485_length_233_cov_1.103261_g9319_i0	PRJNA312107	9485	233	1.103261	2.57059813	Portunus trituberculatus	210409	Arthropoda	Arthropoda	43.1	0.0197	NR	MPC69193.1	210409	g9319	i0	37.8	0.579399141630901	45	27	57.9	1	32	166	135	178	MPC69193.1 hypothetical protein [Portunus trituberculatus]	diamond	135	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Portunus	Portunus trituberculatus
30105730	30105730	PRJNA312107_P_NODE_20932_length_167_cov_0.881356_g20766_i0	PRJNA312107	20932	167	0.881356	1.47186452	Trichonephila clavipes	2585209	Arthropoda	Arthropoda	40	0.0294	NR	GFX02599.1	2585209	g20766	i0	70.8	0.431137724550898	24	7	43.1	0	47	118	15	38	GFX02599.1 hypothetical protein TNCV_728531 [Trichonephila clavipes]	diamond	72	40	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavipes
30295849	30295849	PRJNA312107_P_NODE_7992_length_253_cov_1.470588_g7826_i0	PRJNA312107	7992	253	1.470588	3.72058764	Daphnia magna	35525	Arthropoda	Arthropoda	40.4	0.0427	NR	KZR97555.1	35525	g7826	i0	73.9	0.272727272727273	23	6	27.3	0	190	122	2	24	KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna]	diamond	69	40.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna
30359125	30359125	PRJNA312107_P_NODE_26352_length_161_cov_3.285714_g26186_i0	PRJNA312107	26352	161	3.285714	5.28999954	Artemia franciscana	6661	Arthropoda	Arthropoda	115	4.089999999999999e-31	NR	KAK2708759.1	6661	g26186	i0	94.3	3.95031055900621	53	3	98.8	0	161	3	32	84	KAK2708759.1 hypothetical protein QYM36_014385 [Artemia franciscana]	diamond	636	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
30471159	30471159	PRJNA312107_P_NODE_18013_length_171_cov_5.762295_g17847_i0	PRJNA312107	18013	171	5.762295	9.85352445	root	1	Root_unresolved	Root_unresolved	57.8	7.19e-8	NR	EFX83242.1	6669	g17847	i0	74.4	157.368421052632	39	10	68.4	0	171	55	588	626	EFX83242.1 hypothetical protein DAPPUDRAFT_315683 [Daphnia pulex]	diamond	26910	58.2	0.993127147766323	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
32002505	32002505	PRJNA312107_P_NODE_23558_length_164_cov_0.904348_g23392_i0	PRJNA312107	23558	164	0.904348	1.48313072	Clunio marinus	568069	Arthropoda	Arthropoda	82.8	9.62e-17	NR	CRK99937.1	568069	g23392	i0	81.8	1.00609756097561	55	9	98.8	1	162	1	486	540	CRK99937.1 CLUMA_CG013236, isoform A [Clunio marinus]	diamond	165	82.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Clunio	Clunio marinus
32572210	32572210	PRJNA312107_P_NODE_20159_length_168_cov_0.873950_g19993_i0	PRJNA312107	20159	168	0.87395	1.468236	Caerostris darwini	1538125	Arthropoda	Arthropoda	40.4	0.0424	NR	GIY08290.1	1538125	g19993	i0	64	0.446428571428571	25	9	44.6	0	3	77	49	73	GIY08290.1 hypothetical protein CDAR_293221 [Caerostris darwini]	diamond	75	40.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Caerostris	Caerostris darwini

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;