metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA800053" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA800053" and tax_phylum = "Cressdnaviricota"

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
796239	796239	PRJNA800053_P_NODE_3361_length_481_cov_2.764706_g3198_i0	PRJNA800053	3361	481	2.764706	13.29823586	Galvornvirus isengard	2955925	Viruses	Viruses	372	3.17e-98	NTclustered	gi\|2302008592\|gb\|MT202085.1\|	1954248	g3198	i0	81.928	1.03534303534304	498	37	97	22	4	471	972	1446	MAG: Circoviridae sp. isolate CN23_L15_1845, complete genome	blastn	498	372	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
2071917	2071917	PRJNA800053_P_NODE_10202_length_305_cov_3.530172_g10038_i0	PRJNA800053	10202	305	3.530172	10.7670246	Galvornvirus isengard	2955925	Viruses	Viruses	235	2.6299999999999996e-57	NTclustered	gi\|2302021005\|gb\|MT208525.1\|	1954248	g10038	i0	87.379	0.770491803278688	206	25	67	1	100	304	71	276	MAG: Circoviridae sp. isolate CN23_L19_1107, complete genome	blastn	235	235	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
2072044	2072044	PRJNA800053_P_NODE_2802_length_518_cov_6.532584_g2642_i0	PRJNA800053	2802	518	6.532584	33.83878512	Tick-associated circular virus-2	2951484	Viruses	Viruses	952	0	NTclustered	gi\|2263979286\|gb\|ON456885.1\|	2951484	g2642	i0	100	0.994208494208494	515	0	99	0	1	515	1209	1723	Tick-associated circular virus-2 isolate Tick114CressC5, complete genome	blastn	515	952	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-2
2495470	2495470	PRJNA800053_P_NODE_5042_length_404_cov_5.187311_g4879_i0	PRJNA800053	5042	404	5.187311	20.95673644	Circovirus	39725	Viruses	Viruses	728	0	NTclustered	gi\|2099633452\|gb\|MZ556231.1\|	2863961	g4879	i0	99.5	3.94306930693069	400	2	99	0	2	401	751	1150	Sichuan mosquito circovirus 3 isolate mos092cirl02-10 genomic sequence	blastn	1593	728	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Sichuan mosquito circovirus 3
3347292	3347292	PRJNA800053_P_NODE_6683_length_361_cov_6.413194_g6519_i0	PRJNA800053	6683	361	6.413194	23.15163034	Tick-associated circular virus-5	2951487	Viruses	Viruses	658	0	NTclustered	gi\|2263979295\|gb\|ON456888.1\|	2951487	g6519	i0	100	0.986149584487535	356	0	99	0	3	358	2509	2154	Tick-associated circular virus-5 isolate Tick114CressC10, complete genome	blastn	356	658	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-5
4624694	4624694	PRJNA800053_P_NODE_3824_length_455_cov_3.586387_g3661_i0	PRJNA800053	3824	455	3.586387	16.31806085	Sichuan tick-associated circovirus 3	2951470	Viruses	Viruses	717	0	NTclustered	gi\|2263979276\|gb\|ON456881.1\|	2951470	g3661	i0	98.522	1.94065934065934	406	6	99	0	4	409	2574	2979	Sichuan tick-associated circovirus 3 isolate Tick101/112Circo, complete genome	blastn	883	717	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Sichuan tick-associated circovirus 3
4624723	4624723	PRJNA800053_P_NODE_9044_length_320_cov_1.554656_g8880_i0	PRJNA800053	9044	320	1.554656	4.9748992	Galvornvirus isengard	2955925	Viruses	Viruses	361	4.389999999999999e-95	NTclustered	gi\|2302005424\|gb\|MT201198.1\|	1954248	g8880	i0	90.036	0.878125	281	25	87	3	1	279	4749	4470	MAG: Circoviridae sp. isolate CN3_L09_45, complete genome	blastn	281	361	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
5899756	5899756	PRJNA800053_P_NODE_19105_length_248_cov_1.400000_g18941_i0	PRJNA800053	19105	248	1.4	3.472	Tick-associated circular virus-5	2951487	Viruses	Viruses	453	5.2600000000000005e-123	NTclustered	gi\|2263979295\|gb\|ON456888.1\|	2951487	g18941	i0	100	0.987903225806452	245	0	99	0	2	246	285	41	Tick-associated circular virus-5 isolate Tick114CressC10, complete genome	blastn	245	453	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-5
5899819	5899819	PRJNA800053_P_NODE_5045_length_404_cov_3.794562_g4882_i0	PRJNA800053	5045	404	3.794562	15.33003048	Reagent-associated CRESS-like virus 6	2875814	Viruses	Viruses	741	0	NTclustered	gi\|2094552983\|gb\|MZ824232.1\|	2875814	g4882	i0	100	0.992574257425743	401	0	99	0	1	401	2001	2401	Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence	blastn	401	741	1	Viruses		Shotokuvirae	Cressdnaviricota					Reagent-associated CRESS-like virus 6
5899822	5899822	PRJNA800053_P_NODE_545_length_1020_cov_10.451954_g440_i0	PRJNA800053	545	1020	10.451954	106.6099308	Ninurtavirus floridaense	3431122	Viruses	Viruses	466	3.12e-126	NTclustered	gi\|254688530\|ref\|NC_013027.1\|	642255	g440	i0	77.494	4.17745098039216	822	155	79	26	64	871	952	147	Circovirus-like genome RW-E, complete genome	blastn	4261	466	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Saturnivirales	Kanorauviridae	Ninurtavirus	Ninurtavirus floridaense
8449334	8449334	PRJNA800053_P_NODE_47_length_2236_cov_19.012945_g35_i0	PRJNA800053	47	2236	19.012945	425.1294502	Sichuan mosquito circovirus 3	2863961	Viruses	Viruses	1986	0	NTclustered	gi\|2717470348\|gb\|PP272780.1\|	2863961	g35	i0	99.184	1.82647584973166	1103	7	49	2	186	1288	1101	1	MAG: Sichuan mosquito circovirus 3 isolate circo_1 replication-associated protein gene, partial cds	blastn	4084	1986	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Sichuan mosquito circovirus 3
8449343	8449343	PRJNA800053_P_NODE_5867_length_380_cov_2.729642_g5704_i0	PRJNA800053	5867	380	2.729642	10.3726396	Cirlivirales sp.	2809008	Viruses	Viruses	564	3.7599999999999996e-156	NTclustered	gi\|2906144154\|gb\|PQ646098.1\|	2809008	g5704	i0	93.651	1.18684210526316	378	23	99	1	1	377	593	970	MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence	blastn	451	564	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales			Cirlivirales sp.
11000062	11000062	PRJNA800053_P_NODE_16009_length_259_cov_1.344086_g15845_i0	PRJNA800053	16009	259	1.344086	3.48118274	Cressdnaviricota sp.	2748378	Viruses	Viruses	309	1.2700000000000002e-79	NTclustered	gi\|1436208475\|gb\|MH617186.1\|	2748378	g15845	i0	88.417	1.97683397683398	259	26	99	4	1	257	826	570	MAG: Cressdnaviricota sp. isolate ctfh008, complete genome	blastn	512	309	1	Viruses		Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
11000178	11000178	PRJNA800053_P_NODE_8809_length_323_cov_5.304000_g8645_i0	PRJNA800053	8809	323	5.304	17.13192	Sichuan tick-associated circovirus 3	2951470	Viruses	Viruses	593	4.0199999999999986e-165	NTclustered	gi\|2263979276\|gb\|ON456881.1\|	2951470	g8645	i0	100	1.08978328173375	321	0	99	0	1	321	411	91	Sichuan tick-associated circovirus 3 isolate Tick101/112Circo, complete genome	blastn	352	593	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Sichuan tick-associated circovirus 3
11000181	11000181	PRJNA800053_P_NODE_9289_length_316_cov_5.037037_g9125_i0	PRJNA800053	9289	316	5.037037	15.91703692	Tick-associated circular virus-5	2951487	Viruses	Viruses	573	5.109999999999998e-159	NTclustered	gi\|2263979295\|gb\|ON456888.1\|	2951487	g9125	i0	99.681	0.990506329113924	313	1	99	0	1	313	1877	1565	Tick-associated circular virus-5 isolate Tick114CressC10, complete genome	blastn	313	573	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-5
13549856	13549856	PRJNA800053_P_NODE_25151_length_210_cov_6.379562_g24987_i0	PRJNA800053	25151	210	6.379562	13.3970802	Galvornvirus isengard	2955925	Viruses	Viruses	145	2.96e-30	NTclustered	gi\|2302015738\|gb\|MT203473.1\|	1954248	g24987	i0	85.106	0.671428571428571	141	21	67	0	68	208	608	468	MAG: Circoviridae sp. isolate CN23_L15_1840, complete genome	blastn	141	145	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
13973792	13973792	PRJNA800053_P_NODE_16451_length_256_cov_1.562842_g16287_i0	PRJNA800053	16451	256	1.562842	4.00087552	Viruses	10239	Viruses	Viruses	462	9.07e-126	NTclustered	gi\|1848664582\|gb\|MN891788.1\|	2740165	g16287	i0	99.219	2.98828125	256	2	100	0	1	256	416	161	Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome	blastn	765	462	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota					Brassica caulorapa CRESS virus
14824518	14824518	PRJNA800053_P_NODE_11372_length_292_cov_2.360731_g11208_i0	PRJNA800053	11372	292	2.360731	6.89333452	Cirlivirales sp.	2809008	Viruses	Viruses	453	6.350000000000001e-123	NTclustered	gi\|2906144154\|gb\|PQ646098.1\|	2809008	g11208	i0	97.368	0.910958904109589	266	7	91	0	3	268	1590	1325	MAG: Cirlivirales sp. isolate k127_3115209 genomic sequence	blastn	266	453	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales			Cirlivirales sp.
16098722	16098722	PRJNA800053_P_NODE_1793_length_624_cov_13.686025_g1639_i0	PRJNA800053	1793	624	13.686025	85.400796	Tick-associated circular virus-6	2951488	Viruses	Viruses	1149	0	NTclustered	gi\|2263979298\|gb\|ON456889.1\|	2951488	g1639	i0	100	0.996794871794872	622	0	99	0	1	622	911	290	Tick-associated circular virus-6 isolate Tick114CressC11, complete genome	blastn	622	1149	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-6
16098740	16098740	PRJNA800053_P_NODE_1953_length_605_cov_2.832707_g1797_i0	PRJNA800053	1953	605	2.832707	17.13787735	Galvornvirus isengard	2955925	Viruses	Viruses	294	9.02e-75	NTclustered	gi\|2302005424\|gb\|MT201198.1\|	1954248	g1797	i0	80.818	0.646280991735537	391	62	63	10	68	447	3885	4273	MAG: Circoviridae sp. isolate CN3_L09_45, complete genome	blastn	391	294	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
17374597	17374597	PRJNA800053_P_NODE_1634_length_647_cov_2.275261_g1481_i0	PRJNA800053	1634	647	2.275261	14.72093867	Tick-associated circular virus-6	2951488	Viruses	Viruses	1051	0	NTclustered	gi\|2263979298\|gb\|ON456889.1\|	2951488	g1481	i0	99.652	1.06336939721793	575	2	99	0	70	644	1612	1038	Tick-associated circular virus-6 isolate Tick114CressC11, complete genome	blastn	688	1051	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-6
18647628	18647628	PRJNA800053_P_NODE_12375_length_284_cov_1.819905_g12211_i0	PRJNA800053	12375	284	1.819905	5.1685302	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	359	1.38e-94	NTclustered	gi\|1836405723\|gb\|MT138265.1\|	3003968	g12211	i0	89.474	1.00352112676056	285	28	100	2	1	284	1897	1614	MAG: Parvo-like hybrid virus UC4 isolate par077par1 genomic sequence	blastn	285	359	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
18647754	18647754	PRJNA800053_P_NODE_7875_length_338_cov_2.713208_g7711_i0	PRJNA800053	7875	338	2.713208	9.17064304	Sichuan tick-associated circovirus 3	2951470	Viruses	Viruses	614	3.2499999999999993e-171	NTclustered	gi\|2263979276\|gb\|ON456881.1\|	2951470	g7711	i0	99.701	0.99112426035503	335	1	99	0	4	338	549	883	Sichuan tick-associated circovirus 3 isolate Tick101/112Circo, complete genome	blastn	335	614	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Sichuan tick-associated circovirus 3
19923012	19923012	PRJNA800053_P_NODE_1936_length_607_cov_4.393258_g1780_i0	PRJNA800053	1936	607	4.393258	26.66707606	Marine snail associated circular virus	1692255	Viruses	Viruses	549	1.7499999999999993e-151	NTclustered	gi\|2080100044\|gb\|MZ244277.1\|	1692255	g1780	i0	99.34	1.34431630971993	303	2	50	0	13	315	303	1	MAG: Marine snail associated circular virus isolate 353circoc2 sequence	blastn	816	549	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Marine snail associated circular virus
19923077	19923077	PRJNA800053_P_NODE_7276_length_349_cov_63.815217_g7112_i0	PRJNA800053	7276	349	63.815217	222.71510733	Tick-associated circular virus-6	2951488	Viruses	Viruses	540	5.77e-149	NTclustered	gi\|2263979298\|gb\|ON456889.1\|	2951488	g7112	i0	94.587	2	351	15	99	2	2	349	2706	2357	Tick-associated circular virus-6 isolate Tick114CressC11, complete genome	blastn	698	540	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-6
21198708	21198708	PRJNA800053_P_NODE_8817_length_323_cov_3.328000_g8653_i0	PRJNA800053	8817	323	3.328	10.74944	Galvornvirus isengard	2955925	Viruses	Viruses	124	6.34e-24	NTclustered	gi\|2302021005\|gb\|MT208525.1\|	1954248	g8653	i0	86.842	0.352941176470588	114	12	35	2	157	269	879	990	MAG: Circoviridae sp. isolate CN23_L19_1107, complete genome	blastn	114	124	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
21198710	21198710	PRJNA800053_P_NODE_9597_length_312_cov_3.995816_g9433_i0	PRJNA800053	9597	312	3.995816	12.46694592	Tick-associated circular virus-6	2951488	Viruses	Viruses	350	9.24e-92	NTclustered	gi\|2263979298\|gb\|ON456889.1\|	2951488	g9433	i0	99.482	1.25961538461538	193	0	99	1	1	192	193	1	Tick-associated circular virus-6 isolate Tick114CressC11, complete genome	blastn	393	350	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Tick-associated circular virus-6
21621951	21621951	PRJNA800053_P_NODE_13357_length_277_cov_1.455882_g13193_i0	PRJNA800053	13357	277	1.455882	4.03279314	Viruses	10239	Viruses	Viruses	501	2.11e-137	NTclustered	gi\|1848664582\|gb\|MN891788.1\|	2740165	g13193	i0	99.635	2.96750902527076	274	1	99	0	1	274	1010	737	Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome	blastn	822	501	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota					Brassica caulorapa CRESS virus
21621974	21621974	PRJNA800053_P_NODE_22137_length_243_cov_2.794118_g21973_i0	PRJNA800053	22137	243	2.794118	6.78970674	Arfiviricetes	2732423	Viruses	Viruses	444	3.09e-120	NTclustered	gi\|2626080284\|gb\|OR270688.1\|	1954248	g21973	i0	100	6.58024691358025	240	0	99	0	4	243	325	564	MAG: Circoviridae sp. isolate GL83, complete genome	blastn	1599	444	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
25022872	25022872	PRJNA800053_P_NODE_40_length_2342_cov_47.247245_g33_i0	PRJNA800053	40	2342	47.247245	1106.5304779	Gemycircularvirus derva1	2844437	Viruses	Viruses	4279	0	NTclustered	gi\|2263979301\|gb\|ON456890.1\|	2025477	g33	i0	99.957	1.98121263877028	2320	1	99	0	20	2339	2443	124	Tick-associated genomovirus 1 isolate Tick114genomoC5, complete genome	blastn	4640	4279	1	Viruses		Shotokuvirae	Cressdnaviricota	Repensiviricetes	Geplafuvirales	Genomoviridae	Gemycircularvirus	Gemycircularvirus derva1
25022879	25022879	PRJNA800053_P_NODE_5860_length_380_cov_4.423453_g5697_i0	PRJNA800053	5860	380	4.423453	16.8091214	Galvornvirus isengard	2955925	Viruses	Viruses	348	4.1300000000000004e-91	NTclustered	gi\|2302008592\|gb\|MT202085.1\|	1954248	g5697	i0	83.551	1.51315789473684	383	51	99	8	1	377	402	26	MAG: Circoviridae sp. isolate CN23_L15_1845, complete genome	blastn	575	348	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard

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