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

5 rows where analysis = "blastn", bioproject = "PRJNA1218816" 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_family	tax_genus	tax_species
6711270	6711270	PRJNA1218816_P_NODE_53046_length_253_cov_1.488889_g52613_i0	PRJNA1218816	53046	253	1.488889	3.76688917	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	429	9.079999999999999e-116	NTclustered	gi\|307112323\|gb\|HQ132380.1\|	166587	g52613	i0	97.233	100.320158102767	253	7	100	0	1	253	303	51	Uncultured Chloroflexi bacterium clone X-49 16S ribosomal RNA gene, partial sequence	blastn	25381	429	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
7987008	7987008	PRJNA1218816_P_NODE_9707_length_836_cov_1.813893_g9332_i0	PRJNA1218816	9707	836	1.813893	15.16414548	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	972	0	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g9332	i0	87.886	286.058612440191	842	83	99	16	1	833	63879	64710	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	239145	972	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10537301	10537301	PRJNA1218816_P_NODE_49429_length_266_cov_1.196891_g48996_i0	PRJNA1218816	49429	266	1.196891	3.18373006	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	219	2.27e-52	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g48996	i0	82.937	196.289473684211	252	34	93	9	1	248	2202014	2202260	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	52213	219	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
17623992	17623992	PRJNA1218816_P_NODE_30434_length_364_cov_2.635739_g30001_i0	PRJNA1218816	30434	364	2.635739	9.59408996	Bacillati	1783272	Bacteria	Bacteria	340	6.579999999999999e-89	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g30001	i0	83.924	179.739010989011	367	47	99	10	2	364	2828217	2827859	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	65425	342	0.994152046783626	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
22009980	22009980	PRJNA1218816_P_NODE_25538_length_412_cov_2.587021_g25105_i0	PRJNA1218816	25538	412	2.587021	10.65852652	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	459	2.0000000000000003e-124	NTclustered	gi\|2874254062\|emb\|OY970386.1\|	1672391	g25105	i0	86.842	109.711165048544	418	45	100	8	1	412	1889839	1889426	MAG: uncultured Chloroflexia bacterium isolate MFD03726.bin.c.14 genome assembly, chromosome: 1	blastn	45201	459	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;