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

15 rows where analysis = "blastn", bioproject = "PRJNA641707" 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
616387	616387	PRJNA641707_P_NODE_41281_length_339_cov_5.917241_g38640_i0	PRJNA641707	41281	339	5.917241	20.05944699	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	257	6.320000000000001e-64	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g38640	i0	93.143	33.905604719764	175	12	52	0	49	223	2061597	2061423	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	11494	257	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
1157585	1157585	PRJNA641707_P_NODE_308701_length_162_cov_1.991150_g306038_i0	PRJNA641707	308701	162	1.99115	3.225663	Fibrobacter	832	Bacteria	Bacteria	279	5.68e-71	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g306038	i0	98.726	179.20987654321	157	2	97	0	1	157	945	789	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	29032	279	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
3166578	3166578	PRJNA641707_P_NODE_310583_length_161_cov_6.223214_g307920_i0	PRJNA641707	310583	161	6.223214	10.01937454	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	141	2.78e-29	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g307920	i0	83.333	0.968944099378882	156	23	95	2	2	154	1594356	1594201	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	156	141	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
4441682	4441682	PRJNA641707_P_NODE_24224_length_442_cov_25.592875_g21654_i0	PRJNA641707	24224	442	25.592875	113.1205075	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	625	2.0099999999999994e-174	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g21654	i0	92.308	195.617647058824	442	31	100	2	1	442	1595095	1594657	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	86463	625	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
5716057	5716057	PRJNA641707_P_NODE_17365_length_522_cov_7.733615_g14948_i0	PRJNA641707	17365	522	7.733615	40.3694703	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	292	2.77e-74	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g14948	i0	88.75	271.990421455939	240	26	59	1	279	517	1594662	1594423	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	141979	292	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
6995309	6995309	PRJNA641707_P_NODE_55386_length_287_cov_13.705882_g52725_i0	PRJNA641707	55386	287	13.705882	39.33588134	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	239	1.9e-58	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g52725	i0	82.105	450.411149825784	285	46	98	4	1	282	2062777	2062495	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	129268	239	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
7535027	7535027	PRJNA641707_P_NODE_251846_length_181_cov_8.159091_g249183_i0	PRJNA641707	251846	181	8.159091	14.76795471	Fibrobacter	832	Bacteria	Bacteria	237	3.95e-58	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g249183	i0	90.909	151.823204419889	176	16	97	0	5	180	1077	1252	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	27480	237	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
10817308	10817308	PRJNA641707_P_NODE_202589_length_197_cov_4.202703_g199926_i0	PRJNA641707	202589	197	4.202703	8.27932491	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	329	7.04e-86	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g199926	i0	97.409	299.989847715736	193	5	98	0	5	197	2060814	2061006	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	59098	329	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
12091794	12091794	PRJNA641707_P_NODE_168930_length_201_cov_10.532895_g166267_i0	PRJNA641707	168930	201	10.532895	21.17111895	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	259	9.6e-65	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g166267	i0	90.244	197.412935323383	205	10	97	1	6	200	2981878	2982082	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	39680	259	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
15917793	15917793	PRJNA641707_P_NODE_282693_length_169_cov_5.625000_g280030_i0	PRJNA641707	282693	169	5.625	9.50625	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	241	2.81e-59	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g280030	i0	92.353	457.183431952663	170	12	100	1	1	169	1596760	1596591	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	77264	241	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
17188760	17188760	PRJNA641707_P_NODE_10094_length_675_cov_19.902556_g8089_i0	PRJNA641707	10094	675	19.902556	134.342253	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	616	1.8999999999999999e-171	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g8089	i0	86.702	170.545185185185	564	64	83	10	114	671	1595430	1594872	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	115118	616	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
17194212	17194212	PRJNA641707_P_NODE_36394_length_359_cov_8.638710_g33759_i0	PRJNA641707	36394	359	8.63871	31.0129689	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	189	2.48e-43	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g33759	i0	89.542	40.8635097493036	153	10	42	6	208	357	1594269	1594418	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	14670	189	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
17194904	17194904	PRJNA641707_P_NODE_66514_length_258_cov_11.526316_g63851_i0	PRJNA641707	66514	258	11.526316	29.73789528	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	265	2.77e-66	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g63851	i0	86.531	147.418604651163	245	28	93	3	1	240	1595841	1595597	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	38034	265	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
19740919	19740919	PRJNA641707_P_NODE_24476_length_440_cov_5.736573_g21900_i0	PRJNA641707	24476	440	5.736573	25.2409212	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	257	8.4e-64	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g21900	i0	93.143	49.4931818181818	175	12	64	0	49	223	2061597	2061423	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	21777	257	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
20284312	20284312	PRJNA641707_P_NODE_43516_length_329_cov_16.675000_g40869_i0	PRJNA641707	43516	329	16.675	54.86075	Fibrobacter	832	Bacteria	Bacteria	196	1.35e-45	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g40869	i0	91.608	13.0577507598784	143	11	43	1	187	329	1566	1707	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	4296	196	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);;