metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_phylum = "Candidatus Colwelliibacteriota"

5 rows where analysis = "diamond", bioproject = "PRJNA340009" 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
10595662	10595662	PRJNA340009_P_NODE_18609_length_278_cov_10.882096_g18302_i0	PRJNA340009	18609	278	10.882096	30.25222688	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	55.8	9.91e-7	NR	MBI2010932.1	2750074	g18302	i0	55.3	0.507194244604317	47	20	49.6	1	130	267	4	50	MBI2010932.1 alpha/beta hydrolase [Candidatus Colwellbacteria bacterium]	diamond	141	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium
26680330	26680330	PRJNA340009_P_NODE_49141_length_185_cov_1.191176_g48834_i0	PRJNA340009	49141	185	1.191176	2.2036756	Bacteria	2	Bacteria	Bacteria	89.7	4.52e-19	NR	MBI3274015.1	2750074	g48834	i0	70	1.96216216216216	60	18	97.3	0	184	5	297	356	MBI3274015.1 D-aminoacylase [Candidatus Colwellbacteria bacterium]	diamond	363	89.7	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium
29270695	29270695	PRJNA340009_P_NODE_16869_length_290_cov_54.290456_g16562_i0	PRJNA340009	16869	290	54.290456	157.4423224	Bacteria	2	Bacteria	Bacteria	161	1.7e-46	NR	PIR98235.1	1974540	g16562	i0	73.7	2.90689655172414	95	25	98.3	0	287	3	59	153	PIR98235.1 MAG: hypothetical protein COT89_00815 [Candidatus Colwellbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_22]	diamond	843	161	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_22
30011678	30011678	PRJNA340009_P_NODE_62711_length_167_cov_0.864407_g62404_i0	PRJNA340009	62711	167	0.864407	1.44355969	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	44.7	0.00275	NR	MDD4931375.1	2750074	g62404	i0	45.7	1.56287425149701	46	25	82.6	0	3	140	150	195	MDD4931375.1 hypothetical protein [Candidatus Colwellbacteria bacterium]	diamond	261	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium
30296304	30296304	PRJNA340009_P_NODE_27252_length_236_cov_4.625668_g26945_i0	PRJNA340009	27252	236	4.625668	10.91657648	Candidatus Colwellbacteria bacterium RIFCSPLOWO2_12_FULL_43_11	1797693	Bacteria	Bacteria	144	7.319999999999998e-42	NR	OGY61842.1	1797693	g26945	i0	84.6	0.991525423728814	78	12	99.2	0	235	2	113	190	OGY61842.1 MAG: hypothetical protein A3F99_02235 [Candidatus Colwellbacteria bacterium RIFCSPLOWO2_12_FULL_43_11]	diamond	234	144	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota	Candidatus Colwellbacteria bacterium RIFCSPLOWO2_12_FULL_43_11

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