metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA657860" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA657860" and tax_clade = "FCB group"

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
625463	625463	PRJNA657860_P_NODE_881_length_353_cov_2.832278_g825_i0	PRJNA657860	881	353	2.832278	9.99794134	Prevotella sp. GTC17259	3236795	Bacteria	Bacteria	479	1.2899999999999996e-130	NTclustered	gi\|2774262205\|dbj\|AP035787.1\|	3236795	g825	i0	91.292	271.101983002833	356	23	100	6	1	353	884073	884423	Prevotella sp. GTC17259 DNA, complete genome	blastn	95699	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. GTC17259
1161364	1161364	PRJNA657860_P_NODE_1661_length_246_cov_2.918660_g1605_i0	PRJNA657860	1661	246	2.91866	7.1799036	Flavobacteriaceae	49546	Bacteria	Bacteria	399	6.889999999999999e-107	NTclustered	gi\|1866591240\|gb\|CP058364.1\|	1170699	g1605	i0	95.951	604.166666666667	247	9	100	1	1	246	366278	366032	Galbibacter sp. BG1 chromosome, complete genome	blastn	148625	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Galbibacter	Galbibacter sp. BG1
1161365	1161365	PRJNA657860_P_NODE_1801_length_234_cov_1.329949_g1745_i0	PRJNA657860	1801	234	1.329949	3.11208066	Prevotella	838	Bacteria	Bacteria	278	3.18e-70	NTclustered	gi\|2774262205\|dbj\|AP035787.1\|	3236795	g1745	i0	88.889	257.25641025641	225	25	100	0	1	225	884874	885098	Prevotella sp. GTC17259 DNA, complete genome	blastn	60198	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. GTC17259
4989689	4989689	PRJNA657860_P_NODE_1744_length_239_cov_0.950495_g1688_i0	PRJNA657860	1744	239	0.950495	2.27168305	Mucilaginibacter	423349	Bacteria	Bacteria	248	2.55e-61	NTclustered	gi\|1008898244\|gb\|CP014773.1\|	1300914	g1688	i0	94.969	235.853556485356	159	7	69	1	81	239	475298	475141	Mucilaginibacter sp. PAMC 26640 chromosome, complete genome	blastn	56369	248	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. PAMC 26640
4989690	4989690	PRJNA657860_P_NODE_1844_length_230_cov_3.300518_g1788_i0	PRJNA657860	1844	230	3.300518	7.5911914	Weeksellaceae	2762318	Bacteria	Bacteria	412	8.18e-111	NTclustered	gi\|2620028799\|gb\|CP084355.1\|	34085	g1788	i0	99.13	373.926086956522	230	1	100	1	1	230	1136820	1136592	Riemerella anatipestifer strain RA-PNBC-21-0706-AS chromosome	blastn	86003	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella anatipestifer
10090012	10090012	PRJNA657860_P_NODE_3528_length_156_cov_3.058824_g3472_i0	PRJNA657860	3528	156	3.058824	4.77176544	Cloacibacterium	501783	Bacteria	Bacteria	287	3.24e-73	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g3472	i0	100	465.160256410256	155	0	99	0	1	155	1872400	1872554	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	72565	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
11364828	11364828	PRJNA657860_P_NODE_1829_length_232_cov_1.143590_g1773_i0	PRJNA657860	1829	232	1.14359	2.6531288	Elizabethkingia	308865	Bacteria	Bacteria	189	1.5199999999999996e-43	NTclustered	gi\|1979345949\|gb\|CP069277.1\|	1117645	g1773	i0	83.028	388.211206896552	218	27	92	9	1	213	361072	361284	Elizabethkingia anophelis strain SEA01 chromosome, complete genome	blastn	90065	189	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
17203442	17203442	PRJNA657860_P_NODE_2754_length_179_cov_1.028169_g2698_i0	PRJNA657860	2754	179	1.0281690000000001	1.84042251	Empedobacter stercoris	1628248	Bacteria	Bacteria	326	8.09e-85	NTclustered	gi\|2304450266\|gb\|CP104209.1\|	1628248	g2698	i0	100	307.240223463687	176	0	100	0	1	176	85146	85321	Empedobacter stercoris strain SCVM0123 chromosome, complete genome	blastn	54996	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
18477738	18477738	PRJNA657860_P_NODE_1955_length_220_cov_2.224044_g1899_i0	PRJNA657860	1955	220	2.224044	4.8928968	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	346	7.980000000000001e-91	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g1899	i0	95.023	437.754545454545	221	9	100	2	1	220	442756	442975	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	96306	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
18477749	18477749	PRJNA657860_P_NODE_2915_length_173_cov_1.411765_g2859_i0	PRJNA657860	2915	173	1.411765	2.44235345	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	281	1.7e-71	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g2859	i0	95.954	278.560693641619	173	7	100	0	1	173	1902427	1902255	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	48191	281	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19012926	19012926	PRJNA657860_P_NODE_2015_length_215_cov_1.859551_g1959_i0	PRJNA657860	2015	215	1.859551	3.99803465	Flavobacterium	237	Bacteria	Bacteria	231	2.27e-56	NTclustered	gi\|2153913845\|gb\|CP087135.1\|	2893886	g1959	i0	86.449	541.502325581395	214	25	99	4	3	214	1907139	1906928	Flavobacterium galactosidilyticum strain F-340 chromosome, complete genome	blastn	116423	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium galactosidilyticum
19012928	19012928	PRJNA657860_P_NODE_2355_length_196_cov_1.433962_g2299_i0	PRJNA657860	2355	196	1.433962	2.81056552	Gemmatimonadota	142182	Bacteria	Bacteria	261	2.5900000000000002e-65	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g2299	i0	90.816	289.505102040816	196	17	100	1	1	196	1904156	1903962	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	56743	263	0.992395437262357	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19752444	19752444	PRJNA657860_P_NODE_1376_length_278_cov_1.713693_g1320_i0	PRJNA657860	1376	278	1.713693	4.76406654	Flavobacterium channae	2897181	Bacteria	Bacteria	475	1.2799999999999997e-129	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g1320	i0	99.615	455.521582733813	260	1	94	0	1	260	486201	485942	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	126635	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
19752448	19752448	PRJNA657860_P_NODE_1916_length_224_cov_2.877005_g1860_i0	PRJNA657860	1916	224	2.877005	6.4444912	Prevotella sp. oral taxon 475	712471	Bacteria	Bacteria	361	2.9099999999999993e-95	NTclustered	gi\|2028838898\|gb\|CP072334.1\|	712471	g1860	i0	95.964	270.580357142857	223	7	99	1	1	223	657063	656843	Prevotella sp. oral taxon 475 strain F0059 chromosome, complete genome	blastn	60610	361	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 475
21027974	21027974	PRJNA657860_P_NODE_1357_length_279_cov_3.392562_g1301_i0	PRJNA657860	1357	279	3.392562	9.46524798	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g1301	i0	100	500.888888888889	279	0	100	0	1	279	806634	806912	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	139748	516	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
21027996	21027996	PRJNA657860_P_NODE_3337_length_161_cov_1.556452_g3281_i0	PRJNA657860	3337	161	1.556452	2.50588772	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	248	1.59e-61	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g3281	i0	94.969	380.795031055901	159	6	98	2	4	161	111830	111987	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	61308	248	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
25387850	25387850	PRJNA657860_P_NODE_1440_length_270_cov_4.845494_g1384_i0	PRJNA657860	1440	270	4.845494	13.0828338	Weeksellaceae	2762318	Bacteria	Bacteria	488	1.5899999999999995e-133	NTclustered	gi\|2034626265\|gb\|CP064938.1\|	651561	g1384	i0	99.259	513.022222222222	270	2	100	0	1	270	34507	34776	Chryseobacterium arthrosphaerae strain SQ099 chromosome	blastn	138516	488	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium arthrosphaerae

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