metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA385396" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA385396" 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
406817	406817	PRJNA385396_P_NODE_1341_length_623_cov_2.692727_g1250_i0	PRJNA385396	1341	623	2.692727	16.77568921	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	773	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g1250	i0	89.12	95.8908507223114	625	62	100	6	1	623	3485477	3486097	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	59740	773	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
406995	406995	PRJNA385396_P_NODE_21301_length_241_cov_0.916667_g21209_i0	PRJNA385396	21301	241	0.916667	2.20916747	Chryseobacterium suipulveris	2929800	Bacteria	Bacteria	344	3.199999999999999e-90	NTclustered	gi\|2216359423\|gb\|CP094532.1\|	2929800	g21209	i0	96.209	0.87551867219917	211	7	87	1	1	210	2886319	2886529	Chryseobacterium suipulveris strain SC2-2 chromosome, complete genome	blastn	211	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium suipulveris
1076556	1076556	PRJNA385396_P_NODE_701_length_817_cov_1.650538_g618_i0	PRJNA385396	701	817	1.650538	13.48489546	Gemmatimonas	173479	Bacteria	Bacteria	592	3.91e-164	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g618	i0	80.535	269.700122399021	822	117	98	32	1	802	1643	845	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	220345	592	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
4233905	4233905	PRJNA385396_P_NODE_14004_length_251_cov_0.865169_g13912_i0	PRJNA385396	14004	251	0.865169	2.17157419	Chryseobacterium suipulveris	2929800	Bacteria	Bacteria	398	2.5399999999999994e-106	NTclustered	gi\|2216359423\|gb\|CP094532.1\|	2929800	g13912	i0	95.219	1	251	12	100	0	1	251	1449205	1448955	Chryseobacterium suipulveris strain SC2-2 chromosome, complete genome	blastn	251	398	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium suipulveris
4904549	4904549	PRJNA385396_P_NODE_3244_length_426_cov_0.875354_g3152_i0	PRJNA385396	3244	426	0.875354	3.72900804	Weeksellaceae	2762318	Bacteria	Bacteria	689	0	NTclustered	gi\|2870348478\|gb\|CP175957.1\|	34085	g3152	i0	95.794	368.866197183099	428	16	100	2	1	426	998878	998451	Riemerella anatipestifer strain RAf490 chromosome, complete genome	blastn	157137	689	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella anatipestifer
9335029	9335029	PRJNA385396_P_NODE_18308_length_245_cov_0.895349_g18216_i0	PRJNA385396	18308	245	0.895349	2.19360505	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	403	5.299999999999998e-108	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g18216	i0	96.327	66.7755102040816	245	9	100	0	1	245	1783194	1783438	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	16360	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
9335045	9335045	PRJNA385396_P_NODE_18888_length_244_cov_0.900585_g18796_i0	PRJNA385396	18888	244	0.900585	2.1974274	Chryseobacterium suipulveris	2929800	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2216359423\|gb\|CP094532.1\|	2929800	g18796	i0	99.18	1	244	2	100	0	1	244	735389	735632	Chryseobacterium suipulveris strain SC2-2 chromosome, complete genome	blastn	244	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium suipulveris
9335286	9335286	PRJNA385396_P_NODE_7368_length_319_cov_3.739837_g7276_i0	PRJNA385396	7368	319	3.739837	11.93008003	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	351	2.63e-92	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g7276	i0	89.781	534.865203761756	274	28	87	0	28	301	1904483	1904756	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	170622	351	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9335312	9335312	PRJNA385396_P_NODE_8088_length_309_cov_1.305085_g7996_i0	PRJNA385396	8088	309	1.305085	4.03271265	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	381	3.239999999999999e-101	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g7996	i0	89.068	168.546925566343	311	28	100	6	1	309	1552977	1552671	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	52081	381	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
10610998	10610998	PRJNA385396_P_NODE_8629_length_302_cov_1.008734_g8537_i0	PRJNA385396	8629	302	1.008734	3.04637668	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	448	3.0699999999999995e-121	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g8537	i0	93.399	354.771523178808	303	18	100	2	1	302	3683	3382	Dyadobacter pollutisoli strain U1 chromosome	blastn	107141	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
11279759	11279759	PRJNA385396_P_NODE_7969_length_311_cov_0.915966_g7877_i0	PRJNA385396	7969	311	0.915966	2.84865426	Niabella	379899	Bacteria	Bacteria	492	1.45e-134	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g7877	i0	95.469	232.183279742765	309	12	100	2	4	311	1679396	1679089	Niabella sp. I6 chromosome	blastn	72209	492	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6
11885428	11885428	PRJNA385396_P_NODE_11030_length_273_cov_1.540000_g10938_i0	PRJNA385396	11030	273	1.54	4.2042	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	497	2.68e-136	NTclustered	gi\|1527179843\|gb\|CP034173.1\|	536441	g10938	i0	99.632	65.5274725274725	272	1	99	0	2	273	642570	642841	Chryseobacterium taklimakanense strain F9257 chromosome, complete genome	blastn	17889	497	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
13160846	13160846	PRJNA385396_P_NODE_4671_length_373_cov_1.183333_g4579_i0	PRJNA385396	4671	373	1.183333	4.41383209	Antarcticibacterium sp. 1MA-6-2	2908210	Bacteria	Bacteria	536	8.039999999999999e-148	NTclustered	gi\|2181152707\|gb\|CP091036.1\|	2908210	g4579	i0	100	320.109919571046	290	0	99	0	83	372	297128	297417	Antarcticibacterium sp. 1MA-6-2 chromosome, complete genome	blastn	119401	536	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Antarcticibacterium	Antarcticibacterium sp. 1MA-6-2
13160866	13160866	PRJNA385396_P_NODE_5291_length_357_cov_1.084507_g5199_i0	PRJNA385396	5291	357	1.084507	3.87168999	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	346	1.38e-90	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g5199	i0	84.615	4.64425770308123	351	50	97	3	9	356	422031	422380	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1658	346	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13160955	13160955	PRJNA385396_P_NODE_7931_length_311_cov_1.352941_g7839_i0	PRJNA385396	7931	311	1.352941	4.20764651	Epilithonimonas zeae	1416779	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g7839	i0	100	482.900321543408	311	0	100	0	1	311	2242796	2242486	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	150182	575	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
15104306	15104306	PRJNA385396_P_NODE_1932_length_533_cov_3.143478_g1840_i0	PRJNA385396	1932	533	3.143478	16.75473774	Gemmatimonas	173479	Bacteria	Bacteria	617	4.11e-172	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g1840	i0	87.709	69.0412757973734	537	56	100	9	1	533	560	30	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	36799	617	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
15709725	15709725	PRJNA385396_P_NODE_2193_length_506_cov_2.780600_g2101_i0	PRJNA385396	2193	506	2.7806	14.069836	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	532	1.4499999999999996e-146	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g2101	i0	85.853	415.95652173913	516	55	100	16	1	506	5915747	5915240	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	210474	532	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16984252	16984252	PRJNA385396_P_NODE_16134_length_248_cov_0.880000_g16042_i0	PRJNA385396	16134	248	0.88	2.1824	Prevotella bivia	28125	Bacteria	Bacteria	431	2.47e-116	NTclustered	gi\|2515259909\|gb\|CP126677.1\|	28125	g16042	i0	97.984	2	248	5	100	0	1	248	830558	830311	Prevotella bivia strain PLW0727 chromosome 2, complete sequence	blastn	496	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
18928041	18928041	PRJNA385396_P_NODE_135_length_1608_cov_3.820847_g95_i0	PRJNA385396	135	1608	3.820847	61.43921976	Aquirufa	2676247	Bacteria	Bacteria	1751	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g95	i0	86.442	474.071517412935	1630	184	100	32	1	1608	358668	360282	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	762307	1766	0.991506228765572	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
22083595	22083595	PRJNA385396_P_NODE_6598_length_331_cov_1.647287_g6506_i0	PRJNA385396	6598	331	1.647287	5.45251997	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	435	2.6500000000000003e-117	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g6506	i0	90.361	140.027190332326	332	30	100	2	1	331	1903216	1902886	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	46349	435	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23358939	23358939	PRJNA385396_P_NODE_16819_length_247_cov_0.885057_g16727_i0	PRJNA385396	16819	247	0.885057	2.18609079	uncultured Ferruginibacter sp.	1042239	Bacteria	Bacteria	224	4.469999999999999e-54	NTclustered	gi\|2575820297\|emb\|OY730416.1\|	1042239	g16727	i0	83.471	0.979757085020243	242	38	98	2	7	247	1973106	1972866	MAG: uncultured Ferruginibacter sp. isolate 52100660-89e0-41f3-aa4d-b5ad2bee9e90 genome assembly, chromosome: 1	blastn	242	224	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	uncultured Ferruginibacter sp.
23359060	23359060	PRJNA385396_P_NODE_21899_length_229_cov_2.391026_g21807_i0	PRJNA385396	21899	229	2.391026	5.47544954	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	385	1.77e-102	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g21807	i0	96.943	442.318777292576	229	7	100	0	1	229	1407667	1407895	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	101291	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
23359208	23359208	PRJNA385396_P_NODE_599_length_879_cov_2.617866_g521_i0	PRJNA385396	599	879	2.617866	23.01104214	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	1181	0	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g521	i0	90.981	151.485779294653	887	64	100	14	1	879	172876	171998	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	133156	1181	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24633171	24633171	PRJNA385396_P_NODE_12780_length_256_cov_1.169399_g12688_i0	PRJNA385396	12780	256	1.169399	2.99366144	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	106	1.76e-18	NTclustered	gi\|2874253929\|emb\|OY970254.1\|	866510	g12688	i0	83.051	0.4609375	118	18	46	2	139	255	2227535	2227651	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.1.55 genome assembly, chromosome: 1	blastn	118	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
24633533	24633533	PRJNA385396_P_NODE_6500_length_333_cov_1.503846_g6408_i0	PRJNA385396	6500	333	1.503846	5.00780718	Bergeyella cardium	1585976	Bacteria	Bacteria	436	7.409999999999999e-118	NTclustered	gi\|2504455906\|gb\|CP121693.1\|	1585976	g6408	i0	90.476	419.585585585586	336	25	100	4	1	333	993440	993771	Bergeyella cardium strain BC chromosome, complete genome	blastn	139722	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella cardium

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