metadata: contig_metadata: 7 rows where bioproject = "PRJNA1073183" and tax

7 rows where bioproject = "PRJNA1073183" 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
16318605	16318605	PRJNA1073183_P_NODE_29853_length_247_cov_0.885057_g29758_i0	PRJNA1073183	29853	247	0.885057	2.18609079	Coccolithovirus	346673	Viruses	Viruses	457	4.05e-124	NTclustered	gi\|74275075\|gb\|DQ127559.1\|	181209	g29758	i0	100	7	247	0	100	0	1	247	2800	2554	Emiliania huxleyi virus 163 clone combi108+110.seq partial sequence	blastn	1729	457	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Emiliania huxleyi virus 163
27121797	27121797	PRJNA1073183_P_NODE_29102_length_248_cov_0.880000_g29007_i0	PRJNA1073183	29102	248	0.88	2.1824	Orthopoxvirus	10242	Viruses	Viruses	115	1.04e-30	NR	UXL57756.1	10244	g29007	i0	61.7	13.4516129032258	81	31	98	0	4	246	45	125	UXL57756.1 Thymidine kinase, partial [Monkeypox virus]	diamond	3336	116	0.991379310344828	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
28362174	28362174	PRJNA1073183_P_NODE_27246_length_250_cov_0.870056_g27151_i0	PRJNA1073183	27246	250	0.870056	2.17514	Barrevirus sp.	2487763	Viruses	Viruses	63.5	7.43e-10	NR	AYV77273.1	2487763	g27151	i0	38.1	1.008	84	50	98.4	1	4	249	129	212	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	252	63.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
29901060	29901060	PRJNA1073183_P_NODE_27331_length_250_cov_0.870056_g27236_i0	PRJNA1073183	27331	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	49.3	1.88e-4	NR	AET42571.1	181211	g27236	i0	39.7	2.256	63	38	75.6	0	1	189	255	317	AET42571.1 fatty acid elongase [Emiliania huxleyi virus 202]	diamond	564	49.7	0.991951710261569	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Emiliania huxleyi virus 202
30572665	30572665	PRJNA1073183_P_NODE_14513_length_341_cov_1.679104_g14418_i0	PRJNA1073183	14513	341	1.679104	5.72574464	Edafosvirus sp.	2487765	Viruses	Viruses	164	4.47e-46	NR	AYV78014.1	2487765	g14418	i0	66.1	0.98533724340176	112	38	98.5	0	338	3	261	372	AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.]	diamond	336	164	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
30952253	30952253	PRJNA1073183_P_NODE_28314_length_249_cov_0.875000_g28219_i0	PRJNA1073183	28314	249	0.875	2.17875	Homavirus sp.	2487769	Viruses	Viruses	132	2.73e-35	NR	AYV82419.1	2487769	g28219	i0	73.2	0.987951807228916	82	22	98.8	0	246	1	98	179	AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.]	diamond	246	132	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
32596761	32596761	PRJNA1073183_P_NODE_26440_length_251_cov_0.865169_g26345_i0	PRJNA1073183	26440	251	0.865169	2.17157419	Harvfovirus sp.	2487768	Viruses	Viruses	44.7	0.00432	NR	AYV81692.1	2487768	g26345	i0	27.7	0.99203187250996006	83	54	99.2	1	1	249	57	133	AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.]	diamond	249	44.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus 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);;