metadata: contig_metadata: 20 rows where bioproject = "PRJNA1193541" and tax

20 rows where bioproject = "PRJNA1193541" 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
320662	320662	PRJNA1193541_P_NODE_15181_length_241_cov_0.910714_g15043_i0	PRJNA1193541	15181	241	0.910714	2.19482074	Chryseobacterium sp.	1871047	Bacteria	Bacteria	143	1.2499999999999998e-29	NTclustered	gi\|1757093052\|gb\|CP044507.1\|	1871047	g15043	i0	89.381	1.33195020746888	113	12	47	0	1	113	1330349	1330461	Chryseobacterium sp. strain SNU WT7 chromosome, complete genome	blastn	321	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
320817	320817	PRJNA1193541_P_NODE_8381_length_301_cov_1.350877_g8243_i0	PRJNA1193541	8381	301	1.350877	4.06613977	Pseudobacter ginsenosidimutans	661488	Bacteria	Bacteria	472	1.81e-128	NTclustered	gi\|1721651342\|gb\|CP042431.1\|	661488	g8243	i0	95.05	249.016611295681	303	10	100	5	1	301	498910	498611	Pseudobacter ginsenosidimutans strain Gsoil 221 chromosome, complete genome	blastn	74954	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Pseudobacter ginsenosidimutans
1042383	1042383	PRJNA1193541_P_NODE_14681_length_242_cov_1.366864_g14543_i0	PRJNA1193541	14681	242	1.366864	3.30781088	Weeksellaceae	2762318	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g14543	i0	100	328.756198347107	242	0	100	0	1	242	36875	36634	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	79559	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
1595235	1595235	PRJNA1193541_P_NODE_13342_length_247_cov_0.885057_g13204_i0	PRJNA1193541	13342	247	0.885057	2.18609079	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	363	9.079999999999999e-96	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g13204	i0	93.469	428.643724696356	245	15	99	1	1	245	112808	112565	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	105875	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
2871421	2871421	PRJNA1193541_P_NODE_2143_length_526_cov_1.335541_g2006_i0	PRJNA1193541	2143	526	1.335541	7.02494566	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	885	0	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g2006	i0	96.987	458.283269961977	531	8	100	4	1	526	730458	730985	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	241057	885	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
4147523	4147523	PRJNA1193541_P_NODE_14904_length_242_cov_0.911243_g14766_i0	PRJNA1193541	14904	242	0.911243	2.20520806	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	363	8.869999999999999e-96	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g14766	i0	93.776	170.52479338843	241	15	99	0	1	241	2977661	2977901	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	41267	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
4147668	4147668	PRJNA1193541_P_NODE_8344_length_302_cov_1.344978_g8206_i0	PRJNA1193541	8344	302	1.344978	4.06183356	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	518	2.31e-142	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g8206	i0	97.69	346.675496688742	303	3	100	2	1	302	113664	113365	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	104696	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
10524450	10524450	PRJNA1193541_P_NODE_8709_length_294_cov_1.990950_g8571_i0	PRJNA1193541	8709	294	1.99095	5.853393	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	527	3.719999999999999e-145	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g8571	i0	98.98	281.608843537415	294	3	100	0	1	294	56418	56711	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	82793	527	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
11799145	11799145	PRJNA1193541_P_NODE_12990_length_248_cov_0.880000_g12852_i0	PRJNA1193541	12990	248	0.88	2.1824	Chryseobacterium indologenes	253	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1957908205\|gb\|CP067044.1\|	253	g12852	i0	100	98.7620967741936	245	0	99	0	4	248	3792873	3792629	Chryseobacterium indologenes strain 3125 chromosome, complete genome	blastn	24493	453	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
15623320	15623320	PRJNA1193541_P_NODE_10813_length_268_cov_1.897436_g10675_i0	PRJNA1193541	10813	268	1.897436	5.08512848	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	399	7.609999999999999e-107	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g10675	i0	93.657	479.742537313433	268	15	99	2	1	267	1235257	1234991	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	128571	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
17620170	17620170	PRJNA1193541_P_NODE_2194_length_521_cov_1.352679_g2057_i0	PRJNA1193541	2194	521	1.352679	7.04745759	Emticicia	312278	Bacteria	Bacteria	798	0	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g2057	i0	94.434	460.99424184261	521	26	100	3	1	521	23	540	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	240178	798	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
22719230	22719230	PRJNA1193541_P_NODE_13258_length_247_cov_0.885057_g13120_i0	PRJNA1193541	13258	247	0.885057	2.18609079	Bacteroides	816	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|2101501970\|gb\|CP083813.1\|	28116	g13120	i0	98.222	30.0607287449393	225	0	89	1	23	243	3591789	3592013	Bacteroides ovatus strain FDAARGOS_1516 chromosome	blastn	7425	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides ovatus
27420286	27420286	PRJNA1193541_P_NODE_10763_length_269_cov_1.515306_g10625_i0	PRJNA1193541	10763	269	1.515306	4.07617314	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	60.5	2.69e-9	NR	MCT4327038.1	1117645	g10625	i0	51.8	2.28624535315985	56	25	61.3	2	1	165	63	117	MCT4327038.1 hypothetical protein [Elizabethkingia anophelis]	diamond	615	60.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
28114503	28114503	PRJNA1193541_P_NODE_8845_length_292_cov_1.780822_g8707_i0	PRJNA1193541	8845	292	1.780822	5.20000024	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	42.7	0.0308	NR	HET9948058.1	2910168	g8707	i0	37.3	0.523972602739726	51	32	52.4	0	21	173	72	122	HET9948058.1 thioesterase family protein [Longimicrobiales bacterium]	diamond	153	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
28304071	28304071	PRJNA1193541_P_NODE_13546_length_246_cov_0.890173_g13408_i0	PRJNA1193541	13546	246	0.890173	2.18982558	Chitinophagia bacterium	2448778	Bacteria	Bacteria	70.5	4.82e-12	NR	NCW13641.1	2448778	g13408	i0	44.6	0.792682926829268	65	36	79.3	0	3	197	138	202	NCW13641.1 hypothetical protein [Chitinophagia bacterium]	diamond	195	70.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia				Chitinophagia bacterium
28588439	28588439	PRJNA1193541_P_NODE_12787_length_249_cov_0.875000_g12649_i0	PRJNA1193541	12787	249	0.875	2.17875	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	181	5.75e-51	NR	MBN8853668.1	2044944	g12649	i0	100	2	83	0	100	0	1	249	521	603	MBN8853668.1 M1 family peptidase [Sphingobacteriales bacterium]	diamond	498	181	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
29409126	29409126	PRJNA1193541_P_NODE_11049_length_265_cov_1.572917_g10911_i0	PRJNA1193541	11049	265	1.572917	4.16823005	Aureitalea sp. L	1872661	Bacteria	Bacteria	45.4	0.00535	NR	WP_265198814.1	2816962	g10911	i0	40.4	0.588679245283019	52	31	58.9	0	176	21	252	303	WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47]	diamond	156	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureitalea	Aureitalea sp. L0-47
30009366	30009366	PRJNA1193541_P_NODE_15091_length_241_cov_0.916667_g14953_i0	PRJNA1193541	15091	241	0.916667	2.20916747	Spirosoma foliorum	2710596	Bacteria	Bacteria	45.8	0.00297	NR	WP_182459608.1	2710596	g14953	i0	40	0.684647302904564	55	32	67.2	1	80	241	10	64	WP_182459608.1 hypothetical protein [Spirosoma foliorum]	diamond	165	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma foliorum
30293922	30293922	PRJNA1193541_P_NODE_13052_length_248_cov_0.880000_g12914_i0	PRJNA1193541	13052	248	0.88	2.1824	Chryseolinea sp.	2059303	Bacteria	Bacteria	159	3.13e-44	NR	HTF18095.1	2059303	g12914	i0	92.7	1.98387096774194	82	6	99.2	0	2	247	62	143	HTF18095.1 DNA repair protein RecN [Chryseolinea sp.]	diamond	492	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea sp.
31842237	31842237	PRJNA1193541_P_NODE_11117_length_264_cov_1.612565_g10979_i0	PRJNA1193541	11117	264	1.612565	4.2571716	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	170	3.56e-49	NR	MBT3611732.1	2021391	g10979	i0	93	0.977272727272727	86	6	97.7	0	262	5	112	197	MBT3611732.1 hypothetical protein [Flavobacteriales bacterium]	diamond	258	170	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium

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