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

6 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
1408208	1408208	PRJEB66218_P_NODE_50942_length_473_cov_3.342233_g48525_i0	PRJEB66218	50942	473	3.342233	15.80876209	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	455	2.9999999999999995e-123	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g48525	i0	84.134	62.8266384778013	479	67	100	9	1	473	3681380	3680905	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	29717	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
2684888	2684888	PRJEB66218_P_NODE_97163_length_312_cov_1.553785_g94735_i0	PRJEB66218	97163	312	1.553785	4.8478092	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	479	1.1299999999999996e-130	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g94735	i0	94.788	32.0096153846154	307	16	98	0	6	312	3682540	3682234	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9987	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
12886298	12886298	PRJEB66218_P_NODE_228851_length_204_cov_1.811189_g226421_i0	PRJEB66218	228851	204	1.811189	3.69482556	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	246	7.609999999999999e-61	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g226421	i0	88.67	67.1813725490196	203	22	99	1	2	204	3679933	3679732	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13705	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14162550	14162550	PRJEB66218_P_NODE_6912_length_1728_cov_5.381524_g5841_i0	PRJEB66218	6912	1728	5.381524	92.99273472	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1400	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5841	i0	84.621	129.710069444444	1437	189	89	26	310	1728	3681231	3682653	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	224139	1400	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
21807716	21807716	PRJEB66218_P_NODE_130318_length_261_cov_3.545000_g127889_i0	PRJEB66218	130318	261	3.545	9.25245	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	427	3.38e-115	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g127889	i0	96.169	191.091954022989	261	10	100	0	1	261	3679768	3680028	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	49875	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
24359711	24359711	PRJEB66218_P_NODE_60020_length_425_cov_1.793956_g57599_i0	PRJEB66218	60020	425	1.793956	7.624313	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	429	1.62e-115	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g57599	i0	85.012	56.9388235294118	427	59	100	4	1	425	3681380	3680957	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	24199	429	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);;