metadata: contig_metadata: 15 rows where bioproject = "PRJEB56699" and tax

15 rows where bioproject = "PRJEB56699" 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
124578	124578	PRJEB56699_P_NODE_5201_length_204_cov_3.920000_g4971_i0	PRJEB56699	5201	204	3.92	7.9968	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g4971	i0	99.02	269.475490196078	204	2	100	0	1	204	217272	217475	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	54973	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
992050	992050	PRJEB56699_P_NODE_4221_length_237_cov_23.740385_g3991_i0	PRJEB56699	4221	237	23.740385	56.26471245	Bacteroidota	976	Bacteria	Bacteria	244	3.27e-60	NTclustered	gi\|2659462819\|gb\|CP136426.1\|	1735111	g3991	i0	86.486	250.489451476793	222	30	99	0	16	237	1196001	1195780	Bergeyella porcorum strain QD2021 chromosome, complete genome	blastn	59366	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella porcorum
1399034	1399034	PRJEB56699_P_NODE_3022_length_308_cov_4.641577_g2792_i0	PRJEB56699	3022	308	4.641577	14.29605716	Cloacibacterium caeni	2004710	Bacteria	Bacteria	514	3.05e-141	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g2792	i0	98.955	292.886363636364	287	3	93	0	1	287	1875654	1875940	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	90209	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
2674665	2674665	PRJEB56699_P_NODE_4383_length_230_cov_4.691542_g4153_i0	PRJEB56699	4383	230	4.691542	10.7905466	Flavobacterium cerinum	2502784	Bacteria	Bacteria	420	4.89e-113	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g4153	i0	99.565	690.208695652174	230	1	100	0	1	230	719250	719021	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	158748	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
4819981	4819981	PRJEB56699_P_NODE_424_length_885_cov_7.214953_g321_i0	PRJEB56699	424	885	7.214953	63.85233405	Aquirufa	2676247	Bacteria	Bacteria	983	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g321	i0	86.898	263.892655367232	893	97	100	17	1	885	360463	359583	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	233545	989	0.993933265925177	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
4819987	4819987	PRJEB56699_P_NODE_6484_length_158_cov_2.759690_g6254_i0	PRJEB56699	6484	158	2.75969	4.3603102	Flavobacterium	237	Bacteria	Bacteria	254	3.3400000000000003e-63	NTclustered	gi\|2477680642\|gb\|CP114882.2\|	3016339	g6254	i0	96.129	524.658227848101	155	6	98	0	1	155	122711	122865	Flavobacterium lacustre strain IMCC36792 chromosome, complete genome	blastn	82896	254	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium lacustre
6095167	6095167	PRJEB56699_P_NODE_545_length_787_cov_14.195251_g57_i1	PRJEB56699	545	787	14.195251	111.71662537	Fluviicola	332102	Bacteria	Bacteria	1051	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g57	i1	90.909	346.304955527319	792	59	100	11	1	787	1854	1071	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	272542	1051	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
11603023	11603023	PRJEB56699_P_NODE_4750_length_217_cov_3.031915_g4520_i0	PRJEB56699	4750	217	3.031915	6.57925555	Mucilaginibacter mali	2740462	Bacteria	Bacteria	183	6.51e-42	NTclustered	gi\|1850321202\|gb\|CP054139.1\|	2740462	g4520	i0	94.215	131.433179723502	121	5	56	1	97	217	1169546	1169664	Mucilaginibacter mali strain G2-14 chromosome, complete genome	blastn	28521	183	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter mali
12878206	12878206	PRJEB56699_P_NODE_2691_length_334_cov_10.724590_g2461_i0	PRJEB56699	2691	334	10.72459	35.8201306	Flavobacterium cerinum	2502784	Bacteria	Bacteria	481	3.39e-131	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g2461	i0	96.246	393.01497005988	293	11	88	0	41	333	721507	721215	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	131267	481	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
13745464	13745464	PRJEB56699_P_NODE_1551_length_465_cov_14.853211_g1343_i0	PRJEB56699	1551	465	14.853211	69.06743115	Cloacibacterium	501783	Bacteria	Bacteria	671	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1343	i0	98.677	397.150537634409	378	5	81	0	86	463	129273	129650	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	184675	671	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
15019866	15019866	PRJEB56699_P_NODE_92_length_1679_cov_18.912727_g57_i0	PRJEB56699	92	1679	18.912727	317.54468633	Fluviicola	332102	Bacteria	Bacteria	1742	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g57	i0	85.647	455.921381774866	1700	195	99	42	6	1679	21	1697	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	765492	1742	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
15019867	15019867	PRJEB56699_P_NODE_972_length_591_cov_11.996441_g802_i0	PRJEB56699	972	591	11.996441	70.89896631	Fluviicola	332102	Bacteria	Bacteria	725	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g802	i0	88.945	519.576988155668	597	52	100	14	1	591	19	607	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	307070	725	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
21394102	21394102	PRJEB56699_P_NODE_597_length_749_cov_12.381944_g57_i2	PRJEB56699	597	749	12.381944	92.74076056	Fluviicola	332102	Bacteria	Bacteria	1029	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g57	i2	92.435	432.631508678238	727	46	97	8	1	724	1071	1791	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	324041	1029	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
24350450	24350450	PRJEB56699_P_NODE_4080_length_243_cov_8.588785_g3850_i0	PRJEB56699	4080	243	8.588785	20.87074755	Flavobacterium sp. N2270	2986831	Bacteria	Bacteria	324	4.2e-84	NTclustered	gi\|2324023718\|gb\|CP110005.1\|	2986831	g3850	i0	91.213	545.41975308642	239	20	98	1	2	240	292079	291842	Flavobacterium sp. N2270 chromosome, complete genome	blastn	132537	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2270
28423386	28423386	PRJEB56699_P_NODE_4866_length_214_cov_1.540541_g4636_i0	PRJEB56699	4866	214	1.540541	3.29675774	Niabella hibiscisoli	1825928	Bacteria	Bacteria	42.4	0.0268	NR	WP_240847907.1	1825928	g4636	i0	48.6	0.490654205607477	35	18	49.1	0	78	182	36	70	WP_240847907.1 J domain-containing protein [Niabella hibiscisoli]	diamond	105	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella hibiscisoli

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