metadata: contig_metadata: 10 rows where bioproject = "PRJNA1158727" and tax

10 rows where bioproject = "PRJNA1158727" and tax_kingdom = "Bamfordvirae"

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
14332456	14332456	PRJNA1158727_P_NODE_119212_length_268_cov_1.579487_g111751_i0	PRJNA1158727	119212	268	1.579487	4.23302516	Erythrocytic necrosis virus	1543320	Viruses	Viruses	385	2.13e-102	NTclustered	gi\|1624806662\|gb\|MK638698.1\|	1543320	g111751	i0	92.565	5.82462686567164	269	18	100	2	1	268	358	91	Erythrocytic necrosis virus isolate SEQ_13 putative RNA-dependent DNA polymerase mRNA, complete cds	blastn	1561	385	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
15065244	15065244	PRJNA1158727_P_NODE_148392_length_246_cov_1.132948_g140930_i0	PRJNA1158727	148392	246	1.132948	2.78705208	root	1	Root_unresolved	Root_unresolved	446	8.719999999999999e-121	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g140930	i0	100	97.9674796747967	241	0	98	0	6	246	15223	14983	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	24100	446	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
27185929	27185929	PRJNA1158727_P_NODE_118922_length_268_cov_2.610256_g111461_i0	PRJNA1158727	118922	268	2.610256	6.99548608	Orthopoxvirus	10242	Viruses	Viruses	177	1.17e-49	NR	WBA78916.1	10244	g111461	i0	97.8	41.8432835820896	89	2	99.6	0	268	2	343	431	WBA78916.1 mRNA capping enzyme large subunit [Monkeypox virus]	diamond	11214	177	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
27545885	27545885	PRJNA1158727_P_NODE_137804_length_250_cov_0.870056_g130342_i0	PRJNA1158727	137804	250	0.870056	2.17514	Terrestrivirus sp.	2487775	Viruses	Viruses	72	1.38e-12	NR	AYV75160.1	2487775	g130342	i0	46.1	0.912	76	40	90	1	248	24	264	339	AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.]	diamond	228	72	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
29408674	29408674	PRJNA1158727_P_NODE_112829_length_276_cov_1.275862_g105368_i0	PRJNA1158727	112829	276	1.275862	3.52137912	Erythrocytic necrosis virus	1543320	Viruses	Viruses	43.9	0.00333	NR	QCF47503.1	1543320	g105368	i0	65.5	0.315217391304348	29	10	31.5	0	129	215	27	55	QCF47503.1 putative tyrosine kinase [Erythrocytic necrosis virus]	diamond	87	43.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
29408702	29408702	PRJNA1158727_P_NODE_46289_length_537_cov_1.823276_g38844_i0	PRJNA1158727	46289	537	1.823276	9.79099212	Acanthamoeba polyphaga mimivirus	212035	Viruses	Viruses	57.8	4.49e-6	NR	YP_010777733.1	212035	g38844	i0	26.8	0.854748603351955	153	96	82.7	5	534	91	208	349	YP_010777733.1 putative serine/threonine-protein kinase/receptor [Acanthamoeba polyphaga mimivirus]	diamond	459	57.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense
29882613	29882613	PRJNA1158727_P_NODE_63631_length_405_cov_0.927711_g56170_i0	PRJNA1158727	63631	405	0.927711	3.75722955	Camelpox virus	28873	Viruses	Viruses	276	2.07e-85	NR	NP_570494.1	28873	g56170	i0	98.5	8.05185185185185	135	2	100	0	1	405	457	591	NP_570494.1 CMLV104 [Camelpox virus]	diamond	3261	276	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus camelpox
29901862	29901862	PRJNA1158727_P_NODE_109751_length_280_cov_1.115942_g102290_i0	PRJNA1158727	109751	280	1.115942	3.1246376	Orthopoxvirus	10242	Viruses	Viruses	195	7.31e-56	NR	WBA78916.1	10244	g102290	i0	98.9	17.925	93	1	99.6	0	279	1	598	690	WBA78916.1 mRNA capping enzyme large subunit [Monkeypox virus]	diamond	5019	195	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
30249521	30249521	PRJNA1158727_P_NODE_62072_length_413_cov_2.082353_g54611_i0	PRJNA1158727	62072	413	2.082353	8.60011789	Orthopoxvirus	10242	Viruses	Viruses	266	1.3199999999999999e-81	NR	XEX54345.1	10244	g54611	i0	99.3	23.8837772397094	137	1	99.5	0	413	3	47	183	XEX54345.1 mRNA capping enzyme large subunit, partial [Monkeypox virus]	diamond	9864	266	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
32632411	32632411	PRJNA1158727_P_NODE_140280_length_249_cov_1.045455_g132818_i0	PRJNA1158727	140280	249	1.045455	2.60318295	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	50.4	3.58e-5	NR	DAC81313.1	2609857	g132818	i0	51.3	1.57831325301205	39	19	47	0	3	119	72	110	DAC81313.1 TPA_asm: adenain [Larimichthys croaker adintovirus]	diamond	393	50.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Larimichthys croaker adintovirus

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