metadata: contig_metadata: 10 rows where analysis = "blastn" and tax

10 rows where analysis = "blastn" and tax_clade = "Jingmenvirus group"

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_species
1806028	1806028	PRJNA556992_P_NODE_574322_length_261_cov_1.617021_g572133_i0	PRJNA556992	574322	261	1.617021	4.22042481	Wuhan aphid virus 1	1746067	Viruses	Viruses	215	2.87e-51	NTclustered	gi\|1946667006\|gb\|MW023850.1\|	1746067	g572133	i0	83.7	0.869731800766284	227	37	87	0	4	230	2096	1870	Wuhan aphid virus 1 strain STN1WV1 putative capsid protein and hypothetical protein genes, complete cds	blastn	227	215	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 1
5488160	5488160	PRJNA315399_S_NODE_148265_length_161_cov_4.524194_g148064_i0	PRJNA315399	148265	161	4.524194	7.28395234	Wuhan aphid virus 2	1746068	Viruses	Viruses	159	7.66e-35	NTclustered	gi\|2444492076\|gb\|OP797725.1\|	1746068	g148064	i0	87.591	0.850931677018634	137	17	85	0	25	161	4	140	Wuhan aphid virus 2 isolate 12842-WAV2S4 segment 4 hypothetical protein (VP3) gene, partial cds	blastn	137	159	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 2
5614606	5614606	PRJNA546018_S_NODE_22505_length_338_cov_6.541516_g22180_i0	PRJNA546018	22505	338	6.541516	22.11032408	Wuhan aphid virus 1	1746067	Viruses	Viruses	313	1.33e-80	NTclustered	gi\|943496544\|gb\|KR902723.1\|	1746067	g22180	i0	84.543	1.87573964497041	317	47	93	2	1	316	1507	1192	Wuhan aphid virus 1 strain WHYC-1 segment 3, complete sequence	blastn	634	313	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 1
9542013	9542013	PRJNA641707_P_NODE_219588_length_193_cov_7.534722_g216925_i0	PRJNA641707	219588	193	7.534722	14.54201346	Wuhan aphid virus 1	1746067	Viruses	Viruses	159	9.529999999999999e-35	NTclustered	gi\|1817956133\|dbj\|LC516840.1\|	1746067	g216925	i0	95.05	0.523316062176166	101	5	52	0	1	101	132	32	Wuhan aphid virus 1 06BaA3 genomic RNA, segment 2, partial sequence	blastn	101	159	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 1
17504969	17504969	PRJNA946307_P_NODE_171034_length_155_cov_2.641509_g170160_i0	PRJNA946307	171034	155	2.641509	4.09433895	Wuhan aphid virus 2	1746068	Viruses	Viruses	176	7.25e-40	NTclustered	gi\|952002246\|ref\|NC_028387.1\|	1746068	g170160	i0	89.286	3.61290322580645	140	15	90	0	2	141	1543	1404	Wuhan aphid virus 2 strain WHYC-2 segment 4, complete sequence	blastn	560	176	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 2
22061103	22061103	PRJNA315399_S_NODE_164678_length_157_cov_3.133333_g164477_i0	PRJNA315399	164678	157	3.133333	4.91933281	Wuhan aphid virus 2	1746068	Viruses	Viruses	187	3.3999999999999993e-43	NTclustered	gi\|943496531\|gb\|KR902726.1\|	1746068	g164477	i0	88.462	1.98726114649682	156	16	99	2	2	156	972	818	Wuhan aphid virus 2 strain WHYC-2 segment 2, complete sequence	blastn	312	187	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 2
24592088	24592088	PRJNA188516_P_NODE_5540_length_164_cov_0.904348_g5490_i0	PRJNA188516	5540	164	0.904348	1.48313072	Wuhan aphid virus 1	1746067	Viruses	Viruses	193	7.73e-45	NTclustered	gi\|952002240\|ref\|NC_028385.1\|	1746067	g5490	i0	96.552	1.41463414634146	116	4	71	0	1	116	1	116	Wuhan aphid virus 1 strain WHYC-1 segment 4, complete sequence	blastn	232	193	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 1
24736975	24736975	PRJNA546018_S_NODE_35060_length_262_cov_2.099502_g34735_i0	PRJNA546018	35060	262	2.099502	5.50069524	Wuhan aphid virus 1	1746067	Viruses	Viruses	272	1.69e-68	NTclustered	gi\|1817956135\|dbj\|LC516841.1\|	1746067	g34735	i0	87.654	2.75954198473282	243	19	90	8	24	258	2314	2553	Wuhan aphid virus 1 06BaA3 gene for non-structural protein 2, complete cds	blastn	723	272	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 1
24761375	24761375	PRJNA556992_P_NODE_957480_length_235_cov_2.401235_g955290_i0	PRJNA556992	957480	235	2.401235	5.64290225	Wuhan aphid virus 1	1746067	Viruses	Viruses	291	4.1e-74	NTclustered	gi\|1817956135\|dbj\|LC516841.1\|	1746067	g955290	i0	88.983	2.99574468085106	236	24	100	2	1	235	674	440	Wuhan aphid virus 1 06BaA3 gene for non-structural protein 2, complete cds	blastn	704	291	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 1
24841122	24841122	PRJNA641707_P_NODE_274620_length_172_cov_6.487805_g271957_i0	PRJNA641707	274620	172	6.487805	11.1590246	Wuhan aphid virus 2	1746068	Viruses	Viruses	241	2.87e-59	NTclustered	gi\|952002246\|ref\|NC_028387.1\|	1746068	g271957	i0	92.771	2.88372093023256	166	12	97	0	1	166	2348	2513	Wuhan aphid virus 2 strain WHYC-2 segment 4, complete sequence	blastn	496	241	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Wuhan aphid virus 2

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