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

6 rows where analysis = "blastn", bioproject = "PRJNA436017" 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
1705777	1705777	PRJNA436017_P_NODE_302_length_1459_cov_13.627989_g243_i0	PRJNA436017	302	1459	13.627989	198.83235951	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1122	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g243	i0	80.92	73.4139821795751	1478	232	100	38	1	1459	3682680	3681234	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	107111	1122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
6808747	6808747	PRJNA436017_P_NODE_786_length_1034_cov_20.251755_g652_i0	PRJNA436017	786	1034	20.251755	209.4031467	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	966	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g652	i0	83.699	136.557059961315	1049	145	99	24	2	1034	3681642	3682680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	141200	966	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
13184615	13184615	PRJNA436017_P_NODE_431_length_1296_cov_32.846704_g352_i0	PRJNA436017	431	1296	32.846704	425.69328384	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1199	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g352	i0	83.61	117.571759259259	1324	170	100	42	1	1296	3681376	3682680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	152373	1199	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14459752	14459752	PRJNA436017_P_NODE_432_length_1296_cov_32.671962_g353_i0	PRJNA436017	432	1296	32.671962	423.42862752	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1194	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g353	i0	83.535	117.571759259259	1324	171	100	42	1	1296	3682680	3681376	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	152373	1194	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18282582	18282582	PRJNA436017_P_NODE_555_length_1171_cov_14.016755_g452_i0	PRJNA436017	555	1171	14.016755	164.13620105	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1048	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g452	i0	83.193	65.932536293766	1184	160	99	28	1	1170	3682680	3681522	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	77207	1048	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
20832316	20832316	PRJNA436017_P_NODE_14497_length_219_cov_1.043956_g14199_i0	PRJNA436017	14497	219	1.043956	2.28626364	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	143	1.12e-29	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g14199	i0	78.924	351.826484018265	223	38	99	9	2	219	1479107	1479325	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	77050	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium MEL.A1

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