metadata: contig_metadata: 23 rows where bioproject = "PRJNA1012699" and tax

23 rows where bioproject = "PRJNA1012699" and tax_phylum = "Pisuviricota"

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_species
2708348	2708348	PRJNA1012699_P_NODE_263_length_641_cov_6.580986_g234_i0	PRJNA1012699	263	641	6.580986	42.18412026	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1101	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g234	i0	97.66	3	641	15	100	0	1	641	6267	5627	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1923	1101	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
3984559	3984559	PRJNA1012699_P_NODE_304_length_604_cov_3.156309_g274_i0	PRJNA1012699	304	604	3.156309	19.06410636	Zebrafish picornavirus 1	2304617	Viruses	Viruses	974	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g274	i0	95.847	2.99172185430464	602	25	99	0	3	604	1633	2234	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1807	974	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
10361293	10361293	PRJNA1012699_P_NODE_89_length_1103_cov_5.780583_g68_i0	PRJNA1012699	89	1103	5.780583	63.75983049	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1888	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g68	i0	97.721	3.28286491387126	1097	25	99	0	4	1100	7097	8193	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	3621	1888	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12911602	12911602	PRJNA1012699_P_NODE_131_length_885_cov_3.227833_g104_i0	PRJNA1012699	131	885	3.227833	28.56632205	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1471	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g104	i0	96.719	2.93220338983051	884	28	99	1	1	884	23	905	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2595	1471	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12911606	12911606	PRJNA1012699_P_NODE_151_length_824_cov_4.107856_g124_i0	PRJNA1012699	151	824	4.107856	33.84873344	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1341	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g124	i0	96.107	2.99514563106796	822	32	99	0	2	823	1709	888	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2468	1341	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
14186617	14186617	PRJNA1012699_P_NODE_1432_length_315_cov_2.231405_g1400_i0	PRJNA1012699	1432	315	2.231405	7.02892575	Zebrafish picornavirus 1	2304617	Viruses	Viruses	479	1.1399999999999996e-130	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1400	i0	94.249	3.00952380952381	313	18	99	0	2	314	2936	3248	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	948	479	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
14186625	14186625	PRJNA1012699_P_NODE_2012_length_279_cov_2.266990_g1980_i0	PRJNA1012699	2012	279	2.26699	6.3249021	Zebrafish picornavirus 1	2304617	Viruses	Viruses	466	7.74e-127	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1980	i0	97.101	2.96774193548387	276	8	99	0	3	278	3487	3212	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	828	466	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
18009885	18009885	PRJNA1012699_P_NODE_635_length_441_cov_3.847826_g603_i0	PRJNA1012699	635	441	3.847826	16.96891266	Zebrafish picornavirus 1	2304617	Viruses	Viruses	682	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g603	i0	94.582	3.00680272108844	443	21	99	3	1	440	2720	3162	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1326	682	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
20559164	20559164	PRJNA1012699_P_NODE_137_length_868_cov_4.533333_g110_i0	PRJNA1012699	137	868	4.533333	39.34933044	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1483	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g110	i0	97.683	2.98617511520737	863	20	99	0	4	866	6247	7109	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2592	1483	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23110310	23110310	PRJNA1012699_P_NODE_19_length_1799_cov_4.223638_g13_i0	PRJNA1012699	19	1799	4.223638	75.98324762	Zebrafish picornavirus 1	2304617	Viruses	Viruses	2952	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g13	i0	96.28	3.00055586436909	1801	64	99	1	1	1798	3986	5786	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	5398	2952	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
23110329	23110329	PRJNA1012699_P_NODE_319_length_595_cov_4.040230_g289_i0	PRJNA1012699	319	595	4.04023	24.0393685	Zebrafish picornavirus 1	2304617	Viruses	Viruses	998	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g289	i0	96.97	2.97478991596639	594	18	99	0	1	594	2221	2814	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1770	998	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
27730202	27730202	PRJNA1012699_P_NODE_344_length_576_cov_1.079523_g314_i0	PRJNA1012699	344	576	1.079523	6.21805248	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	244	6.38e-71	NR	WWZ85593.1	3132542	g314	i0	62.7	1.00520833333333	193	62	99.5	3	2	574	2404	2588	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	579	244	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
28108577	28108577	PRJNA1012699_P_NODE_1345_length_324_cov_2.342629_g1313_i0	PRJNA1012699	1345	324	2.342629	7.59011796	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	115	2.14e-27	NR	WWZ85593.1	3132542	g1313	i0	73.6	0.666666666666667	72	19	66.7	0	3	218	2910	2981	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	216	115	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
28234804	28234804	PRJNA1012699_P_NODE_1746_length_293_cov_1.054545_g1714_i0	PRJNA1012699	1746	293	1.054545	3.08981685	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	110	8.11e-26	NR	WWZ85593.1	3132542	g1714	i0	71.8	0.870307167235495	85	24	87	0	255	1	4	88	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	255	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
28266400	28266400	PRJNA1012699_P_NODE_2326_length_265_cov_1.432292_g2294_i0	PRJNA1012699	2326	265	1.432292	3.7955738	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	147	8.07e-39	NR	WWZ85593.1	3132542	g2294	i0	79.3	0.984905660377358	87	18	98.5	0	263	3	1602	1688	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	261	147	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
28866493	28866493	PRJNA1012699_P_NODE_1088_length_354_cov_1.106762_g1056_i0	PRJNA1012699	1088	354	1.106762	3.91793748	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	110	1.81e-25	NR	WWZ85593.1	3132542	g1056	i0	50.4	0.991525423728814	117	46	89	3	352	38	797	913	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	351	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
28961504	28961504	PRJNA1012699_P_NODE_528_length_475_cov_2.238806_g496_i0	PRJNA1012699	528	475	2.238806	10.6343285	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	240	4.97e-70	NR	WWZ85593.1	3132542	g496	i0	69.8	1.00421052631579	159	46	99.2	1	3	473	2592	2750	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	477	240	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
29655472	29655472	PRJNA1012699_P_NODE_3550_length_245_cov_1.354651_g3518_i0	PRJNA1012699	3550	245	1.354651	3.31889495	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	134	2.42e-34	NR	WWZ85593.1	3132542	g3518	i0	79	0.991836734693878	81	17	99.2	0	3	245	2316	2396	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	243	134	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
30603461	30603461	PRJNA1012699_P_NODE_3033_length_250_cov_0.881356_g3001_i0	PRJNA1012699	3033	250	0.881356	2.20339	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	70.9	5.29e-12	NR	WWZ85593.1	3132542	g3001	i0	47.9	0.852	71	37	85.2	0	213	1	475	545	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	213	70.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
30698307	30698307	PRJNA1012699_P_NODE_1394_length_319_cov_1.231707_g1362_i0	PRJNA1012699	1394	319	1.231707	3.92914533	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	142	7.409999999999999e-37	NR	WWZ85593.1	3132542	g1362	i0	67.3	0.978056426332288	104	34	97.8	0	7	318	1034	1137	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	312	142	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
30698310	30698310	PRJNA1012699_P_NODE_794_length_403_cov_1.684848_g762_i0	PRJNA1012699	794	403	1.684848	6.78993744	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	122	4.3e-29	NR	WWZ85593.1	3132542	g762	i0	41.3	1.40694789081886	189	55	99	5	400	2	1798	1986	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	567	122	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
31709998	31709998	PRJNA1012699_P_NODE_1977_length_281_cov_1.471154_g1945_i0	PRJNA1012699	1977	281	1.471154	4.13394274	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	127	1.08e-31	NR	WWZ85593.1	3132542	g1945	i0	59.8	0.98220640569395	92	37	98.2	0	278	3	2739	2830	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	276	127	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
32501171	32501171	PRJNA1012699_P_NODE_2539_length_256_cov_1.699454_g2507_i0	PRJNA1012699	2539	256	1.699454	4.35060224	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	100	2.87e-22	NR	WWZ85593.1	3132542	g2507	i0	63.1	0.984375	84	30	97.3	1	254	6	1377	1460	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	252	100	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4

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