metadata: contig_metadata: 8 rows where bioproject = "PRJNA541476" and tax

8 rows where bioproject = "PRJNA541476" 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
26824855	26824855	PRJNA541476_P_NODE_11141_length_346_cov_1.058608_g10935_i0	PRJNA541476	11141	346	1.058608	3.66278368	Terrestrivirus sp.	2487775	Viruses	Viruses	71.6	6.33e-12	NR	AYV75160.1	2487775	g10935	i0	38.2	0.771676300578035	89	48	73.7	2	291	37	91	176	AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.]	diamond	267	71.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
27235906	27235906	PRJNA541476_P_NODE_7923_length_401_cov_3.411585_g7719_i0	PRJNA541476	7923	401	3.411585	13.68045585	Micromonas pusilla virus 12T	755272	Viruses	Viruses	122	2.2e-29	NR	YP_007676312.1	755272	g7719	i0	51.5	2.96259351620948	132	55	98.8	1	3	398	203	325	YP_007676312.1 heat shock protein 70 [Micromonas pusilla virus 12T]	diamond	1188	122	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Micromonas pusilla virus 12T
28751601	28751601	PRJNA541476_P_NODE_20727_length_279_cov_1.495146_g20521_i0	PRJNA541476	20727	279	1.495146	4.17145734	Faunusvirus sp.	2487766	Viruses	Viruses	63.9	2.03e-9	NR	AYV79658.1	2487766	g20521	i0	51.4	0.752688172043011	70	30	72	3	77	277	476	544	AYV79658.1 MAG: putative helicase/exonuclease [Faunusvirus sp.]	diamond	210	63.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Faunusvirus sp.
30551653	30551653	PRJNA541476_P_NODE_21073_length_278_cov_0.892683_g20867_i0	PRJNA541476	21073	278	0.892683	2.48165874	Tupanvirus deep ocean	2126984	Viruses	Viruses	89.7	5.1e-19	NR	YP_010781083.1	2126984	g20867	i0	53.2	1.70503597122302	79	36	85.3	1	238	2	124	201	YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean]	diamond	474	89.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
30994214	30994214	PRJNA541476_P_NODE_4194_length_560_cov_2.316222_g3998_i0	PRJNA541476	4194	560	2.316222	12.9708432	Edafosvirus sp.	2487765	Viruses	Viruses	55.1	3.85e-5	NR	AYV78965.1	2487765	g3998	i0	60.5	0.203571428571429	38	15	20.4	0	268	381	203	240	AYV78965.1 MAG: DEAD/SNF2-like helicase, partial [Edafosvirus sp.]	diamond	114	55.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
31088906	31088906	PRJNA541476_P_NODE_41615_length_230_cov_2.063694_g41409_i0	PRJNA541476	41615	230	2.063694	4.7464962	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	73.2	3.64e-13	NR	VBB18459.1	2420051	g41409	i0	48.6	0.939130434782609	72	37	93.9	0	14	229	183	254	VBB18459.1 class I SAM-dependent methyltransferase [Yasminevirus sp. GU-2018]	diamond	216	73.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32385799	32385799	PRJNA541476_P_NODE_11679_length_339_cov_2.966165_g11473_i0	PRJNA541476	11679	339	2.966165	10.05529935	Terrestrivirus sp.	2487775	Viruses	Viruses	48.5	0.00104	NR	AYV76628.1	2487775	g11473	i0	38.8	0.752212389380531	85	39	70.8	3	45	284	215	291	AYV76628.1 MAG: hypothetical protein Terrestrivirus10_12 [Terrestrivirus sp.]	diamond	255	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
32417554	32417554	PRJNA541476_P_NODE_5619_length_478_cov_2.293827_g5417_i0	PRJNA541476	5619	478	2.293827	10.96449306	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	77.8	2.95e-13	NR	YP_010803800.1	3060017	g5417	i0	58.6	0.728033472803347	58	24	36.4	0	237	64	1048	1105	YP_010803800.1 helicase/uvrB [Fadolivirus algeromassiliense]	diamond	348	77.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense

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