metadata: contig_metadata: 19 rows where bioproject = "PRJNA591127", tax_kingdom = "Bacillati" and tax

19 rows where bioproject = "PRJNA591127", tax_kingdom = "Bacillati" 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
565018	565018	PRJNA591127_P_NODE_13761_length_198_cov_2.130435_g13592_i0	PRJNA591127	13761	198	2.130435	4.2182613	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	185	1.62e-42	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g13592	i0	86.471	12.6616161616162	170	22	86	1	11	180	3522593	3522425	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	2507	185	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
565117	565117	PRJNA591127_P_NODE_25641_length_165_cov_1.781250_g25472_i0	PRJNA591127	25641	165	1.78125	2.9390625	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	141	2.86e-29	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g25472	i0	82.53	8.4	166	24	99	5	2	165	3523724	3523562	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	1386	141	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1138919	1138919	PRJNA591127_P_NODE_441_length_893_cov_6.641355_g139_i1	PRJNA591127	441	893	6.641355	59.30730015	Roseiflexus	120961	Bacteria	Bacteria	442	4.5799999999999984e-119	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g139	i1	76.29	343.165733482643	911	168	100	41	1	893	892	12	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	306447	442	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
1138936	1138936	PRJNA591127_P_NODE_6221_length_295_cov_2.201550_g6053_i0	PRJNA591127	6221	295	2.20155	6.4945725	Chloroflexus	1107	Bacteria	Bacteria	302	2.46e-77	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g6053	i0	87.313	327	268	28	90	6	1	265	816	1080	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	96465	302	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
3116025	3116025	PRJNA591127_P_NODE_26483_length_161_cov_1.056452_g26314_i0	PRJNA591127	26483	161	1.056452	1.70088772	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	178	2.12e-40	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g26314	i0	87.662	164.906832298137	154	17	94	1	10	161	2827428	2827581	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	26550	178	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
8791476	8791476	PRJNA591127_P_NODE_12767_length_206_cov_1.207101_g12598_i0	PRJNA591127	12767	206	1.207101	2.48662806	Bacteria	2	Bacteria	Bacteria	274	3.5299999999999997e-69	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g12598	i0	90.777	172.956310679612	206	18	100	1	1	206	1651	1855	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	35629	276	0.992753623188406	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
8791487	8791487	PRJNA591127_P_NODE_13527_length_200_cov_1.447853_g13358_i0	PRJNA591127	13527	200	1.447853	2.895706	Chloroflexus	1107	Bacteria	Bacteria	135	1.68e-27	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g13358	i0	80.102	203.965	196	27	96	10	3	193	1128	1316	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	40793	135	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
14593998	14593998	PRJNA591127_P_NODE_3772_length_372_cov_2.122388_g3604_i0	PRJNA591127	3772	372	2.122388	7.89528336	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	366	1.1099999999999999e-96	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g3604	i0	85.205	363.470430107527	365	45	97	9	12	372	971329	971688	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	135211	366	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17142734	17142734	PRJNA591127_P_NODE_24074_length_174_cov_2.226277_g23905_i0	PRJNA591127	24074	174	2.226277	3.87372198	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	244	2.25e-60	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g23905	i0	91.954	716.936781609195	174	14	100	0	1	174	2092954	2092781	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	124747	244	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18417009	18417009	PRJNA591127_P_NODE_32235_length_150_cov_1.460177_g32066_i0	PRJNA591127	32235	150	1.460177	2.1902655	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	220	3.16e-53	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g32066	i0	93.333	110.5	150	9	100	1	1	150	1027836	1027984	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	16575	220	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19691463	19691463	PRJNA591127_P_NODE_22276_length_186_cov_2.429530_g22107_i0	PRJNA591127	22276	186	2.42953	4.5189258	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	200	5.369999999999999e-47	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g22107	i0	88.623	182.241935483871	167	15	89	4	1	166	1858251	1858088	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	33897	200	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22242195	22242195	PRJNA591127_P_NODE_23598_length_177_cov_3.057143_g23429_i0	PRJNA591127	23598	177	3.057143	5.41114311	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	102	1.46e-17	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g23429	i0	83.333	33.6553672316384	114	16	64	3	2	114	2776683	2776794	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	5957	102	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
23517572	23517572	PRJNA591127_P_NODE_9179_length_243_cov_1.325243_g9011_i0	PRJNA591127	9179	243	1.325243	3.22034049	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	339	1.4999999999999997e-88	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g9011	i0	91.77	126.736625514403	243	20	100	0	1	243	2203470	2203228	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	30797	339	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
28216434	28216434	PRJNA591127_P_NODE_17166_length_197_cov_2.575000_g16997_i0	PRJNA591127	17166	197	2.575	5.07275	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	52.8	5.91e-6	NR	NMC84415.1	2024896	g16997	i0	100	0.365482233502538	24	0	36.5	0	196	125	115	138	NMC84415.1 DUF3160 domain-containing protein [Anaerolineaceae bacterium]	diamond	72	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28406191	28406191	PRJNA591127_P_NODE_16746_length_197_cov_2.712500_g16577_i0	PRJNA591127	16746	197	2.7125	5.343625	Anaerolineales bacterium	2073117	Bacteria	Bacteria	58.2	7.28e-8	NR	HNO31874.1	2073117	g16577	i0	100	0.380710659898477	25	0	38.1	0	75	1	94	118	HNO31874.1 hypothetical protein [Anaerolineales bacterium]	diamond	75	58.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29763635	29763635	PRJNA591127_P_NODE_11131_length_220_cov_8.710383_g10962_i0	PRJNA591127	11131	220	8.710383	19.1628426	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	120	5.099999999999999e-33	NR	MDO9333994.1	2026733	g10962	i0	74.4	1.22727272727273	90	5	98.2	1	2	217	29	118	MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium]	diamond	270	120	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
30111260	30111260	PRJNA591127_P_NODE_30232_length_151_cov_3.035088_g30063_i0	PRJNA591127	30232	151	3.035088	4.58298288	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.4	1.76e-5	NR	MCL6509824.1	2052143	g30063	i0	84.6	0.516556291390728	26	4	51.7	0	73	150	72	97	MCL6509824.1 conjugal transfer protein TraL [Anaerolineae bacterium]	diamond	78	50.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31596951	31596951	PRJNA591127_P_NODE_21936_length_188_cov_6.516556_g21767_i0	PRJNA591127	21936	188	6.516556	12.25112528	Anaerolineales bacterium	2073117	Bacteria	Bacteria	130	4.8e-34	NR	HNO31874.1	2073117	g21767	i0	100	0.98936170212766	62	0	98.9	0	1	186	237	298	HNO31874.1 hypothetical protein [Anaerolineales bacterium]	diamond	186	130	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32514480	32514480	PRJNA591127_P_NODE_20139_length_197_cov_1.800000_g19970_i0	PRJNA591127	20139	197	1.8	3.546	Anaerolineae bacterium	2052143	Bacteria	Bacteria	42.4	0.0136	NR	MCA9911727.1	2052143	g19970	i0	84	1.14213197969543	25	4	38.1	0	1	75	103	127	MCA9911727.1 hypothetical protein [Anaerolineae bacterium]	diamond	225	42.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;