metadata: contig_metadata: 16 rows where bioproject = "PRJNA437204" and tax

16 rows where bioproject = "PRJNA437204" and tax_phylum = "Fibrobacterota"

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
5536170	5536170	PRJNA437204_P_NODE_35105_length_338_cov_4.301887_g34806_i0	PRJNA437204	35105	338	4.301887	14.54037806	Fibrobacter succinogenes	833	Bacteria	Bacteria	265	3.7599999999999995e-66	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g34806	i0	82.133	26.1775147928994	347	27	100	11	1	338	753675	753355	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	8848	265	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
5537079	5537079	PRJNA437204_P_NODE_82485_length_251_cov_0.865169_g82186_i0	PRJNA437204	82485	251	0.865169	2.17157419	Fibrobacter succinogenes	833	Bacteria	Bacteria	193	1.28e-44	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g82186	i0	81.739	1.83266932270916	230	42	92	0	20	249	3663843	3663614	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	460	193	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
5537409	5537409	PRJNA437204_P_NODE_99945_length_247_cov_0.885057_g99646_i0	PRJNA437204	99945	247	0.885057	2.18609079	Fibrobacter succinogenes	833	Bacteria	Bacteria	261	3.41e-65	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g99646	i0	86.555	1.92712550607287	238	30	96	2	11	247	407879	408115	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	476	261	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
6810039	6810039	PRJNA437204_P_NODE_27886_length_365_cov_5.208904_g27587_i0	PRJNA437204	27886	365	5.208904	19.0124996	Fibrobacter succinogenes	833	Bacteria	Bacteria	368	3.03e-97	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g27587	i0	85.714	24.372602739726	371	28	99	12	1	362	753355	753709	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	8896	368	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
17010628	17010628	PRJNA437204_P_NODE_83474_length_250_cov_2.875706_g83175_i0	PRJNA437204	83474	250	2.875706	7.189265	Fibrobacter succinogenes	833	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g83175	i0	84.545	35.684	220	22	88	5	23	242	753587	753380	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	8921	207	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
19558660	19558660	PRJNA437204_P_NODE_49956_length_300_cov_3.180617_g49657_i0	PRJNA437204	49956	300	3.180617	9.541851	Fibrobacter succinogenes	833	Bacteria	Bacteria	427	3.97e-115	NTclustered	gi\|559133573\|tpe\|HG788729.1\|	59374	g49657	i0	92.409	4.93333333333333	303	18	100	5	1	300	7	307	TPA: Fibrobacter succinogenes subsp. succinogenes S85 transfer-messenger mRNA Fibro_succi_S85, single chain mature transcript	blastn	1480	427	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
23385597	23385597	PRJNA437204_P_NODE_84779_length_250_cov_0.870056_g84480_i0	PRJNA437204	84779	250	0.870056	2.17514	Fibrobacter succinogenes	833	Bacteria	Bacteria	318	2.02e-82	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g84480	i0	89.6	2	250	26	100	0	1	250	3678339	3678588	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	500	318	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
27138685	27138685	PRJNA437204_P_NODE_104942_length_246_cov_0.890173_g104643_i0	PRJNA437204	104942	246	0.890173	2.18982558	Fibrobacter sp. UWR2	1964352	Bacteria	Bacteria	171	3.7e-51	NR	WP_088636820.1	1964352	g104643	i0	100	1	82	0	100	0	1	246	96	177	WP_088636820.1 TIGR02147 family protein [Fibrobacter sp. UWR2]	diamond	246	171	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWR2
27202100	27202100	PRJNA437204_P_NODE_103382_length_246_cov_0.890173_g103083_i0	PRJNA437204	103382	246	0.890173	2.18982558	Fibrobacter sp. UWT2	1896224	Bacteria	Bacteria	167	4.8999999999999996e-48	NR	WP_072797043.1	1896224	g103083	i0	100	10	82	0	100	0	246	1	260	341	WP_072797043.1 hemolysin family protein [Fibrobacter sp. UWT2]	diamond	2460	167	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWT2
27833921	27833921	PRJNA437204_P_NODE_80764_length_251_cov_0.865169_g80465_i0	PRJNA437204	80764	251	0.865169	2.17157419	Fibrobacter sp. UWH4	1896210	Bacteria	Bacteria	147	1.25e-41	NR	WP_072978995.1	1896210	g80465	i0	89.2	0.99203187250996006	83	9	99.2	0	251	3	11	93	WP_072978995.1 M23 family metallopeptidase [Fibrobacter sp. UWH4]	diamond	249	147	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWH4
28212606	28212606	PRJNA437204_P_NODE_106006_length_246_cov_0.861272_g105707_i0	PRJNA437204	106006	246	0.861272	2.11872912	Fibrobacter sp.	35828	Bacteria	Bacteria	155	4.93e-44	NR	MBR3669623.1	35828	g105707	i0	96.3	1.97560975609756	81	3	98.8	0	2	244	270	350	MBR3669623.1 Na/Pi cotransporter family protein [Fibrobacter sp.]	diamond	486	155	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28355464	28355464	PRJNA437204_P_NODE_125566_length_241_cov_0.916667_g125267_i0	PRJNA437204	125566	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	90.5	5.56e-19	NR	KMQ52423.1	1008392	g125267	i0	51.3	3.95850622406639	78	38	97.1	0	5	238	399	476	KMQ52423.1 signal peptidase [Chitinispirillum alkaliphilum]	diamond	954	90.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae	Chitinispirillum	Chitinispirillum alkaliphilum
28718136	28718136	PRJNA437204_P_NODE_109627_length_245_cov_0.895349_g109328_i0	PRJNA437204	109627	245	0.895349	2.19360505	Fibrobacter sp. UWH4	1896210	Bacteria	Bacteria	164	2.12e-45	NR	WP_254793838.1	1896210	g109328	i0	96.3	1.98367346938776	81	3	99.2	0	243	1	62	142	WP_254793838.1 tetratricopeptide repeat protein [Fibrobacter sp. UWH4]	diamond	486	164	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWH4
29633289	29633289	PRJNA437204_P_NODE_112810_length_244_cov_0.900585_g112511_i0	PRJNA437204	112810	244	0.900585	2.1974274	Fibrobacter sp.	35828	Bacteria	Bacteria	67	1.01e-10	NR	WP_290993461.1	35828	g112511	i0	96.8	0.762295081967213	31	1	38.1	0	3	95	474	504	WP_290993461.1 HD-GYP domain-containing protein [Fibrobacter sp.]	diamond	186	67	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29854832	29854832	PRJNA437204_P_NODE_91751_length_249_cov_0.875000_g91452_i0	PRJNA437204	91751	249	0.875	2.17875	uncultured Fibrobacter sp.	261512	Bacteria	Bacteria	172	8.41e-49	NR	WP_297700320.1	261512	g91452	i0	95.1	1.97590361445783	82	4	98.8	0	2	247	44	125	WP_297700320.1 ABC transporter substrate-binding protein [uncultured Fibrobacter sp.]	diamond	492	172	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	uncultured Fibrobacter sp.
31261398	31261398	PRJNA437204_P_NODE_87955_length_250_cov_0.864407_g87656_i0	PRJNA437204	87955	250	0.864407	2.1610175	FCB group	1783270	Bacteria	Bacteria	156	5.7199999999999986e-43	NR	WP_163438601.1	833	g87656	i0	97.6	1.992	83	2	99.6	0	250	2	4	86	WP_163438601.1 L-lactate permease [Fibrobacter succinogenes]	diamond	498	156	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes

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