metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA533623" 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_genus	tax_species
506753	506753	PRJNA533623_P_NODE_47761_length_304_cov_11.106996_g45982_i0	PRJNA533623	47761	304	11.106996	33.76526784	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.028	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g45982	i0	100	0.0921052631578947	28	0	9	0	277	304	85	58	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
1782659	1782659	PRJNA533623_P_NODE_77022_length_202_cov_8.141844_g75241_i0	PRJNA533623	77022	202	8.141844	16.44652488	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.018	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g75241	i0	100	0.138613861386139	28	0	14	0	175	202	85	58	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
4333823	4333823	PRJNA533623_P_NODE_57104_length_265_cov_1.911765_g55324_i0	PRJNA533623	57104	265	1.911765	5.06617725	Sopolycivirus gammalasii	3432535	Viruses	Viruses	453	5.68e-123	NTclustered	gi\|1236513340\|ref\|NC_035456.1\|	2018503	g55324	i0	97.719	2.96981132075472	263	6	99	0	3	265	4457	4195	Lasius niger virus 1 isolate Cambridge-Lni, complete genome	blastn	787	453	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Sopolycivirus gammalasii
5609647	5609647	PRJNA533623_P_NODE_13765_length_635_cov_35.867596_g12088_i0	PRJNA533623	13765	635	35.867596	227.7592346	Porcine bastrovirus	2588662	Viruses	Viruses	65.8	8.1e-6	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g12088	i0	100	1.71181102362205	35	0	6	0	175	209	41	7	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	1087	65.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
5609734	5609734	PRJNA533623_P_NODE_1725_length_1556_cov_31.658194_g1096_i0	PRJNA533623	1725	1556	31.658194	492.60149864	Senecavirus valles	3241303	Viruses	Viruses	1923	0	NTclustered	gi\|1776925997\|gb\|MN233021.1\|	390157	g1096	i0	98.707	97.5443444730077	1083	14	98	0	469	1551	5162	6244	Senecavirus A isolate USA/IA05-401302/2005, complete genome	blastn	151779	1923	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Senecavirus	Senecavirus valles
11985003	11985003	PRJNA533623_P_NODE_30030_length_414_cov_3.036827_g28260_i0	PRJNA533623	30030	414	3.036827	12.57246378	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	678	0	NTclustered	gi\|1851856049\|gb\|MT138136.1\|	3003959	g28260	i0	98.691	2.75603864734299	382	5	92	0	17	398	2825	2444	MAG: Picornavirales sp. isolate zftwig05rna4 genomic sequence, sequence	blastn	1141	678	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
13260415	13260415	PRJNA533623_P_NODE_44671_length_319_cov_29.546512_g42897_i0	PRJNA533623	44671	319	29.546512	94.25337328	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.03	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g42897	i0	100	0.0877742946708464	28	0	9	0	292	319	85	58	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
13260872	13260872	PRJNA533623_P_NODE_66091_length_232_cov_12.222222_g64310_i0	PRJNA533623	66091	232	12.222222	28.35555504	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.021	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g64310	i0	100	0.120689655172414	28	0	12	0	160	187	41	14	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
13261051	13261051	PRJNA533623_P_NODE_74591_length_207_cov_14.650685_g72810_i0	PRJNA533623	74591	207	14.650685	30.32691795	Porcine bastrovirus	2588662	Viruses	Viruses	54.7	0.005	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g72810	i0	100	0.140096618357488	29	0	14	0	1	29	15	43	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	29	54.7	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
14535312	14535312	PRJNA533623_P_NODE_40132_length_344_cov_1.713781_g38358_i0	PRJNA533623	40132	344	1.713781	5.89540664	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.033	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g38358	i0	100	0.0813953488372093	28	0	8	0	317	344	85	58	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
15808615	15808615	PRJNA533623_P_NODE_16793_length_574_cov_4.571150_g15069_i0	PRJNA533623	16793	574	4.57115	26.238401	Senecavirus valles	3241303	Viruses	Viruses	1050	0	NTclustered	gi\|1776925997\|gb\|MN233021.1\|	390157	g15069	i0	99.652	99.8257839721254	575	1	100	1	1	574	7201	6627	Senecavirus A isolate USA/IA05-401302/2005, complete genome	blastn	57300	1050	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Senecavirus	Senecavirus valles
15809219	15809219	PRJNA533623_P_NODE_41393_length_336_cov_19.647273_g39619_i0	PRJNA533623	41393	336	19.647273	66.01483728	Sopolycivirus gammalasii	3432535	Viruses	Viruses	451	2.67e-122	NTclustered	gi\|1236513340\|ref\|NC_035456.1\|	2018503	g39619	i0	92.675	1.86904761904762	314	21	93	2	24	336	3054	3366	Lasius niger virus 1 isolate Cambridge-Lni, complete genome	blastn	628	451	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Sopolycivirus gammalasii
19632368	19632368	PRJNA533623_P_NODE_31456_length_402_cov_8.029326_g29685_i0	PRJNA533623	31456	402	8.029326	32.27789052	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.039	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g29685	i0	96.875	0.0796019900497512	32	0	8	1	371	402	45	15	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	32	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
19633425	19633425	PRJNA533623_P_NODE_79076_length_192_cov_12.587786_g77295_i0	PRJNA533623	79076	192	12.587786	24.16854912	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.017	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g77295	i0	100	0.145833333333333	28	0	15	0	165	192	42	15	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
19633470	19633470	PRJNA533623_P_NODE_8516_length_800_cov_32.870095_g7046_i0	PRJNA533623	8516	800	32.870095	262.96076	Porcine bastrovirus	2588662	Viruses	Viruses	56.5	0.006	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g7046	i0	100	0.0375	30	0	4	0	771	800	42	13	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	30	56.5	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
22182615	22182615	PRJNA533623_P_NODE_15038_length_608_cov_6.217550_g13336_i0	PRJNA533623	15038	608	6.21755	37.802704	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	54.7	0.017	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g13336	i0	100	0.0476973684210526	29	0	5	0	1	29	58	86	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	29	54.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
22183871	22183871	PRJNA533623_P_NODE_67298_length_228_cov_9.461078_g65517_i0	PRJNA533623	67298	228	9.461078	21.57125784	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.02	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g65517	i0	100	0.12280701754386	28	0	12	0	1	28	16	43	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
23458517	23458517	PRJNA533623_P_NODE_31959_length_398_cov_7.341246_g30188_i0	PRJNA533623	31959	398	7.341246	29.21815908	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.038	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g30188	i0	100	0.070351758793969807	28	0	7	0	371	398	42	15	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
23458528	23458528	PRJNA533623_P_NODE_32479_length_394_cov_7.768769_g30708_i0	PRJNA533623	32479	394	7.768769	30.60894986	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.038	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g30708	i0	100	0.0710659898477157	28	0	7	0	1	28	58	85	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
24733274	24733274	PRJNA533623_P_NODE_80140_length_183_cov_20.139344_g78359_i0	PRJNA533623	80140	183	20.139344	36.85499952	Porcine bastrovirus	2588662	Viruses	Viruses	58.4	3.35e-4	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g78359	i0	100	0.322404371584699	31	0	17	0	1	31	13	43	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	59	58.4	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
25344381	25344381	PRJNA533623_P_NODE_55420_length_271_cov_10.261905_g53640_i0	PRJNA533623	55420	271	10.261905	27.80976255	root	1	Root_unresolved	Root_unresolved	420	5.91e-113	NTclustered	gi\|9790340\|ref\|NC_001555.1\|	12227	g53640	i0	100	45.2140221402214	227	0	84	0	24	250	6818	6592	Tobacco etch virus, complete genome	blastn	12253	420	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus nicotianainsculpentis

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