metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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
329053	329053	PRJNA1204310_P_NODE_30981_length_335_cov_1.099237_g30684_i0	PRJNA1204310	30981	335	1.099237	3.68244395	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	473	5.689999999999999e-129	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g30684	i0	92.262	296.379104477612	336	22	100	4	1	335	2698	3030	Pedobacter sp. SL55 chromosome	blastn	99287	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
1603422	1603422	PRJNA1204310_P_NODE_14302_length_469_cov_1.209596_g14005_i0	PRJNA1204310	14302	469	1.209596	5.67300524	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	701	0	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g14005	i0	93.617	360.65671641791	470	28	100	2	1	469	517544	518012	Pedobacter sp. SL55 chromosome	blastn	169148	701	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
4155978	4155978	PRJNA1204310_P_NODE_26744_length_357_cov_1.373239_g26447_i0	PRJNA1204310	26744	357	1.373239	4.90246323	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2108125167\|gb\|CP070731.1\|	1871037	g26447	i0	100	0.0784313725490196	28	0	8	0	176	203	2361442	2361469	MAG: Flavobacteriaceae bacterium isolate bin416 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
4156164	4156164	PRJNA1204310_P_NODE_34764_length_317_cov_0.913934_g34467_i0	PRJNA1204310	34764	317	0.913934	2.89717078	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	209	1.67e-49	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g34467	i0	80	147.577287066246	310	41	97	17	1	300	2011	2309	Dyadobacter pollutisoli strain U1 chromosome	blastn	46782	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
7422907	7422907	PRJNA1204310_P_NODE_35466_length_313_cov_1.745833_g35169_i0	PRJNA1204310	35466	313	1.745833	5.46445729	Bacteroides	816	Bacteria	Bacteria	185	2.7699999999999994e-42	NTclustered	gi\|2098178328\|gb\|CP081913.1\|	46506	g35169	i0	85.475	16.3929712460064	179	25	57	1	134	312	2199636	2199813	Bacteroides stercoris strain BFG-121 chromosome, complete genome	blastn	5131	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides stercoris
9973051	9973051	PRJNA1204310_P_NODE_23208_length_379_cov_2.800654_g22911_i0	PRJNA1204310	23208	379	2.800654	10.61447866	root	1	Root_unresolved	Root_unresolved	701	0	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g22911	i0	100	154.688654353562	379	0	100	0	1	379	1047478	1047100	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	58627	701	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
9973098	9973098	PRJNA1204310_P_NODE_35468_length_313_cov_1.725000_g35171_i0	PRJNA1204310	35468	313	1.725	5.39925	Pedobacter	84567	Bacteria	Bacteria	568	2.3499999999999998e-157	NTclustered	gi\|265678672\|ref\|NR_028977.1\|	151894	g35171	i0	99.361	105.603833865815	313	2	100	0	1	313	359	47	Pedobacter africanus strain K 1/K2 16S ribosomal RNA, partial sequence	blastn	33054	568	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter africanus
10532971	10532971	PRJNA1204310_P_NODE_329_length_1923_cov_8.094595_g286_i0	PRJNA1204310	329	1923	8.094595	155.65906185	Bacteroidales bacterium	2030927	Bacteria	Bacteria	2351	0	NTclustered	gi\|2621785016\|emb\|OY781474.1\|	2030927	g286	i0	90.044	477.442537701508	1838	151	95	29	3	1825	2633463	2631643	MAG: Bacteroidales bacterium isolate d554a065-6b18-4027-98a3-e240c86e67dd genome assembly, chromosome: 1	blastn	918122	2351	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
12523777	12523777	PRJNA1204310_P_NODE_8790_length_587_cov_2.972763_g8502_i0	PRJNA1204310	8790	587	2.972763	17.45011881	Bacteroidota	976	Bacteria	Bacteria	933	0	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g8502	i0	100	165.18398637138	505	0	86	0	1	505	1047063	1046559	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	96963	939	0.993610223642173	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
13082504	13082504	PRJNA1204310_P_NODE_23091_length_380_cov_1.768730_g22794_i0	PRJNA1204310	23091	380	1.76873	6.721174	Bacteroides faecium	2715212	Bacteria	Bacteria	464	3.929999999999999e-126	NTclustered	gi\|1828977791\|gb\|CP050831.1\|	2715212	g22794	i0	88.918	428.478947368421	388	27	100	16	1	380	2421523	2421144	Bacteroides faecium strain CBA7301 chromosome, complete genome	blastn	162822	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides faecium
16906249	16906249	PRJNA1204310_P_NODE_32094_length_329_cov_1.531250_g31797_i0	PRJNA1204310	32094	329	1.53125	5.0378125	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	448	3.3799999999999995e-121	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g31797	i0	91.437	320.841945288754	327	26	99	2	5	329	955522	955848	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	105557	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
23280839	23280839	PRJNA1204310_P_NODE_15979_length_446_cov_2.013405_g15682_i0	PRJNA1204310	15979	446	2.013405	8.9797863	Runella sp. SP2	2268026	Bacteria	Bacteria	758	0	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g15682	i0	97.309	306.695067264574	446	12	100	0	1	446	5735428	5735873	Runella sp. SP2 chromosome, complete genome	blastn	136786	758	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
23281329	23281329	PRJNA1204310_P_NODE_3559_length_875_cov_1.814214_g3324_i0	PRJNA1204310	3559	875	1.814214	15.8743725	Chlorobaculum tepidum	1097	Bacteria	Bacteria	54.7	0.025	NTclustered	gi\|21672293\|gb\|AE006470.1\|	194439	g3324	i0	100	0.0331428571428571	29	0	3	0	229	257	1660132	1660104	Chlorobium tepidum TLS, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
23281863	23281863	PRJNA1204310_P_NODE_60879_length_244_cov_0.912281_g60582_i0	PRJNA1204310	60879	244	0.912281	2.22596564	Phocaeicola vulgatus	821	Bacteria	Bacteria	329	9.08e-86	NTclustered	gi\|2916523787\|gb\|CP181423.1\|	821	g60582	i0	90.984	100	244	22	100	0	1	244	1195476	1195719	Phocaeicola vulgatus strain sJLG0017 chromosome, complete genome	blastn	24400	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
23997158	23997158	PRJNA1204310_P_NODE_48499_length_262_cov_0.936508_g48202_i0	PRJNA1204310	48499	262	0.936508	2.45365096	Pedobacter	84567	Bacteria	Bacteria	396	9.589999999999997e-106	NTclustered	gi\|2738722518\|gb\|CP157278.1\|	1503925	g48202	i0	93.916	315.721374045802	263	14	100	2	1	262	2592256	2591995	Pedobacter lusitanus strain NL19 chromosome, complete genome	blastn	82719	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter lusitanus

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