metadata: contig_metadata: 26 rows where bioproject = "PRJNA630162" and tax

26 rows where bioproject = "PRJNA630162" 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
602307	602307	PRJNA630162_P_NODE_45581_length_262_cov_1.596244_g44058_i0	PRJNA630162	45581	262	1.596244	4.18215928	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	252	2.1999999999999997e-62	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g44058	i0	84.27	641.347328244275	267	33	100	6	1	262	2981706	2981444	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	168033	252	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
602337	602337	PRJNA630162_P_NODE_48681_length_253_cov_1.259804_g47158_i0	PRJNA630162	48681	253	1.259804	3.18730412	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	147	2.23e-39	NR	HEX7510617.1	2663014	g47158	i0	76.8	1.94466403162055	82	19	97.2	0	4	249	319	400	HEX7510617.1 phosphoenolpyruvate carboxykinase (GTP) [Chitinivibrionales bacterium]	diamond	492	147	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
1151210	1151210	PRJNA630162_P_NODE_137061_length_168_cov_0.873950_g135538_i0	PRJNA630162	137061	168	0.87395	1.468236	Fibrobacter	832	Bacteria	Bacteria	132	1.7600000000000002e-26	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g135538	i0	83.117	75.5416666666667	154	17	90	7	1	152	432	286	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	12691	132	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
3152991	3152991	PRJNA630162_P_NODE_22903_length_383_cov_7.080838_g21385_i0	PRJNA630162	22903	383	7.080838	27.11960954	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	466	1.0999999999999999e-126	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g21385	i0	88.802	185.955613577023	384	37	99	6	3	383	2061397	2061777	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	71221	466	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
3703226	3703226	PRJNA630162_P_NODE_67043_length_216_cov_1.856287_g65520_i0	PRJNA630162	67043	216	1.856287	4.00957992	Fibrobacter	832	Bacteria	Bacteria	152	1.83e-32	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g65520	i0	81.218	16.5787037037037	197	29	89	6	7	199	1279	1471	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	3581	152	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
4430499	4430499	PRJNA630162_P_NODE_93504_length_189_cov_3.635714_g91981_i0	PRJNA630162	93504	189	3.635714	6.87149946	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	202	1.5199999999999998e-47	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g91981	i0	88.69	93.031746031746	168	16	88	3	3	168	1594436	1594270	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	17583	202	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
5706112	5706112	PRJNA630162_P_NODE_59545_length_228_cov_25.804469_g58022_i0	PRJNA630162	59545	228	25.804469	58.83418932	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	372	1.37e-98	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g58022	i0	96.847	76.4561403508772	222	7	97	0	1	222	2062091	2061870	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	17432	372	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
7529379	7529379	PRJNA630162_P_NODE_54726_length_238_cov_2.423280_g53203_i0	PRJNA630162	54726	238	2.42328	5.7674064	root	1	Root_unresolved	Root_unresolved	139	8.21e-38	NR	NLW33541.1	35828	g53203	i0	88.5	29.2310924369748	78	9	98.3	0	5	238	190	267	NLW33541.1 type I glyceraldehyde-3-phosphate dehydrogenase [Fibrobacter sp.]	diamond	6957	140	0.992857142857143	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
8255399	8255399	PRJNA630162_P_NODE_38787_length_286_cov_2.666667_g37264_i0	PRJNA630162	38787	286	2.666667	7.62666762	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	372	1.79e-98	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g37264	i0	90.459	332.178321678322	283	26	99	1	5	286	1596623	1596905	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	95003	372	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
10079932	10079932	PRJNA630162_P_NODE_46688_length_258_cov_4.799043_g45165_i0	PRJNA630162	46688	258	4.799043	12.38153094	Fibrobacter	832	Bacteria	Bacteria	340	4.48e-89	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g45165	i0	90.625	170.22480620155	256	24	99	0	3	258	545	800	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	43918	340	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
10806367	10806367	PRJNA630162_P_NODE_30329_length_328_cov_3.713262_g28807_i0	PRJNA630162	30329	328	3.713262	12.17949936	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	320	7.66e-83	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g28807	i0	88.519	57.2865853658537	270	24	81	6	4	270	1595439	1595174	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	18790	320	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
10806773	10806773	PRJNA630162_P_NODE_69749_length_212_cov_4.239264_g68226_i0	PRJNA630162	69749	212	4.239264	8.98723968	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	255	1.32e-63	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g68226	i0	89.655	87.4669811320755	203	18	98	3	6	207	2980646	2980846	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	18543	255	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
12081840	12081840	PRJNA630162_P_NODE_56250_length_235_cov_1.849462_g54727_i0	PRJNA630162	56250	235	1.849462	4.3462357	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	220	5.46e-53	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g54727	i0	89.011	97.4893617021277	182	15	88	5	47	227	2980893	2980716	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	22910	220	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
12081969	12081969	PRJNA630162_P_NODE_68750_length_213_cov_5.536585_g67227_i0	PRJNA630162	68750	213	5.536585	11.79292605	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	263	7.95e-66	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g67227	i0	89.806	830.741784037559	206	19	96	2	7	210	1596630	1596835	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	176948	263	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
12082194	12082194	PRJNA630162_P_NODE_89250_length_192_cov_2.048951_g87727_i0	PRJNA630162	89250	192	2.048951	3.93398592	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	196	7.22e-46	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g87727	i0	85.714	139.098958333333	189	24	97	3	1	187	2981925	2981738	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	26707	196	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
13356634	13356634	PRJNA630162_P_NODE_56011_length_235_cov_5.892473_g54488_i0	PRJNA630162	56011	235	5.892473	13.84731155	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	91.6	4.46e-14	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g54488	i0	81.818	45.1617021276596	110	18	46	2	26	133	2061595	2061486	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	10613	91.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
14631227	14631227	PRJNA630162_P_NODE_43572_length_268_cov_4.255708_g42049_i0	PRJNA630162	43572	268	4.255708	11.40529744	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	427	3.49e-115	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g42049	i0	96.183	142.787313432836	262	9	97	1	3	263	1596517	1596256	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	38267	427	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
14631369	14631369	PRJNA630162_P_NODE_56272_length_235_cov_1.741935_g54749_i0	PRJNA630162	56272	235	1.741935	4.09354725	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	191	4.28e-44	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g54749	i0	82.727	104.4	220	32	92	5	3	218	1595681	1595464	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	24534	191	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
14631408	14631408	PRJNA630162_P_NODE_60112_length_227_cov_10.983146_g58589_i0	PRJNA630162	60112	227	10.983146	24.93174142	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	263	8.58e-66	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g58589	i0	87.712	285.867841409692	236	15	98	4	4	225	2062511	2062746	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	64892	263	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
18454484	18454484	PRJNA630162_P_NODE_5735_length_799_cov_84.045333_g4623_i0	PRJNA630162	5735	799	84.045333	671.52221067	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	1077	0	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g4623	i0	91.125	214.704630788486	800	64	99	7	1	797	2981708	2982503	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	171549	1077	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
19728028	19728028	PRJNA630162_P_NODE_114116_length_177_cov_2.656250_g112593_i0	PRJNA630162	114116	177	2.65625	4.7015625	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	261	2.28e-65	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g112593	i0	94.675	119.197740112994	169	8	95	1	3	171	2060467	2060300	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	21098	261	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
19728952	19728952	PRJNA630162_P_NODE_50596_length_248_cov_1.427136_g49073_i0	PRJNA630162	50596	248	1.427136	3.53929728	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	377	3.26e-100	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g49073	i0	95	133.923387096774	240	12	97	0	8	247	2060330	2060569	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	33213	377	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
21004709	21004709	PRJNA630162_P_NODE_41877_length_274_cov_3.866667_g40354_i0	PRJNA630162	41877	274	3.866667	10.59466758	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	244	3.8699999999999996e-60	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g40354	i0	87.923	205.660583941606	207	25	76	0	16	222	1595503	1595709	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	56351	244	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
21005237	21005237	PRJNA630162_P_NODE_95717_length_188_cov_1.805755_g94194_i0	PRJNA630162	95717	188	1.805755	3.3948194	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	267	5.289999999999999e-67	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g94194	i0	93.333	64.9255319148936	180	12	96	0	7	186	2981841	2982020	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	12206	267	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
21553432	21553432	PRJNA630162_P_NODE_4877_length_864_cov_10.018405_g3841_i0	PRJNA630162	4877	864	10.018405	86.5590192	Fibrobacter	832	Bacteria	Bacteria	749	0	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g3841	i0	82.494	90.7256944444444	874	134	100	17	1	864	1027	1891	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	78387	754	0.993368700265252	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
31692495	31692495	PRJNA630162_P_NODE_107537_length_181_cov_1.545455_g106014_i0	PRJNA630162	107537	181	1.545455	2.79727355	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	65.1	1.89e-10	NR	HLP41311.1	2725311	g106014	i0	47.5	1.95580110497238	59	31	97.8	0	179	3	140	198	HLP41311.1 patatin-like phospholipase family protein [Fibrobacteria bacterium]	diamond	354	65.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria 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);;