metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1123686" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1123686" 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
280901	280901	PRJNA1123686_S_NODE_13821_length_172_cov_6.664336_g13789_i0	PRJNA1123686	13821	172	6.664336	11.46265792	Polaribacter litorisediminis	1908341	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2094553133\|gb\|CP082966.1\|	1908341	g13789	i0	94.444	0.209302325581395	36	1	21	1	133	168	3385212	3385246	Polaribacter litorisediminis strain OITF-11 chromosome, complete genome	blastn	36	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter litorisediminis
280902	280902	PRJNA1123686_S_NODE_13961_length_171_cov_22.971831_g13929_i0	PRJNA1123686	13961	171	22.971831	39.28183101	Bacteroidales bacterium	2030927	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621707164\|emb\|OY764960.1\|	2030927	g13929	i0	100	0.16374269005848	28	0	16	0	52	79	2642931	2642958	MAG: Bacteroidales bacterium isolate 98b5a9af-caee-4748-8dc1-d08c89d51036 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
2305359	2305359	PRJNA1123686_S_NODE_14722_length_169_cov_3.435714_g14690_i0	PRJNA1123686	14722	169	3.435714	5.80635666	Capnocytophaga	1016	Bacteria	Bacteria	285	1.28e-72	NTclustered	gi\|1242548571\|gb\|CP022379.1\|	1019	g14690	i0	97.041	299.934911242604	169	5	100	0	1	169	1137957	1137789	Capnocytophaga sputigena strain D1179 chromosome, complete genome	blastn	50689	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
2831565	2831565	PRJNA1123686_S_NODE_1823_length_293_cov_20.568182_g1791_i0	PRJNA1123686	1823	293	20.568182	60.26477326	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2107987552\|gb\|CP070779.1\|	2030809	g1791	i0	100	0.0989761092150171	29	0	10	0	87	115	1128365	1128393	MAG: Candidatus Hydrogenedentota bacterium isolate bin18 chromosome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota					Candidatus Hydrogenedentota bacterium
8683256	8683256	PRJNA1123686_S_NODE_8447_length_198_cov_12.165680_g8415_i0	PRJNA1123686	8447	198	12.16568	24.0880464	Bacteroidales	171549	Bacteria	Bacteria	220	4.45e-53	NTclustered	gi\|2098161568\|gb\|CP081906.1\|	328812	g8415	i0	89.714	307.136363636364	175	15	88	2	1	175	154100	153929	Parabacteroides goldsteinii strain BFG-241 chromosome, complete genome	blastn	60813	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides goldsteinii
9208858	9208858	PRJNA1123686_S_NODE_1708_length_297_cov_13.205224_g1676_i0	PRJNA1123686	1708	297	13.205224	39.21951528	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	405	1.84e-108	NTclustered	gi\|2874254111\|emb\|OY970196.1\|	866510	g1676	i0	91.525	244.111111111111	295	24	99	1	1	294	2746839	2747133	MAG: uncultured Chitinophagaceae bacterium isolate MFD09671.bin.c.4 genome assembly, chromosome: 1	blastn	72501	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
12508821	12508821	PRJNA1123686_S_NODE_2930_length_261_cov_4.883621_g2898_i0	PRJNA1123686	2930	261	4.883621	12.74625081	Capnocytophaga	1016	Bacteria	Bacteria	411	3.409999999999999e-110	NTclustered	gi\|1242548571\|gb\|CP022379.1\|	1019	g2898	i0	95.019	247.325670498084	261	13	100	0	1	261	2162427	2162687	Capnocytophaga sputigena strain D1179 chromosome, complete genome	blastn	64552	411	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
13034614	13034614	PRJNA1123686_S_NODE_4171_length_240_cov_4.578199_g4139_i0	PRJNA1123686	4171	240	4.578199	10.9876776	Hoylesella nanceiensis	425941	Bacteria	Bacteria	438	1.4199999999999995e-118	NTclustered	gi\|1139266120\|emb\|LT680141.1\|	425941	g4139	i0	99.583	96.7583333333333	240	1	100	0	1	240	458	697	Prevotella nanceiensis partial 16S rRNA gene, isolate W078T_5555	blastn	23222	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella nanceiensis
14309789	14309789	PRJNA1123686_S_NODE_17532_length_160_cov_8.236641_g17500_i0	PRJNA1123686	17532	160	8.236641	13.1786256	Segatella copri	165179	Bacteria	Bacteria	285	1.2e-72	NTclustered	gi\|2726128879\|gb\|CP152352.1\|	165179	g17500	i0	98.75	1	160	2	100	0	1	160	2024864	2025023	Segatella copri strain HDD05 chromosome, complete genome	blastn	160	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
16858112	16858112	PRJNA1123686_S_NODE_3134_length_257_cov_10.315789_g3102_i0	PRJNA1123686	3134	257	10.315789	26.51157773	Capnocytophaga sp. oral taxon 878	1316596	Bacteria	Bacteria	464	2.5299999999999998e-126	NTclustered	gi\|1359128826\|gb\|CP027229.1\|	1316596	g3102	i0	99.225	324.124513618677	258	1	100	1	1	257	1888034	1887777	Capnocytophaga sp. oral taxon 878 strain F0545 chromosome, complete genome	blastn	83300	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sp. oral taxon 878
19406800	19406800	PRJNA1123686_S_NODE_8396_length_198_cov_37.514793_g8364_i0	PRJNA1123686	8396	198	37.514793	74.27929014	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	60.2	1.03e-4	NTclustered	gi\|1893901079\|gb\|CP059213.1\|	1653831	g8364	i0	97.222	0.181818181818182	36	0	18	1	163	198	202974	202940	Blattabacterium cuenoti strain CARBpar chromosome, complete genome	blastn	36	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
20682334	20682334	PRJNA1123686_S_NODE_10617_length_186_cov_1.828025_g10585_i0	PRJNA1123686	10617	186	1.828025	3.4001265	Phocaeicola salanitronis	376805	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|324316725\|gb\|CP002530.1\|	667015	g10585	i0	96.875	0.172043010752688	32	1	17	0	97	128	506162	506193	Bacteroides salanitronis DSM 18170, complete genome	blastn	32	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola salanitronis
22707019	22707019	PRJNA1123686_S_NODE_19578_length_155_cov_3.761905_g19546_i0	PRJNA1123686	19578	155	3.761905	5.83095275	root	1	Root_unresolved	Root_unresolved	287	3.21e-73	NTclustered	gi\|2646294389\|gb\|PP101285.1\|	28128	g19546	i0	100	104	155	0	100	0	1	155	978	1132	Prevotella corporis strain BBH 044 16S ribosomal RNA gene, partial sequence	blastn	16120	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella corporis

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