metadata: contig_metadata: 16 rows where bioproject = "PRJNA396510" and tax

16 rows where bioproject = "PRJNA396510" 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
4238955	4238955	PRJNA396510_P_NODE_124_length_1207_cov_2.488774_g98_i0	PRJNA396510	124	1207	2.488774	30.03950218	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	1541	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g98	i0	89.803	242.290803645402	1216	105	100	17	1	1207	218014	216809	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	292445	1541	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
4907175	4907175	PRJNA396510_P_NODE_9904_length_191_cov_1.352113_g9835_i0	PRJNA396510	9904	191	1.352113	2.58253583	Flavobacteriales	200644	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g9835	i0	99.476	423.010471204188	191	1	100	0	1	191	168030	167840	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	80795	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
5515635	5515635	PRJNA396510_P_NODE_4145_length_278_cov_2.672489_g4076_i0	PRJNA396510	4145	278	2.672489	7.42951942	Chryseobacterium indologenes	253	Bacteria	Bacteria	475	1.2799999999999997e-129	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g4076	i0	97.482	378.773381294964	278	7	100	0	1	278	3063655	3063932	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	105299	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
8731913	8731913	PRJNA396510_P_NODE_12287_length_172_cov_2.073171_g12218_i0	PRJNA396510	12287	172	2.073171	3.56585412	Dokdonia	326319	Bacteria	Bacteria	202	1.35e-47	NTclustered	gi\|332168736\|gb\|CP002528.1\|	983548	g12218	i0	87.861	278.133720930233	173	19	100	2	1	172	2386335	2386506	Dokdonia sp. 4H-3-7-5 chromosome, complete genome	blastn	47839	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Dokdonia	Dokdonia sp. 4H-3-7-5
10615827	10615827	PRJNA396510_P_NODE_4889_length_259_cov_2.009524_g4820_i0	PRJNA396510	4889	259	2.009524	5.20466716	Chryseobacterium sp. G0162	2487063	Bacteria	Bacteria	468	1.98e-127	NTclustered	gi\|1519554818\|gb\|CP033922.1\|	2487063	g4820	i0	99.228	510.223938223938	259	2	100	0	1	259	1892377	1892119	Chryseobacterium sp. G0162 chromosome, complete genome	blastn	132148	468	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. G0162
11282383	11282383	PRJNA396510_P_NODE_8549_length_204_cov_1.567742_g8480_i0	PRJNA396510	8549	204	1.567742	3.19819368	Weeksellaceae	2762318	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g8480	i0	99.02	407.196078431373	204	2	100	0	1	204	2942634	2942431	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	83068	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
13832655	13832655	PRJNA396510_P_NODE_91_length_1332_cov_2.601715_g72_i0	PRJNA396510	91	1332	2.601715	34.6548438	Chryseobacterium	59732	Bacteria	Bacteria	2405	0	NTclustered	gi\|1566847344\|gb\|CP035532.1\|	253	g72	i0	99.25	530.21021021021	1333	8	100	2	1	1332	2610639	2609308	Chryseobacterium indologenes strain StR 01 chromosome, complete genome	blastn	706240	2405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
15106863	15106863	PRJNA396510_P_NODE_12432_length_171_cov_1.672131_g12363_i0	PRJNA396510	12432	171	1.672131	2.85934401	Aquirufa	2676247	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g12363	i0	98.83	334.900584795322	171	2	100	0	1	171	360738	360568	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	57268	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
15106891	15106891	PRJNA396510_P_NODE_6372_length_231_cov_2.285714_g6303_i0	PRJNA396510	6372	231	2.285714	5.27999934	Flectobacillus	101	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|1420811895\|gb\|MH591747.1\|	50419	g6303	i0	100	99.987012987013	231	0	100	0	1	231	363	133	Flectobacillus sp. strain PW22 16S ribosomal RNA gene, partial sequence	blastn	23097	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
16989352	16989352	PRJNA396510_P_NODE_13294_length_167_cov_0.864407_g13225_i0	PRJNA396510	13294	167	0.864407	1.44355969	Prevotella jejuni	1177574	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|1318680913\|gb\|CP023863.1\|	1177574	g13225	i0	98.204	8.82035928143713	167	3	100	0	1	167	1157441	1157607	Prevotella jejuni strain CD3:33 chromosome I, complete sequence	blastn	1473	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella jejuni
18263561	18263561	PRJNA396510_P_NODE_3915_length_286_cov_1.042194_g3846_i0	PRJNA396510	3915	286	1.042194	2.98067484	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	337	6.52e-88	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g3846	i0	88.849	328.202797202797	278	26	96	5	12	286	2013269	2012994	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	93866	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
18930631	18930631	PRJNA396510_P_NODE_10775_length_184_cov_1.125926_g10706_i0	PRJNA396510	10775	184	1.125926	2.07170384	Aquirufa	2676247	Bacteria	Bacteria	246	6.71e-61	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g10706	i0	90.761	254.652173913043	184	17	100	0	1	184	359069	359252	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	46856	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
19537805	19537805	PRJNA396510_P_NODE_3176_length_314_cov_1.833962_g3107_i0	PRJNA396510	3176	314	1.833962	5.75864068	Flavobacterium sp. Sr18	935222	Bacteria	Bacteria	558	1.42e-154	NTclustered	gi\|1818223938\|gb\|CP049329.1\|	935222	g3107	i0	98.726	550.407643312102	314	4	100	0	1	314	70274	70587	Flavobacterium sp. Sr18 chromosome, complete genome	blastn	172828	558	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. Sr18
22088442	22088442	PRJNA396510_P_NODE_8778_length_202_cov_1.000000_g8709_i0	PRJNA396510	8778	202	1	2.02	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	302	1.5800000000000001e-77	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g8709	i0	93.564	325.024752475248	202	13	100	0	1	202	2013673	2013472	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	65655	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
28875416	28875416	PRJNA396510_P_NODE_11428_length_179_cov_1.176923_g11359_i0	PRJNA396510	11428	179	1.176923	2.10669217	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	43.1	0.0108	NR	RYG34286.1	1869212	g11359	i0	40	0.837988826815642	50	29	83.8	1	170	21	131	179	RYG34286.1 MAG: RNA methyltransferase [Chitinophagaceae bacterium]	diamond	150	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31307634	31307634	PRJNA396510_P_NODE_5815_length_241_cov_1.078125_g5746_i0	PRJNA396510	5815	241	1.078125	2.59828125	Catalimonadaceae bacterium	2927946	Bacteria	Bacteria	42.4	0.0488	NR	HRH34362.1	2927946	g5746	i0	38.1	0.784232365145228	63	32	71	3	37	207	119	180	HRH34362.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Catalimonadaceae bacterium]	diamond	189	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Catalimonadaceae		Catalimonadaceae 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);;