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

27 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
1938695	1938695	PRJNA682078_P_NODE_39942_length_540_cov_3.128480_g38186_i0	PRJNA682078	39942	540	3.12848	16.893792	Alphacoronavirus suis	3433814	Viruses	Viruses	289	3.7200000000000005e-73	NTclustered	gi\|2238311086\|gb\|OM950728.1\|	11153	g38186	i0	100	51.9611111111111	156	0	29	0	368	523	169	324	Canine coronavirus isolate GH8-2, complete genome	blastn	28059	289	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Alphacoronavirus	Alphacoronavirus suis
2449094	2449094	PRJNA682078_P_NODE_4362_length_1820_cov_3.726961_g3494_i0	PRJNA682078	4362	1820	3.726961	67.8306902	Alphacoronavirus	693996	Viruses	Viruses	110	1.1e-18	NTclustered	gi\|1103565\|emb\|X90570.1\|	11135	g3494	i0	96.923	3.4532967032967	65	2	4	0	1415	1479	937	1001	Feline infectious peritonitis virus mRNA for 7a and 7b proteins (strain TN406)	blastn	6285	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Alphacoronavirus	Alphacoronavirus suis
3214770	3214770	PRJNA682078_P_NODE_93823_length_361_cov_2.805556_g92047_i0	PRJNA682078	93823	361	2.805556	10.12805716	Alphacoronavirus porci	3433789	Viruses	Viruses	667	0	NTclustered	gi\|1373510442\|gb\|MH006958.1\|	28295	g92047	i0	100	100	361	0	100	0	1	361	24985	24625	Porcine epidemic diarrhea virus strain PEDV/MEX/MICH/19/2013, complete genome	blastn	36100	667	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Alphacoronavirus	Alphacoronavirus porci
3724997	3724997	PRJNA682078_P_NODE_255603_length_246_cov_0.890173_g253826_i0	PRJNA682078	255603	246	0.890173	2.18982558	Viruses	10239	Viruses	Viruses	63.9	1.03e-5	NTclustered	gi\|2557633336\|emb\|OY694998.1\|	2697049	g253826	i0	97.368	14.8089430894309	38	0	15	1	210	246	19649	19686	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	3643	63.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
4487719	4487719	PRJNA682078_P_NODE_19164_length_782_cov_1.434415_g17594_i0	PRJNA682078	19164	782	1.434415	11.2171253	Fabavirus gynostemmae	3428639	Viruses	Viruses	1284	0	NTclustered	gi\|2322080715\|tpg\|BK061324.1\|	2936688	g17594	i0	96.292	1.49872122762148	782	29	100	0	1	782	2096	1315	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA1, complete sequence	blastn	1172	1284	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
4487727	4487727	PRJNA682078_P_NODE_191884_length_268_cov_1.020513_g190107_i0	PRJNA682078	191884	268	1.020513	2.73497484	Fabavirus gynostemmae	3428639	Viruses	Viruses	446	9.63e-121	NTclustered	gi\|2322080742\|tpg\|BK061325.1\|	2936688	g190107	i0	96.642	1.41417910447761	268	9	100	0	1	268	1523	1790	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA2, complete sequence	blastn	379	446	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
7039751	7039751	PRJNA682078_P_NODE_245726_length_248_cov_0.880000_g243949_i0	PRJNA682078	245726	248	0.88	2.1824	Mamastrovirus felis	3430626	Viruses	Viruses	431	2.47e-116	NTclustered	gi\|2264470731\|gb\|MN977119.1\|	1239566	g243949	i0	97.984	81.758064516129	248	5	100	0	1	248	6522	6769	Mamastrovirus 2 strain AH-2-2020, complete genome	blastn	20276	431	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Mamastrovirus	Mamastrovirus felis
8312747	8312747	PRJNA682078_P_NODE_183687_length_272_cov_2.673367_g181910_i0	PRJNA682078	183687	272	2.673367	7.27155824	Fabavirus betaviciae	3047702	Viruses	Viruses	422	1.65e-113	NTclustered	gi\|2429409206\|gb\|ON125370.1\|	76875	g181910	i0	95.455	96.4411764705882	264	12	97	0	1	264	5640	5903	Broad bean wilt virus 2 isolate BBWV-HR polyprotein gene, complete cds	blastn	26232	422	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus betaviciae
9586451	9586451	PRJNA682078_P_NODE_117848_length_328_cov_1.129412_g116071_i0	PRJNA682078	117848	328	1.129412	3.70447136	Gammafusarivirus lentinualea	2955929	Viruses	Viruses	601	2.4399999999999998e-167	NTclustered	gi\|2500381614\|ref\|NC_076860.1\|	2778976	g116071	i0	99.695	1	328	1	100	0	1	328	3491	3164	Lentinula edodes fusarivirus 1 isolate Le14HNZMD RNA-dependent RNA polymerase (QKS38_gp1) gene, complete cds	blastn	328	601	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae	Gammafusarivirus	Gammafusarivirus lentinualea
9590276	9590276	PRJNA682078_P_NODE_267148_length_244_cov_1.555556_g265371_i0	PRJNA682078	267148	244	1.555556	3.79555664	Lentinula edodes fusarivirus 4	2992850	Viruses	Viruses	438	1.45e-118	NTclustered	gi\|2324991068\|gb\|OK636210.1\|	2992850	g265371	i0	99.18	1	244	1	100	1	1	244	23	265	Lentinula edodes fusarivirus 4 isolate LED2-6 RNA-dependent RNA polymerase (RdRp) gene, complete cds	blastn	244	438	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae		Lentinula edodes fusarivirus 4
9591070	9591070	PRJNA682078_P_NODE_298388_length_226_cov_2.013072_g296611_i0	PRJNA682078	298388	226	2.013072	4.54954272	Chrocagosk virus	3129397	Viruses	Viruses	99	2.55e-16	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g296611	i0	78.75	0.707964601769911	160	24	67	8	23	174	519	676	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	160	99	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
10865522	10865522	PRJNA682078_P_NODE_2589_length_2645_cov_2.059876_g1906_i0	PRJNA682078	2589	2645	2.059876	54.4837202	Fabavirus gynostemmae	3428639	Viruses	Viruses	4324	0	NTclustered	gi\|2322080715\|tpg\|BK061324.1\|	2936688	g1906	i0	96.181	1.35198487712665	2645	99	100	1	1	2645	3011	5653	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA1, complete sequence	blastn	3576	4324	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
12137312	12137312	PRJNA682078_P_NODE_114830_length_331_cov_2.713178_g113053_i0	PRJNA682078	114830	331	2.713178	8.98061918	Fabavirus gynostemmae	3428639	Viruses	Viruses	560	4.19e-155	NTclustered	gi\|2322080715\|tpg\|BK061324.1\|	2936688	g113053	i0	97.273	1.42598187311178	330	9	99	0	2	331	5	334	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA1, complete sequence	blastn	472	560	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
12143173	12143173	PRJNA682078_P_NODE_87230_length_373_cov_1.540000_g85455_i0	PRJNA682078	87230	373	1.54	5.7442	Fabavirus betaviciae	3047702	Viruses	Viruses	634	2.77e-177	NTclustered	gi\|1524754172\|gb\|MH645159.1\|	76875	g85455	i0	97.319	90.0938337801609	373	10	100	0	1	373	5531	5903	Broad bean wilt virus 2 isolate BBWV2_RNA1, partial genome	blastn	33605	634	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus betaviciae
13416837	13416837	PRJNA682078_P_NODE_46391_length_502_cov_4.020979_g44627_i0	PRJNA682078	46391	502	4.020979	20.18531458	Fabavirus betaviciae	3047702	Viruses	Viruses	869	0	NTclustered	gi\|1935608366\|gb\|MN786955.1\|	76875	g44627	i0	98	97.3227091633466	500	10	99	0	1	500	3504	3005	Broad bean wilt virus 2 isolate LNSY segment RNA2 polyprotein gene, complete cds	blastn	48856	869	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus betaviciae
14687397	14687397	PRJNA682078_P_NODE_132372_length_312_cov_0.794979_g130595_i0	PRJNA682078	132372	312	0.794979	2.48033448	Iflavirus sp.	1916690	Viruses	Viruses	560	3.92e-155	NTclustered	gi\|2895513821\|tpg\|BK068531.1\|	1916690	g130595	i0	99.038	1.99038461538462	312	3	100	0	1	312	9336	9647	TPA_asm: Iflavirus sp. isolate WUR60 polyprotein gene, complete cds	blastn	621	560	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus sp.
14690116	14690116	PRJNA682078_P_NODE_24372_length_692_cov_1.326333_g22672_i0	PRJNA682078	24372	692	1.326333	9.17822436	Fabavirus gynostemmae	3428639	Viruses	Viruses	1173	0	NTclustered	gi\|2322080715\|tpg\|BK061324.1\|	2936688	g22672	i0	97.254	1	692	19	100	0	1	692	2369	3060	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA1, complete sequence	blastn	692	1173	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
17235957	17235957	PRJNA682078_P_NODE_116614_length_329_cov_1.804688_g114837_i0	PRJNA682078	116614	329	1.804688	5.93742352	Fabavirus gynostemmae	3428639	Viruses	Viruses	597	3.169999999999999e-166	NTclustered	gi\|2322080742\|tpg\|BK061325.1\|	2936688	g114837	i0	99.392	1	329	2	100	0	1	329	2076	2404	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA2, complete sequence	blastn	329	597	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
17236914	17236914	PRJNA682078_P_NODE_155154_length_290_cov_1.419355_g153377_i0	PRJNA682078	155154	290	1.419355	4.1161295	Fabavirus gynostemmae	3428639	Viruses	Viruses	470	6.259999999999999e-128	NTclustered	gi\|2322080715\|tpg\|BK061324.1\|	2936688	g153377	i0	95.862	1	290	12	100	0	1	290	453	742	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA1, complete sequence	blastn	290	470	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
17241622	17241622	PRJNA682078_P_NODE_79634_length_389_cov_1.155063_g77859_i0	PRJNA682078	79634	389	1.155063	4.49319507	Alphacoronavirus porci	3433789	Viruses	Viruses	708	0	NTclustered	gi\|1884653818\|gb\|MT090145.1\|	28295	g77859	i0	99.486	100	389	2	100	0	1	389	25205	25593	Porcine epidemic diarrhea virus strain CH/HNYY/2018, complete genome	blastn	38900	708	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Alphacoronavirus	Alphacoronavirus porci
18515337	18515337	PRJNA682078_P_NODE_62795_length_434_cov_1.498615_g61020_i0	PRJNA682078	62795	434	1.498615	6.5039891	Fabavirus gynostemmae	3428639	Viruses	Viruses	763	0	NTclustered	gi\|2322080742\|tpg\|BK061325.1\|	2936688	g61020	i0	98.387	1	434	7	100	0	1	434	2654	3087	TPA_asm: Gynostemma pentaphyllum secovirus isolate China segment RNA2, complete sequence	blastn	434	763	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus gynostemmae
19788011	19788011	PRJNA682078_P_NODE_241216_length_248_cov_1.320000_g239439_i0	PRJNA682078	241216	248	1.32	3.2736	Alphacoronavirus suis	3433814	Viruses	Viruses	403	5.38e-108	NTclustered	gi\|2679313459\|gb\|PP351454.1\|	12663	g239439	i0	95.968	99.7620967741936	248	10	100	0	1	248	83	330	Feline coronavirus isolate ACV1/IZSSI_2022PA10026 membrane protein (M) gene, partial cds	blastn	24741	403	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Alphacoronavirus	Alphacoronavirus suis
21065672	21065672	PRJNA682078_P_NODE_61377_length_439_cov_1.262295_g59603_i0	PRJNA682078	61377	439	1.262295	5.54147505	Lentinula edodes fusarivirus 4	2992850	Viruses	Viruses	741	0	NTclustered	gi\|2324991068\|gb\|OK636210.1\|	2992850	g59603	i0	97.254	0.995444191343964	437	12	99	0	1	437	5546	5110	Lentinula edodes fusarivirus 4 isolate LED2-6 RNA-dependent RNA polymerase (RdRp) gene, complete cds	blastn	437	741	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae		Lentinula edodes fusarivirus 4
21066233	21066233	PRJNA682078_P_NODE_87457_length_373_cov_0.993333_g85682_i0	PRJNA682078	87457	373	0.993333	3.70513209	Fabavirus betaviciae	3047702	Viruses	Viruses	628	1.2899999999999998e-175	NTclustered	gi\|2202597465\|gb\|MZ571837.1\|	76875	g85682	i0	97.051	84.6246648793566	373	11	100	0	1	373	3005	2633	Broad bean wilt virus 2 isolate LNSY-YZC segment RNA2, complete sequence	blastn	31565	628	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Fabavirus	Fabavirus betaviciae
23615247	23615247	PRJNA682078_P_NODE_2939_length_2405_cov_5.214837_g2222_i0	PRJNA682078	2939	2405	5.214837	125.41682985	Alphacoronavirus suis	3433814	Viruses	Viruses	3640	0	NTclustered	gi\|1997114541\|gb\|MT239439.1\|	12663	g2222	i0	94.692	98.8910602910603	2355	106	99	5	3	2340	29333	26981	Feline coronavirus strain ZJU1617, complete genome	blastn	237833	3640	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Alphacoronavirus	Alphacoronavirus suis
24887568	24887568	PRJNA682078_P_NODE_256040_length_246_cov_0.890173_g254263_i0	PRJNA682078	256040	246	0.890173	2.18982558	Iflavirus sp.	1916690	Viruses	Viruses	455	1.4500000000000002e-123	NTclustered	gi\|2895513821\|tpg\|BK068531.1\|	1916690	g254263	i0	100	2	246	0	100	0	1	246	9980	9735	TPA_asm: Iflavirus sp. isolate WUR60 polyprotein gene, complete cds	blastn	492	455	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus sp.
24887812	24887812	PRJNA682078_P_NODE_265420_length_245_cov_0.895349_g263643_i0	PRJNA682078	265420	245	0.895349	2.19360505	Lentinula edodes deltaflexivirus 2	2778980	Viruses	Viruses	453	5.1900000000000006e-123	NTclustered	gi\|1928162793\|gb\|MN744724.1\|	2778980	g263643	i0	100	1	245	0	100	0	1	245	1669	1425	Lentinula edodes deltaflexivirus 2 isolate Le10WIL RNA-dependent RNA polymerase gene, partial cds; and hypothetical protein gene, complete cds	blastn	245	453	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Lentinula edodes deltaflexivirus 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);;