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

31 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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
195551	195551	PRJNA1092581_P_NODE_101161_length_251_cov_2.634831_g100628_i0	PRJNA1092581	101161	251	2.634831	6.61342581	Cucumovirus PSV	3428133	Viruses	Viruses	353	5.569999999999998e-93	NTclustered	gi\|4099093\|gb\|U83332.1\|PSU83332	12313	g100628	i0	94.397	48.7490039840637	232	10	92	3	1	231	231	2	Peanut stunt virus putative RNA dependent RNA polymerase (2a) and putative movement protein (2b) genes, complete cds	blastn	12236	353	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Cucumovirus	Cucumovirus PSV
196680	196680	PRJNA1092581_P_NODE_32661_length_483_cov_8.148780_g32129_i0	PRJNA1092581	32661	483	8.14878	39.3586074	Allexivirus deltallii	3433711	Viruses	Viruses	856	0	NTclustered	gi\|1722561170\|gb\|MN059346.1\|	12430	g32129	i0	100	85.0828157349897	463	0	96	0	21	483	7952	8414	Garlic virus D isolate G120-3, complete genome	blastn	41095	856	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus deltallii
197089	197089	PRJNA1092581_P_NODE_47741_length_390_cov_11.151420_g47208_i0	PRJNA1092581	47741	390	11.15142	43.490538	Betaflexiviridae sp.	1955154	Viruses	Viruses	359	1.96e-94	NTclustered	gi\|2463200070\|gb\|OP021693.1\|	1955154	g47208	i0	91.288	1.74358974358974	264	21	67	2	3	265	8166	7904	Betaflexiviridae sp. isolate GYCV replicase, triple gene block protein1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds	blastn	680	359	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae		Betaflexiviridae sp.
1017942	1017942	PRJNA1092581_P_NODE_18361_length_649_cov_16.623264_g17845_i0	PRJNA1092581	18361	649	16.623264	107.88498336	Potyvirus	12195	Viruses	Viruses	1186	0	NTclustered	gi\|2165402893\|gb\|OK491086.1\|	12216	g17845	i0	100	99.5285053929122	642	0	99	0	8	649	9681	9040	Potato virus Y isolate SXQY-4, complete genome	blastn	64594	1186	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus yituberosi
1472526	1472526	PRJNA1092581_P_NODE_81942_length_285_cov_2.594340_g81409_i0	PRJNA1092581	81942	285	2.59434	7.393869	Trichovirus chloropersicae	3432984	Viruses	Viruses	412	1.0499999999999999e-110	NTclustered	gi\|2504505089\|gb\|OP923917.1\|	2358294	g81409	i0	92.982	63.3824561403509	285	16	100	2	1	285	7151	7431	Peach chlorotic leaf spot virus isolate Apricot XJ, complete genome	blastn	18064	412	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Trichovirus chloropersicae
2747909	2747909	PRJNA1092581_P_NODE_51963_length_372_cov_3.464883_g51430_i0	PRJNA1092581	51963	372	3.464883	12.88936476	Allexivirus ecsallii	3433712	Viruses	Viruses	455	2.31e-123	NTclustered	gi\|410131120\|gb\|JQ807994.1\|	150284	g51430	i0	95.172	70.8091397849462	290	11	77	2	2	288	8345	8056	Garlic virus X isolate SW3, complete genome	blastn	26341	455	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus ecsallii
3568903	3568903	PRJNA1092581_P_NODE_46103_length_398_cov_11.036923_g45570_i0	PRJNA1092581	46103	398	11.036923	43.92695354	Potyvirus	12195	Viruses	Viruses	697	0	NTclustered	gi\|2582377801\|gb\|OP179327.1\|	12216	g45570	i0	100	94.7286432160804	377	0	95	0	21	397	5463	5839	Potato virus Y isolate GZ 137, complete genome	blastn	37702	697	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus yituberosi
4022661	4022661	PRJNA1092581_P_NODE_124044_length_210_cov_2.890511_g123511_i0	PRJNA1092581	124044	210	2.890511	6.0700731	Aphthovirus vesiculae	3426401	Viruses	Viruses	56.5	0.001	NTclustered	gi\|1164579649\|dbj\|LC149658.1\|	12118	g123511	i0	100	14.2857142857143	30	0	14	0	91	120	3526	3497	Foot-and-mouth disease virus - type O gene for polyprotein, complete cds, strain: O/JPN/2010-103/1S	blastn	3000	56.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Aphthovirus	Aphthovirus vesiculae
5300478	5300478	PRJNA1092581_P_NODE_7025_length_985_cov_5.628289_g6665_i0	PRJNA1092581	7025	985	5.628289	55.43864665	Potexvirus ecscacti	3433821	Viruses	Viruses	1748	0	NTclustered	gi\|1110865423\|gb\|KX883791.1\|	112227	g6665	i0	99.378	2.93604060913706	964	6	98	0	1	964	2901	1938	Cactus virus X strain SCM51431 ORF1, ORF2, ORF3, and ORF4 genes, complete cds	blastn	2892	1748	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus ecscacti
7848817	7848817	PRJNA1092581_P_NODE_14127_length_733_cov_4.307576_g13638_i0	PRJNA1092581	14127	733	4.307576	31.57453208	Phytophthora infestans RNA virus 4	1077832	Viruses	Viruses	1293	0	NTclustered	gi\|1008869902\|gb\|KU295723.1\|	1077832	g13638	i0	99.438	9.71350613915416	712	4	97	0	22	733	1718	2429	Phytophthora infestans RNA virus 4 isolate PiRV-4-YN17, partial genome	blastn	7120	1293	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Phytophthora infestans RNA virus 4
7850700	7850700	PRJNA1092581_P_NODE_85827_length_277_cov_3.019608_g85294_i0	PRJNA1092581	85827	277	3.019608	8.36431416	Fusarium poae partitivirus 3	2974658	Viruses	Viruses	182	3.12e-41	NTclustered	gi\|2295827863\|gb\|OK524191.1\|	2974658	g85294	i0	83.756	0.711191335740072	197	27	70	5	25	217	1805	1610	Fusarium poae partitivirus 3 strain F.1189 segment 2, complete sequence	blastn	197	182	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Fusarium poae partitivirus 3
9124771	9124771	PRJNA1092581_P_NODE_51508_length_374_cov_3.029900_g50975_i0	PRJNA1092581	51508	374	3.0299	11.331826	Hulunbuir Botou tick virus 2	2972054	Viruses	Viruses	612	1.2999999999999995e-170	NTclustered	gi\|2820295208\|gb\|PQ180956.1\|	2972054	g50975	i0	99.701	13.0935828877005	334	1	89	0	13	346	334	1	MAG: Hulunbuir Botou tick virus 2 isolate Hebei_059 genomic sequence	blastn	4897	612	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Hulunbuir Botou tick virus 2
9125008	9125008	PRJNA1092581_P_NODE_59888_length_342_cov_10.602230_g59355_i0	PRJNA1092581	59888	342	10.60223	36.2596266	Allexivirus ecsascalonicum	3433713	Viruses	Viruses	65.8	4.15e-6	NTclustered	gi\|1678654015\|gb\|MH389250.1\|	31770	g59355	i0	80.899	2.80701754385965	89	11	25	6	21	105	1	87	Shallot virus X isolate 13-04-2, complete genome	blastn	960	65.8	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus ecsascalonicum
11221919	11221919	PRJNA1092581_P_NODE_61469_length_338_cov_1.173585_g60936_i0	PRJNA1092581	61469	338	1.173585	3.9667173	Orthorubulavirus	2560195	Viruses	Viruses	619	6.969999999999999e-173	NTclustered	gi\|2449300967\|gb\|ON241249.1\|	2560580	g60936	i0	99.704	79.4437869822485	338	1	100	0	1	338	386	49	Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome	blastn	26852	619	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
11675689	11675689	PRJNA1092581_P_NODE_46730_length_395_cov_4.937888_g46197_i0	PRJNA1092581	46730	395	4.937888	19.5046576	Cucumovirus PSV	3428133	Viruses	Viruses	656	0	NTclustered	gi\|2575892182\|gb\|OR233183.1\|	12313	g46197	i0	97.65	92.093670886076	383	7	97	2	1	382	12	393	Peanut stunt virus isolate DSMZ PV-0203 segment RNA 1, complete sequence	blastn	36377	656	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Cucumovirus	Cucumovirus PSV
11676277	11676277	PRJNA1092581_P_NODE_70730_length_311_cov_2.588235_g70197_i0	PRJNA1092581	70730	311	2.588235	8.04941085	Tobamovirus tomatotessellati	3432892	Viruses	Viruses	575	1.3899999999999995e-159	NTclustered	gi\|2201440261\|gb\|OL652662.1\|	12253	g70197	i0	100	99.9228295819936	311	0	100	0	1	311	4608	4918	Tomato mosaic virus isolate NVWA36783860, complete genome	blastn	31076	575	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
12951574	12951574	PRJNA1092581_P_NODE_78291_length_293_cov_2.081818_g77758_i0	PRJNA1092581	78291	293	2.081818	6.09972674	Potyvirus yituberosi	3240642	Viruses	Viruses	542	1.32e-149	NTclustered	gi\|2583174907\|gb\|OR359626.1\|	12216	g77758	i0	100	99.9965870307167	293	0	100	0	1	293	457	165	Potato virus Y isolate PVY-P10 polyprotein gene, partial cds	blastn	29299	542	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus yituberosi
18047392	18047392	PRJNA1092581_P_NODE_108375_length_242_cov_3.136095_g107842_i0	PRJNA1092581	108375	242	3.136095	7.5893499	Coltivirus dermacentoris	3428066	Viruses	Viruses	342	1.16e-89	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g107842	i0	97.044	1.45454545454545	203	6	84	0	40	242	4486	4688	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	352	342	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
18047629	18047629	PRJNA1092581_P_NODE_118875_length_225_cov_7.355263_g118342_i0	PRJNA1092581	118875	225	7.355263	16.54934175	Chrocagost virus	3129398	Viruses	Viruses	296	8.37e-76	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g118342	i0	93.532	94.5244444444444	201	10	88	3	27	225	5868	5669	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	21268	296	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
19321494	19321494	PRJNA1092581_P_NODE_111996_length_237_cov_2.109756_g111463_i0	PRJNA1092581	111996	237	2.109756	5.00012172	Skokie picorna-like virus	2789431	Viruses	Viruses	409	1.1e-109	NTclustered	gi\|1935607038\|gb\|MT747994.1\|	2789431	g111463	i0	97.881	2.9873417721519	236	5	99	0	2	237	4435	4200	Skokie picorna-like virus strain USAdp-2 polyprotein gene, complete cds	blastn	708	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Skokie picorna-like virus
20597082	20597082	PRJNA1092581_P_NODE_124077_length_209_cov_43.360294_g123544_i0	PRJNA1092581	124077	209	43.360294	90.62301446	Betacoronavirus pandemicum	3418604	Viruses	Viruses	110	1.07e-19	NTclustered	gi\|2326415437\|gb\|OP789280.1\|	2697049	g123544	i0	98.413	30.1435406698565	63	0	30	1	120	182	28462	28401	Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OKPHL0020340/2022 ORF1ab polyprotein (ORF1ab) and ORF1a polyprotein (ORF1ab) genes, partial cds; and surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), ORF7b (ORF7b), ORF8 protein (ORF8), nucleocapsid phosphoprotein (N), and ORF10 protein (ORF10) genes, complete cds	blastn	6300	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
20597295	20597295	PRJNA1092581_P_NODE_17357_length_667_cov_2.794613_g16845_i0	PRJNA1092581	17357	667	2.794613	18.64006871	Coltivirus dermacentoris	3428066	Viruses	Viruses	996	0	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g16845	i0	96.072	81.3973013493253	611	24	92	0	55	665	5388	4778	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	54292	996	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
21872957	21872957	PRJNA1092581_P_NODE_14078_length_734_cov_10.284418_g13589_i0	PRJNA1092581	14078	734	10.284418	75.48762812	Tobamovirus capsici	3432865	Viruses	Viruses	1339	0	NTclustered	gi\|1791312535\|gb\|MN616927.1\|	12239	g13589	i0	99.591	94.4291553133515	734	3	100	0	1	734	4843	5576	Pepper mild mottle virus isolate ZJ2, complete genome	blastn	69311	1339	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus capsici
21873041	21873041	PRJNA1092581_P_NODE_16938_length_674_cov_3.231281_g16429_i0	PRJNA1092581	16938	674	3.231281	21.77883394	Allexivirus alphallii	3433708	Viruses	Viruses	1194	0	NTclustered	gi\|1722560631\|gb\|MN059269.1\|	12433	g16429	i0	99.542	94.5548961424332	655	3	97	0	1	655	8664	8010	Garlic virus A isolate G26-3, complete genome	blastn	63730	1194	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus alphallii
21873341	21873341	PRJNA1092581_P_NODE_28018_length_525_cov_2.599558_g27486_i0	PRJNA1092581	28018	525	2.599558	13.6476795	Phytophthora infestans RNA virus 4	1077832	Viruses	Viruses	959	0	NTclustered	gi\|1012306342\|ref\|NC_029782.1\|	1077832	g27486	i0	99.619	8.15619047619048	525	2	100	0	1	525	2414	2938	Phytophthora infestans RNA virus 4 isolate FLa2005, complete genome	blastn	4282	959	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Phytophthora infestans RNA virus 4
21873937	21873937	PRJNA1092581_P_NODE_49658_length_382_cov_3.097087_g49125_i0	PRJNA1092581	49658	382	3.097087	11.83087234	Astroviridae sp.	2585114	Viruses	Viruses	667	0	NTclustered	gi\|1851856021\|gb\|MT138002.1\|	2585114	g49125	i0	98.168	1	382	7	100	0	1	382	5384	5003	MAG: Astroviridae sp. isolate cra070ast1 genomic sequence, sequence	blastn	382	667	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Astroviridae sp.
21874015	21874015	PRJNA1092581_P_NODE_52858_length_368_cov_3.905085_g52325_i0	PRJNA1092581	52858	368	3.905085	14.3707128	Stralarivirus lychnis	3052754	Viruses	Viruses	270	8.869999999999999e-68	NTclustered	gi\|2063685004\|gb\|MW035176.1\|	1676256	g52325	i0	87.712	60.9375	236	23	99	5	135	368	3563	3332	Lychnis mottle virus isolate AR_44 segment RNA2, complete sequence	blastn	22425	270	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Stralarivirus	Stralarivirus lychnis
23147842	23147842	PRJNA1092581_P_NODE_106519_length_244_cov_5.912281_g105986_i0	PRJNA1092581	106519	244	5.912281	14.42596564	Cucumovirus CMV	3428131	Viruses	Viruses	412	8.759999999999998e-111	NTclustered	gi\|2017768906\|gb\|MW556589.1\|	12305	g105986	i0	100	91.4426229508197	223	0	91	0	21	243	670	892	Cucumber mosaic virus isolate WSJ segment RNA3, complete sequence	blastn	22312	412	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Cucumovirus	Cucumovirus CMV
23149691	23149691	PRJNA1092581_P_NODE_63699_length_330_cov_11.214008_g63166_i0	PRJNA1092581	63699	330	11.214008	37.0062264	Hansenia oviformis nepovirus	3115769	Viruses	Viruses	366	9.77e-97	NTclustered	gi\|2752247854\|tpg\|BK065084.1\|	3115769	g63166	i0	89.86	3.18181818181818	286	28	86	1	22	306	7575	7860	TPA_asm: Hansenia oviformis nepovirus segment RNA1 polyprotein gene, complete cds	blastn	1050	366	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Hansenia oviformis nepovirus
23150204	23150204	PRJNA1092581_P_NODE_83619_length_281_cov_7.899038_g83086_i0	PRJNA1092581	83619	281	7.899038	22.19629678	Betacoronavirus pandemicum	3418604	Viruses	Viruses	472	1.6799999999999998e-128	NTclustered	gi\|2230647867\|gb\|ON343363.1\|	2697049	g83086	i0	99.237	93.2384341637011	262	0	93	1	1	260	29870	29609	Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CA-CDPH-2000013366/2020, complete genome	blastn	26200	472	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
24421395	24421395	PRJNA1092581_P_NODE_101200_length_251_cov_2.488764_g100667_i0	PRJNA1092581	101200	251	2.488764	6.24679764	Ripachij virus	3130407	Viruses	Viruses	241	4.52e-59	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g100667	i0	86.916	157.872509960159	214	28	85	0	19	232	479	692	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	39626	241	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus

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