metadata: contig_metadata: 14 rows where bioproject = "PRJNA977246", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA977246", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

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
4779264	4779264	PRJNA977246_S_NODE_20764_length_301_cov_4.088235_g19772_i0	PRJNA977246	20764	301	4.088235	12.30558735	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	131	4.41e-33	NR	MEP7326841.1	2026742	g19772	i0	77.2	0.916943521594684	92	21	91.7	0	296	21	556	647	MEP7326841.1 protein kinase [Gemmatimonadota bacterium]	diamond	276	131	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
6054365	6054365	PRJNA977246_S_NODE_21065_length_298_cov_3.498141_g20073_i0	PRJNA977246	21065	298	3.498141	10.42446018	Gemmatirosa sp.	2510638	Bacteria	Bacteria	196	7.36e-60	NR	HZF66602.1	2510638	g20073	i0	96.9	0.966442953020134	96	3	96.6	0	289	2	80	175	HZF66602.1 SPFH domain-containing protein [Gemmatirosa sp.]	diamond	288	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
7329314	7329314	PRJNA977246_S_NODE_40606_length_179_cov_4.120000_g39614_i0	PRJNA977246	40606	179	4.12	7.3748	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	285	1.3699999999999998e-72	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g39614	i0	99.363	1.75418994413408	157	1	88	0	1	157	1553765	1553609	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	314	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
9879735	9879735	PRJNA977246_S_NODE_45308_length_165_cov_2.933824_g44316_i0	PRJNA977246	45308	165	2.933824	4.8408096	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	122	1.0399999999999997e-23	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g44316	i0	81.579	2.76969696969697	152	24	91	4	6	155	1067931	1068080	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	457	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
12430481	12430481	PRJNA977246_S_NODE_26530_length_250_cov_3.289593_g25538_i0	PRJNA977246	26530	250	3.289593	8.2239825	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g25538	i0	85.652	49.388	230	33	92	0	13	242	802614	802843	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	12347	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
21353535	21353535	PRJNA977246_S_NODE_37677_length_190_cov_3.037267_g36685_i0	PRJNA977246	37677	190	3.037267	5.7708073	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	156	1.21e-33	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g36685	i0	81.959	2.04210526315789	194	26	100	9	1	190	3042707	3042519	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	388	156	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
21671167	21671167	PRJNA977246_S_NODE_20337_length_305_cov_860.967391_g19345_i0	PRJNA977246	20337	305	860.967391	2625.95054255	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	98.6	1.68e-21	NR	HEX6065740.1	2910168	g19345	i0	64.8	1.72131147540984	88	30	85.6	1	302	42	288	375	HEX6065740.1 FTR1 family protein [Longimicrobiales bacterium]	diamond	525	98.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
26652157	26652157	PRJNA977246_S_NODE_23701_length_273_cov_3.688525_g22709_i0	PRJNA977246	23701	273	3.688525	10.06967325	Bacteria	2	Bacteria	Bacteria	59.3	4.72e-8	NR	MBI4421315.1	2026742	g22709	i0	60.8	2.76923076923077	51	18	53.8	1	149	3	42	92	MBI4421315.1 2-phosphosulfolactate phosphatase [Gemmatimonadota bacterium]	diamond	756	59.7	0.993299832495812	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27405593	27405593	PRJNA977246_S_NODE_48083_length_158_cov_3.139535_g47091_i0	PRJNA977246	48083	158	3.139535	4.9604653	Gemmatirosa sp.	2510638	Bacteria	Bacteria	99.8	3.89e-24	NR	HZF67294.1	2510638	g47091	i0	90.4	0.987341772151899	52	5	98.7	0	2	157	66	117	HZF67294.1 nucleotidyltransferase domain-containing protein [Gemmatirosa sp.]	diamond	156	99.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
28163273	28163273	PRJNA977246_S_NODE_30045_length_226_cov_3.609137_g29053_i0	PRJNA977246	30045	226	3.609137	8.15664962	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	111	1.71e-26	NR	HQR18241.1	2448054	g29053	i0	70.7	3.98230088495575	75	22	99.6	0	225	1	459	533	HQR18241.1 protein kinase [Gemmatimonadales bacterium]	diamond	900	111	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29552206	29552206	PRJNA977246_S_NODE_36390_length_195_cov_3.734940_g35398_i0	PRJNA977246	36390	195	3.73494	7.283133	Gemmatirosa sp.	2510638	Bacteria	Bacteria	95.9	3.59e-23	NR	HZF66787.1	2510638	g35398	i0	75.4	1	65	16	100	0	1	195	12	76	HZF66787.1 ferritin-like domain-containing protein [Gemmatirosa sp.]	diamond	195	95.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
29779588	29779588	PRJNA977246_S_NODE_24971_length_262_cov_5.506438_g23979_i0	PRJNA977246	24971	262	5.506438	14.42686756	Bacteria	2	Bacteria	Bacteria	47	0.00154	NR	MFN9215176.1	2026742	g23979	i0	42.2	2.06106870229008	90	45	96.2	4	4	255	247	335	MFN9215176.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	540	47	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31606371	31606371	PRJNA977246_S_NODE_27356_length_244_cov_3.162791_g26364_i0	PRJNA977246	27356	244	3.162791	7.71721004	Gemmatirosa sp.	2510638	Bacteria	Bacteria	79.7	6.24e-16	NR	HZF67294.1	2510638	g26364	i0	90.9	0.540983606557377	44	4	54.1	0	111	242	1	44	HZF67294.1 nucleotidyltransferase domain-containing protein [Gemmatirosa sp.]	diamond	132	79.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
32270861	32270861	PRJNA977246_S_NODE_44138_length_168_cov_4.510791_g43146_i0	PRJNA977246	44138	168	4.510791	7.57812888	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	82.4	1.38e-16	NR	HOX21343.1	2448054	g43146	i0	81.3	3.41071428571429	48	9	85.7	0	23	166	207	254	HOX21343.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	573	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;