metadata: contig_metadata: 23 rows where bioproject = "PRJEB2333", tax_clade = "FCB group" and tax

23 rows where bioproject = "PRJEB2333", tax_clade = "FCB group" and tax_kingdom = "Pseudomonadati"

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
1297076	1297076	PRJEB2333_P_NODE_3582_length_240_cov_2.206897_g2805_i0	PRJEB2333	3582	240	2.206897	5.2965528	Spirosoma taeanense	2735870	Bacteria	Bacteria	257	4.26e-64	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g2805	i0	86.475	209.95	244	22	99	11	1	239	5430770	5430533	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	50388	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
2572761	2572761	PRJEB2333_P_NODE_3263_length_408_cov_1.557951_g2487_i0	PRJEB2333	3263	408	1.557951	6.35644008	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	233	1.3e-56	NTclustered	gi\|2626245886\|emb\|OY829943.1\|	2053594	g2487	i0	97.778	232.450980392157	135	3	33	0	1	135	967609	967475	MAG: Prolixibacteraceae bacterium isolate 87e00be5-c4e0-41ce-ad20-391b9c562bec genome assembly, chromosome: 1	blastn	94840	233	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
6401002	6401002	PRJEB2333_P_NODE_3166_length_422_cov_0.857143_g2391_i0	PRJEB2333	3166	422	0.857143	3.61714346	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	191	8.25e-44	NTclustered	gi\|2647208394\|gb\|CP141191.1\|	259	g2391	i0	98.165	128.812796208531	109	2	46	0	314	422	410197	410089	Sphingobacterium thalpophilum strain YX-3 chromosome, complete genome	blastn	54359	191	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
8639243	8639243	PRJEB2333_P_NODE_2567_length_559_cov_1.047893_g1799_i0	PRJEB2333	2567	559	1.047893	5.85772187	Flavobacterium	237	Bacteria	Bacteria	195	8.65e-45	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g1799	i0	86.857	166.060822898032	175	21	31	2	25	198	1419011	1419184	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	92828	195	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
8949878	8949878	PRJEB2333_P_NODE_1788_length_1122_cov_11.204608_g1123_i0	PRJEB2333	1788	1122	11.204608	125.71570176	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	1166	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g1123	i0	85.501	300.257575757576	1138	141	100	21	1	1122	358672	359801	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	336889	1166	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
8949882	8949882	PRJEB2333_P_NODE_3448_length_349_cov_6.474359_g2671_i0	PRJEB2333	3448	349	6.474359	22.59551291	uncultured Flexibacter sp.	158757	Bacteria	Bacteria	407	6.11e-109	NTclustered	gi\|1481058922\|gb\|MH938160.1\|	158757	g2671	i0	87.749	101.300859598854	351	39	100	4	1	349	4	352	Uncultured Flexibacter sp. clone 8 16S ribosomal RNA gene, partial sequence	blastn	35354	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flexibacteraceae	Flexibacter	uncultured Flexibacter sp.
8949883	8949883	PRJEB2333_P_NODE_3508_length_274_cov_1.991561_g2731_i0	PRJEB2333	3508	274	1.991561	5.45687714	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	399	7.799999999999999e-107	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g2731	i0	93.04	113.901459854015	273	19	99	0	2	274	1075477	1075749	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	31209	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
8949884	8949884	PRJEB2333_P_NODE_4308_length_169_cov_1.325758_g3531_i0	PRJEB2333	4308	169	1.325758	2.24053102	Flavobacterium marginilacus	3003256	Bacteria	Bacteria	75	3.01e-9	NTclustered	gi\|2476885802\|gb\|CP113975.3\|	3003256	g3531	i0	86.111	16.0591715976331	72	7	42	3	99	169	443207	443276	Flavobacterium marginilacus strain IMCC34673 chromosome, complete genome	blastn	2714	75	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium marginilacus
11189496	11189496	PRJEB2333_P_NODE_3489_length_286_cov_4.036145_g2712_i0	PRJEB2333	3489	286	4.036145	11.5433747	Aquirufa	2676247	Bacteria	Bacteria	259	1.45e-64	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g2712	i0	83.333	457.811188811189	288	40	98	5	7	286	214291	214578	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	130934	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
11189508	11189508	PRJEB2333_P_NODE_4069_length_182_cov_9.413793_g3292_i0	PRJEB2333	4069	182	9.413793	17.13310326	Aquirufa	2676247	Bacteria	Bacteria	303	3.87e-78	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g3292	i0	96.703	329.005494505494	182	6	100	0	1	182	360889	361070	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	59879	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
11500902	11500902	PRJEB2333_P_NODE_3710_length_216_cov_2.944134_g2933_i0	PRJEB2333	3710	216	2.944134	6.35932944	Runella sp. SP2	2268026	Bacteria	Bacteria	259	1.05e-64	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g2933	i0	88.426	418.217592592593	216	23	99	2	1	215	5733368	5733154	Runella sp. SP2 chromosome, complete genome	blastn	90335	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
12465307	12465307	PRJEB2333_P_NODE_4070_length_182_cov_7.393103_g3293_i0	PRJEB2333	4070	182	7.393103	13.45544746	Cloacibacterium	501783	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3293	i0	100	487.005494505494	182	0	100	0	1	182	129287	129468	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	88635	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
13739607	13739607	PRJEB2333_P_NODE_3491_length_284_cov_4.939271_g2714_i0	PRJEB2333	3491	284	4.939271	14.02752964	Chryseobacterium	59732	Bacteria	Bacteria	514	2.78e-141	NTclustered	gi\|1586140306\|gb\|CP031676.1\|	250	g2714	i0	99.296	552.232394366197	284	2	100	0	1	284	2655153	2654870	Chryseobacterium gleum strain 110146 chromosome	blastn	156834	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
13739610	13739610	PRJEB2333_P_NODE_3711_length_216_cov_2.882682_g2934_i0	PRJEB2333	3711	216	2.882682	6.22659312	Cytophagales	768507	Bacteria	Bacteria	217	6.39e-52	NTclustered	gi\|1481087475\|gb\|CP032382.1\|	2321403	g2934	i0	87.047	153.314814814815	193	23	89	2	1	192	899841	899650	Chryseolinea soli strain KIS68-18 chromosome, complete genome	blastn	33116	217	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea soli
14050988	14050988	PRJEB2333_P_NODE_3312_length_403_cov_1.240437_g2536_i0	PRJEB2333	3312	403	1.240437	4.99896111	Spirosoma montaniterrae	1178516	Bacteria	Bacteria	183	1.31e-41	NTclustered	gi\|1142450876\|gb\|CP014263.1\|	1178516	g2536	i0	92.857	43.5161290322581	126	9	31	0	277	402	3064813	3064688	Spirosoma montaniterrae strain DY10 chromosome, complete genome	blastn	17537	183	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma montaniterrae
15014017	15014017	PRJEB2333_P_NODE_2792_length_483_cov_4.221973_g2020_i0	PRJEB2333	2792	483	4.221973	20.39212959	Adhaeribacter	299566	Bacteria	Bacteria	182	5.75e-41	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g2020	i0	79.323	137.612836438923	266	49	54	6	1	262	94441	94178	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	66467	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
16599682	16599682	PRJEB2333_P_NODE_2934_length_455_cov_2.354067_g2161_i0	PRJEB2333	2934	455	2.354067	10.71100485	Tellurirhabdus bombi	2907205	Bacteria	Bacteria	523	7.779999999999997e-144	NTclustered	gi\|2179090906\|gb\|CP090557.1\|	2907205	g2161	i0	88.785	282.956043956044	428	46	94	2	1	428	418441	418016	Tellurirhabdus bombi strain IE-0392 chromosome, complete genome	blastn	128745	523	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus bombi
17564025	17564025	PRJEB2333_P_NODE_3674_length_221_cov_5.070652_g2897_i0	PRJEB2333	3674	221	5.070652	11.20614092	Flavobacteriales	200644	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|2428403098\|gb\|CP115636.1\|	238	g2897	i0	100	452.009049773756	221	0	100	0	1	221	167991	168211	Elizabethkingia meningoseptica strain 2022CK-00380 chromosome, complete genome	blastn	99894	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
17874471	17874471	PRJEB2333_P_NODE_2675_length_514_cov_1.788260_g1905_i0	PRJEB2333	2675	514	1.78826	9.1916564	Flavobacterium covae	2906076	Bacteria	Bacteria	300	1.63e-76	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g1905	i0	96.667	222.41439688716	180	6	35	0	1	180	566320	566141	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	114321	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
18837943	18837943	PRJEB2333_P_NODE_2775_length_488_cov_1.680710_g2004_i0	PRJEB2333	2775	488	1.68071	8.2018648	Sphingobacterium	28453	Bacteria	Bacteria	346	1.95e-90	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g2004	i0	94.643	216.743852459016	224	11	58	1	1	224	1767860	1768082	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	105771	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
22663083	22663083	PRJEB2333_P_NODE_2418_length_633_cov_2.401007_g1657_i0	PRJEB2333	2418	633	2.401007	15.19837431	Flectobacillus	101	Bacteria	Bacteria	577	8.389999999999998e-160	NTclustered	gi\|255763064\|gb\|GQ374919.1\|	665460	g1657	i0	100	74.3696682464455	312	0	75	0	1	312	465	154	Flectobacillus sp. HMD2002 16S ribosomal RNA gene, partial sequence	blastn	47076	577	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. HMD2002
22974851	22974851	PRJEB2333_P_NODE_2439_length_624_cov_2.255537_g1677_i0	PRJEB2333	2439	624	2.255537	14.07455088	Chryseobacterium endophyticum	1854762	Bacteria	Bacteria	520	1.41e-142	NTclustered	gi\|2731632474\|gb\|CP154834.1\|	1854762	g1677	i0	98.316	315.225961538462	297	3	73	2	329	624	102698	102993	Chryseobacterium endophyticum strain OsEnb-ALM-A6 chromosome, complete genome	blastn	196701	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium endophyticum
25212252	25212252	PRJEB2333_P_NODE_3540_length_253_cov_4.555556_g2763_i0	PRJEB2333	3540	253	4.555556	11.52555668	Chryseobacterium	59732	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g2763	i0	100	503.675889328063	253	0	100	0	1	253	2627111	2626859	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	127430	468	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense

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