metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA841653" 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
830303	830303	PRJNA841653_P_NODE_25701_length_322_cov_1.196787_g25027_i0	PRJNA841653	25701	322	1.196787	3.85365414	Ripalen virus	3130538	Viruses	Viruses	418	2.589999999999999e-112	NTclustered	gi\|2717320031\|gb\|PP172840.1\|	3130538	g25027	i0	94.526	247.416149068323	274	10	84	5	1	272	4273	4543	MAG: Ripalen virus isolate KCAP1_k141_90819 genomic sequence	blastn	79668	418	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripalen virus
2106542	2106542	PRJNA841653_P_NODE_822_length_2927_cov_4.409951_g714_i0	PRJNA841653	822	2927	4.409951	129.07926577	Zebrafish picornavirus 1	2304617	Viruses	Viruses	4867	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g714	i0	96.78	2.99214212504271	2919	91	99	1	1	2919	6512	3597	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	8758	4867	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
3381287	3381287	PRJNA841653_P_NODE_33263_length_283_cov_36.876190_g32589_i0	PRJNA841653	33263	283	36.87619	104.3596177	Chronazanb virus	3129852	Viruses	Viruses	135	2.5200000000000003e-27	NTclustered	gi\|2717318485\|gb\|PP172249.1\|	3129852	g32589	i0	94.318	41.7455830388693	88	5	31	0	57	144	4485	4398	MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence	blastn	11814	135	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazanb virus
4658626	4658626	PRJNA841653_P_NODE_21284_length_353_cov_2.128571_g20610_i0	PRJNA841653	21284	353	2.128571	7.51385563	Amaranthus cryptic virus 1	2593933	Viruses	Viruses	542	1.6199999999999999e-149	NTclustered	gi\|1722559079\|gb\|MH898472.1\|	2593933	g20610	i0	95.322	0.968838526912181	342	14	97	2	3	343	1221	1561	Amaranthus cryptic virus 1 isolate Won segment RNA2, complete sequence	blastn	342	542	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Amaranthus cryptic virus 1
7208792	7208792	PRJNA841653_P_NODE_39406_length_263_cov_1.147368_g38732_i0	PRJNA841653	39406	263	1.147368	3.01757784	Zebrafish picornavirus 1	2304617	Viruses	Viruses	448	2.6199999999999995e-121	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g38732	i0	98.054	3.91254752851711	257	5	98	0	7	263	7854	8110	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1029	448	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7608551	7608551	PRJNA841653_P_NODE_13226_length_453_cov_4.676316_g12555_i0	PRJNA841653	13226	453	4.676316	21.18371148	Viruses	10239	Viruses	Viruses	337	1.0799999999999995e-87	NTclustered	gi\|2284073649\|gb\|ON872653.1\|	2808997	g12555	i0	82.576	17.476821192053	396	55	86	13	65	453	336	724	MAG: Botourmiaviridae sp. isolate TIGMIC_34 hypothetical protein gene, complete cds	blastn	7917	337	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
8482962	8482962	PRJNA841653_P_NODE_1787_length_1429_cov_3.328171_g1450_i0	PRJNA841653	1787	1429	3.328171	47.55956359	Amaranthus cryptic virus 2	2593934	Viruses	Viruses	1984	0	NTclustered	gi\|1722559081\|gb\|MH898473.1\|	2593934	g1450	i0	92.396	2.01049685094472	1394	102	97	4	35	1426	3	1394	Amaranthus cryptic virus 2 isolate Won segment RNA1, complete sequence	blastn	2873	1984	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Amaranthus cryptic virus 2
9758637	9758637	PRJNA841653_P_NODE_4128_length_851_cov_3.107969_g3555_i0	PRJNA841653	4128	851	3.107969	26.44881619	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1478	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g3555	i0	98.118	2.94124559341951	850	13	99	3	1	849	36	883	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2503	1478	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
12309464	12309464	PRJNA841653_P_NODE_2550_length_1114_cov_3.205572_g2106_i0	PRJNA841653	2550	1114	3.205572	35.71007208	Amaranthus cryptic virus 1	2593933	Viruses	Viruses	1480	0	NTclustered	gi\|1722559079\|gb\|MH898472.1\|	2593933	g2106	i0	90.876	0.993716337522442	1107	95	99	6	4	1107	14	1117	Amaranthus cryptic virus 1 isolate Won segment RNA2, complete sequence	blastn	1107	1480	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Amaranthus cryptic virus 1
12309533	12309533	PRJNA841653_P_NODE_28310_length_306_cov_1.785408_g27636_i0	PRJNA841653	28310	306	1.785408	5.46334848	Amaranthus tuberculatus amalgavirus 2	2982038	Viruses	Viruses	283	9.3e-72	NTclustered	gi\|2322080777\|tpg\|BK062279.1\|	2982038	g27636	i0	83.828	0.990196078431373	303	43	98	6	4	303	1344	1643	TPA_asm: Amaranthus tuberculatus amalgavirus 2, complete genome	blastn	303	283	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Amalgaviridae	Amalgavirus	Amaranthus tuberculatus amalgavirus 2
13584072	13584072	PRJNA841653_P_NODE_30011_length_297_cov_1.937500_g29337_i0	PRJNA841653	30011	297	1.9375	5.754375	Zebrafish picornavirus 1	2304617	Viruses	Viruses	484	2.3e-132	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g29337	i0	96.575	2.95959595959596	292	10	98	0	1	292	3424	3133	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	879	484	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13584652	13584652	PRJNA841653_P_NODE_6211_length_683_cov_4.424590_g5581_i0	PRJNA841653	6211	683	4.42459	30.2199497	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1000	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g5581	i0	93.225	2.99414348462665	679	46	99	0	1	679	3245	2567	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2045	1000	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14858033	14858033	PRJNA841653_P_NODE_1572_length_1598_cov_5.824918_g1286_i0	PRJNA841653	1572	1598	5.824918	93.08218964	Zebrafish picornavirus 1	2304617	Viruses	Viruses	2603	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1286	i0	96.28	2.97747183979975	1586	59	99	0	13	1598	1000	2585	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	4758	2603	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
18681470	18681470	PRJNA841653_P_NODE_21215_length_354_cov_1.334520_g20541_i0	PRJNA841653	21215	354	1.33452	4.7242008	Zebrafish picornavirus 1	2304617	Viruses	Viruses	558	1.62e-154	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g20541	i0	95.429	2.96892655367232	350	16	99	0	3	352	2633	2982	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1051	558	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
19956755	19956755	PRJNA841653_P_NODE_26996_length_314_cov_1.116183_g26322_i0	PRJNA841653	26996	314	1.116183	3.50481462	Skokie tombus-like virus	2789423	Viruses	Viruses	451	2.48e-122	NTclustered	gi\|1933757594\|gb\|MW177751.1\|	2789423	g26322	i0	97.71	0.834394904458599	262	6	83	0	40	301	1270	1009	Skokie tombus-like virus strain USAdp coat protein gene, partial cds	blastn	262	451	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Skokie tombus-like virus
21233071	21233071	PRJNA841653_P_NODE_63437_length_233_cov_2.381250_g62763_i0	PRJNA841653	63437	233	2.38125	5.5483125	Zebrafish picornavirus 1	2304617	Viruses	Viruses	407	3.86e-109	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g62763	i0	98.276	2.98712446351931	232	4	99	0	1	232	6610	6841	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	696	407	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
25056472	25056472	PRJNA841653_P_NODE_26380_length_317_cov_2.852459_g25706_i0	PRJNA841653	26380	317	2.852459	9.04229503	Zebrafish picornavirus 1	2304617	Viruses	Viruses	544	4.0199999999999996e-150	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g25706	i0	97.778	2.96845425867508	315	7	99	0	1	315	7481	7795	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	941	544	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
25057178	25057178	PRJNA841653_P_NODE_6320_length_676_cov_2.565506_g5689_i0	PRJNA841653	6320	676	2.565506	17.34282056	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1123	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g5689	i0	96.87	2.97781065088757	671	21	99	0	6	676	6726	7396	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	2013	1123	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
25057278	25057278	PRJNA841653_P_NODE_980_length_2431_cov_3.246395_g829_i0	PRJNA841653	980	2431	3.246395	78.91986245	Hangzhou mito-like virus 9	3028986	Viruses	Viruses	2758	0	NTclustered	gi\|2465104871\|gb\|OQ363045.1\|	3028986	g829	i0	91.373	0.829699712052653	2017	170	83	4	251	2265	2015	1	MAG: Hangzhou mito-like virus 9 isolate gl067 genomic sequence	blastn	2017	2758	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Hangzhou mito-like virus 9

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