metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
426964	426964	PRJNA429937_P_NODE_5401_length_1488_cov_7.197395_g3187_i0	PRJNA429937	5401	1488	7.197395	107.0972376	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	2494	0	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g3187	i0	97.281	1.13709677419355	1471	39	99	1	19	1488	5439625	5438155	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	1692	2494	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
1700858	1700858	PRJNA429937_P_NODE_149542_length_184_cov_2.090323_g126915_i0	PRJNA429937	149542	184	2.090323	3.84619432	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	97.1	7.15e-16	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g126915	i0	87.059	0.46195652173913	85	11	46	0	99	183	2677839	2677755	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	85	97.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2976727	2976727	PRJNA429937_P_NODE_15583_length_930_cov_95.315205_g9210_i0	PRJNA429937	15583	930	95.315205	886.4314065	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	263	3.99e-65	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g9210	i0	86.235	41.8602150537634	247	29	41	5	683	927	239861	240104	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	38930	263	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2977568	2977568	PRJNA429937_P_NODE_49983_length_501_cov_3.616525_g32678_i0	PRJNA429937	49983	501	3.616525	18.11879025	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	219	4.559999999999999e-52	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g32678	i0	83.966	102.596806387226	237	28	46	8	4	234	240254	240486	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	51401	219	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8080256	8080256	PRJNA429937_P_NODE_53087_length_483_cov_4.759912_g21845_i2	PRJNA429937	53087	483	4.759912	22.99037496	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	484	3.919999999999999e-132	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g21845	i2	85.163	46.2339544513458	492	52	100	18	1	483	273610	273131	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	22331	484	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9354813	9354813	PRJNA429937_P_NODE_39888_length_570_cov_46.837338_g25191_i0	PRJNA429937	39888	570	46.837338	266.9728266	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	627	7.339999999999999e-175	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g25191	i0	87.207	460.456140350877	555	66	97	5	20	570	5335070	5335623	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	262460	627	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
10015318	10015318	PRJNA429937_P_NODE_102308_length_295_cov_5.398496_g79694_i0	PRJNA429937	102308	295	5.398496	15.9255632	Bacteria	2	Bacteria	Bacteria	289	1.9199999999999996e-73	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g79694	i0	88.211	135.108474576271	246	24	82	5	1	242	239159	238915	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	39857	289	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11905453	11905453	PRJNA429937_P_NODE_41030_length_561_cov_7.992481_g26023_i0	PRJNA429937	41030	561	7.992481	44.83781841	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	259	3.03e-64	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g26023	i0	76.429	83.6613190730838	560	85	95	32	28	561	238925	239463	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	46934	259	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11905676	11905676	PRJNA429937_P_NODE_51450_length_492_cov_4.902808_g33791_i0	PRJNA429937	51450	492	4.902808	24.12181536	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	353	1.18e-92	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g33791	i0	83.905	31.0142276422764	379	51	92	9	120	492	274379	274753	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	15259	353	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11905809	11905809	PRJNA429937_P_NODE_58370_length_455_cov_3.737089_g39065_i0	PRJNA429937	58370	455	3.737089	17.00375495	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	207	8.899999999999999e-49	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g39065	i0	83.122	114.246153846154	237	30	51	8	222	452	240486	240254	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	51982	207	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14456146	14456146	PRJNA429937_P_NODE_70192_length_402_cov_4.680965_g48640_i0	PRJNA429937	70192	402	4.680965	18.8174793	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	327	5.72e-85	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g48640	i0	82.039	351.756218905473	412	49	99	20	7	402	240486	240084	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	141406	327	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15729717	15729717	PRJNA429937_P_NODE_59133_length_451_cov_5.040284_g33791_i1	PRJNA429937	59133	451	5.040284	22.73168084	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	353	1.07e-92	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g33791	i1	83.905	35.7937915742794	379	51	83	9	79	451	274379	274753	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	16143	353	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15729843	15729843	PRJNA429937_P_NODE_65533_length_421_cov_5.390306_g33791_i2	PRJNA429937	65533	421	5.390306	22.69318826	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	387	9.78e-103	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g33791	i2	83.771	39.2327790973872	419	56	98	11	1	412	274753	274340	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	16517	387	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17003841	17003841	PRJNA429937_P_NODE_34654_length_615_cov_144.199659_g21465_i0	PRJNA429937	34654	615	144.199659	886.82790285	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	473	1.1e-128	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g21465	i0	83.773	116.747967479675	493	66	89	13	4	489	240104	239619	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	71800	473	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19552480	19552480	PRJNA429937_P_NODE_35196_length_610_cov_7.419966_g21845_i0	PRJNA429937	35196	610	7.419966	45.2617926	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	350	1.91e-91	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g21845	i0	83.047	57.9786885245902	407	47	66	17	211	610	273219	273610	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	35367	350	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19552529	19552529	PRJNA429937_P_NODE_37476_length_590_cov_4.598930_g23466_i0	PRJNA429937	37476	590	4.59893	27.133687	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	654	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g23466	i0	86.689	108.566101694915	601	66	100	9	1	590	273592	274189	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	64054	654	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19552647	19552647	PRJNA429937_P_NODE_43076_length_546_cov_8.996132_g27482_i0	PRJNA429937	43076	546	8.996132	49.11888072	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	139	4.01e-28	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g27482	i0	92.784	44.6666666666667	97	5	18	2	272	367	2202260	2202165	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	24388	139	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
23378779	23378779	PRJNA429937_P_NODE_39079_length_577_cov_3.950730_g21845_i1	PRJNA429937	39079	577	3.95073	22.7957121	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	449	1.7299999999999995e-121	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g21845	i1	86.215	37.5181975736568	428	44	73	13	157	577	273191	273610	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	21648	449	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24651846	24651846	PRJNA429937_P_NODE_103980_length_290_cov_383.605364_g81363_i0	PRJNA429937	103980	290	383.605364	1112.4555556	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	241	5.340000000000001e-59	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g81363	i0	82.155	86.9068965517241	297	37	100	10	1	290	4664225	4664512	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	25203	241	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
24651953	24651953	PRJNA429937_P_NODE_112100_length_269_cov_1.425000_g89478_i0	PRJNA429937	112100	269	1.425	3.83325	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	97.1	1.12e-15	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g89478	i0	87.059	0.315985130111524	85	11	32	0	2	86	2677755	2677839	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	85	97.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24653072	24653072	PRJNA429937_P_NODE_45300_length_531_cov_3.348606_g29150_i0	PRJNA429937	45300	531	3.348606	17.78109786	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	237	1.34e-57	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g29150	i0	81.908	150.83615819209	304	34	55	16	19	310	240192	240486	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	80094	237	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);;