metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1248471" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1248471" 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
26648338	26648338	PRJNA1248471_S_NODE_20441_length_164_cov_0.886957_g20341_i0	PRJNA1248471	20441	164	0.886957	1.45460948	Lepidoptera	7088	Arthropoda	Arthropoda	54.7	2.11e-8	NR	ABK29471.1	29058	g20341	i0	67.6	3.38414634146341	37	12	67.7	0	23	133	7	43	ABK29471.1 CHK1 checkpoint-like protein, partial [Helicoverpa armigera]	diamond	555	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa armigera
27263360	27263360	PRJNA1248471_S_NODE_16443_length_174_cov_0.824000_g16343_i0	PRJNA1248471	16443	174	0.824	1.43376	Nephila pilipes	299642	Arthropoda	Arthropoda	53.5	5.07e-7	NR	GFS75278.1	299642	g16343	i0	53.6	0.96551724137931	56	24	96.6	1	2	169	86	139	GFS75278.1 hypothetical protein NPIL_163541 [Nephila pilipes]	diamond	168	53.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Nephila	Nephila pilipes
27674053	27674053	PRJNA1248471_S_NODE_17544_length_170_cov_1.264463_g17444_i0	PRJNA1248471	17544	170	1.264463	2.1495871	Trichonephila clavipes	2585209	Arthropoda	Arthropoda	50.1	3.64e-5	NR	GFV75940.1	2585209	g17444	i0	42.6	4.97647058823529	47	26	82.9	1	141	1	126	171	GFV75940.1 retrovirus-related Pol polyprotein from transposon TNT 1-94 [Trichonephila clavipes]	diamond	846	50.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavipes
27723874	27723874	PRJNA1248471_S_NODE_17304_length_171_cov_1.008197_g17204_i0	PRJNA1248471	17304	171	1.008197	1.72401687	Aphididae	27482	Arthropoda	Arthropoda	52.8	4.02e-6	NR	VVC42870.1	506608	g17204	i0	67.6	1.78947368421053	34	11	59.6	0	68	169	383	416	VVC42870.1 Hypothetical protein CINCED_3A024611 [Cinara cedri]	diamond	306	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Cinara	Cinara cedri
27737319	27737319	PRJNA1248471_S_NODE_14124_length_184_cov_0.711111_g14024_i0	PRJNA1248471	14124	184	0.711111	1.30844424	Aphis glycines	307491	Arthropoda	Arthropoda	58.5	3.31e-8	NR	KAE9522218.1	307491	g14024	i0	65.9	0.717391304347826	44	15	71.7	0	52	183	202	245	KAE9522218.1 hypothetical protein AGLY_017384 [Aphis glycines]	diamond	132	58.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis glycines
28368381	28368381	PRJNA1248471_S_NODE_13446_length_187_cov_1.963768_g13346_i0	PRJNA1248471	13446	187	1.963768	3.67224616	Thrips palmi	161013	Arthropoda	Arthropoda	123	7.35e-32	NR	XP_034233573.1	161013	g13346	i0	91.9	0.994652406417112	62	5	99.5	0	186	1	100	161	XP_034233573.1 28S ribosomal protein S9, mitochondrial [Thrips palmi]	diamond	186	123	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi
28621237	28621237	PRJNA1248471_S_NODE_7227_length_225_cov_0.619318_g7127_i0	PRJNA1248471	7227	225	0.619318	1.3934655	Nephila pilipes	299642	Arthropoda	Arthropoda	71.2	1.27e-13	NR	GFS75278.1	299642	g7127	i0	60.7	0.746666666666667	56	22	74.7	0	6	173	65	120	GFS75278.1 hypothetical protein NPIL_163541 [Nephila pilipes]	diamond	168	71.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Nephila	Nephila pilipes
29189575	29189575	PRJNA1248471_S_NODE_22749_length_161_cov_0.687500_g22649_i0	PRJNA1248471	22749	161	0.6875	1.106875	Nephila pilipes	299642	Arthropoda	Arthropoda	47	1.44e-4	NR	GFS75278.1	299642	g22649	i0	61.1	0.670807453416149	36	14	67.1	0	2	109	86	121	GFS75278.1 hypothetical protein NPIL_163541 [Nephila pilipes]	diamond	108	47	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Nephila	Nephila pilipes
30389996	30389996	PRJNA1248471_S_NODE_17013_length_172_cov_0.853659_g16913_i0	PRJNA1248471	17013	172	0.853659	1.46829348	Oedothorax gibbosus	931172	Arthropoda	Arthropoda	44.3	4.73e-4	NR	KAG8170973.1	931172	g16913	i0	53.8	0.680232558139535	39	11	55.8	1	98	3	11	49	KAG8170973.1 hypothetical protein JTE90_002692 [Oedothorax gibbosus]	diamond	117	44.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Linyphiidae	Oedothorax	Oedothorax gibbosus
30831850	30831850	PRJNA1248471_S_NODE_19794_length_165_cov_0.862069_g19694_i0	PRJNA1248471	19794	165	0.862069	1.42241385	Zele chlorophthalmus	1080924	Arthropoda	Arthropoda	53.9	1.42e-6	NR	YP_009512897.1	1080924	g19694	i0	70	20.3636363636364	40	11	72.7	1	163	44	272	310	YP_009512897.1 cytochrome b [Zele chlorophthalmus]	diamond	3360	53.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Zele	Zele chlorophthalmus
32381624	32381624	PRJNA1248471_S_NODE_19859_length_165_cov_0.758621_g19759_i0	PRJNA1248471	19859	165	0.758621	1.25172465	Oedothorax gibbosus	931172	Arthropoda	Arthropoda	42	0.0064	NR	KAG8155936.1	931172	g19759	i0	89.5	0.345454545454545	19	2	34.5	0	64	8	8	26	KAG8155936.1 hypothetical protein JTE90_009672 [Oedothorax gibbosus]	diamond	57	42	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Linyphiidae	Oedothorax	Oedothorax gibbosus
32476637	32476637	PRJNA1248471_S_NODE_3399_length_292_cov_1.559671_g3299_i0	PRJNA1248471	3399	292	1.559671	4.55423932	Thrips setosus	163897	Arthropoda	Arthropoda	62.8	8.89e-10	NR	UEP15873.1	163897	g3299	i0	75.6	0.924657534246575	45	11	46.2	0	156	290	54	98	UEP15873.1 NADH dehydrogenase subunit 6 [Thrips setosus]	diamond	270	62.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips setosus

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);;