metadata: contig_metadata: 5 rows where bioproject = "PRJNA630162" and tax_phylum = "Candidatus Colwelliibacteriota"

5 rows where bioproject = "PRJNA630162" and tax_phylum = "Candidatus Colwelliibacteriota"

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_clade	tax_phylum	tax_species
3702853	3702853	PRJNA630162_P_NODE_141783_length_166_cov_2.222222_g140260_i0	PRJNA630162	141783	166	2.222222	3.68888852	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	94	1.15e-22	NR	MDD4931421.1	2750074	g140260	i0	81.5	2.96385542168675	54	10	97.6	0	4	165	41	94	MDD4931421.1 hypothetical protein [Candidatus Colwellbacteria bacterium]	diamond	492	94	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium
28691467	28691467	PRJNA630162_P_NODE_109827_length_180_cov_1.236641_g108304_i0	PRJNA630162	109827	180	1.236641	2.2259538	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	55.8	3.73e-7	NR	MDD4930543.1	2750074	g108304	i0	44.6	0.933333333333333	56	28	93.3	1	6	173	55	107	MDD4930543.1 hypothetical protein [Candidatus Colwellbacteria bacterium]	diamond	168	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium
28912059	28912059	PRJNA630162_P_NODE_159408_length_162_cov_1.601770_g157885_i0	PRJNA630162	159408	162	1.60177	2.5948674	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	88.6	7.15e-19	NR	MDD4930891.1	2750074	g157885	i0	64.2	0.981481481481482	53	19	98.1	0	161	3	314	366	MDD4930891.1 glycosyltransferase [Candidatus Colwellbacteria bacterium]	diamond	159	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium
29638132	29638132	PRJNA630162_P_NODE_133090_length_169_cov_0.866667_g131567_i0	PRJNA630162	133090	169	0.866667	1.46466723	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	69.3	7.07e-13	NR	MDD4930909.1	2750074	g131567	i0	59.2	0.869822485207101	49	20	87	0	9	155	126	174	MDD4930909.1 hypothetical protein [Candidatus Colwellbacteria bacterium]	diamond	147	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium
30554455	30554455	PRJNA630162_P_NODE_148033_length_165_cov_0.896552_g146510_i0	PRJNA630162	148033	165	0.896552	1.4793108	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	46.2	4.34e-4	NR	MDD4931373.1	2750074	g146510	i0	41.7	0.872727272727273	48	28	87.3	0	16	159	1	48	MDD4931373.1 hypothetical protein [Candidatus Colwellbacteria bacterium]	diamond	144	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium

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