metadata: contig_metadata: 9 rows where bioproject = "PRJNA1120060", tax_phylum = "Negarnaviricota" and tax

9 rows where bioproject = "PRJNA1120060", tax_phylum = "Negarnaviricota" 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
252619	252619	PRJNA1120060_P_NODE_2523121_length_253_cov_1.705556_g2505049_i0	PRJNA1120060	2523121	253	1.705556	4.31505668	Jeilongvirus myodesis	3052267	Viruses	Viruses	54.7	0.006	NTclustered	gi\|2238885404\|gb\|OK623357.1\|	2116604	g2505049	i0	100	0.114624505928854	29	0	11	0	203	231	4525	4553	Pohorje myodes paramyxovirus 1 strain BE/Ninove/Mg/1/2019, complete genome	blastn	29	54.7	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Jeilongvirus	Jeilongvirus myodesis
4069230	4069230	PRJNA1120060_P_NODE_1750984_length_283_cov_1.276190_g1732976_i0	PRJNA1120060	1750984	283	1.27619	3.6116177	Orthobunyavirus akabaneense	1933178	Viruses	Viruses	52.8	0.026	NTclustered	gi\|1540611772\|gb\|MH244904.1\|	70566	g1732976	i0	96.875	1.01766784452297	32	0	11	1	136	167	864	894	Akabane virus strain HN10169 RNA-dependent RNA polymerase gene, partial cds	blastn	288	52.8	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Peribunyaviridae	Orthobunyavirus	Orthobunyavirus akabaneense
6627005	6627005	PRJNA1120060_P_NODE_2253526_length_263_cov_1.363158_g2235472_i0	PRJNA1120060	2253526	263	1.363158	3.58510554	Orthohantavirus puumalaense	3052493	Viruses	Viruses	54.7	0.007	NTclustered	gi\|2775691421\|gb\|OR573659.1\|	3052493	g2235472	i0	100	0.771863117870722	29	0	11	0	153	181	1094	1122	Orthohantavirus puumalaense isolate 25R1_Sorby_2020 segment S, complete sequence	blastn	203	54.7	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Hantaviridae	Orthohantavirus	Orthohantavirus puumalaense
9165644	9165644	PRJNA1120060_P_NODE_1432948_length_296_cov_4.206278_g1414964_i0	PRJNA1120060	1432948	296	4.206278	12.45058288	Bunyavirus sp.	1907588	Viruses	Viruses	60.2	1.64e-4	NTclustered	gi\|1089711080\|gb\|KX886781.1\|	1907588	g1414964	i0	100	0.108108108108108	32	0	11	0	242	273	6526	6495	Bunyavirus sp. strain Bat/VNM/16715_86 RNA-dependent RNA polymerase (RdRp) gene, complete cds	blastn	32	60.2	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Peribunyaviridae		Bunyavirus sp.
11716698	11716698	PRJNA1120060_P_NODE_1447290_length_296_cov_1.793722_g1429306_i0	PRJNA1120060	1447290	296	1.793722	5.30941712	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	52.8	0.027	NTclustered	gi\|346426591\|gb\|JN543605.1\|	RQ01	g1429306	i0	100	0.0945945945945946	28	0	9	0	177	204	1061	1034	Influenza A virus (A/chicken/Korea/162/2006(H9N2)) segment 3 polymerase PA (PA) gene, partial cds	blastn	28	52.8	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Alphainfluenzavirus	Zebrafish influenza B-like virus
22703223	22703223	PRJNA1120060_P_NODE_270418_length_431_cov_3.491620_g253476_i0	PRJNA1120060	270418	431	3.49162	15.0488822	Alphainfluenzavirus	197911	Viruses	Viruses	52.8	0.042	NTclustered	gi\|1691269012\|gb\|MN093859.1\|	11320	g253476	i0	100	0.649651972157773	28	0	6	0	171	198	1613	1640	Influenza A virus (A/dove/China/151B24/2015(H9N2)) segment 3 polymerase PA (PA) and PA-X protein (PA-X) genes, complete cds	blastn	280	52.8	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Alphainfluenzavirus	Alphainfluenzavirus influenzae
24497356	24497356	PRJNA1120060_P_NODE_804580_length_320_cov_0.838057_g786692_i0	PRJNA1120060	804580	320	0.838057	2.6817824	Orthobunyavirus wyeomyiae	3052456	Viruses	Viruses	54.7	0.008	NTclustered	gi\|1737293863\|gb\|MN092358.1\|	3052456	g786692	i0	96.875	0.1	32	1	10	0	155	186	124	93	Orthobunyavirus wyeomyiae strain Palenque-B549-MX-2008 RNA-dependent RNA polymerase (RdRp) gene, partial cds	blastn	32	54.7	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Peribunyaviridae	Orthobunyavirus	Orthobunyavirus wyeomyiae
26941690	26941690	PRJNA1120060_P_NODE_1496062_length_293_cov_4.122727_g1478074_i0	PRJNA1120060	1496062	293	4.122727	12.07959011	Actinidia fungus negative-stranded RNA virus 1	3079862	Viruses	Viruses	43.9	0.0277	NR	WON42279.1	3079862	g1478074	i0	34.2	0.747440273037543	73	41	69.6	3	242	39	2087	2157	WON42279.1 RNA-dependent RNA polymerase [Actinidia fungus negative-stranded RNA virus 1]	diamond	219	43.9	1	Viruses	Orthornavirae	Negarnaviricota					Actinidia fungus negative-stranded RNA virus 1
27732970	27732970	PRJNA1120060_P_NODE_2752824_length_247_cov_1.718391_g2734740_i0	PRJNA1120060	2752824	247	1.718391	4.24442577	Qingdao RNA virus 4	2979708	Viruses	Viruses	76.6	4.53e-14	NR	BDR95914.1	2979708	g2734740	i0	47.7	0.789473684210526	65	34	78.9	0	219	25	454	518	BDR95914.1 hypothetical protein [Qingdao RNA virus 4]	diamond	195	76.6	1	Viruses	Orthornavirae	Negarnaviricota	Chunqiuviricetes	Muvirales	Qinviridae		Qingdao RNA virus 4

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