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

15 rows where bioproject = "PRJNA168635", tax_clade = "Candidatus Thermofonsia Clade 3" and tax_kingdom = "Bacillati"

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
364240	364240	PRJNA168635_P_NODE_12461_length_230_cov_8.602210_g12045_i0	PRJNA168635	12461	230	8.60221	19.785083	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	298	2.39e-76	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g12045	i0	90.95	186.986956521739	221	20	96	0	10	230	3497937	3497717	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	43007	298	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
364263	364263	PRJNA168635_P_NODE_1381_length_669_cov_78.277419_g1056_i0	PRJNA168635	1381	669	78.277419	523.67593311	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	808	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g1056	i0	88.688	721.605381165919	663	74	99	1	7	669	3497953	3497292	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	482754	808	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
2915119	2915119	PRJNA168635_P_NODE_20583_length_180_cov_2.885496_g20167_i0	PRJNA168635	20583	180	2.885496	5.1938928	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	165	1.88e-36	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g20167	i0	90.476	258.772222222222	126	11	69	1	1	125	3494415	3494540	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	46579	165	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
2915373	2915373	PRJNA168635_P_NODE_5403_length_363_cov_10.519108_g4998_i0	PRJNA168635	5403	363	10.519108	38.18436204	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	521	2.18e-143	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g4998	i0	92.582	188.939393939394	364	26	100	1	1	363	3497275	3497638	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	68585	521	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
4191626	4191626	PRJNA168635_P_NODE_24_length_2210_cov_118.007867_g12_i1	PRJNA168635	24	2210	118.007867	2607.9738607	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1749	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g12	i1	83.078	110.317194570136	1962	295	94	30	140	2082	3496359	3494416	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	243801	1749	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
9292448	9292448	PRJNA168635_P_NODE_1588_length_633_cov_14.777397_g290_i2	PRJNA168635	1588	633	14.777397	93.54092301	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	584	5.01e-162	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g290	i2	83.516	168.315955766193	637	94	99	9	5	633	3494588	3495221	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	106544	584	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
13118269	13118269	PRJNA168635_P_NODE_2191_length_548_cov_12.511022_g1817_i0	PRJNA168635	2191	548	12.511022	68.56040056	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	734	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g1817	i0	90.909	152.877737226277	550	45	100	5	1	548	3497092	3497638	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	83777	734	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
15667149	15667149	PRJNA168635_P_NODE_13913_length_216_cov_9.467066_g13497_i0	PRJNA168635	13913	216	9.467066	20.44886256	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	252	1.75e-62	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g13497	i0	87.907	4.53240740740741	215	25	99	1	1	215	3495956	3495743	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	979	252	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
18216088	18216088	PRJNA168635_P_NODE_15_length_2415_cov_116.433221_g12_i0	PRJNA168635	15	2415	116.433221	2811.86228715	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1749	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g12	i0	83.078	157.536645962733	1962	295	94	30	345	2287	3496359	3494416	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	380451	1749	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
18216432	18216432	PRJNA168635_P_NODE_55_length_1973_cov_15.212578_g42_i0	PRJNA168635	55	1973	15.212578	300.14416394	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	2235	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g42	i0	87.475	91.772427774962	1964	214	99	25	24	1973	3496359	3494414	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	181067	2235	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
19490306	19490306	PRJNA168635_P_NODE_15536_length_203_cov_3.967532_g15120_i0	PRJNA168635	15536	203	3.967532	8.05408996	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	248	2.1e-61	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g15120	i0	88.67	43.6305418719212	203	23	100	0	1	203	3495515	3495717	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	8857	248	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
20765977	20765977	PRJNA168635_P_NODE_1877_length_588_cov_11.747681_g290_i3	PRJNA168635	1877	588	11.747681	69.07636428	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	640	9.75e-179	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g290	i3	86.851	169.294217687075	578	69	97	6	4	575	3495411	3494835	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	99545	640	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
22041347	22041347	PRJNA168635_P_NODE_6218_length_339_cov_11.037931_g5808_i0	PRJNA168635	6218	339	11.037931	37.41858609	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	448	3.4899999999999997e-121	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g5808	i0	90.643	200.185840707965	342	25	100	6	1	339	3497328	3496991	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	67863	448	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
23316384	23316384	PRJNA168635_P_NODE_10519_length_254_cov_7.180488_g10104_i0	PRJNA168635	10519	254	7.180488	18.23843952	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	237	5.9300000000000005e-58	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g10104	i0	83.969	166.779527559055	262	27	97	9	1	247	3494675	3494414	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	42362	237	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
23316788	23316788	PRJNA168635_P_NODE_399_length_1077_cov_58.301556_g290_i0	PRJNA168635	399	1077	58.301556	627.90775812	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1188	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g290	i0	86.835	168.188486536676	1071	131	99	9	1	1064	3495902	3494835	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	181139	1188	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);;