metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1123309" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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
7931245	7931245	PRJNA1123309_P_NODE_34687_length_284_cov_1.014218_g34307_i0	PRJNA1123309	34687	284	1.014218	2.88037912	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	244	4.03e-60	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g34307	i0	86.087	141.288732394366	230	29	80	3	57	284	2202536	2202308	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	40126	244	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
8682074	8682074	PRJNA1123309_P_NODE_13587_length_416_cov_0.938776_g13210_i0	PRJNA1123309	13587	416	0.938776	3.90530816	Roseiflexus	120961	Bacteria	Bacteria	348	4.56e-91	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g13210	i0	83.047	146.925480769231	407	45	96	19	5	403	2502	2112	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	61121	348	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
9205982	9205982	PRJNA1123309_P_NODE_10028_length_476_cov_3.158809_g9652_i0	PRJNA1123309	10028	476	3.158809	15.03593084	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	350	1.4700000000000002e-91	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g9652	i0	84.021	87.6470588235294	388	36	80	12	96	475	1399	1030	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	41720	350	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
10481949	10481949	PRJNA1123309_P_NODE_39369_length_272_cov_1.437186_g38989_i0	PRJNA1123309	39369	272	1.437186	3.90914592	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	191	5.07e-44	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g38989	i0	82.511	57.9007352941176	223	33	81	5	1	220	273604	273385	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	15749	191	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11232362	11232362	PRJNA1123309_P_NODE_4449_length_684_cov_1.382979_g4115_i0	PRJNA1123309	4449	684	1.382979	9.45957636	Chloroflexus	1107	Bacteria	Bacteria	451	5.760000000000001e-122	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g4115	i0	80.124	188.49269005848	644	96	93	26	1	633	825	1447	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	128929	451	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
11756998	11756998	PRJNA1123309_P_NODE_52930_length_250_cov_0.881356_g52550_i0	PRJNA1123309	52930	250	0.881356	2.20339	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	106	1.71e-18	NTclustered	gi\|2893356050\|emb\|OZ220473.1\|	2026734	g52550	i0	80.272	73.664	147	24	58	5	107	250	1468144	1468288	MAG: Dehalococcoidia bacterium isolate 87cb072c-069b-458f-9ccb-7e689b7dc65c genome assembly, chromosome: 1	blastn	18416	106	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
14307552	14307552	PRJNA1123309_P_NODE_6952_length_563_cov_1.502041_g6591_i0	PRJNA1123309	6952	563	1.502041	8.45649083	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	606	9.439999999999999e-169	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g6591	i0	86.549	229.886323268206	565	59	99	15	9	563	273815	274372	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	129426	606	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16855525	16855525	PRJNA1123309_P_NODE_33954_length_285_cov_2.033019_g33574_i0	PRJNA1123309	33954	285	2.033019	5.79410415	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	211	4.1e-50	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g33574	i0	82.661	34.519298245614	248	33	85	8	43	284	274536	274779	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	9838	211	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16855563	16855563	PRJNA1123309_P_NODE_38394_length_274_cov_3.597015_g38014_i0	PRJNA1123309	38394	274	3.597015	9.8558211	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	99	3.19e-16	NTclustered	gi\|2621704081\|emb\|OY761543.1\|	2026734	g38014	i0	81.061	5.23722627737226	132	18	47	6	4	132	2208905	2208778	MAG: Dehalococcoidia bacterium isolate d8cdd4bd-f85c-46d1-a80f-042a7445dbc9 genome assembly, chromosome: 1	blastn	1435	99	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
19403943	19403943	PRJNA1123309_P_NODE_16196_length_386_cov_1.226837_g15817_i0	PRJNA1123309	16196	386	1.226837	4.73559082	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g15817	i0	100	0.0725388601036269	28	0	7	0	314	341	1230200	1230173	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
20679545	20679545	PRJNA1123309_P_NODE_19677_length_356_cov_1.067138_g19298_i0	PRJNA1123309	19677	356	1.067138	3.79901128	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	276	1.84e-69	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g19298	i0	82.5	39.0561797752809	320	50	89	5	1	317	2202159	2202475	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	13904	276	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
21954945	21954945	PRJNA1123309_P_NODE_23298_length_331_cov_2.589147_g22919_i0	PRJNA1123309	23298	331	2.589147	8.57007657	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	549	9.069999999999996e-152	NTclustered	gi\|389547047\|gb\|JQ401975.1\|	166587	g22919	i0	97.516	97.3474320241692	322	6	97	2	10	329	98	419	Uncultured Chloroflexi bacterium clone CNY_02222 16S ribosomal RNA gene, partial sequence	blastn	32222	549	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
22705985	22705985	PRJNA1123309_P_NODE_54958_length_248_cov_2.525714_g54578_i0	PRJNA1123309	54958	248	2.525714	6.26377072	Thermobaculum	262406	Bacteria	Bacteria	241	4.46e-59	NTclustered	gi\|470485526\|ref\|NR_076705.1\|	166501	g54578	i0	86.404	170.737903225806	228	22	90	8	22	244	683	906	Thermobaculum terrenum strain ATCC BAA-798 23S ribosomal RNA gene, complete sequence	blastn	42343	241	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
23230749	23230749	PRJNA1123309_P_NODE_48119_length_253_cov_0.866667_g47739_i0	PRJNA1123309	48119	253	0.866667	2.19266751	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	196	1e-45	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g47739	i0	81.78	1.6403162055336	236	41	93	2	15	249	936542	936308	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	415	196	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae

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