metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA811725" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA811725" 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
1223777	1223777	PRJNA811725_P_NODE_13981_length_401_cov_461.048780_g240_i5	PRJNA811725	13981	401	461.04878	1848.8056078	root	1	Root_unresolved	Root_unresolved	706	0	NTclustered	gi\|83281396\|gb\|AC167967.6\|	7176	g240	i5	100	154.950124688279	382	0	95	0	20	401	468	87	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence	blastn	62135	706	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
2085601	2085601	PRJNA811725_P_NODE_20822_length_332_cov_1.783784_g20576_i0	PRJNA811725	20822	332	1.783784	5.92216288	Cimex lectularius	79782	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|498915507\|emb\|HF969883.1\|	79782	g20576	i0	96.97	4.78915662650602	33	1	10	0	1	33	340	308	Cimex lectularius microsatellite DNA locus Cle020, clone K01AXFGR	blastn	1590	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cimicidae	Cimex	Cimex lectularius
2085801	2085801	PRJNA811725_P_NODE_40502_length_243_cov_1.358824_g40256_i0	PRJNA811725	40502	243	1.358824	3.30194232	Cimex lectularius	79782	Arthropoda	Arthropoda	65.8	2.81e-6	NTclustered	gi\|498915507\|emb\|HF969883.1\|	79782	g40256	i0	100	8.32510288065844	35	0	14	0	209	243	306	340	Cimex lectularius microsatellite DNA locus Cle020, clone K01AXFGR	blastn	2023	65.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cimicidae	Cimex	Cimex lectularius
2499453	2499453	PRJNA811725_P_NODE_26222_length_299_cov_3.938053_g25976_i0	PRJNA811725	26222	299	3.938053	11.77477847	root	1	Root_unresolved	Root_unresolved	473	5.0099999999999997e-129	NTclustered	gi\|91176468\|gb\|AC167662.6\|	7176	g25976	i0	94.62	28.4816053511706	316	0	100	1	1	299	88604	88919	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940141D9, complete sequence	blastn	8516	473	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
5913429	5913429	PRJNA811725_P_NODE_34485_length_260_cov_1.705882_g34239_i0	PRJNA811725	34485	260	1.705882	4.4352932	Culex quinquefasciatus	7176	Arthropoda	Arthropoda	442	1.1999999999999999e-119	NTclustered	gi\|91176468\|gb\|AC167662.6\|	7176	g34239	i0	97.318	33.3	261	5	100	2	1	260	6868	6609	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940141D9, complete sequence	blastn	8658	442	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
8463032	8463032	PRJNA811725_P_NODE_33907_length_264_cov_1.502618_g33661_i0	PRJNA811725	33907	264	1.502618	3.96691152	Cimex lectularius	79782	Arthropoda	Arthropoda	58.4	5.18e-4	NTclustered	gi\|498915507\|emb\|HF969883.1\|	79782	g33661	i0	100	7.91666666666667	31	0	12	0	234	264	310	340	Cimex lectularius microsatellite DNA locus Cle020, clone K01AXFGR	blastn	2090	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cimicidae	Cimex	Cimex lectularius
11013849	11013849	PRJNA811725_P_NODE_23309_length_313_cov_2.212500_g23063_i0	PRJNA811725	23309	313	2.2125	6.925125	Cimex lectularius	79782	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|498915507\|emb\|HF969883.1\|	79782	g23063	i0	100	6.42172523961661	30	0	10	0	284	313	311	340	Cimex lectularius microsatellite DNA locus Cle020, clone K01AXFGR	blastn	2010	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cimicidae	Cimex	Cimex lectularius
13563596	13563596	PRJNA811725_P_NODE_28491_length_290_cov_1.419355_g28245_i0	PRJNA811725	28491	290	1.419355	4.1161295	Timema monikensis	170555	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|1946403072\|emb\|OB793013.1\|	170555	g28245	i0	100	0.096551724137931	28	0	10	0	251	278	69520	69547	3_Tms_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema monikensis
19936571	19936571	PRJNA811725_P_NODE_18416_length_353_cov_2.700000_g18170_i0	PRJNA811725	18416	353	2.7	9.531	Pyemotes zhonghuajia	2749944	Arthropoda	Arthropoda	108	7.02e-19	NTclustered	gi\|2260370515\|gb\|OM396909.2\|	2749944	g18170	i0	78.01	1.08215297450425	191	29	52	10	167	350	722	906	Pyemotes zhonghuajia chromosome A mitochondrion, complete sequence	blastn	382	108	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Pyemotidae	Pyemotes	Pyemotes zhonghuajia
21212013	21212013	PRJNA811725_P_NODE_14377_length_396_cov_2.046440_g14132_i0	PRJNA811725	14377	396	2.04644	8.1039024	Demodex folliculorum	481310	Arthropoda	Arthropoda	689	0	NTclustered	gi\|360047396\|gb\|HQ728004.1\|	481310	g14132	i0	99.472	42.4166666666667	379	2	96	0	18	396	1182	804	Demodex folliculorum isolate 3-S6-Df2 28S ribosomal RNA gene, partial sequence	blastn	16797	689	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex folliculorum
21212132	21212132	PRJNA811725_P_NODE_29457_length_286_cov_3.009390_g29211_i0	PRJNA811725	29457	286	3.00939	8.6068554	Metopolophium dirhodum	44670	Arthropoda	Arthropoda	147	1.18e-30	NTclustered	gi\|2621231836\|ref\|XR_009664134.1\|	44670	g29211	i0	80.258	0.814685314685315	233	15	80	11	1	229	2419	2214	PREDICTED: Metopolophium dirhodum UDP-glucose 4-epimerase-like (LOC132941129), transcript variant X2, misc_RNA	blastn	233	147	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Metopolophium	Metopolophium dirhodum

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