metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_species
12748721	12748721	PRJNA980587_P_NODE_36410_length_391_cov_0.968553_g35617_i0	PRJNA980587	36410	391	0.968553	3.78704223	Chloroflexota	200795	Bacteria	Bacteria	492	1.8599999999999998e-134	NTclustered	gi\|2814788344\|emb\|OY760098.2\|	2952883	g35617	i0	90.786	518.419437340153	369	33	99	1	22	389	1540032	1539664	MAG: Aggregatilineales bacterium isolate 38e3f777-17bf-4c24-a9d7-54fd166e8adf genome assembly, chromosome: 1	blastn	202702	492	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineales bacterium
13710017	13710017	PRJNA980587_P_NODE_96731_length_209_cov_4.397059_g95938_i0	PRJNA980587	96731	209	4.397059	9.18985331	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	252	1.68e-62	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g95938	i0	88.517	18.0909090909091	209	22	99	2	2	209	275793	276000	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	3781	252	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
16258710	16258710	PRJNA980587_P_NODE_5593_length_1219_cov_4.492147_g5114_i0	PRJNA980587	5593	1219	4.492147	54.75927193	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	1256	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g5114	i0	85.45	170.664479081214	1244	139	100	31	1	1219	273051	274277	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	208040	1256	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
18807879	18807879	PRJNA980587_P_NODE_74935_length_258_cov_2.140541_g74142_i0	PRJNA980587	74935	258	2.140541	5.52259578	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	243	1.3e-59	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g74142	i0	84.836	230.031007751938	244	33	93	4	14	254	274570	274812	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	59348	243	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
24221139	24221139	PRJNA980587_P_NODE_28039_length_460_cov_1.726098_g27246_i0	PRJNA980587	28039	460	1.726098	7.9400508	Chloroflexota	200795	Bacteria	Bacteria	462	1.7399999999999999e-125	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g27246	i0	85.281	92.4630434782609	462	52	98	14	5	454	381154	380697	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	42533	462	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineales 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);;