metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA438687" 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_species
435391	435391	PRJNA438687_S_NODE_781_length_404_cov_9.569106_g692_i0	PRJNA438687	781	404	9.569106	38.65918824	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	340	7.38e-89	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g692	i0	82.195	227.613861386139	410	59	99	14	1	401	1594046	1594450	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	91956	340	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	uncultured Fibrobacteria bacterium
1710155	1710155	PRJNA438687_S_NODE_3202_length_250_cov_2.655814_g3112_i0	PRJNA438687	3202	250	2.655814	6.639535	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	228	3.4999999999999995e-55	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g3112	i0	90.805	132.068	174	10	68	5	1	171	2981107	2980937	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	33017	228	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
1710211	1710211	PRJNA438687_S_NODE_5802_length_183_cov_3.418919_g5712_i0	PRJNA438687	5802	183	3.418919	6.25662177	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	158	3.21e-34	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g5712	i0	83.051	121.901639344262	177	26	96	4	3	177	1593952	1594126	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	22308	158	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	uncultured Fibrobacteria bacterium
1710217	1710217	PRJNA438687_S_NODE_602_length_434_cov_14.563910_g514_i0	PRJNA438687	602	434	14.56391	63.2073694	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	424	7.71e-114	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g514	i0	84.439	163.723502304147	437	60	99	8	1	432	1595063	1595496	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	71056	424	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	uncultured Fibrobacteria bacterium
2986009	2986009	PRJNA438687_S_NODE_4583_length_207_cov_5.261628_g4493_i0	PRJNA438687	4583	207	5.261628	10.89156996	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	191	3.68e-44	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g4493	i0	84.135	221.570048309179	208	21	98	12	6	207	2061237	2061438	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	45865	191	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
4262378	4262378	PRJNA438687_S_NODE_7344_length_160_cov_2.176000_g7254_i0	PRJNA438687	7344	160	2.176	3.4816	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	279	5.59e-71	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g7254	i0	98.125	169.3875	160	3	100	0	1	160	2981726	2981567	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	27102	279	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
5538986	5538986	PRJNA438687_S_NODE_3305_length_245_cov_2.938095_g3215_i0	PRJNA438687	3305	245	2.938095	7.19833275	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	342	1.17e-89	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g3215	i0	91.837	173.163265306122	245	20	100	0	1	245	2061768	2061524	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	42425	342	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
8088479	8088479	PRJNA438687_S_NODE_2427_length_284_cov_5.823293_g2337_i0	PRJNA438687	2427	284	5.823293	16.53815212	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	364	2.969999999999999e-96	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g2337	i0	89.86	94.0915492957746	286	25	100	2	1	284	2981711	2981428	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	26722	364	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
11914118	11914118	PRJNA438687_S_NODE_8010_length_152_cov_3.358974_g7920_i0	PRJNA438687	8010	152	3.358974	5.10564048	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	226	6.919999999999997e-55	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g7920	i0	93.421	32.1118421052632	152	10	100	0	1	152	2060541	2060390	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	4881	226	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
13189050	13189050	PRJNA438687_S_NODE_7091_length_163_cov_5.101562_g7001_i0	PRJNA438687	7091	163	5.101562	8.31554606	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	171	3.59e-38	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g7001	i0	85.802	457.650306748466	162	22	99	1	2	162	1596744	1596905	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	74597	171	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	uncultured Fibrobacteria bacterium
19561182	19561182	PRJNA438687_S_NODE_2296_length_291_cov_4.585938_g2206_i0	PRJNA438687	2296	291	4.585938	13.34507958	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	411	3.8599999999999997e-110	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g2206	i0	92.15	95.46735395189	293	19	100	4	1	291	2981428	2981718	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	27781	411	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
19561239	19561239	PRJNA438687_S_NODE_4676_length_205_cov_3.376471_g4586_i0	PRJNA438687	4676	205	3.376471	6.92176555	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	172	1.32e-38	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g4586	i0	82.266	628.390243902439	203	32	98	4	3	203	2980828	2980628	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	128820	172	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		Fibrobacterota bacterium
20836820	20836820	PRJNA438687_S_NODE_1157_length_361_cov_12.211656_g1067_i0	PRJNA438687	1157	361	12.211656	44.08407816	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	375	1.79e-99	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g1067	i0	86.207	188.185595567867	348	46	96	2	8	353	1595865	1595518	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	67935	375	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	uncultured Fibrobacteria bacterium
23387491	23387491	PRJNA438687_S_NODE_3459_length_239_cov_5.093137_g3369_i0	PRJNA438687	3459	239	5.093137	12.17259743	uncultured Fibrobacterota bacterium	187319	Bacteria	Bacteria	409	1.11e-109	NTclustered	gi\|118041593\|gb\|EF074547.1\|	187319	g3369	i0	97.49	98.765690376569	239	6	100	0	1	239	717	479	Uncultured Fibrobacteres bacterium clone GASP-WC1S3_A05 16S ribosomal RNA gene, partial sequence	blastn	23605	409	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota		uncultured Fibrobacterota bacterium
24661535	24661535	PRJNA438687_S_NODE_2780_length_267_cov_99.926724_g2690_i0	PRJNA438687	2780	267	99.926724	266.80435308	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	305	1.7e-78	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g2690	i0	92.202	557.947565543071	218	14	81	3	1	216	1596576	1596792	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	148972	305	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	uncultured 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);;