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

16 rows where bioproject = "PRJNA397736" 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
4239193	4239193	PRJNA397736_S_NODE_1624_length_218_cov_2.116402_g1588_i0	PRJNA397736	1624	218	2.116402	4.61375636	uncultured Ferruginibacter sp.	1042239	Bacteria	Bacteria	313	8.01e-81	NTclustered	gi\|2575820297\|emb\|OY730416.1\|	1042239	g1588	i0	93.458	141.518348623853	214	8	98	3	4	217	3393728	3393521	MAG: uncultured Ferruginibacter sp. isolate 52100660-89e0-41f3-aa4d-b5ad2bee9e90 genome assembly, chromosome: 1	blastn	30851	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	uncultured Ferruginibacter sp.
5515846	5515846	PRJNA397736_S_NODE_2485_length_169_cov_2.314286_g2449_i0	PRJNA397736	2485	169	2.314286	3.91114334	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	254	3.6e-63	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g2449	i0	94.578	389.408284023669	166	6	97	3	4	167	443526	443690	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	65810	254	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
6789878	6789878	PRJNA397736_S_NODE_3026_length_151_cov_5.204918_g2990_i0	PRJNA397736	3026	151	5.204918	7.85942618	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	246	5.27e-61	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g2990	i0	96.026	424.483443708609	151	6	100	0	1	151	443195	443045	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	64097	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
11890939	11890939	PRJNA397736_S_NODE_1910_length_197_cov_4.452381_g1874_i0	PRJNA397736	1910	197	4.452381	8.77119057	uncultured Flavobacteriaceae bacterium	165436	Bacteria	Bacteria	331	1.96e-86	NTclustered	gi\|186920876\|gb\|EU629823.1\|	165436	g1874	i0	100	81.4162436548223	179	0	91	0	2	180	181	3	Uncultured Flavobacteriaceae bacterium clone NSV3Q1b48 16S ribosomal RNA gene, partial sequence	blastn	16039	331	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		uncultured Flavobacteriaceae bacterium
13165890	13165890	PRJNA397736_S_NODE_3031_length_151_cov_4.368852_g2995_i0	PRJNA397736	3031	151	4.368852	6.59696652	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	196	5.38e-46	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g2995	i0	93.846	245.370860927152	130	8	86	0	1	130	1237309	1237180	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	37051	196	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
14441043	14441043	PRJNA397736_S_NODE_1032_length_283_cov_5.314961_g996_i0	PRJNA397736	1032	283	5.314961	15.04133963	Ferruginibacter albus	2875540	Bacteria	Bacteria	407	4.84e-109	NTclustered	gi\|2096325587\|gb\|CP083388.1\|	2875540	g996	i0	92.857	209.816254416961	280	20	99	0	4	283	768419	768140	Ferruginibacter albus strain KIS38-8 chromosome, complete genome	blastn	59378	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter albus
14441044	14441044	PRJNA397736_S_NODE_1072_length_276_cov_17.076923_g1036_i0	PRJNA397736	1072	276	17.076923	47.13230748	Bergeyella cardium	1585976	Bacteria	Bacteria	300	8.21e-77	NTclustered	gi\|2504455906\|gb\|CP121693.1\|	1585976	g1036	i0	87.594	255.427536231884	266	24	95	5	15	276	993685	993425	Bergeyella cardium strain BC chromosome, complete genome	blastn	70498	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella cardium
15714818	15714818	PRJNA397736_S_NODE_2033_length_190_cov_3.391304_g1997_i0	PRJNA397736	2033	190	3.391304	6.4434776	Polaribacter gangjinensis	574710	Bacteria	Bacteria	224	3.2699999999999995e-54	NTclustered	gi\|2713796322\|gb\|CP150662.1\|	574710	g1997	i0	88.083	344.726315789474	193	17	100	6	1	190	16993	17182	Polaribacter gangjinensis strain JCM 16152 chromosome, complete genome	blastn	65498	224	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter gangjinensis
16382343	16382343	PRJNA397736_S_NODE_2873_length_156_cov_8.748031_g2837_i0	PRJNA397736	2873	156	8.748031	13.64692836	Flavobacteriales	200644	Bacteria	Bacteria	267	4.2199999999999997e-67	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g2837	i0	97.436	419.051282051282	156	4	100	0	1	156	227547	227702	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	65372	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
16989616	16989616	PRJNA397736_S_NODE_1914_length_197_cov_4.101190_g1878_i0	PRJNA397736	1914	197	4.10119	8.0793443	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	348	1.94e-91	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g1878	i0	98.477	175.802030456853	197	3	100	0	1	197	442497	442301	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	34633	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
17657493	17657493	PRJNA397736_S_NODE_2674_length_162_cov_3.315789_g2638_i0	PRJNA397736	2674	162	3.315789	5.37157818	Ferruginibacter	1004303	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2129682579\|gb\|CP086063.1\|	563172	g2638	i0	99.383	244.70987654321	162	1	100	0	1	162	1664669	1664830	Ferruginibacter lapsinanis strain KACC 15035 chromosome, complete genome	blastn	39643	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
20813739	20813739	PRJNA397736_S_NODE_3037_length_151_cov_2.819672_g3001_i0	PRJNA397736	3037	151	2.819672	4.2577047200000004	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	268	1.12e-67	NTclustered	gi\|2874253929\|emb\|OY970254.1\|	866510	g3001	i0	98.675	253.033112582781	151	2	100	0	1	151	3405292	3405142	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.1.55 genome assembly, chromosome: 1	blastn	38208	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
22088652	22088652	PRJNA397736_S_NODE_2958_length_153_cov_5.903226_g2922_i0	PRJNA397736	2958	153	5.903226	9.03193578	Riemerella anatipestifer	34085	Bacteria	Bacteria	270	3.1799999999999996e-68	NTclustered	gi\|190333591\|gb\|EU715012.1\|	34085	g2922	i0	98.684	205.647058823529	152	2	99	0	1	152	2131	2282	Riemerella anatipestifer strain RAf104 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31464	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella anatipestifer
22756869	22756869	PRJNA397736_S_NODE_918_length_298_cov_3.598513_g882_i0	PRJNA397736	918	298	3.598513	10.72356874	Prevotellaceae	171552	Bacteria	Bacteria	401	2.3899999999999992e-107	NTclustered	gi\|2580284204\|gb\|OR338521.1\|	59823	g882	i0	90.97	461.51677852349	299	25	100	2	1	298	1497	1200	Prevotella sp. strain k141_12813 hypothetical protein gene, complete cds	blastn	137532	405	0.990123456790123	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
24031670	24031670	PRJNA397736_S_NODE_2339_length_176_cov_3.469388_g2303_i0	PRJNA397736	2339	176	3.469388	6.10612288	Pseudobacter	1860196	Bacteria	Bacteria	313	6.1699999999999985e-81	NTclustered	gi\|1721651342\|gb\|CP042431.1\|	661488	g2303	i0	98.864	226.960227272727	176	1	100	1	1	176	498827	498653	Pseudobacter ginsenosidimutans strain Gsoil 221 chromosome, complete genome	blastn	39945	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Pseudobacter ginsenosidimutans
24638530	24638530	PRJNA397736_S_NODE_2580_length_165_cov_3.316176_g2544_i0	PRJNA397736	2580	165	3.316176	5.4716904	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	272	9.73e-69	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g2544	i0	96.364	531.169696969697	165	6	100	0	1	165	1235088	1234924	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	87643	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.

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