metadata: contig_metadata: 23 rows where bioproject = "PRJNA645397" and tax

23 rows where bioproject = "PRJNA645397" 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
619597	619597	PRJNA645397_P_NODE_7401_length_190_cov_1.184397_g7328_i0	PRJNA645397	7401	190	1.184397	2.2503543	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	298	1.9e-76	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g7328	i0	98.802	1.75263157894737	167	2	88	0	24	190	1995258	1995424	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	333	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
3170397	3170397	PRJNA645397_P_NODE_7263_length_192_cov_0.902098_g7190_i0	PRJNA645397	7263	192	0.902098	1.73202816	Chryseobacterium gambrini	373672	Bacteria	Bacteria	270	4.19e-68	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g7190	i0	96.341	3.41666666666667	164	6	85	0	29	192	4206813	4206976	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	656	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
12098995	12098995	PRJNA645397_P_NODE_10850_length_163_cov_0.912281_g10777_i0	PRJNA645397	10850	163	0.912281	1.48701803	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g10777	i0	98.773	3.22699386503067	163	2	100	0	1	163	2875305	2875467	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	526	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
13373660	13373660	PRJNA645397_P_NODE_5991_length_213_cov_0.884146_g5918_i0	PRJNA645397	5991	213	0.884146	1.88323098	Chryseobacterium gambrini	373672	Bacteria	Bacteria	326	1e-84	NTclustered	gi\|2429907221\|gb\|CP116008.1\|	373672	g5918	i0	98.378	37.1596244131455	185	3	87	0	29	213	632151	632335	Chryseobacterium gambrini strain DMF-6 chromosome, complete genome	blastn	7915	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
15922468	15922468	PRJNA645397_S_NODE_1313_length_169_cov_1.966667_g1311_i0	PRJNA645397	1313	169	1.966667	3.32366723	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g1311	i0	99.412	12.1597633136095	170	0	100	1	1	169	2460110	2459941	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	2055	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
17197586	17197586	PRJNA645397_P_NODE_9674_length_167_cov_0.881356_g9601_i0	PRJNA645397	9674	167	0.881356	1.47186452	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	169	1.33e-37	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g9601	i0	85.311	36	177	10	96	3	7	167	2530039	2529863	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	6012	169	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
19010668	19010668	PRJNA645397_P_NODE_10175_length_165_cov_0.896552_g10102_i0	PRJNA645397	10175	165	0.896552	1.4793108	Weeksellaceae	2762318	Bacteria	Bacteria	246	5.9e-61	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g10102	i0	98.561	1.85454545454545	139	2	84	0	27	165	2597355	2597493	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	306	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
19010679	19010679	PRJNA645397_S_NODE_1075_length_183_cov_1.126866_g1073_i0	PRJNA645397	1075	183	1.126866	2.06216478	Weeksellaceae	2762318	Bacteria	Bacteria	220	4.04e-53	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g1073	i0	97.656	6.39890710382514	128	3	70	0	1	128	918149	918276	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	1171	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
19746410	19746410	PRJNA645397_P_NODE_10536_length_164_cov_0.904348_g10463_i0	PRJNA645397	10536	164	0.904348	1.48313072	Chryseobacterium gambrini	373672	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g10463	i0	98.78	2.28048780487805	164	2	100	0	1	164	847396	847233	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	374	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
19746411	19746411	PRJNA645397_P_NODE_10556_length_164_cov_0.904348_g10483_i0	PRJNA645397	10556	164	0.904348	1.48313072	Chryseobacterium gambrini	373672	Bacteria	Bacteria	209	7.68e-50	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g10483	i0	91.503	5.04268292682927	153	12	93	1	12	164	120832	120983	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	827	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
19746429	19746429	PRJNA645397_P_NODE_4836_length_240_cov_1.445026_g4763_i0	PRJNA645397	4836	240	1.445026	3.4680624	Planobacterium oryzisoli	2771435	Bacteria	Bacteria	156	1.99e-44	NR	WP_194739227.1	2771435	g4763	i0	98.8	1	80	1	100	0	240	1	148	227	WP_194739227.1 DNA polymerase III subunit gamma/tau [Planobacterium oryzisoli]	diamond	240	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Planobacterium oryzisoli
21561145	21561145	PRJNA645397_P_NODE_3117_length_306_cov_0.805447_g3044_i0	PRJNA645397	3117	306	0.805447	2.46466782	Weeksellaceae	2762318	Bacteria	Bacteria	544	3.86e-150	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g3044	i0	98.697	2.00653594771242	307	3	100	1	1	306	961113	961419	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	614	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
22296726	22296726	PRJNA645397_P_NODE_2558_length_337_cov_2.194444_g2485_i0	PRJNA645397	2558	337	2.194444	7.39527628	Chryseobacterium gambrini	373672	Bacteria	Bacteria	562	1.19e-155	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g2485	i0	99.045	389.905044510386	314	2	93	1	1	313	1783604	1783917	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	131398	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
23572340	23572340	PRJNA645397_P_NODE_9219_length_169_cov_0.866667_g9146_i0	PRJNA645397	9219	169	0.866667	1.46466723	Kaistella haifensis	421525	Bacteria	Bacteria	261	2.15e-65	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g9146	i0	98.639	1.03550295857988	147	2	87	0	23	169	2578933	2578787	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	175	261	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
24111062	24111062	PRJNA645397_P_NODE_10239_length_165_cov_0.896552_g10166_i0	PRJNA645397	10239	165	0.896552	1.4793108	Alistipes	239759	Bacteria	Bacteria	126	8.02e-25	NTclustered	gi\|2188886390\|dbj\|AP025581.1\|	214856	g10166	i0	90.526	15.8969696969697	95	9	58	0	8	102	3221789	3221883	Alistipes finegoldii CE91-St15 DNA, complete genome	blastn	2623	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes finegoldii
24845946	24845946	PRJNA645397_S_NODE_500_length_242_cov_1.129534_g498_i0	PRJNA645397	500	242	1.129534	2.73347228	Flavisolibacter sp.	1954249	Bacteria	Bacteria	158	1.24e-46	NR	HEY0059840.1	1954249	g498	i0	91.3	0.991735537190083	80	7	99.2	0	3	242	119	198	HEY0059840.1 monofunctional biosynthetic peptidoglycan transglycosylase [Flavisolibacter sp.]	diamond	240	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter sp.
26828284	26828284	PRJNA645397_S_NODE_741_length_210_cov_0.968944_g739_i0	PRJNA645397	741	210	0.968944	2.0347824	Flaviaestuariibacter sp.	1986182	Bacteria	Bacteria	91.7	1.48e-19	NR	MDB5195670.1	1986182	g739	i0	68.1	3.08571428571429	72	21	100	2	210	1	277	348	MDB5195670.1 family peptidase [Flaviaesturariibacter sp.]	diamond	648	91.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flaviaestuariibacter	Flaviaestuariibacter sp.
27492172	27492172	PRJNA645397_P_NODE_4503_length_250_cov_1.064677_g4430_i0	PRJNA645397	4503	250	1.064677	2.6616925	Planobacterium oryzisoli	2771435	Bacteria	Bacteria	137	3.1099999999999997e-37	NR	WP_194739227.1	2771435	g4430	i0	94.5	0.876	73	4	87.6	0	2	220	286	358	WP_194739227.1 DNA polymerase III subunit gamma/tau [Planobacterium oryzisoli]	diamond	219	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Planobacterium oryzisoli
27713505	27713505	PRJNA645397_P_NODE_9204_length_169_cov_0.866667_g9131_i0	PRJNA645397	9204	169	0.866667	1.46466723	Flavobacterium sp. J372	2898436	Bacteria	Bacteria	77.8	6.08e-15	NR	WP_257866644.1	2898436	g9131	i0	84.1	0.781065088757396	44	7	78.1	0	168	37	890	933	WP_257866644.1 AsmA family protein [Flavobacterium sp. J372]	diamond	132	77.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. J372
28104094	28104094	PRJNA645397_S_NODE_725_length_212_cov_1.276074_g723_i0	PRJNA645397	725	212	1.276074	2.70527688	Bacteria	2	Bacteria	Bacteria	103	1.97e-25	NR	MBA3675699.1	1869212	g723	i0	81.4	1.9811320754717	70	13	99.1	0	210	1	139	208	MBA3675699.1 LysE family transporter [Chitinophagaceae bacterium]	diamond	420	104	0.990384615384615	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29272299	29272299	PRJNA645397_S_NODE_1569_length_163_cov_0.877193_g1567_i0	PRJNA645397	1569	163	0.877193	1.42982459	Flavisolibacter	398041	Bacteria	Bacteria	102	1.26e-25	NR	RYZ25218.1	1869212	g1567	i0	92.6	2.96319018404908	54	4	99.4	0	163	2	89	142	RYZ25218.1 MAG: glutamate racemase, partial [Chitinophagaceae bacterium]	diamond	483	103	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29607161	29607161	PRJNA645397_P_NODE_7250_length_192_cov_1.048951_g7177_i0	PRJNA645397	7250	192	1.048951	2.01398592	Flavobacterium sp. J372	2898436	Bacteria	Bacteria	112	4.22e-27	NR	WP_257866644.1	2898436	g7177	i0	94.8	0.90625	58	3	90.6	0	19	192	742	799	WP_257866644.1 AsmA family protein [Flavobacterium sp. J372]	diamond	174	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. J372
30081105	30081105	PRJNA645397_S_NODE_672_length_220_cov_1.087719_g670_i0	PRJNA645397	672	220	1.087719	2.3929818	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	92	1.23e-19	NR	WP_146784015.1	661481	g670	i0	85.7	0.668181818181818	49	7	66.8	0	74	220	1	49	WP_146784015.1 prolyl oligopeptidase family serine peptidase [Flavisolibacter ginsenosidimutans]	diamond	147	92	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans

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