metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA816047" 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
25634166	25634166	PRJNA816047b_S_NODE_35113_length_285_cov_2.424528_g32801_i0	PRJNA816047	35113	285	2.424528	6.9099048	Roseiflexus	120961	Bacteria	Bacteria	159	1.51e-34	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g32801	i0	83.24	9.50526315789474	179	25	62	5	17	194	52	226	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	2709	159	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
25734878	25734878	PRJNA816047b_S_NODE_33546_length_291_cov_0.876147_g31234_i0	PRJNA816047	33546	291	0.876147	2.54958777	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	69.4	2.68e-7	NTclustered	gi\|2893358447\|emb\|OZ220739.1\|	3022862	g31234	i0	93.478	0.15807560137457	46	3	16	0	1	46	855452	855407	MAG: Tepidiformaceae bacterium isolate ddb3cf28-bb63-44a4-8fd1-08202229d10a genome assembly, chromosome: 1	blastn	46	69.4	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
25738114	25738114	PRJNA816047d_S_NODE_143410_length_219_cov_2911.771084_g141575_i0	PRJNA816047	143410	219	2911.771084	6376.77867396	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	76.8	1.15e-9	NTclustered	gi\|2166239447\|dbj\|LC662861.1\|	2026734	g141575	i0	95.745	193.420091324201	47	2	21	0	156	202	5116	5162	Dehalococcoidia bacterium ARSSAG-00000218 DNA, putative prophage region, clone: 00000218_pp1	blastn	42359	76.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
25742316	25742316	PRJNA816047d_S_NODE_77970_length_264_cov_1.033175_g76135_i0	PRJNA816047	77970	264	1.033175	2.727582	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	431	2.65e-116	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g76135	i0	96.887	0.973484848484849	257	8	97	0	1	257	888665	888409	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	257	431	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
25876061	25876061	PRJNA816047d_S_NODE_40331_length_340_cov_3.526132_g38496_i0	PRJNA816047	40331	340	3.526132	11.9888488	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	206	2.33e-48	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g38496	i0	87.64	0.523529411764706	178	21	52	1	20	196	4345217	4345394	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	178	206	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
26009794	26009794	PRJNA816047d_S_NODE_128532_length_232_cov_2735.988827_g126697_i0	PRJNA816047	128532	232	2735.988827	6347.49407864	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	78.7	3.42e-10	NTclustered	gi\|2166239447\|dbj\|LC662861.1\|	2026734	g126697	i0	100	183.375	42	0	18	0	18	59	5162	5121	Dehalococcoidia bacterium ARSSAG-00000218 DNA, putative prophage region, clone: 00000218_pp1	blastn	42543	78.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26009970	26009970	PRJNA816047d_S_NODE_133188_length_228_cov_2.371429_g131353_i0	PRJNA816047	133188	228	2.371429	5.40685812	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2621704692\|emb\|OY762063.1\|	2026734	g131353	i0	100	0.12280701754386	28	0	12	0	118	145	2263657	2263684	MAG: Dehalococcoidia bacterium isolate 5405c63e-44e1-4988-9b68-fe709a885d54 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26011874	26011874	PRJNA816047d_S_NODE_31788_length_378_cov_7406.273846_g29954_i0	PRJNA816047	31788	378	7406.273846	27995.71513788	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	564	3.74e-156	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g29954	i0	99.357	2.32804232804233	311	2	82	0	1	311	696183	696493	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	880	564	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
26014710	26014710	PRJNA816047d_S_NODE_86500_length_258_cov_2.282927_g84665_i0	PRJNA816047	86500	258	2.282927	5.88995166	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	451	1.98e-122	NTclustered	gi\|269790643\|gb\|CP001826.1\|	525904	g84665	i0	98.438	0.992248062015504	256	4	99	0	1	256	612189	612444	Thermobaculum terrenum ATCC BAA-798 chromosome 2, complete sequence	blastn	256	451	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
26148286	26148286	PRJNA816047d_S_NODE_35893_length_358_cov_1.422951_g34058_i0	PRJNA816047	35893	358	1.422951	5.09416458	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	209	1.9e-49	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g34058	i0	78.778	0.868715083798883	311	66	87	0	23	333	4091801	4091491	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	311	209	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26150560	26150560	PRJNA816047d_S_NODE_77437_length_264_cov_4.364929_g75602_i0	PRJNA816047	77437	264	4.364929	11.52341256	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	344	3.55e-90	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g75602	i0	93.86	0.863636363636364	228	14	86	0	22	249	1501955	1502182	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	228	344	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
26284894	26284894	PRJNA816047d_S_NODE_46790_length_320_cov_38889.782772_g44955_i0	PRJNA816047	46790	320	38889.782772	124447.3048704	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	76.8	1.78e-9	NTclustered	gi\|2166239447\|dbj\|LC662861.1\|	2026734	g44955	i0	100	119.325	41	0	13	0	256	296	5119	5159	Dehalococcoidia bacterium ARSSAG-00000218 DNA, putative prophage region, clone: 00000218_pp1	blastn	38184	76.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26418972	26418972	PRJNA816047d_S_NODE_196063_length_200_cov_3312.557823_g194228_i0	PRJNA816047	196063	200	3312.557823	6625.115646	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	80.5	7.97e-11	NTclustered	gi\|2166239447\|dbj\|LC662861.1\|	2026734	g194228	i0	94.34	210.99	53	1	26	2	18	68	5162	5110	Dehalococcoidia bacterium ARSSAG-00000218 DNA, putative prophage region, clone: 00000218_pp1	blastn	42198	80.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26552160	26552160	PRJNA816047b_S_NODE_47040_length_252_cov_0.860335_g44728_i0	PRJNA816047	47040	252	0.860335	2.1680442	Anaerolinea thermophila UNI-1	926569	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|319993263\|dbj\|AP012029.1\|	926569	g44728	i0	94.444	0.142857142857143	36	2	14	0	129	164	1951544	1951509	Anaerolinea thermophila UNI-1 DNA, complete genome	blastn	36	56.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
26556157	26556157	PRJNA816047d_S_NODE_35224_length_361_cov_1.194805_g33389_i0	PRJNA816047	35224	361	1.194805	4.31324605	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	580	3.529999999999999e-161	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g33389	i0	99.071	0.894736842105263	323	3	89	0	39	361	695682	696004	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	323	580	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
26556951	26556951	PRJNA816047d_S_NODE_49032_length_315_cov_0.919847_g47197_i0	PRJNA816047	49032	315	0.919847	2.89751805	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	466	8.89e-127	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g47197	i0	94.408	0.965079365079365	304	16	97	1	12	315	1822265	1821963	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	304	466	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
26557515	26557515	PRJNA816047d_S_NODE_58816_length_293_cov_2.254167_g56981_i0	PRJNA816047	58816	293	2.254167	6.60470931	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	257	5.36e-64	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g56981	i0	84.674	38.2525597269625	261	37	88	3	1	259	861286	861545	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	11208	257	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);;