metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJDB12134" and tax

16 rows where analysis = "blastn", bioproject = "PRJDB12134" 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
59	59	PRJDB12134_P_NODE_14401_length_242_cov_0.905325_g14266_i0	PRJDB12134	14401	242	0.905325	2.1908865	Chryseobacterium aureum	2497456	Bacteria	Bacteria	322	1.5e-83	NTclustered	gi\|1543017349\|gb\|CP034661.1\|	2497456	g14266	i0	91.139	16.702479338843	237	21	98	0	6	242	4090501	4090265	Chryseobacterium aureum strain 17S1E7 chromosome	blastn	4042	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium aureum
182	182	PRJDB12134_P_NODE_8901_length_315_cov_0.797521_g8766_i0	PRJDB12134	8901	315	0.797521	2.51219115	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	555	1.8399999999999994e-153	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g8766	i0	98.418	461.12380952381	316	3	100	2	1	315	806320	806634	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	145254	555	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
980645	980645	PRJDB12134_P_NODE_9541_length_297_cov_1.834821_g9406_i0	PRJDB12134	9541	297	1.834821	5.44941837	Prevotella	838	Bacteria	Bacteria	532	8.08e-147	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g9406	i0	98.99	234.639730639731	297	3	100	0	1	297	698082	697786	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	69688	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
4808574	4808574	PRJDB12134_P_NODE_9624_length_295_cov_1.842342_g9489_i0	PRJDB12134	9624	295	1.842342	5.4349089	Pedobacter	84567	Bacteria	Bacteria	544	3.71e-150	NTclustered	gi\|470484653\|ref\|NR_076660.1\|	984	g9489	i0	100	331.193220338983	294	0	99	0	1	294	540	833	Pedobacter heparinus strain DSM 2366 23S ribosomal RNA gene, complete sequence	blastn	97702	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
9908817	9908817	PRJDB12134_P_NODE_9208_length_305_cov_1.383621_g9073_i0	PRJDB12134	9208	305	1.383621	4.22004405	Haliscomenobacter	2349	Bacteria	Bacteria	250	9.39e-62	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g9073	i0	89.95	266.291803278689	199	12	65	3	1	199	1648	1458	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	81219	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
10202994	10202994	PRJDB12134_P_NODE_4889_length_484_cov_1.423358_g4755_i0	PRJDB12134	4889	484	1.423358	6.88905272	Dyadobacter chenwenxiniae	2906456	Bacteria	Bacteria	861	0	NTclustered	gi\|2221365986\|gb\|CP094997.1\|	2906456	g4755	i0	98.76	404.092975206612	484	6	100	0	1	484	5504660	5504177	Dyadobacter chenwenxiniae strain LJ419 chromosome, complete genome	blastn	195581	861	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter chenwenxiniae
10203069	10203069	PRJDB12134_P_NODE_9709_length_293_cov_2.809091_g9574_i0	PRJDB12134	9709	293	2.809091	8.23063663	Prevotella sp. oral taxon 475	712471	Bacteria	Bacteria	252	2.4999999999999997e-62	NTclustered	gi\|2028838898\|gb\|CP072334.1\|	712471	g9574	i0	97.297	1.96245733788396	148	4	100	0	146	293	411430	411283	Prevotella sp. oral taxon 475 strain F0059 chromosome, complete genome	blastn	575	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 475
11478024	11478024	PRJDB12134_P_NODE_14070_length_243_cov_1.817647_g13935_i0	PRJDB12134	14070	243	1.817647	4.41688221	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g13935	i0	99.588	22.8312757201646	243	1	100	0	1	243	437308	437066	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	5548	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
12459783	12459783	PRJDB12134_P_NODE_12250_length_253_cov_1.788889_g12115_i0	PRJDB12134	12250	253	1.788889	4.52588917	Adhaeribacter	299566	Bacteria	Bacteria	407	4.2500000000000005e-109	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g12115	i0	95.669	271.130434782609	254	9	100	2	1	253	94822	94570	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	68596	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
14028080	14028080	PRJDB12134_P_NODE_13772_length_245_cov_0.906977_g13637_i0	PRJDB12134	13772	245	0.906977	2.22209365	Capnocytophaga leadbetteri	327575	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g13637	i0	98.776	4.86122448979592	245	3	100	0	1	245	1431077	1431321	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	1191	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
15302239	15302239	PRJDB12134_P_NODE_5133_length_470_cov_1.949622_g4999_i0	PRJDB12134	5133	470	1.949622	9.1632234	Pedobacter sp. FW305-3-2-15-E-R2A2	3140251	Bacteria	Bacteria	785	0	NTclustered	gi\|2720698973\|gb\|CP151803.1\|	3140251	g4999	i0	96.809	354.778723404255	470	15	100	0	1	470	6988372	6988841	Pedobacter sp. FW305-3-2-15-E-R2A2 chromosome, complete genome	blastn	166746	785	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. FW305-3-2-15-E-R2A2
16283357	16283357	PRJDB12134_P_NODE_11973_length_258_cov_1.675676_g11838_i0	PRJDB12134	11973	258	1.675676	4.32324408	Pedobacter	84567	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|470484653\|ref\|NR_076660.1\|	984	g11838	i0	99.225	345.728682170543	258	2	100	0	1	258	2788	2531	Pedobacter heparinus strain DSM 2366 23S ribosomal RNA gene, complete sequence	blastn	89198	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
16283359	16283359	PRJDB12134_P_NODE_12953_length_249_cov_1.460227_g12818_i0	PRJDB12134	12953	249	1.460227	3.63596523	Capnocytophaga	1016	Bacteria	Bacteria	375	1.18e-99	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g12818	i0	99.517	271.028112449799	207	0	83	1	44	249	371179	370973	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	67486	375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
17851930	17851930	PRJDB12134_P_NODE_13075_length_249_cov_0.880682_g12940_i0	PRJDB12134	13075	249	0.880682	2.19289818	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	327	3.34e-85	NTclustered	gi\|2647208394\|gb\|CP141191.1\|	259	g12940	i0	91.915	374.626506024096	235	17	94	2	15	249	751793	751561	Sphingobacterium thalpophilum strain YX-3 chromosome, complete genome	blastn	93282	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
24225856	24225856	PRJDB12134_P_NODE_11300_length_269_cov_1.500000_g11165_i0	PRJDB12134	11300	269	1.5	4.035	Sphingobacterium sp. UDSM-2020	2795738	Bacteria	Bacteria	464	2.67e-126	NTclustered	gi\|1948801041\|gb\|CP066166.1\|	2795738	g11165	i0	97.77	2.23791821561338	269	6	100	0	1	269	782410	782142	Sphingobacterium sp. UDSM-2020 chromosome	blastn	602	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. UDSM-2020
25206763	25206763	PRJDB12134_P_NODE_9120_length_308_cov_1.263830_g8985_i0	PRJDB12134	9120	308	1.26383	3.8925964	Niabella	379899	Bacteria	Bacteria	412	1.1399999999999997e-110	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g8985	i0	90.939	144.636363636364	309	24	100	4	1	308	1677630	1677935	Niabella sp. I6 chromosome	blastn	44548	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6

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