metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJEB65099" and tax

24 rows where analysis = "blastn", bioproject = "PRJEB65099" 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
129918	129918	PRJEB65099_P_NODE_1541_length_492_cov_1.489260_g1436_i0	PRJEB65099	1541	492	1.48926	7.3271592	Pseudocnuella soli	2502779	Bacteria	Bacteria	898	0	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g1436	i0	99.593	287.94918699187	492	2	100	0	1	492	1185821	1186312	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	141671	898	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
129922	129922	PRJEB65099_P_NODE_3301_length_310_cov_1.902954_g3196_i0	PRJEB65099	3301	310	1.902954	5.8991574	Pseudocnuella soli	2502779	Bacteria	Bacteria	562	1.08e-155	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g3196	i0	99.357	194.958064516129	311	1	100	1	1	310	1187802	1187492	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	60437	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
993922	993922	PRJEB65099_P_NODE_6061_length_246_cov_0.901734_g5956_i0	PRJEB65099	6061	246	0.901734	2.21826564	Flavobacteriales	200644	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g5956	i0	98.374	6.54471544715447	246	4	100	0	1	246	2180746	2180991	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	1610	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
2269073	2269073	PRJEB65099_P_NODE_4142_length_275_cov_1.410891_g4037_i0	PRJEB65099	4142	275	1.410891	3.87995025	FCB group	1783270	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|1139283804\|emb\|LT697528.1\|	28132	g4037	i0	100	102	275	0	100	0	1	275	490	216	Prevotella melaninogenica partial 16S rRNA gene, isolate 212N_22946	blastn	28050	508	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
2680062	2680062	PRJEB65099_P_NODE_5883_length_247_cov_0.896552_g5778_i0	PRJEB65099	5883	247	0.896552	2.21448344	Cloacibacterium caeni	2004710	Bacteria	Bacteria	385	1.94e-102	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g5778	i0	94.737	3	247	13	100	0	1	247	286216	285970	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	741	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
3956062	3956062	PRJEB65099_P_NODE_6744_length_243_cov_0.900000_g6639_i0	PRJEB65099	6744	243	0.9	2.187	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	224	4.3899999999999996e-54	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g6639	i0	87.629	27.238683127572	194	22	79	2	1	193	1103029	1103221	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	6619	224	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
6097039	6097039	PRJEB65099_P_NODE_4825_length_254_cov_1.635359_g4720_i0	PRJEB65099	4825	254	1.635359	4.15381186	Cloacibacterium	501783	Bacteria	Bacteria	448	2.5199999999999996e-121	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g4720	i0	98.425	4.00393700787402	254	4	100	0	1	254	2360905	2361158	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1017	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
6508163	6508163	PRJEB65099_P_NODE_3286_length_311_cov_1.336134_g3181_i0	PRJEB65099	3286	311	1.336134	4.15537674	Pedobacter sp. WC2423	3234142	Bacteria	Bacteria	553	6.539999999999998e-153	NTclustered	gi\|2775827545\|gb\|CP162005.1\|	3234142	g3181	i0	98.714	351.27652733119	311	4	100	0	1	311	3045336	3045026	Pedobacter sp. WC2423 chromosome, complete genome	blastn	109247	553	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. WC2423
6508189	6508189	PRJEB65099_P_NODE_846_length_697_cov_1.820513_g746_i0	PRJEB65099	846	697	1.820513	12.68897561	Pseudocnuella soli	2502779	Bacteria	Bacteria	1282	0	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g746	i0	99.857	255.060258249641	697	1	100	0	1	697	1187157	1186461	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	177777	1282	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
7782328	7782328	PRJEB65099_P_NODE_5507_length_250_cov_0.881356_g5402_i0	PRJEB65099	5507	250	0.881356	2.20339	Macellibacteroides fermentans	879969	Bacteria	Bacteria	429	8.949999999999998e-116	NTclustered	gi\|2814788327\|emb\|OY761811.2\|	879969	g5402	i0	97.6	1	250	6	100	0	1	250	753746	753995	MAG: Macellibacteroides fermentans isolate d0a889a5-798e-43a2-b832-13c0a728dcc0 genome assembly, chromosome: 1	blastn	250	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Macellibacteroides	Macellibacteroides fermentans
8646946	8646946	PRJEB65099_P_NODE_3667_length_291_cov_1.288991_g3562_i0	PRJEB65099	3667	291	1.288991	3.75096381	Chryseobacterium	59732	Bacteria	Bacteria	244	4.14e-60	NTclustered	gi\|2889300677\|gb\|CP177162.1\|	59733	g3562	i0	97.222	3.17525773195876	144	4	49	0	1	144	4237309	4237452	Chryseobacterium scophthalmum strain LGBM4 chromosome, complete genome	blastn	924	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium scophthalmum
9057221	9057221	PRJEB65099_P_NODE_6548_length_244_cov_0.912281_g6443_i0	PRJEB65099	6548	244	0.912281	2.22596564	Pseudocnuella soli	2502779	Bacteria	Bacteria	350	6.969999999999998e-92	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g6443	i0	92.917	0.983606557377049	240	17	98	0	1	240	2338763	2338524	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	240	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
9057226	9057226	PRJEB65099_P_NODE_6928_length_242_cov_0.923077_g6823_i0	PRJEB65099	6928	242	0.923077	2.23384634	Flavobacterium covae	2906076	Bacteria	Bacteria	189	1.5899999999999996e-43	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g6823	i0	90.066	24.8429752066116	151	7	59	5	87	229	1578491	1578341	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	6012	189	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
9921982	9921982	PRJEB65099_P_NODE_4448_length_265_cov_3.755208_g4343_i0	PRJEB65099	4448	265	3.755208	9.9513012	Flavobacterium	237	Bacteria	Bacteria	311	3.62e-80	NTclustered	gi\|470481948\|ref\|NR_076504.1\|	986	g4343	i0	87.97	556.211320754717	266	28	99	4	1	264	274	11	Flavobacterium johnsoniae strain UW101 23S ribosomal RNA gene, complete sequence	blastn	147396	313	0.993610223642173	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
10332956	10332956	PRJEB65099_P_NODE_3589_length_294_cov_1.226244_g3484_i0	PRJEB65099	3589	294	1.226244	3.60515736	Flavobacterium limnophilum	3003262	Bacteria	Bacteria	492	1.36e-134	NTclustered	gi\|2477668611\|gb\|CP114289.2\|	3003262	g3484	i0	97.561	526.068027210884	287	7	98	0	8	294	2725461	2725747	Flavobacterium limnophilum strain IMCC36791 chromosome, complete genome	blastn	154664	492	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium limnophilum
12472830	12472830	PRJEB65099_P_NODE_5630_length_249_cov_0.886364_g5525_i0	PRJEB65099	5630	249	0.886364	2.20704636	Hoylesella	2974257	Bacteria	Bacteria	405	1.5e-108	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g5525	i0	98.276	12.0803212851406	232	2	93	2	1	232	2722444	2722215	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	3008	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
13747294	13747294	PRJEB65099_P_NODE_3911_length_283_cov_1.209524_g3806_i0	PRJEB65099	3911	283	1.209524	3.42295292	Bacteroidales	171549	Bacteria	Bacteria	63.9	1.21e-5	NTclustered	gi\|2733781693\|gb\|CP152350.1\|	165179	g3806	i0	100	0.830388692579505	34	0	12	0	95	128	124134	124101	Segatella copri strain HDA03 chromosome, complete genome	blastn	235	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
14158348	14158348	PRJEB65099_P_NODE_3772_length_287_cov_1.906542_g3667_i0	PRJEB65099	3772	287	1.906542	5.47177554	Flavobacterium eburneipallidum	3003263	Bacteria	Bacteria	514	2.82e-141	NTclustered	gi\|2493280413\|gb\|CP114291.2\|	3003263	g3667	i0	98.955	554.177700348432	287	3	100	0	1	287	1346796	1346510	Flavobacterium eburneipallidum strain IMCC36793 chromosome, complete genome	blastn	159049	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium eburneipallidum
14158349	14158349	PRJEB65099_P_NODE_3892_length_283_cov_2.000000_g3787_i0	PRJEB65099	3892	283	2	5.66	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	381	2.929999999999999e-101	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g3787	i0	91.166	93.5724381625442	283	21	99	4	4	283	801442	801161	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	26481	381	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15021769	15021769	PRJEB65099_P_NODE_6392_length_244_cov_2.730994_g6287_i0	PRJEB65099	6392	244	2.730994	6.66362536	Pedobacter	84567	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1272249552\|gb\|CP024091.1\|	363852	g6287	i0	98.77	301.897540983607	244	3	100	0	1	244	1383892	1384135	Pedobacter ginsengisoli strain T01R-27 chromosome, complete genome	blastn	73663	435	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ginsengisoli
16706610	16706610	PRJEB65099_P_NODE_4414_length_266_cov_2.373057_g4309_i0	PRJEB65099	4414	266	2.373057	6.31233162	Pedobacter sp. FW305-3-2-15-E-R2A2	3140251	Bacteria	Bacteria	431	2.67e-116	NTclustered	gi\|2720698973\|gb\|CP151803.1\|	3140251	g4309	i0	95.865	384.101503759398	266	11	100	0	1	266	5951302	5951037	Pedobacter sp. FW305-3-2-15-E-R2A2 chromosome, complete genome	blastn	102171	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. FW305-3-2-15-E-R2A2
17981510	17981510	PRJEB65099_P_NODE_6875_length_242_cov_0.923077_g6770_i0	PRJEB65099	6875	242	0.923077	2.23384634	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	375	1.14e-99	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g6770	i0	94.628	2	242	13	100	0	1	242	2255226	2255467	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	484	375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
23081880	23081880	PRJEB65099_P_NODE_6319_length_245_cov_0.906977_g6214_i0	PRJEB65099	6319	245	0.906977	2.22209365	Bacteroides graminisolvens	477666	Bacteria	Bacteria	403	5.299999999999998e-108	NTclustered	gi\|2621703509\|emb\|OY762556.1\|	477666	g6214	i0	96.327	1	245	9	100	0	1	245	2083591	2083347	MAG: Bacteroides graminisolvens isolate c2c85108-0b76-4fb4-8ed9-98fc9390ecb6 genome assembly, chromosome: 1	blastn	245	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides graminisolvens
24355771	24355771	PRJEB65099_P_NODE_5400_length_250_cov_0.881356_g5295_i0	PRJEB65099	5400	250	0.881356	2.20339	uncultured Ferruginibacter sp.	1042239	Bacteria	Bacteria	394	3.27e-105	NTclustered	gi\|2575820297\|emb\|OY730416.1\|	1042239	g5295	i0	95.219	243.476	251	8	99	4	1	249	3394363	3394611	MAG: uncultured Ferruginibacter sp. isolate 52100660-89e0-41f3-aa4d-b5ad2bee9e90 genome assembly, chromosome: 1	blastn	60869	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	uncultured Ferruginibacter sp.

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