metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1255065" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1255065" 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
360354	360354	PRJNA1255065_P_NODE_58081_length_254_cov_0.770732_g55853_i0	PRJNA1255065	58081	254	0.770732	1.95765928	Pestivirus bovis	3052619	Viruses	Viruses	412	9.18e-111	NTclustered	gi\|1408941610\|gb\|MG950357.1\|	981676	g55853	i0	96.047	99.4370078740157	253	10	99	0	2	254	8294	8042	Bovine viral diarrhea virus 1b isolate B1A polyprotein gene, partial cds	blastn	25257	412	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
1053060	1053060	PRJNA1255065_P_NODE_115401_length_168_cov_0.873950_g113173_i0	PRJNA1255065	115401	168	0.87395	1.468236	Tobamovirus	12234	Viruses	Viruses	311	2.11e-80	NTclustered	gi\|2837380181\|gb\|PP099897.1\|	1761477	g113173	i0	100	100	168	0	100	0	1	168	3065	3232	Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome	blastn	16800	311	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus fructirugosum
2910695	2910695	PRJNA1255065_P_NODE_130263_length_165_cov_0.896552_g128035_i0	PRJNA1255065	130263	165	0.896552	1.4793108	Pestivirus bovis	3052619	Viruses	Viruses	252	1.27e-62	NTclustered	gi\|2289973227\|gb\|OP020143.1\|	3052619	g128035	i0	94.479	98.8484848484848	163	9	99	0	1	163	10363	10525	MAG: Pestivirus A isolate BVDV1_NSWp0.3 polyprotein gene, complete cds	blastn	16310	252	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
4187644	4187644	PRJNA1255065_P_NODE_72164_length_215_cov_0.957831_g69936_i0	PRJNA1255065	72164	215	0.957831	2.05933665	Pestivirus bovis	3052619	Viruses	Viruses	379	7.659999999999998e-101	NTclustered	gi\|800924328\|gb\|KP941589.1\|	11099	g69936	i0	98.598	99.5395348837209	214	3	99	0	2	215	10750	10537	Bovine viral diarrhea virus 1 strain USMARC-55923 polyprotein gene, complete cds	blastn	21401	379	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
5464054	5464054	PRJNA1255065_P_NODE_99665_length_174_cov_1.864000_g97437_i0	PRJNA1255065	99665	174	1.864	3.24336	Zebrafish picornavirus 1	2304617	Viruses	Viruses	289	1.02e-73	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g97437	i0	97.076	2.51724137931034	171	5	98	0	4	174	8	178	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	438	289	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6738440	6738440	PRJNA1255065_P_NODE_85726_length_192_cov_1.055944_g83498_i0	PRJNA1255065	85726	192	1.055944	2.02741248	Pestivirus bovis	3052619	Viruses	Viruses	322	1.14e-83	NTclustered	gi\|459284076\|gb\|JX297517.1\|	981676	g83498	i0	96.875	100	192	6	100	0	1	192	11202	11011	Bovine viral diarrhea virus type 1b isolate Hercules polyprotein gene, complete cds	blastn	19200	322	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
8013750	8013750	PRJNA1255065_P_NODE_34007_length_412_cov_1.123967_g31787_i0	PRJNA1255065	34007	412	1.123967	4.63074404	Pestivirus bovis	3052619	Viruses	Viruses	725	0	NTclustered	gi\|1540352923\|gb\|MH231153.1\|	11099	g31787	i0	98.537	99.9854368932039	410	6	99	0	3	412	5514	5105	Bovine viral diarrhea virus 1 isolate Nebraska polyprotein gene, complete cds	blastn	41194	725	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
9288657	9288657	PRJNA1255065_P_NODE_61708_length_241_cov_1.661458_g59480_i0	PRJNA1255065	61708	241	1.661458	4.00411378	Zebrafish picornavirus 1	2304617	Viruses	Viruses	440	3.959999999999999e-119	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g59480	i0	99.585	3	241	1	100	0	1	241	4456	4696	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	723	440	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9288918	9288918	PRJNA1255065_P_NODE_94268_length_181_cov_0.787879_g92040_i0	PRJNA1255065	94268	181	0.787879	1.42606099	Pestivirus bovis	3052619	Viruses	Viruses	291	2.9899999999999993e-74	NTclustered	gi\|2858850717\|gb\|PQ613792.1\|	11099	g92040	i0	95.58	99.4861878453039	181	8	100	0	1	181	3257	3077	Bovine viral diarrhea virus 1 isolate USMARC/PI-91-21/MDBK polyprotein gene, complete cds	blastn	18007	291	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
10564820	10564820	PRJNA1255065_P_NODE_94929_length_180_cov_1.190840_g92701_i0	PRJNA1255065	94929	180	1.19084	2.143512	Zebrafish picornavirus 1	2304617	Viruses	Viruses	272	1.08e-68	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g92701	i0	93.889	3	180	11	100	0	1	180	1472	1651	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	540	272	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13114591	13114591	PRJNA1255065_P_NODE_92291_length_183_cov_1.365672_g90063_i0	PRJNA1255065	92291	183	1.365672	2.49917976	Pestivirus bovis	3052619	Viruses	Viruses	289	1.0899999999999998e-73	NTclustered	gi\|1248821481\|emb\|LT907991.1\|	11099	g90063	i0	95.082	70.6174863387978	183	9	100	0	1	183	10616	10434	Bovine viral diarrhea virus 1 isolate VE_138cp_05 genome assembly, complete genome: monopartite	blastn	12923	289	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
13806682	13806682	PRJNA1255065_P_NODE_27951_length_487_cov_1.070776_g25752_i0	PRJNA1255065	27951	487	1.070776	5.21467912	Pestivirus	11095	Viruses	Viruses	784	0	NTclustered	gi\|530291193\|gb\|KC963967.1\|	11099	g25752	i0	95.688	99.8829568788501	487	21	100	0	1	487	873	1359	Bovine viral diarrhea virus 1 isolate 12F004, complete genome	blastn	48643	784	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
16355641	16355641	PRJNA1255065_P_NODE_31013_length_446_cov_1.403023_g28800_i0	PRJNA1255065	31013	446	1.403023	6.25748258	Pestivirus	11095	Viruses	Viruses	754	0	NTclustered	gi\|800924334\|gb\|KP941592.1\|	11099	g28800	i0	97.309	94.8139013452915	446	9	100	3	1	446	456	14	Bovine viral diarrhea virus 1 strain USMARC-55926 polyprotein gene, complete cds	blastn	42287	758	0.994722955145119	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
16936990	16936990	PRJNA1255065_P_NODE_100894_length_173_cov_1.419355_g98666_i0	PRJNA1255065	100894	173	1.419355	2.45548415	Zebrafish picornavirus 1	2304617	Viruses	Viruses	270	3.69e-68	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g98666	i0	94.798	3	173	9	100	0	1	173	2335	2163	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	519	270	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16937512	16937512	PRJNA1255065_P_NODE_153654_length_162_cov_0.884956_g151426_i0	PRJNA1255065	153654	162	0.884956	1.43362872	Totivirus sp.	2776824	Viruses	Viruses	185	1.2699999999999999e-42	NTclustered	gi\|1918615619\|gb\|MT949668.1\|	2776824	g151426	i0	87.5	0.987654320987654	160	20	99	0	1	160	547	706	Totivirus sp. isolate sequence_10295 genomic sequence	blastn	160	185	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
16938006	16938006	PRJNA1255065_P_NODE_95214_length_179_cov_2.307692_g92986_i0	PRJNA1255065	95214	179	2.307692	4.13076868	Zebrafish picornavirus 1	2304617	Viruses	Viruses	276	8.27e-70	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g92986	i0	99.342	2.91620111731844	152	1	100	0	1	152	1148	1299	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	522	276	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
20761682	20761682	PRJNA1255065_P_NODE_140377_length_164_cov_0.904348_g138149_i0	PRJNA1255065	140377	164	0.904348	1.48313072	Pestivirus tauri	3052626	Viruses	Viruses	296	5.73e-76	NTclustered	gi\|998226330\|gb\|KT832820.1\|	54315	g138149	i0	99.387	99.3536585365854	163	1	99	0	1	163	11303	11465	Bovine viral diarrhea virus 2 strain USMARC-60767, complete genome	blastn	16294	296	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus tauri
22037006	22037006	PRJNA1255065_P_NODE_36258_length_388_cov_0.908555_g34037_i0	PRJNA1255065	36258	388	0.908555	3.5251934	Pestivirus bovis	3052619	Viruses	Viruses	645	1.3399999999999995e-180	NTclustered	gi\|2858850691\|gb\|PQ613779.1\|	11099	g34037	i0	96.649	100	388	13	100	0	1	388	7728	8115	Bovine viral diarrhea virus 1 isolate USMARC/PI-86-21/Serum polyprotein gene, complete cds	blastn	38800	645	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
23311939	23311939	PRJNA1255065_P_NODE_102179_length_172_cov_0.910569_g99951_i0	PRJNA1255065	102179	172	0.910569	1.56617868	Pestivirus bovis	3052619	Viruses	Viruses	285	1.31e-72	NTclustered	gi\|1129879417\|gb\|KX170076.1\|	11099	g99951	i0	97.041	97.8953488372093	169	5	98	0	1	169	74	242	Bovine viral diarrhea virus 1 isolate V078 E1 gene, partial cds	blastn	16838	285	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
23312348	23312348	PRJNA1255065_P_NODE_143879_length_163_cov_0.912281_g141651_i0	PRJNA1255065	143879	163	0.912281	1.48701803	Zebrafish picornavirus 1	2304617	Viruses	Viruses	283	4.43e-72	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g141651	i0	98.148	2.98159509202454	162	3	99	0	2	163	7454	7293	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	486	283	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);;