metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
792997	792997	PRJNA799842_P_NODE_11781_length_913_cov_4.797619_g10551_i0	PRJNA799842	11781	913	4.797619	43.80226147	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1565	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10551	i0	97.593	2.93209200438116	914	20	100	2	1	913	18	930	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2677	1565	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
793504	793504	PRJNA799842_P_NODE_143381_length_250_cov_0.870056_g141808_i0	PRJNA799842	143381	250	0.870056	2.17514	Zebrafish picornavirus 1	2304617	Viruses	Viruses	388	1.5199999999999998e-103	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g141808	i0	94.8	2.776	250	12	100	1	1	250	287	39	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	694	388	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
793694	793694	PRJNA799842_P_NODE_154181_length_248_cov_0.880000_g152608_i0	PRJNA799842	154181	248	0.88	2.1824	Tobamovirus odontoglossi	3432881	Viruses	Viruses	449	6.81e-122	NTclustered	gi\|1861660922\|dbj\|LC556233.1\|	12238	g152608	i0	99.593	16.8629032258065	246	1	99	0	1	246	15	260	Odontoglossum ringspot virus 1 ISC-2019-PKO gene for 183 kDa replicase protein, partial cds	blastn	4182	449	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus odontoglossi
3344401	3344401	PRJNA799842_P_NODE_135263_length_251_cov_0.865169_g133690_i0	PRJNA799842	135263	251	0.865169	2.17157419	brine shrimp yue-like virus 9	2900461	Viruses	Viruses	436	5.369999999999999e-118	NTclustered	gi\|2209094451\|gb\|OL472856.1\|	2900461	g133690	i0	98.008	3	251	5	100	0	1	251	876	626	MAG: Brine shrimp yue-like virus 9 isolate CK/00-16 segment 1 RNA-dependent RNA polymerase gene, complete cds	blastn	753	436	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 9
4622341	4622341	PRJNA799842_P_NODE_168504_length_245_cov_0.895349_g166931_i0	PRJNA799842	168504	245	0.895349	2.19360505	Potyvirus glycitessellati	3240532	Viruses	Viruses	448	2.41e-121	NTclustered	gi\|2621721683\|dbj\|LC786829.1\|	12222	g166931	i0	99.592	100	245	1	100	0	1	245	5367	5123	Soybean mosaic virus CC20s gene for polyprotein, complete cds	blastn	24500	448	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus glycitessellati
4623342	4623342	PRJNA799842_P_NODE_42944_length_434_cov_2.188366_g41372_i0	PRJNA799842	42944	434	2.188366	9.49750844	Tobamovirus tomatotessellati	3432892	Viruses	Viruses	802	0	NTclustered	gi\|2463200702\|gb\|ON987477.1\|	12253	g41372	i0	100	99.3271889400922	434	0	100	0	1	434	437	4	Tomato mosaic virus isolate NPPO-NL 41833930 RdRp, small replicase subunit, MP, and CP genes, complete cds	blastn	43108	802	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
5898876	5898876	PRJNA799842_P_NODE_62665_length_360_cov_1.052265_g61092_i0	PRJNA799842	62665	360	1.052265	3.788154	Zebrafish picornavirus 1	2304617	Viruses	Viruses	562	1.27e-155	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g61092	i0	94.972	2.96944444444444	358	18	99	0	1	358	2264	2621	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1069	562	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5899077	5899077	PRJNA799842_P_NODE_7225_length_1158_cov_1.277419_g6296_i0	PRJNA799842	7225	1158	1.277419	14.79251202	Tobamovirus tomatotessellati	3432892	Viruses	Viruses	2111	0	NTclustered	gi\|2744300783\|gb\|PP915779.1\|	12253	g6296	i0	99.568	99.2564766839378	1158	5	100	0	1	1158	3943	5100	Tomato mosaic virus isolate Pi20, complete genome	blastn	114939	2111	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
5899604	5899604	PRJNA799842_P_NODE_97905_length_294_cov_1.036199_g96332_i0	PRJNA799842	97905	294	1.036199	3.04642506	Alphacarmovirus dianthi	3047728	Viruses	Viruses	117	9.54e-22	NTclustered	gi\|2217167995\|gb\|OM867874.1\|	11986	g96332	i0	98.485	8.07823129251701	66	1	22	0	1	66	3201	3136	Carnation mottle virus isolate DSMZ PV-1234, partial sequence	blastn	2375	117	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Alphacarmovirus	Alphacarmovirus dianthi
9721214	9721214	PRJNA799842_P_NODE_121908_length_265_cov_1.203125_g120335_i0	PRJNA799842	121908	265	1.203125	3.18828125	Zebrafish picornavirus 1	2304617	Viruses	Viruses	451	2.04e-122	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g120335	i0	97.358	3	265	7	100	0	1	265	1417	1681	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	795	451	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
12272182	12272182	PRJNA799842_P_NODE_108870_length_280_cov_1.487923_g107297_i0	PRJNA799842	108870	280	1.487923	4.1661844	Guiyang Paspalum paspaloides solemo-like virus 1	2970294	Viruses	Viruses	473	4.649999999999999e-129	NTclustered	gi\|2320142004\|gb\|OM514387.1\|	2970294	g107297	i0	97.143	63.025	280	8	100	0	1	280	2336	2615	MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence	blastn	17647	473	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae		Guiyang Paspalum paspaloides solemo-like virus 1
12698249	12698249	PRJNA799842_P_NODE_129130_length_257_cov_1.255435_g127557_i0	PRJNA799842	129130	257	1.255435	3.22646795	Tobamovirus	12234	Viruses	Viruses	475	1.1699999999999999e-129	NTclustered	gi\|2085776112\|gb\|MZ388458.1\|	12253	g127557	i0	100	99.9922178988327	257	0	100	0	1	257	793	537	Tomato mosaic virus isolate ToMV-WF, complete genome	blastn	25698	475	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
13547912	13547912	PRJNA799842_P_NODE_188031_length_241_cov_0.916667_g186458_i0	PRJNA799842	188031	241	0.916667	2.20916747	Guiyang Paspalum paspaloides solemo-like virus 1	2970294	Viruses	Viruses	350	6.87e-92	NTclustered	gi\|2320142004\|gb\|OM514387.1\|	2970294	g186458	i0	92.917	0.995850622406639	240	17	99	0	2	241	1031	1270	MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence	blastn	240	350	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae		Guiyang Paspalum paspaloides solemo-like virus 1
14821192	14821192	PRJNA799842_P_NODE_108092_length_281_cov_1.466346_g106519_i0	PRJNA799842	108092	281	1.466346	4.12043226	Zebrafish picornavirus 1	2304617	Viruses	Viruses	409	1.33e-109	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g106519	i0	92.883	3	281	20	100	0	1	281	2716	2996	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	843	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14822455	14822455	PRJNA799842_P_NODE_176792_length_243_cov_0.905882_g175219_i0	PRJNA799842	176792	243	0.905882	2.20129326	Pestivirus ovis	3052622	Viruses	Viruses	52.8	0.022	NTclustered	gi\|3851352\|gb\|AF026726.1\|	60990	g175219	i0	100	0.11522633744856	28	0	12	0	183	210	200	173	Border disease virus strain D1586/2 polyprotein gene, partial cds and partial 3'-noncoding region	blastn	28	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus ovis
17371819	17371819	PRJNA799842_P_NODE_138074_length_251_cov_0.865169_g136501_i0	PRJNA799842	138074	251	0.865169	2.17157419	Potyvirus orionspassiflorae	3240573	Viruses	Viruses	459	1.1499999999999996e-124	NTclustered	gi\|1335762644\|gb\|KY614052.1\|	341167	g136501	i0	99.602	11.8366533864542	251	1	100	0	1	251	5882	5632	East Asian Passiflora virus isolate pt, complete genome	blastn	2971	459	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus orionspassiflorae
17372184	17372184	PRJNA799842_P_NODE_159094_length_247_cov_0.885057_g157521_i0	PRJNA799842	159094	247	0.885057	2.18609079	Guiyang Paspalum paspaloides solemo-like virus 1	2970294	Viruses	Viruses	296	9.34e-76	NTclustered	gi\|2320142004\|gb\|OM514387.1\|	2970294	g157521	i0	94.764	0.773279352226721	191	8	77	2	55	244	1619	1808	MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence	blastn	191	296	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae		Guiyang Paspalum paspaloides solemo-like virus 1
18645599	18645599	PRJNA799842_P_NODE_175_length_3964_cov_37.838859_g109_i0	PRJNA799842	175	3964	37.838859	1499.93237076	Alphacarmovirus dianthi	3047728	Viruses	Viruses	7055	0	NTclustered	gi\|2217167995\|gb\|OM867874.1\|	11986	g109	i0	98.789	46.0146316851665	3965	47	100	1	1	3964	3972	8	Carnation mottle virus isolate DSMZ PV-1234, partial sequence	blastn	182402	7055	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Alphacarmovirus	Alphacarmovirus dianthi
18646249	18646249	PRJNA799842_P_NODE_37855_length_465_cov_1.964286_g36284_i0	PRJNA799842	37855	465	1.964286	9.1339299	Zebrafish picornavirus 1	2304617	Viruses	Viruses	798	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g36284	i0	97.634	2.99784946236559	465	11	100	0	1	465	4057	4521	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1394	798	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19921641	19921641	PRJNA799842_P_NODE_38356_length_462_cov_1.658098_g36785_i0	PRJNA799842	38356	462	1.658098	7.66041276	Tobamovirus tomatotessellati	3432892	Viruses	Viruses	848	0	NTclustered	gi\|2085776112\|gb\|MZ388458.1\|	12253	g36785	i0	99.784	99.8528138528139	462	1	100	0	1	462	5854	6315	Tomato mosaic virus isolate ToMV-WF, complete genome	blastn	46132	848	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
21197247	21197247	PRJNA799842_P_NODE_40897_length_446_cov_1.959786_g39326_i0	PRJNA799842	40897	446	1.959786	8.74064556	Zebrafish picornavirus 1	2304617	Viruses	Viruses	671	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g39326	i0	94.292	2.95964125560538	438	25	98	0	9	446	5476	5039	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1320	671	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
21197645	21197645	PRJNA799842_P_NODE_57_length_6175_cov_7.528024_g18_i1	PRJNA799842	57	6175	7.528024	464.855482	Zebrafish picornavirus 1	2304617	Viruses	Viruses	10087	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g18	i1	96.148	3.00210526315789	6179	233	100	5	1	6175	969	7146	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	18538	10087	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22471223	22471223	PRJNA799842_P_NODE_178338_length_243_cov_0.905882_g176765_i0	PRJNA799842	178338	243	0.905882	2.20129326	Potexvirus ecspitayae	3433835	Viruses	Viruses	448	2.39e-121	NTclustered	gi\|385282600\|gb\|JF930327.1\|	1176736	g176765	i0	100	9.66666666666667	242	0	99	0	2	243	4257	4016	Pitaya virus X isolate P37, complete genome	blastn	2349	448	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus ecspitayae
22896100	22896100	PRJNA799842_P_NODE_11378_length_930_cov_2.256709_g10184_i0	PRJNA799842	11378	930	2.256709	20.9873937	Tobamovirus	12234	Viruses	Viruses	1696	0	NTclustered	gi\|2744300783\|gb\|PP915779.1\|	12253	g10184	i0	99.57	97.9698924731183	930	4	100	0	1	930	3164	2235	Tomato mosaic virus isolate Pi20, complete genome	blastn	91112	1696	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
22896518	22896518	PRJNA799842_P_NODE_178618_length_243_cov_0.905882_g177045_i0	PRJNA799842	178618	243	0.905882	2.20129326	Alphaendornavirus	2003394	Viruses	Viruses	388	1.47e-103	NTclustered	gi\|2837369272\|gb\|PQ408681.1\|	362693	g177045	i0	95.473	7	243	11	100	0	1	243	2187	1945	Oryza sativa alphaendornavirus isolate Andong polyprotein gene, complete cds	blastn	1701	388	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Alphaendornavirus oryzae
23748402	23748402	PRJNA799842_P_NODE_8079_length_1100_cov_9.037001_g18_i2	PRJNA799842	8079	1100	9.037001	99.407011	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1820	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g18	i2	96.545	3.47181818181818	1100	37	100	1	1	1100	8185	7087	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	3819	1820	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
25021217	25021217	PRJNA799842_P_NODE_31580_length_515_cov_2.748869_g30016_i0	PRJNA799842	31580	515	2.748869	14.15667535	Tobamovirus tomatotessellati	3432892	Viruses	Viruses	929	0	NTclustered	gi\|2744300783\|gb\|PP915779.1\|	12253	g30016	i0	99.223	99.9961165048544	515	4	100	0	1	515	5245	5759	Tomato mosaic virus isolate Pi20, complete genome	blastn	51498	929	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
25021440	25021440	PRJNA799842_P_NODE_40_length_7285_cov_8.778841_g18_i0	PRJNA799842	40	7285	8.778841	639.53856685	Zebrafish picornavirus 1	2304617	Viruses	Viruses	11860	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g18	i0	96.048	3.07288949897049	7288	284	100	4	1	7285	969	8255	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	22386	11860	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1

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