metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Candidatus Melainabacteria"

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_kingdom	tax_phylum	tax_species
4720755	4720755	PRJNA911178_P_NODE_214464_length_264_cov_1.225131_g211990_i0	PRJNA911178	214464	264	1.225131	3.23434584	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	222	1.74e-53	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g211990	i0	82.264	69.0416666666667	265	39	99	8	3	264	3681207	3680948	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	18227	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
9819126	9819126	PRJNA911178_P_NODE_102568_length_357_cov_2.531690_g100097_i0	PRJNA911178	102568	357	2.53169	9.0381333	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	427	4.81e-115	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g100097	i0	89.736	363.529411764706	341	26	94	8	1	336	3682173	3682509	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	129780	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18744706	18744706	PRJNA911178_P_NODE_44615_length_516_cov_2.654628_g42194_i0	PRJNA911178	44615	516	2.654628	13.69788048	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	915	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g42194	i0	99.02	233.84496124031	510	5	99	0	1	510	3682156	3682665	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	120664	915	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22570549	22570549	PRJNA911178_P_NODE_77538_length_402_cov_4.379939_g75073_i0	PRJNA911178	77538	402	4.379939	17.60735478	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	654	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g75073	i0	96.465	142.900497512438	396	14	99	0	3	398	3680254	3680649	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	57446	654	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
23844724	23844724	PRJNA911178_P_NODE_245919_length_250_cov_0.870056_g243445_i0	PRJNA911178	245919	250	0.870056	2.17514	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	374	4.2499999999999986e-99	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g243445	i0	93.927	0.988	247	15	99	0	1	247	3842322	3842076	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	247	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
23845851	23845851	PRJNA911178_P_NODE_90739_length_376_cov_2.580858_g88269_i0	PRJNA911178	90739	376	2.580858	9.70402608	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	684	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g88269	i0	99.469	156.94414893617	377	1	100	1	1	376	3681799	3682175	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	59011	684	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria 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);;