metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA315314" 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
2931508	2931508	PRJNA315314_S_NODE_25063_length_167_cov_3.594203_g24742_i0	PRJNA315314	25063	167	3.594203	6.00231901	Anaerolinea thermophila	167964	Bacteria	Bacteria	183	4.759999999999998e-42	NTclustered	gi\|319993263\|dbj\|AP012029.1\|	926569	g24742	i0	89.583	297.958083832335	144	15	86	0	1	144	198599	198742	Anaerolinea thermophila UNI-1 DNA, complete genome	blastn	49759	183	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
4207977	4207977	PRJNA315314_S_NODE_19224_length_188_cov_3.037736_g18903_i0	PRJNA315314	19224	188	3.037736	5.71094368	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	163	7.13e-36	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g18903	i0	83.333	112.473404255319	186	22	96	9	1	180	2827960	2828142	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	21145	163	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
6758459	6758459	PRJNA315314_S_NODE_19846_length_185_cov_7.980769_g19525_i0	PRJNA315314	19846	185	7.980769	14.76442265	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	196	6.9e-46	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g19525	i0	85.87	7.13513513513514	184	26	99	0	1	184	3495150	3495333	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1320	196	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
6758772	6758772	PRJNA315314_S_NODE_9226_length_266_cov_84.050633_g8905_i0	PRJNA315314	9226	266	84.050633	223.57468378	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	209	1.36e-49	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g8905	i0	80.97	30.6052631578947	268	48	100	3	1	266	3494904	3494638	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	8141	209	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
7443179	7443179	PRJNA315314_S_NODE_19286_length_188_cov_2.251572_g18965_i0	PRJNA315314	19286	188	2.251572	4.23295536	Herpetosiphon	64	Bacteria	Bacteria	303	4.03e-78	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g18965	i0	95.745	6	188	8	100	0	1	188	2726	2913	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	1128	303	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
8717909	8717909	PRJNA315314_S_NODE_23747_length_171_cov_4.323944_g23426_i0	PRJNA315314	23747	171	4.323944	7.39394424	Herpetosiphon	64	Bacteria	Bacteria	311	2.14e-80	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g23426	i0	99.415	135.327485380117	171	1	100	0	1	171	965	1135	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	23141	311	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
9309139	9309139	PRJNA315314_S_NODE_9608_length_261_cov_4.456897_g9287_i0	PRJNA315314	9608	261	4.456897	11.63250117	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	460	3.3399999999999995e-125	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g9287	i0	98.467	41.1915708812261	261	4	100	0	1	261	4626723	4626983	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	10751	460	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
10584483	10584483	PRJNA315314_S_NODE_10709_length_247_cov_49.009174_g10388_i0	PRJNA315314	10709	247	49.009174	121.05265978	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	195	3.51e-45	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g10388	i0	81.857	291.672064777328	237	37	95	6	1	234	3494667	3494434	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	72043	195	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
10584858	10584858	PRJNA315314_S_NODE_5069_length_356_cov_539.669725_g4748_i0	PRJNA315314	5069	356	539.669725	1921.224221	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	309	1.81e-79	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g4748	i0	82.584	880.988764044944	356	57	99	5	1	351	971133	971488	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	313632	309	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11859633	11859633	PRJNA315314_S_NODE_3250_length_442_cov_32.728814_g2930_i0	PRJNA315314	3250	442	32.728814	144.66135788	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	361	6.25e-95	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2930	i0	84.35	156.721719457014	377	50	85	5	66	442	3495867	3495500	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	69271	361	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
14409772	14409772	PRJNA315314_S_NODE_2512_length_499_cov_33.212766_g2206_i0	PRJNA315314	2512	499	33.212766	165.73170234	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	416	1.4999999999999999e-111	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2206	i0	82.107	227.845691382766	503	75	100	11	1	499	3495500	3495991	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	113695	416	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
14409931	14409931	PRJNA315314_S_NODE_5612_length_339_cov_28.432258_g5291_i0	PRJNA315314	5612	339	28.432258	96.38535462	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	424	5.89e-114	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g5291	i0	89.349	160.498525073746	338	35	99	1	1	338	3496990	3497326	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	54409	424	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
15683343	15683343	PRJNA315314_S_NODE_14553_length_214_cov_3.286486_g14232_i0	PRJNA315314	14553	214	3.286486	7.03308004	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	289	1.3199999999999998e-73	NTclustered	gi\|672229662\|emb\|HE861155.1\|	166587	g14232	i0	94.18	81.7943925233645	189	11	88	0	1	189	733	545	Uncultured Chloroflexi bacterium partial 16S rRNA gene, clone5C_14	blastn	17504	289	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
16958350	16958350	PRJNA315314_S_NODE_31214_length_152_cov_5.276423_g30893_i0	PRJNA315314	31214	152	5.276423	8.02016296	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	141	2.58e-29	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g30893	i0	83.66	56.1842105263158	153	22	99	3	2	152	3495045	3494894	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	8540	141	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
18232429	18232429	PRJNA315314_S_NODE_18195_length_193_cov_3.829268_g17874_i0	PRJNA315314	18195	193	3.829268	7.39048724	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	350	5.27e-92	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g17874	i0	100	154.979274611399	189	0	98	0	5	193	5446477	5446665	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	29911	350	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
19507021	19507021	PRJNA315314_S_NODE_6076_length_327_cov_38.550336_g5755_i0	PRJNA315314	6076	327	38.550336	126.05959872	Litorilinea aerophila	1204385	Bacteria	Bacteria	200	1.0399999999999999e-46	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g5755	i0	78.078	415.474006116208	333	62	100	10	1	327	4364	4691	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	135860	200	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
22057385	22057385	PRJNA315314_S_NODE_26898_length_162_cov_2.759398_g26577_i0	PRJNA315314	26898	162	2.759398	4.47022476	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	165	1.66e-36	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g26577	i0	85.535	32.8518518518519	159	21	97	2	1	157	64386	64228	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	5322	165	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22742127	22742127	PRJNA315314_S_NODE_23078_length_173_cov_5.375000_g22757_i0	PRJNA315314	23078	173	5.375	9.29875	Herpetosiphon	64	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g22757	i0	100	6	173	0	100	0	1	173	757	585	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	1038	320	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
23332841	23332841	PRJNA315314_S_NODE_21859_length_177_cov_16.135135_g21538_i0	PRJNA315314	21859	177	16.135135	28.55918895	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	248	1.7799999999999998e-61	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g21538	i0	92.486	435.480225988701	173	13	98	0	5	177	2829180	2829008	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	77080	248	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
24606739	24606739	PRJNA315314_S_NODE_13040_length_225_cov_7.841837_g12719_i0	PRJNA315314	13040	225	7.841837	17.64413325	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	154	5.33e-33	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g12719	i0	84.615	89.0666666666667	156	23	69	1	4	159	3497949	3497795	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	20040	154	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
24606979	24606979	PRJNA315314_S_NODE_26380_length_163_cov_33.701493_g26059_i0	PRJNA315314	26380	163	33.701493	54.93343359	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	252	1.25e-62	NTclustered	gi\|374851800\|dbj\|AP011699.1\|	166587	g26059	i0	94.479	238.509202453988	163	9	100	0	1	163	23262	23100	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF019_G07	blastn	38877	252	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
24607075	24607075	PRJNA315314_S_NODE_32340_length_150_cov_2.785124_g32019_i0	PRJNA315314	32340	150	2.785124	4.177686	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	161	1.95e-35	NTclustered	gi\|2891482144\|emb\|OZ219877.1\|	3069543	g32019	i0	86.184	96.6466666666667	152	18	100	2	1	150	872585	872735	MAG: Phototrophicaceae bacterium isolate a0ca3ffb-69cb-424d-9738-2476a81df9ad genome assembly, chromosome: 3	blastn	14497	161	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
24607207	24607207	PRJNA315314_S_NODE_8860_length_272_cov_4.234568_g8539_i0	PRJNA315314	8860	272	4.234568	11.51802496	Litorilinea aerophila	1204385	Bacteria	Bacteria	267	8.189999999999999e-67	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g8539	i0	84.364	60.3419117647059	275	39	99	4	2	272	4382	4108	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	16413	267	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
25291380	25291380	PRJNA315314_S_NODE_15260_length_209_cov_9.077778_g14939_i0	PRJNA315314	15260	209	9.077778	18.97255602	Caldilinea	233191	Bacteria	Bacteria	235	1.6999999999999998e-57	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g14939	i0	86.854	197.55980861244	213	24	100	2	1	209	1121	1333	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	41290	235	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila

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