metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax_kingdom = "Orthornavirae"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
181210	181210	PRJNA1067370_P_NODE_861_length_1585_cov_1.854497_g657_i0	PRJNA1067370	861	1585	1.854497	29.39377745	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	2492	0	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g657	i0	95.127	13.7129337539432	1580	77	99	0	1	1580	1924	3503	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	21735	2492	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
181299	181299	PRJNA1067370_P_NODE_97101_length_246_cov_0.890173_g96552_i0	PRJNA1067370	97101	246	0.890173	2.18982558	Rotavirus tritogastroenteritidis	3432203	Viruses	Viruses	52.8	0.022	NTclustered	gi\|1464450547\|gb\|MG451424.1\|	36427	g96552	i0	100	0.113821138211382	28	0	11	0	202	229	2636	2663	Rotavirus C strain RVC/Pig-wt/USA/AZ20/2012/G6P5 VP1 (VP1) gene, partial cds	blastn	28	52.8	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Sedoreoviridae	Rotavirus	Rotavirus tritogastroenteritidis
1455395	1455395	PRJNA1067370_P_NODE_20822_length_413_cov_0.900000_g20274_i0	PRJNA1067370	20822	413	0.9	3.717	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	625	1.8699999999999995e-174	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g20274	i0	93.947	2.99757869249395	413	25	100	0	1	413	3963	3551	Sweet potato yellow mottle virus, complete genome	blastn	1238	625	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
1455478	1455478	PRJNA1067370_P_NODE_30282_length_354_cov_1.505338_g29734_i0	PRJNA1067370	30282	354	1.505338	5.32889652	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	520	7.639999999999999e-143	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g29734	i0	93.22	3.94915254237288	354	22	99	2	2	354	3252	2900	Sweet potato yellow mottle virus, complete genome	blastn	1398	520	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
2731503	2731503	PRJNA1067370_P_NODE_61903_length_277_cov_1.181373_g61354_i0	PRJNA1067370	61903	277	1.181373	3.27240321	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	429	1.0099999999999999e-115	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g61354	i0	94.585	3.99638989169675	277	15	100	0	1	277	5156	5432	Sweet potato yellow mottle virus, complete genome	blastn	1107	429	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
4007180	4007180	PRJNA1067370_P_NODE_22844_length_397_cov_2.478395_g22296_i0	PRJNA1067370	22844	397	2.478395	9.83922815	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	678	0	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g22296	i0	97.481	18.9773299748111	397	10	100	0	1	397	28	424	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	7534	678	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
4007265	4007265	PRJNA1067370_P_NODE_33444_length_341_cov_2.044776_g32896_i0	PRJNA1067370	33444	341	2.044776	6.97268616	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	575	1.5499999999999994e-159	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g32896	i0	97.067	11.0029325513196	341	10	100	0	1	341	436	776	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	3752	575	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
5283824	5283824	PRJNA1067370_P_NODE_66945_length_269_cov_1.571429_g66396_i0	PRJNA1067370	66945	269	1.571429	4.22714401	Polerovirus PLRV	3431772	Viruses	Viruses	497	2.63e-136	NTclustered	gi\|1480117866\|gb\|MG356502.1\|	12045	g66396	i0	100	99.9925650557621	269	0	100	0	1	269	3736	4004	Potato leafroll virus isolate PLRV165, complete genome	blastn	26898	497	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae	Polerovirus	Polerovirus PLRV
5283835	5283835	PRJNA1067370_P_NODE_68145_length_267_cov_2.159794_g67596_i0	PRJNA1067370	68145	267	2.159794	5.76664998	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	388	1.64e-103	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g67596	i0	92.884	5.96629213483146	267	19	100	0	1	267	6788	6522	Sweet potato yellow mottle virus, complete genome	blastn	1593	388	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
6558578	6558578	PRJNA1067370_P_NODE_1646_length_1261_cov_4.066498_g1353_i0	PRJNA1067370	1646	1261	4.066498	51.27853978	Hepelivirales sp.	2809460	Viruses	Viruses	793	0	NTclustered	gi\|2416689812\|gb\|OP699083.1\|	2809460	g1353	i0	80.246	0.839016653449643	1058	205	84	4	206	1261	1067	12	Hepelivirales sp. strain MR644-18E/5050 nonstructural polyprotein gene, partial cds	blastn	1058	793	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales			Hepelivirales sp.
6559037	6559037	PRJNA1067370_P_NODE_826_length_1612_cov_3.637427_g631_i0	PRJNA1067370	826	1612	3.637427	58.63532324	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	2684	0	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g631	i0	96.712	46.2382133995037	1612	53	100	0	1	1612	7472	9083	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	74536	2684	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
7833252	7833252	PRJNA1067370_P_NODE_16887_length_453_cov_1.052632_g16339_i0	PRJNA1067370	16887	453	1.052632	4.76842296	Potyvirus batataplumei	3240478	Viruses	Viruses	826	0	NTclustered	gi\|765527324\|gb\|KP115610.1\|	12844	g16339	i0	99.558	100.105960264901	453	2	100	0	1	453	10013	10465	Sweet potato feathery mottle virus isolate IS90, complete genome	blastn	45348	826	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
9108192	9108192	PRJNA1067370_P_NODE_11208_length_545_cov_1.169492_g10666_i0	PRJNA1067370	11208	545	1.169492	6.3737314	Potyvirus batataplumei	3240478	Viruses	Viruses	970	0	NTclustered	gi\|765527324\|gb\|KP115610.1\|	12844	g10666	i0	98.895	99.9449541284404	543	6	99	0	3	545	8088	8630	Sweet potato feathery mottle virus isolate IS90, complete genome	blastn	54470	970	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
10383994	10383994	PRJNA1067370_P_NODE_21789_length_405_cov_1.692771_g21241_i0	PRJNA1067370	21789	405	1.692771	6.85572255	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	536	8.799999999999998e-148	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g21241	i0	90.617	4.6962962962963	405	36	99	2	1	404	2469	2872	Sweet potato yellow mottle virus, complete genome	blastn	1902	536	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
12934451	12934451	PRJNA1067370_P_NODE_21931_length_404_cov_1.531722_g21383_i0	PRJNA1067370	21931	404	1.531722	6.18815688	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	610	5.0999999999999976e-170	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g21383	i0	94.03	5.9480198019802	402	24	99	0	3	404	6513	6112	Sweet potato yellow mottle virus, complete genome	blastn	2403	610	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
14209367	14209367	PRJNA1067370_P_NODE_152_length_2988_cov_2.581818_g90_i0	PRJNA1067370	152	2988	2.581818	77.14472184	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	5073	0	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g90	i0	97.323	17.0619143239625	2988	79	100	1	1	2988	4518	7504	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	50981	5073	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
14209555	14209555	PRJNA1067370_P_NODE_38792_length_323_cov_1.064000_g38244_i0	PRJNA1067370	38792	323	1.064	3.43672	Potyvirus batataplumei	3240478	Viruses	Viruses	592	1.4499999999999999e-164	NTclustered	gi\|765527324\|gb\|KP115610.1\|	12844	g38244	i0	99.69	99.4860681114551	323	1	100	0	1	323	9098	8776	Sweet potato feathery mottle virus isolate IS90, complete genome	blastn	32134	592	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
14209631	14209631	PRJNA1067370_P_NODE_52272_length_291_cov_35.059633_g51723_i0	PRJNA1067370	52272	291	35.059633	102.02353203	Mitovirus sp.	2587224	Viruses	Viruses	174	5.51e-39	NTclustered	gi\|1698234317\|gb\|MN033515.1\|	2587224	g51723	i0	94.643	3.22680412371134	112	6	38	0	5	116	1	112	MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence	blastn	939	174	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
15483831	15483831	PRJNA1067370_P_NODE_75833_length_256_cov_1.278689_g75284_i0	PRJNA1067370	75833	256	1.278689	3.27344384	Chrocagosk virus	3129397	Viruses	Viruses	69.4	2.31e-7	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g75284	i0	100	0.14453125	37	0	14	0	2	38	519	555	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	37	69.4	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
16757985	16757985	PRJNA1067370_P_NODE_73574_length_259_cov_1.655914_g73025_i0	PRJNA1067370	73574	259	1.655914	4.28881726	Polerovirus PLRV	3431772	Viruses	Viruses	468	1.98e-127	NTclustered	gi\|1377542796\|gb\|MF062487.1\|	12045	g73025	i0	99.228	99.953667953668	259	2	100	0	1	259	5285	5027	Potato leafroll virus isolate EP, complete genome	blastn	25888	468	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae	Polerovirus	Polerovirus PLRV
18032738	18032738	PRJNA1067370_P_NODE_6495_length_698_cov_1.388800_g5985_i0	PRJNA1067370	6495	698	1.3888	9.693824	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	1116	0	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g5985	i0	95.552	5.97421203438395	697	31	99	0	2	698	6911	7607	Sweet potato yellow mottle virus, complete genome	blastn	4170	1116	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
19306300	19306300	PRJNA1067370_P_NODE_16116_length_462_cov_1.624679_g15568_i0	PRJNA1067370	16116	462	1.624679	7.50601698	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	767	0	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g15568	i0	96.739	13.969696969697	460	15	99	0	3	462	1231	1690	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	6454	767	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
19306507	19306507	PRJNA1067370_P_NODE_45576_length_308_cov_1.217021_g45028_i0	PRJNA1067370	45576	308	1.217021	3.74842468	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	507	5.0999999999999996e-139	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g45028	i0	96.417	9.89935064935065	307	11	99	0	2	308	826	1132	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	3049	507	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
20581934	20581934	PRJNA1067370_P_NODE_32457_length_345_cov_1.830882_g31909_i0	PRJNA1067370	32457	345	1.830882	6.3165429	Chrocomolt virus	3129476	Viruses	Viruses	429	1.29e-115	NTclustered	gi\|2717317674\|gb\|PP171924.1\|	3129476	g31909	i0	95.203	28.2347826086957	271	13	79	0	1	271	4130	4400	MAG: Chrocomolt virus isolate CC1B_k141_48525 genomic sequence	blastn	9741	429	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Chrocomolt virus
20582007	20582007	PRJNA1067370_P_NODE_4417_length_834_cov_1.950066_g3944_i0	PRJNA1067370	4417	834	1.950066	16.26355044	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	1391	0	NTclustered	gi\|2512663715\|gb\|OQ139537.1\|	263004	g3944	i0	96.763	11.0011990407674	834	27	100	0	1	834	4524	3691	Sweet potato chlorotic fleck virus isolate CFV-SD1, complete genome	blastn	9175	1391	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae
23132954	23132954	PRJNA1067370_P_NODE_14559_length_484_cov_1.114355_g14012_i0	PRJNA1067370	14559	484	1.114355	5.3934782	Potyvirus batataplumei	3240478	Viruses	Viruses	867	0	NTclustered	gi\|765527324\|gb\|KP115610.1\|	12844	g14012	i0	98.967	99.9276859504132	484	5	100	0	1	484	9570	9087	Sweet potato feathery mottle virus isolate IS90, complete genome	blastn	48365	867	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus batataplumei
24406803	24406803	PRJNA1067370_P_NODE_4500_length_826_cov_1.940239_g4023_i0	PRJNA1067370	4500	826	1.940239	16.02637414	Carlavirus chloroipomoeae	3427748	Viruses	Viruses	1304	0	NTclustered	gi\|930624036\|gb\|KR072674.1\|	1718190	g4023	i0	95.157	11.7130750605327	826	40	100	0	1	826	8924	8099	Sweet potato yellow mottle virus, complete genome	blastn	9675	1304	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus chloroipomoeae

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