metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
2350469	2350469	PRJNA382357_P_NODE_37062_length_375_cov_1.340764_g36323_i0	PRJNA382357	37062	375	1.340764	5.027865	Bacteria	2	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2891482054\|emb\|OZ219802.1\|	2026724	g36323	i0	100	2.864	30	0	8	0	87	116	1498933	1498962	MAG: Chloroflexota bacterium isolate 50a8419b-8e17-430b-920a-11f3287aca29 genome assembly, chromosome: 2	blastn	1074	56.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
4231170	4231170	PRJNA382357_P_NODE_51184_length_325_cov_1.231061_g50445_i0	PRJNA382357	51184	325	1.231061	4.00094825	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	58.4	6.56e-4	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g50445	i0	83.333	0.313846153846154	66	8	20	3	99	163	461092	461029	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	102	58.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5506093	5506093	PRJNA382357_P_NODE_107785_length_234_cov_1.878613_g107046_i0	PRJNA382357	107785	234	1.878613	4.39595442	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.2	1.25e-4	NTclustered	gi\|2621701928\|emb\|OY761144.1\|	2026734	g107046	i0	97.143	0.303418803418803	35	1	15	0	136	170	831168	831134	MAG: Dehalococcoidia bacterium isolate d500c233-76a3-46e4-a508-06ea1f82037c genome assembly, chromosome: 1	blastn	71	60.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
5506352	5506352	PRJNA382357_P_NODE_12425_length_601_cov_2.324074_g11707_i0	PRJNA382357	12425	601	2.324074	13.96768474	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	318	5.31e-82	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g11707	i0	84.308	171.728785357737	325	51	99	0	277	601	2827890	2827566	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	103209	318	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
5507322	5507322	PRJNA382357_P_NODE_30325_length_410_cov_1.862464_g29586_i0	PRJNA382357	30325	410	1.862464	7.6361024	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	161	6.27e-35	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g29586	i0	77.667	97.0658536585366	300	44	70	18	116	402	381153	380864	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	39797	161	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
5508262	5508262	PRJNA382357_P_NODE_88145_length_256_cov_1.112821_g87406_i0	PRJNA382357	88145	256	1.112821	2.84882176	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	172	1.71e-38	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g87406	i0	87.417	60.8046875	151	18	59	1	73	222	3521262	3521412	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	15566	172	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
6780541	6780541	PRJNA382357_P_NODE_135606_length_211_cov_0.866667_g134867_i0	PRJNA382357	135606	211	0.866667	1.82866737	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	75	3.96e-9	NTclustered	gi\|2891481993\|emb\|OZ219765.1\|	2026734	g134867	i0	87.5	4.48815165876777	64	8	30	0	121	184	2474063	2474126	MAG: Dehalococcoidia bacterium isolate 2efd49d1-a845-418d-b650-c606456da4a2 genome assembly, chromosome: 2	blastn	947	75	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
8057715	8057715	PRJNA382357_P_NODE_81607_length_264_cov_78.177340_g80868_i0	PRJNA382357	81607	264	78.17734	206.3881776	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	69.4	2.39e-7	NTclustered	gi\|2893358391\|emb\|OZ220682.1\|	2026734	g80868	i0	100	3.65530303030303	37	0	14	0	146	182	504671	504707	MAG: Dehalococcoidia bacterium isolate 0d331d3b-d7ed-4eba-809e-4bb0832fe511 genome assembly, chromosome: 1	blastn	965	69.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
10607000	10607000	PRJNA382357_P_NODE_162769_length_190_cov_11.441860_g162030_i0	PRJNA382357	162769	190	11.44186	21.739534	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	139	1.22e-28	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g162030	i0	97.561	96.8526315789474	82	1	69	1	100	180	5497142	5497061	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	18402	139	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
10608013	10608013	PRJNA382357_P_NODE_65449_length_291_cov_18.886957_g64710_i0	PRJNA382357	65449	291	18.886957	54.96104487	Thermoflexus hugenholtzii	1495650	Bacteria	Bacteria	100	9.49e-17	NTclustered	gi\|2049907263\|gb\|CP076326.1\|	1495650	g64710	i0	90.667	13.5910652920962	75	7	26	0	117	191	1982690	1982616	MAG: Thermoflexus hugenholtzii isolate RBS10-4 chromosome, complete genome	blastn	3955	100	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales	Thermoflexaceae	Thermoflexus	Thermoflexus hugenholtzii
14431682	14431682	PRJNA382357_P_NODE_141172_length_208_cov_1.306122_g140433_i0	PRJNA382357	141172	208	1.306122	2.71673376	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	167	6.24e-37	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g140433	i0	92.308	0.697115384615385	117	9	56	0	92	208	1736750	1736634	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	145	167	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
15103396	15103396	PRJNA382357_P_NODE_9012_length_687_cov_3.565495_g8322_i0	PRJNA382357	9012	687	3.565495	24.49495065	Herpetosiphon	64	Bacteria	Bacteria	706	0	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g8322	i0	98.5	30.9039301310044	400	6	99	0	288	687	677	278	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	21231	706	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
18255092	18255092	PRJNA382357_P_NODE_24995_length_447_cov_1.943005_g24258_i0	PRJNA382357	24995	447	1.943005	8.68523235	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	499	1.29e-136	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g24258	i0	94.479	10.5950782997763	326	14	99	3	121	446	1736302	1736623	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	4736	499	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
19528495	19528495	PRJNA382357_P_NODE_123736_length_220_cov_1.182390_g122997_i0	PRJNA382357	123736	220	1.18239	2.601258	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	287	4.91e-73	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g122997	i0	92.5	0.909090909090909	200	15	91	0	1	200	3594839	3595038	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	200	287	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
22079829	22079829	PRJNA382357_P_NODE_169538_length_173_cov_3.848214_g168799_i0	PRJNA382357	169538	173	3.848214	6.65741022	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	78.7	2.4e-10	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g168799	i0	91.228	4.97687861271676	57	5	33	0	88	144	5484676	5484732	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	861	78.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23354644	23354644	PRJNA382357_P_NODE_118259_length_224_cov_23.625767_g117520_i0	PRJNA382357	118259	224	23.625767	52.92171808	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	65.8	2.56e-6	NTclustered	gi\|2893358391\|emb\|OZ220682.1\|	2026734	g117520	i0	100	4.01339285714286	35	0	31	0	20	54	504673	504707	MAG: Dehalococcoidia bacterium isolate 0d331d3b-d7ed-4eba-809e-4bb0832fe511 genome assembly, chromosome: 1	blastn	899	65.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23354855	23354855	PRJNA382357_P_NODE_13139_length_587_cov_3.342205_g12418_i0	PRJNA382357	13139	587	3.342205	19.61874335	Anaerolineales bacterium	2073117	Bacteria	Bacteria	671	0	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g12418	i0	92.243	319.090289608177	477	32	99	5	1	474	3066759	3067233	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	187306	671	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
23354979	23354979	PRJNA382357_P_NODE_140539_length_208_cov_2.299320_g139800_i0	PRJNA382357	140539	208	2.29932	4.7825856	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	239	1.2999999999999999e-58	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g139800	i0	93.21	84.5913461538462	162	11	78	0	1	162	10923676	10923837	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	17595	239	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23355360	23355360	PRJNA382357_P_NODE_166439_length_181_cov_12.708333_g165700_i0	PRJNA382357	166439	181	12.708333	23.00208273	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	73.1	1.18e-8	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g165700	i0	86.567	1.39779005524862	67	8	37	1	22	88	1265975	1266040	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	253	73.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24630275	24630275	PRJNA382357_P_NODE_50260_length_327_cov_9.853383_g49521_i0	PRJNA382357	50260	327	9.853383	32.22056241	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	89.8	2.34e-13	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g49521	i0	82.353	1.8868501529052	102	18	31	0	58	159	1618521	1618420	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	617	89.8	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);;