metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1104180" 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
1487219	1487219	PRJNA1104180_P_NODE_9122_length_328_cov_8.713725_g8980_i0	PRJNA1104180	9122	328	8.713725	28.581018	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	193	1.74e-44	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g8980	i0	80.303	4.6280487804878	264	44	79	7	55	314	276008	275749	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1518	193	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2763159	2763159	PRJNA1104180_P_NODE_2703_length_536_cov_17.282937_g2562_i0	PRJNA1104180	2703	536	17.282937	92.63654232	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	359	2.77e-94	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g2562	i0	79.737	79.2742537313433	533	79	97	24	3	520	273586	273068	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	42491	359	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7864925	7864925	PRJNA1104180_P_NODE_10767_length_310_cov_1.860759_g10625_i0	PRJNA1104180	10767	310	1.860759	5.7683529	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	401	2.4999999999999992e-107	NTclustered	gi\|389546818\|gb\|JQ401746.1\|	166587	g10625	i0	90.523	95.9129032258064	306	26	98	2	6	310	2	305	Uncultured Chloroflexi bacterium clone CNY_01936 16S ribosomal RNA gene, partial sequence	blastn	29733	401	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
17598032	17598032	PRJNA1104180_P_NODE_28834_length_196_cov_9.528455_g28691_i0	PRJNA1104180	28834	196	9.528455	18.6757718	Herpetosiphon	64	Bacteria	Bacteria	76.8	1.01e-9	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g28691	i0	87.143	2.14285714285714	70	6	35	3	129	196	2832	2764	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	420	76.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
18064204	18064204	PRJNA1104180_P_NODE_8475_length_337_cov_4.511364_g8333_i0	PRJNA1104180	8475	337	4.511364	15.20329668	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	143	1.83e-29	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g8333	i0	79.018	2.93175074183976	224	35	64	10	122	337	274604	274385	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	988	143	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20613609	20613609	PRJNA1104180_P_NODE_27597_length_228_cov_2.193548_g27454_i0	PRJNA1104180	27597	228	2.193548	5.00128944	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	296	8.5e-76	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g27454	i0	90.351	80.1973684210526	228	19	99	3	2	228	273897	274122	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	18285	296	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21889215	21889215	PRJNA1104180_P_NODE_25498_length_242_cov_1.674556_g25355_i0	PRJNA1104180	25498	242	1.674556	4.05242552	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	255	1.55e-63	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g25355	i0	86.192	321.239669421488	239	29	98	2	6	242	275260	275496	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	77740	255	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21889343	21889343	PRJNA1104180_P_NODE_8838_length_332_cov_2.401544_g8696_i0	PRJNA1104180	8838	332	2.401544	7.97312608	Roseiflexus castenholzii	120962	Bacteria	Bacteria	281	3.66e-71	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g8696	i0	82.493	14.7590361445783	337	43	98	12	1	326	1881873	1882204	Roseiflexus castenholzii DSM 13941, complete genome	blastn	4900	281	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
25246600	25246600	PRJNA1104180_P_NODE_15180_length_276_cov_1.852217_g15038_i0	PRJNA1104180	15180	276	1.852217	5.11211892	Herpetosiphon	64	Bacteria	Bacteria	187	6.669999999999998e-43	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g15038	i0	79.298	55.9202898550725	285	45	100	11	1	276	2373	2094	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	15434	187	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus

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