metadata: contig_metadata: 26 rows where bioproject = "PRJNA564013", tax_kingdom = "Orthornavirae" and tax

26 rows where bioproject = "PRJNA564013", tax_kingdom = "Orthornavirae" 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
551945	551945	PRJNA564013_P_NODE_364341_length_187_cov_12.738095_g361489_i0	PRJNA564013	364341	187	12.738095	23.82023765	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.016	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g361489	i0	100	0.149732620320856	28	0	15	0	37	64	15	42	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
553027	553027	PRJNA564013_P_NODE_90761_length_427_cov_11.278689_g87928_i0	PRJNA564013	90761	427	11.278689	48.16000203	Dicistroviridae sp.	1955144	Viruses	Viruses	614	4.19e-171	NTclustered	gi\|2672713543\|gb\|OR723710.1\|	1955144	g87928	i0	94.059	3.7751756440281	404	24	95	0	24	427	2960	3363	MAG: Dicistroviridae sp. isolate RPGXC15-17/86 genomic sequence	blastn	1612	614	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
4378609	4378609	PRJNA564013_P_NODE_327664_length_209_cov_7.472973_g324812_i0	PRJNA564013	327664	209	7.472973	15.61851357	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.018	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g324812	i0	100	0.133971291866029	28	0	13	0	182	209	44	17	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
5650348	5650348	PRJNA564013_P_NODE_108465_length_397_cov_6.973214_g105625_i0	PRJNA564013	108465	397	6.973214	27.68365958	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.038	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g105625	i0	100	0.0705289672544081	28	0	7	0	370	397	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
5652394	5652394	PRJNA564013_P_NODE_189885_length_315_cov_17.519685_g187034_i0	PRJNA564013	189885	315	17.519685	55.18700775	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.029	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g187034	i0	100	0.0888888888888889	28	0	9	0	288	315	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
8204667	8204667	PRJNA564013_P_NODE_3527_length_1681_cov_3.764815_g2655_i0	PRJNA564013	3527	1681	3.764815	63.28654015	Nepovirus avii	3047741	Viruses	Viruses	2876	0	NTclustered	gi\|2054359675\|gb\|MW057708.1\|	12615	g2655	i0	97.56	66.7858417608566	1680	41	99	0	1	1680	6208	7887	Cherry leaf roll virus isolate DSMZ PV-0275 segment RNA1 polyprotein 1 gene, complete cds	blastn	112267	2876	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus avii
8204950	8204950	PRJNA564013_P_NODE_371427_length_177_cov_4.577586_g368575_i0	PRJNA564013	371427	177	4.577586	8.10232722	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.015	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g368575	i0	100	0.15819209039548	28	0	16	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
10754560	10754560	PRJNA564013_P_NODE_275689_length_241_cov_103.350000_g272837_i0	PRJNA564013	275689	241	103.35	249.0735	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g272837	i0	100	0.493775933609959	30	0	12	0	1	30	56	85	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	119	56.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
10755332	10755332	PRJNA564013_P_NODE_317409_length_215_cov_1.733766_g314557_i0	PRJNA564013	317409	215	1.733766	3.7275969	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.019	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g314557	i0	100	0.130232558139535	28	0	13	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
10755489	10755489	PRJNA564013_P_NODE_325229_length_210_cov_45.315436_g322377_i0	PRJNA564013	325229	210	45.315436	95.1624156	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.018	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g322377	i0	100	0.133333333333333	28	0	13	0	183	210	42	15	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
10756068	10756068	PRJNA564013_P_NODE_352709_length_196_cov_11.822222_g349857_i0	PRJNA564013	352709	196	11.822222	23.17155512	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	54.7	0.005	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g349857	i0	100	0.147959183673469	29	0	15	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
10756239	10756239	PRJNA564013_P_NODE_361989_length_190_cov_3.697674_g359137_i0	PRJNA564013	361989	190	3.697674	7.0255806	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.016	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g359137	i0	100	0.147368421052632	28	0	15	0	163	190	42	15	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
10756293	10756293	PRJNA564013_P_NODE_365089_length_186_cov_8.800000_g362237_i0	PRJNA564013	365089	186	8.8	16.368	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	54.7	0.004	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g362237	i0	100	0.155913978494624	29	0	16	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
12031114	12031114	PRJNA564013_P_NODE_371010_length_177_cov_11.965517_g368158_i0	PRJNA564013	371010	177	11.965517	21.17896509	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.015	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g368158	i0	100	0.15819209039548	28	0	16	0	150	177	42	15	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
17126590	17126590	PRJNA564013_P_NODE_204694_length_301_cov_40.870833_g201843_i0	PRJNA564013	204694	301	40.870833	123.02120733	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.028	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g201843	i0	100	0.0930232558139535	28	0	9	0	274	301	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
17130694	17130694	PRJNA564013_P_NODE_84934_length_440_cov_19.036939_g82104_i0	PRJNA564013	84934	440	19.036939	83.7625316	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	54.7	0.012	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g82104	i0	100	0.0659090909090909	29	0	7	0	412	440	87	59	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
19678462	19678462	PRJNA564013_P_NODE_366656_length_184_cov_5.089431_g363804_i0	PRJNA564013	366656	184	5.089431	9.36455304	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.016	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g363804	i0	100	0.152173913043478	28	0	15	0	157	184	43	16	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
19678992	19678992	PRJNA564013_P_NODE_57656_length_526_cov_2.836559_g54872_i0	PRJNA564013	57656	526	2.836559	14.92030034	Nepovirus avii	3047741	Viruses	Viruses	664	0	NTclustered	gi\|2108668855\|gb\|MZ291950.1\|	12615	g54872	i0	89.524	11.532319391635	525	53	99	2	2	525	6156	5633	Cherry leaf roll virus isolate 19SP057 segment RNA1, complete sequence	blastn	6066	664	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus avii
20950467	20950467	PRJNA564013_P_NODE_180337_length_324_cov_9.866920_g177487_i0	PRJNA564013	180337	324	9.86692	31.9688208	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	54.7	0.008	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g177487	i0	100	0.0895061728395062	29	0	9	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
20952054	20952054	PRJNA564013_P_NODE_262837_length_251_cov_3.110526_g259985_i0	PRJNA564013	262837	251	3.110526	7.80742026	Nepovirus glycinis	3048323	Viruses	Viruses	141	4.72e-29	NTclustered	gi\|1125812059\|ref\|NC_032270.1\|	1927714	g259985	i0	87.302	2.45418326693227	126	13	50	3	1	126	7958	8080	Soybean latent spherical virus isolate ND1 segment RNA1, complete sequence	blastn	616	141	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus glycinis
20952983	20952983	PRJNA564013_P_NODE_314317_length_217_cov_1.147436_g311465_i0	PRJNA564013	314317	217	1.147436	2.48993612	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	52.8	0.019	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g311465	i0	100	0.129032258064516	28	0	13	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
21533676	21533676	PRJNA564013_P_NODE_163957_length_339_cov_3.809353_g161107_i0	PRJNA564013	163957	339	3.809353	12.91370667	root	1	Root_unresolved	Root_unresolved	558	1.55e-154	NTclustered	gi\|9790340\|ref\|NC_001555.1\|	12227	g161107	i0	100	47.3982300884956	302	0	89	0	17	318	6487	6788	Tobacco etch virus, complete genome	blastn	16068	558	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus nicotianainsculpentis
23502518	23502518	PRJNA564013_P_NODE_271059_length_245_cov_2.608696_g268207_i0	PRJNA564013	271059	245	2.608696	6.3913052	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	54.7	0.006	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g268207	i0	100	0.118367346938776	29	0	12	0	217	245	86	58	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
23504027	23504027	PRJNA564013_P_NODE_349359_length_199_cov_2.463768_g346507_i0	PRJNA564013	349359	199	2.463768	4.90289832	Porcine bastrovirus	2588662	Viruses	Viruses	54.7	0.005	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g346507	i0	100	0.14572864321608	29	0	15	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
24774152	24774152	PRJNA564013_P_NODE_162020_length_340_cov_163.053763_g159170_i0	PRJNA564013	162020	340	163.053763	554.3827942	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.032	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g159170	i0	100	0.0823529411764706	28	0	8	0	313	340	42	15	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
24776254	24776254	PRJNA564013_P_NODE_268820_length_246_cov_15.362162_g265968_i0	PRJNA564013	268820	246	15.362162	37.79091852	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.022	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g265968	i0	100	0.113821138211382	28	0	11	0	1	28	15	42	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus

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