metadata: contig_metadata: 9 rows where bioproject = "PRJNA1111448", tax_phylum = "Pisuviricota" and tax

9 rows where bioproject = "PRJNA1111448", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

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
217351	217351	PRJNA1111448_S_NODE_115701_length_255_cov_2.027473_g114878_i0	PRJNA1111448	115701	255	2.027473	5.17005615	Wufeng shrew picornavirus 2	3084773	Viruses	Viruses	52.8	0.023	NTclustered	gi\|2633074035\|gb\|OQ716065.1\|	3084773	g114878	i0	100	0.109803921568627	28	0	11	0	103	130	9748	9721	MAG: Wufeng shrew picornavirus 2 isolate WF_Ch.smithii_picorna_3 polyprotein gene, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Wufeng shrew picornavirus 2
4044368	4044368	PRJNA1111448_S_NODE_128324_length_247_cov_0.885057_g127501_i0	PRJNA1111448	128324	247	0.885057	2.18609079	Betacoronavirus pandemicum	3418604	Viruses	Viruses	73.1	1.71e-8	NTclustered	gi\|2557639027\|emb\|OY695365.1\|	2697049	g127501	i0	97.674	16.2388663967611	43	0	17	1	2	44	19286	19245	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	4011	73.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
5320401	5320401	PRJNA1111448_S_NODE_133085_length_244_cov_1.222222_g132262_i0	PRJNA1111448	133085	244	1.222222	2.98222168	Betacoronavirus pandemicum	3418604	Viruses	Viruses	82.4	2.81e-11	NTclustered	gi\|2557415206\|emb\|OY652159.1\|	2697049	g132262	i0	90.625	21.9180327868852	64	3	25	3	177	238	7114	7176	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	5348	82.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
9145719	9145719	PRJNA1111448_S_NODE_4828_length_747_cov_2.074184_g4189_i0	PRJNA1111448	4828	747	2.074184	15.49415448	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	56.5	0.006	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g4189	i0	100	0.0789825970548862	30	0	4	0	718	747	85	56	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	59	56.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
11696232	11696232	PRJNA1111448_S_NODE_124810_length_249_cov_0.801136_g123987_i0	PRJNA1111448	124810	249	0.801136	1.99482864	Betacoronavirus pandemicum	3418604	Viruses	Viruses	97.1	1.03e-15	NTclustered	gi\|2165836885\|emb\|OV197189.1\|	2697049	g123987	i0	93.846	23.6987951807229	65	2	26	2	3	67	29973	29911	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	5901	97.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
16795613	16795613	PRJNA1111448_S_NODE_96314_length_276_cov_1.098522_g95491_i0	PRJNA1111448	96314	276	1.098522	3.03192072	Betacoronavirus pandemicum	3418604	Viruses	Viruses	93.5	1.5e-14	NTclustered	gi\|2165836885\|emb\|OV197189.1\|	2697049	g95491	i0	95	19.6521739130435	60	1	22	2	1	60	29968	29911	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	5424	93.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
20619237	20619237	PRJNA1111448_S_NODE_59337_length_329_cov_1.152344_g58514_i0	PRJNA1111448	59337	329	1.152344	3.79121176	Betacoronavirus pandemicum	3418604	Viruses	Viruses	73.1	2.38e-8	NTclustered	gi\|2557399578\|emb\|OY642376.1\|	2697049	g58514	i0	92.308	13.3434650455927	52	2	16	2	1	52	19297	19248	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	4390	73.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
30384190	30384190	PRJNA1111448_S_NODE_23353_length_444_cov_1.940701_g22531_i0	PRJNA1111448	23353	444	1.940701	8.61671244	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	59.7	4.04e-7	NR	UNY42093.1	3003959	g22531	i0	66.7	0.263513513513513	39	13	26.4	0	327	443	25	63	UNY42093.1 MAG: polyprotein 1 [Picornavirales sp.]	diamond	117	59.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32691427	32691427	PRJNA1111448_S_NODE_73040_length_306_cov_0.991416_g72217_i0	PRJNA1111448	73040	306	0.991416	3.03373296	Picornaviridae sp.	1530251	Viruses	Viruses	180	2.05e-51	NR	URG14993.1	1530251	g72217	i0	78.4	1	102	22	100	0	1	306	34	135	URG14993.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	306	180	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae 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);;