metadata: contig_metadata: 10 rows where bioproject = "PRJNA855894" and tax

10 rows where bioproject = "PRJNA855894" 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
5945580	5945580	PRJNA855894_P_NODE_34025_length_242_cov_0.911243_g33903_i0	PRJNA855894	34025	242	0.911243	2.20520806	Plutella xylostella	51655	Arthropoda	Arthropoda	399	6.759999999999999e-107	NTclustered	gi\|822092743\|ref\|NM_001309062.1\|	51655	g33903	i0	96.68	2.86363636363636	241	7	99	1	1	240	256	496	Plutella xylostella ejaculatory bulb-specific protein 3-like (LOC105393171), mRNA	blastn	693	399	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Plutellidae	Plutella	Plutella xylostella
13988821	13988821	PRJNA855894_P_NODE_27011_length_271_cov_1.984848_g26889_i0	PRJNA855894	27011	271	1.984848	5.37893808	Bemisia	7037	Arthropoda	Arthropoda	501	2.05e-137	NTclustered	gi\|1254338572\|gb\|KY951450.1\|	7038	g26889	i0	100	93.2509225092251	271	0	100	0	1	271	10263	9993	Bemisia tabaci mitochondrion, complete genome	blastn	25271	501	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
14869902	14869902	PRJNA855894_P_NODE_17832_length_360_cov_1.222997_g17710_i0	PRJNA855894	17832	360	1.222997	4.4027892	Eriocheir sinensis	95602	Arthropoda	Arthropoda	619	7.459999999999999e-173	NTclustered	gi\|2312034374\|ref\|XM_050847165.1\|	95602	g17710	i0	97.778	14.7638888888889	360	7	100	1	1	360	2175	1817	PREDICTED: Eriocheir sinensis pseudohemocyanin-2-like (LOC126988766), transcript variant X2, mRNA	blastn	5315	619	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis
14870197	14870197	PRJNA855894_P_NODE_29872_length_251_cov_0.865169_g29750_i0	PRJNA855894	29872	251	0.865169	2.17157419	Bemisia tabaci	7038	Arthropoda	Arthropoda	464	2.47e-126	NTclustered	gi\|1101399012\|ref\|XM_019054985.1\|	7038	g29750	i0	100	1	251	0	100	0	1	251	1362	1612	PREDICTED: Bemisia tabaci lipase maturation factor 2-like (LOC109039494), mRNA	blastn	251	464	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
17420454	17420454	PRJNA855894_P_NODE_30234_length_250_cov_0.870056_g30112_i0	PRJNA855894	30234	250	0.870056	2.17514	Bemisia tabaci	7038	Arthropoda	Arthropoda	462	8.83e-126	NTclustered	gi\|1101400773\|ref\|XM_019055935.1\|	7038	g30112	i0	100	1	250	0	100	0	1	250	1716	1467	PREDICTED: Bemisia tabaci cuticle protein 7-like (LOC109040124), mRNA	blastn	250	462	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
19968767	19968767	PRJNA855894_P_NODE_29176_length_253_cov_1.388889_g29054_i0	PRJNA855894	29176	253	1.388889	3.51388917	Bemisia tabaci	7038	Arthropoda	Arthropoda	466	6.9199999999999996e-127	NTclustered	gi\|1101344275\|ref\|XM_019042300.1\|	7038	g29054	i0	100	1.99209486166008	252	0	99	0	1	252	415	666	PREDICTED: Bemisia tabaci metaxin-2-like (LOC109031031), transcript variant X1, mRNA	blastn	504	466	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
22912462	22912462	PRJNA855894_P_NODE_11558_length_461_cov_1.948454_g11436_i0	PRJNA855894	11558	461	1.948454	8.98237294	root	1	Root_unresolved	Root_unresolved	763	0	NTclustered	gi\|83281396\|gb\|AC167967.6\|	7176	g11436	i0	96.529	165.63557483731	461	16	100	0	1	461	496	956	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence	blastn	76358	769	0.992197659297789	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
24186575	24186575	PRJNA855894_P_NODE_28539_length_258_cov_1.308108_g28417_i0	PRJNA855894	28539	258	1.308108	3.37491864	Bemisia	7037	Arthropoda	Arthropoda	477	3.2699999999999985e-130	NTclustered	gi\|1254338572\|gb\|KY951450.1\|	7038	g28417	i0	100	92.437984496124	258	0	100	0	1	258	9904	9647	Bemisia tabaci mitochondrion, complete genome	blastn	23849	477	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
27970995	27970995	PRJNA855894_P_NODE_33725_length_243_cov_0.905882_g33603_i0	PRJNA855894	33725	243	0.905882	2.20129326	Bemisia tabaci	7038	Arthropoda	Arthropoda	44.7	0.00291	NR	CAH0392752.1	7038	g33603	i0	69	0.358024691358025	29	9	35.8	0	132	218	108	136	CAH0392752.1 unnamed protein product [Bemisia tabaci]	diamond	87	44.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
31097557	31097557	PRJNA855894_P_NODE_27235_length_270_cov_1.050761_g27113_i0	PRJNA855894	27235	270	1.050761	2.8370547	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	115	1.03e-27	NR	KAH9409313.1	59818	g27113	i0	93.7	0.877777777777778	79	5	87.8	0	237	1	1	79	KAH9409313.1 26S protease regulatory subunit 7 [Tyrophagus putrescentiae]	diamond	237	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae

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