metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_clade = "Candidatus Thermofonsia Clade 3"

12 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_clade = "Candidatus Thermofonsia Clade 3"

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
1565734	1565734	PRJNA1148190_P_NODE_142722_length_440_cov_1.547684_g131557_i0	PRJNA1148190	142722	440	1.547684	6.8098096	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	479	1.6499999999999993e-130	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g131557	i0	86.468	40.7863636363636	436	59	99	0	5	440	3806624	3806189	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	17946	479	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
1570119	1570119	PRJNA1148190_P_NODE_428322_length_281_cov_1.033654_g417149_i0	PRJNA1148190	428322	281	1.033654	2.90456774	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	195	4.07e-45	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g417149	i0	81.6	4.81494661921708	250	32	86	11	39	281	2394530	2394288	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1353	195	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
5393891	5393891	PRJNA1148190_P_NODE_120285_length_481_cov_2.512255_g109122_i0	PRJNA1148190	120285	481	2.512255	12.08394655	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	399	1.4499999999999998e-106	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g109122	i0	81.743	2.72765072765073	482	84	99	4	1	480	1037076	1036597	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1312	399	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
6669257	6669257	PRJNA1148190_P_NODE_160586_length_415_cov_2.067251_g149419_i0	PRJNA1148190	160586	415	2.067251	8.57909165	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	401	3.439999999999999e-107	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g149419	i0	84.173	38.1204819277108	417	62	100	4	1	415	3807298	3807712	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	15820	401	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
6671436	6671436	PRJNA1148190_P_NODE_295966_length_321_cov_2.209677_g284793_i0	PRJNA1148190	295966	321	2.209677	7.09306317	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	60.2	1.8e-4	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g284793	i0	89.796	0.152647975077882	49	2	15	3	223	269	481100	481053	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	49	60.2	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
10500418	10500418	PRJNA1148190_P_NODE_509989_length_265_cov_0.968750_g498816_i0	PRJNA1148190	509989	265	0.96875	2.5671875	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	207	4.88e-49	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g498816	i0	91.391	73.8415094339623	151	13	57	0	94	244	3963625	3963475	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	19568	207	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
16874873	16874873	PRJNA1148190_P_NODE_595954_length_251_cov_0.865169_g584781_i0	PRJNA1148190	595954	251	0.865169	2.17157419	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	100	8.01e-17	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g584781	i0	79.71	2.20318725099602	138	28	55	0	44	181	3279621	3279484	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	553	100	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
18142727	18142727	PRJNA1148190_P_NODE_136655_length_450_cov_1.604775_g125490_i0	PRJNA1148190	136655	450	1.604775	7.2214875	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	435	3.699999999999999e-117	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g125490	i0	86.466	95.3022222222222	399	50	88	3	1	397	4406925	4406529	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	42886	435	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
18143025	18143025	PRJNA1148190_P_NODE_153635_length_424_cov_1.672365_g142468_i0	PRJNA1148190	153635	424	1.672365	7.0908276	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	279	1.7200000000000002e-70	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g142468	i0	82.5	12.1132075471698	320	54	75	2	105	423	2349425	2349743	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	5136	279	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
18148576	18148576	PRJNA1148190_P_NODE_522295_length_262_cov_1.608466_g511122_i0	PRJNA1148190	522295	262	1.608466	4.21418092	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	239	1.71e-58	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g511122	i0	83.333	0.984732824427481	258	43	98	0	1	258	2468253	2468510	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	258	239	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
20699951	20699951	PRJNA1148190_P_NODE_647717_length_248_cov_0.880000_g636544_i0	PRJNA1148190	647717	248	0.88	2.1824	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	137	6.019999999999999e-28	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g636544	i0	97.5	3.70967741935484	80	2	32	0	1	80	286226	286147	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	920	137	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
24519083	24519083	PRJNA1148190_P_NODE_264800_length_336_cov_1.117871_g253629_i0	PRJNA1148190	264800	336	1.117871	3.75604656	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	287	7.98e-73	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g253629	i0	83.828	99.8541666666667	303	47	90	2	1	302	1801294	1801595	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	33551	287	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);;