metadata: contig_metadata: 14 rows where bioproject = "PRJNA1255065" and tax

14 rows where bioproject = "PRJNA1255065" and tax_phylum = "Kitrinoviricota"

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
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
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
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
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
28873826	28873826	PRJNA1255065_P_NODE_139928_length_164_cov_0.904348_g137700_i0	PRJNA1255065	139928	164	0.904348	1.48313072	Tolivirales sp.	2809914	Viruses	Viruses	47	4.08e-4	NR	WRQ65890.1	2809914	g137700	i0	44.4	2.01219512195122	54	29	97	1	6	164	167	220	WRQ65890.1 polyprotein, partial [Tolivirales sp.]	diamond	330	47	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Tolivirales sp.

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