metadata: contig_metadata: 22 rows where bioproject = "PRJEB64798", tax_clade = "Candidatus Thermofonsia Clade 3" and tax

22 rows where bioproject = "PRJEB64798", tax_clade = "Candidatus Thermofonsia Clade 3" and tax_superkingdom = "Bacteria"

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_genus	tax_species
128481	128481	PRJEB64798_P_NODE_251181_length_151_cov_7.294118_g249415_i0	PRJEB64798	251181	151	7.294118	11.01411818	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	165	1.52e-36	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g249415	i0	87.586	0.960264900662252	145	15	94	3	5	146	3497812	3497956	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	145	165	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
1401953	1401953	PRJEB64798_P_NODE_17282_length_479_cov_33.223256_g15574_i0	PRJEB64798	17282	479	33.223256	159.13939624	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	656	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g15574	i0	91.579	361.722338204593	475	40	99	0	1	475	3497780	3497306	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	173265	656	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
1403536	1403536	PRJEB64798_P_NODE_45702_length_290_cov_107.195021_g43937_i0	PRJEB64798	45702	290	107.195021	310.8655609	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	340	5.119999999999999e-89	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g43937	i0	91.498	557.224137931035	247	21	85	0	43	289	3497937	3497691	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	161595	340	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
3953439	3953439	PRJEB64798_P_NODE_165264_length_181_cov_2.000000_g163498_i0	PRJEB64798	165264	181	2	3.62	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	87.9	4.21e-13	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g163498	i0	90.769	0.359116022099448	65	6	36	0	1	65	3497774	3497838	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	65	87.9	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
3955151	3955151	PRJEB64798_P_NODE_48204_length_282_cov_21.124464_g46439_i0	PRJEB64798	48204	282	21.124464	59.57098848	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	433	7.95e-117	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g46439	i0	94.346	116.599290780142	283	14	100	2	1	282	3497030	3497311	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	32881	433	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
5229227	5229227	PRJEB64798_P_NODE_12165_length_573_cov_73.026718_g202_i4	PRJEB64798	12165	573	73.026718	418.44309414	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	693	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g202	i4	90.667	459.904013961606	525	44	91	4	4	526	3497511	3496990	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	263525	693	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
6507186	6507186	PRJEB64798_P_NODE_4466_length_909_cov_91.100000_g3523_i0	PRJEB64798	4466	909	91.1	828.099	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	739	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g3523	i0	81.628	131.742574257426	909	151	99	15	11	909	3495302	3494400	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	119754	739	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
9056069	9056069	PRJEB64798_P_NODE_368_length_2544_cov_98.508216_g202_i1	PRJEB64798	368	2544	98.508216	2506.04901504	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	2161	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g202	i1	86.569	238.30856918239	1988	234	98	25	527	2488	3496359	3494379	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	606257	2161	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
9056857	9056857	PRJEB64798_P_NODE_79068_length_216_cov_5.101796_g77302_i0	PRJEB64798	79068	216	5.101796	11.01987936	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	316	6.12e-82	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g77302	i0	93.458	9.1712962962963	214	12	99	2	1	214	3495333	3495122	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1981	316	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
10331703	10331703	PRJEB64798_P_NODE_2869_length_1090_cov_115.817483_g2153_i0	PRJEB64798	2869	1090	115.817483	1262.4105647	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1048	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2153	i0	84.307	152.076146788991	1096	146	99	21	2	1086	3496337	3495257	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	165763	1048	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
11607173	11607173	PRJEB64798_P_NODE_30150_length_358_cov_29.724919_g28393_i0	PRJEB64798	30150	358	29.724919	106.41521002	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	326	1.81e-84	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g28393	i0	88.235	418.22905027933	272	32	76	0	43	314	3497937	3497666	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	149726	326	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
12883166	12883166	PRJEB64798_P_NODE_75191_length_222_cov_7.208092_g73425_i0	PRJEB64798	75191	222	7.208092	16.00196424	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	270	4.9899999999999996e-68	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g73425	i0	89.401	323.342342342342	217	20	96	2	5	218	3494946	3495162	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	71782	270	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
16705834	16705834	PRJEB64798_P_NODE_52314_length_270_cov_9.389140_g50549_i0	PRJEB64798	52314	270	9.38914	25.350678	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	248	2.94e-61	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g50549	i0	84.091	159.651851851852	264	35	96	4	7	264	3495158	3494896	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	43106	248	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
16706039	16706039	PRJEB64798_P_NODE_634_length_2014_cov_71.562341_g453_i0	PRJEB64798	634	2014	71.562341	1441.26554774	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	2241	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g453	i0	87.38	85.6762661370407	1981	215	99	28	43	2008	3496359	3494399	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	172552	2241	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
16706185	16706185	PRJEB64798_P_NODE_72014_length_227_cov_34.382022_g70249_i0	PRJEB64798	72014	227	34.382022	78.04718994	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	298	2.35e-76	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g70249	i0	92.344	583.31718061674	209	16	92	0	1	209	3497686	3497894	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	132413	298	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
17980233	17980233	PRJEB64798_P_NODE_30315_length_357_cov_13.535714_g28558_i0	PRJEB64798	30315	357	13.535714	48.32249898	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	435	2.87e-117	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g28558	i0	89.337	86.2072829131653	347	35	97	2	8	352	3494983	3494637	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	30776	435	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
19254176	19254176	PRJEB64798_P_NODE_252256_length_150_cov_106.811881_g250490_i0	PRJEB64798	252256	150	106.811881	160.2178215	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	158	2.5199999999999998e-34	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g250490	i0	91.304	9.67333333333333	115	10	77	0	21	135	3498162	3498048	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1451	158	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
19254396	19254396	PRJEB64798_P_NODE_36356_length_327_cov_9.841727_g34597_i0	PRJEB64798	36356	327	9.841727	32.18244729	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	209	1.72e-49	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g34597	i0	81.413	426.721712538226	269	38	80	8	6	266	3494415	3494679	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	139538	209	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
20529942	20529942	PRJEB64798_P_NODE_4577_length_901_cov_59.427230_g3619_i0	PRJEB64798	4577	901	59.42723	535.4393423	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	841	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g3619	i0	84.536	115.581576026637	873	109	100	19	1	862	3495502	3496359	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	104139	841	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
21805406	21805406	PRJEB64798_P_NODE_28418_length_369_cov_41.590625_g26662_i0	PRJEB64798	28418	369	41.590625	153.46940625	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	468	2.94e-127	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g26662	i0	92.879	452.989159891599	323	21	87	2	48	369	3496990	3497311	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	167153	468	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
24352584	24352584	PRJEB64798_P_NODE_127540_length_199_cov_7.733333_g125774_i0	PRJEB64798	127540	199	7.733333	15.38933267	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	134	6e-27	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g125774	i0	79.381	38.1507537688442	194	36	96	4	5	195	3494827	3494635	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	7592	134	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
24353066	24353066	PRJEB64798_P_NODE_158600_length_184_cov_3.148148_g156834_i0	PRJEB64798	158600	184	3.148148	5.79259232	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	122	1.1799999999999999e-23	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g156834	i0	83.969	0.71195652173913	131	17	69	2	52	178	1329716	1329846	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	131	122	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.

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