metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1255065" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1255065" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
360204	360204	PRJNA1255065_P_NODE_27301_length_496_cov_1.315436_g25104_i0	PRJNA1255065	27301	496	1.315436	6.52456256	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	496	1.86e-135	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g25104	i0	84.959	243.332661290323	492	71	99	3	5	496	1245426	1245914	Leptolinea sp. HRD-7 DNA, complete genome	blastn	120693	496	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7
5463886	5463886	PRJNA1255065_P_NODE_74265_length_211_cov_0.938272_g72037_i0	PRJNA1255065	74265	211	0.938272	1.97975392	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	206	1.34e-48	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g72037	i0	90.385	653.748815165877	156	15	74	0	56	211	319916	319761	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	137941	206	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
11838722	11838722	PRJNA1255065_P_NODE_142170_length_163_cov_0.912281_g139942_i0	PRJNA1255065	142170	163	0.912281	1.48701803	Tepidiforma flava	3004094	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g139942	i0	98.773	2.00613496932515	163	2	100	0	1	163	1721268	1721106	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	327	291	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
18212125	18212125	PRJNA1255065_P_NODE_48435_length_298_cov_2.811245_g46209_i0	PRJNA1255065	48435	298	2.811245	8.3775101	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	213	1.2e-50	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g46209	i0	82.031	65.7080536912752	256	41	86	5	2	256	3494978	3494727	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	19581	213	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
19486039	19486039	PRJNA1255065_P_NODE_130316_length_165_cov_0.896552_g128088_i0	PRJNA1255065	130316	165	0.896552	1.4793108	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	281	1.62e-71	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g128088	i0	97.576	1	165	3	100	1	1	165	171203	171040	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	165	281	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
22036975	22036975	PRJNA1255065_P_NODE_23738_length_550_cov_1.770459_g21580_i0	PRJNA1255065	23738	550	1.770459	9.7375245	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	412	2.1599999999999993e-110	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g21580	i0	80.541	61.7781818181818	555	93	100	13	1	550	3496080	3495536	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	33978	412	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
22037250	22037250	PRJNA1255065_P_NODE_74218_length_211_cov_0.962963_g71990_i0	PRJNA1255065	74218	211	0.962963	2.03185193	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	150	6.389999999999998e-32	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g71990	i0	88.189	0.601895734597156	127	14	60	1	1	127	4626761	4626886	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	127	150	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
23312410	23312410	PRJNA1255065_P_NODE_151319_length_162_cov_0.920354_g149091_i0	PRJNA1255065	151319	162	0.920354	1.49097348	Tepidiforma flava	3004094	Bacteria	Bacteria	261	2.06e-65	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g149091	i0	95.679	1.99382716049383	162	7	100	0	1	162	619362	619523	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	323	261	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava

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