metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1020641" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1020641" 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
160535	160535	PRJNA1020641_P_NODE_5641_length_251_cov_0.865169_g5598_i0	PRJNA1020641	5641	251	0.865169	2.17157419	Pontimicrobium sp. IMCC45349	3391574	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2894497685\|gb\|CP178208.1\|	3391574	g5598	i0	100	0.111553784860558	28	0	11	0	162	189	3136054	3136081	Pontimicrobium sp. IMCC45349 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pontimicrobium	Pontimicrobium sp. IMCC45349
1003008	1003008	PRJNA1020641_P_NODE_4341_length_291_cov_0.889908_g4298_i0	PRJNA1020641	4341	291	0.889908	2.58963228	Prevotella	838	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|2078768355\|gb\|CP047159.1\|	2691580	g4298	i0	100	5	291	0	100	0	1	291	2419670	2419380	Prevotella sp. Rep29 chromosome, complete genome	blastn	1455	538	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. Rep29
1435386	1435386	PRJNA1020641_P_NODE_5602_length_251_cov_0.865169_g5559_i0	PRJNA1020641	5602	251	0.865169	2.17157419	Prevotella sp. E13-17	2913616	Bacteria	Bacteria	206	1.65e-48	NTclustered	gi\|2190083017\|gb\|CP091787.1\|	2913616	g5559	i0	81.526	0.99203187250996006	249	46	99	0	1	249	3354355	3354107	Prevotella sp. E13-17 chromosome, complete genome	blastn	249	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. E13-17
2710937	2710937	PRJNA1020641_P_NODE_5703_length_250_cov_1.096045_g5660_i0	PRJNA1020641	5703	250	1.096045	2.7401125	Prevotella sp. Rep29	2691580	Bacteria	Bacteria	291	4.41e-74	NTclustered	gi\|2078768355\|gb\|CP047159.1\|	2691580	g5660	i0	87.698	1.008	252	27	99	4	1	249	1138898	1139148	Prevotella sp. Rep29 chromosome, complete genome	blastn	252	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. Rep29
2710938	2710938	PRJNA1020641_P_NODE_5803_length_250_cov_0.870056_g5760_i0	PRJNA1020641	5803	250	0.870056	2.17514	Prevotella sp. E9-3	2913621	Bacteria	Bacteria	97.1	1.03e-15	NTclustered	gi\|2190080074\|gb\|CP091786.1\|	2913621	g5760	i0	87.952	4.832	83	9	33	1	70	152	1498148	1498229	Prevotella sp. E9-3 chromosome, complete genome	blastn	1208	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. E9-3
3987157	3987157	PRJNA1020641_P_NODE_7264_length_242_cov_0.911243_g7221_i0	PRJNA1020641	7264	242	0.911243	2.20520806	Chryseobacterium sp. IHB B 17019	1721091	Bacteria	Bacteria	171	5.77e-38	NTclustered	gi\|959195830\|gb\|CP013293.1\|	1721091	g7221	i0	79.424	1.33884297520661	243	48	100	2	1	242	2941738	2941497	Chryseobacterium sp. IHB B 17019 chromosome, complete genome	blastn	324	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. IHB B 17019
3987158	3987158	PRJNA1020641_P_NODE_7304_length_242_cov_0.911243_g7261_i0	PRJNA1020641	7304	242	0.911243	2.20520806	Coprobacter secundus	1501392	Bacteria	Bacteria	62.1	3.62e-5	NTclustered	gi\|1908102728\|dbj\|AP023322.1\|	2751153	g7261	i0	100	0.520661157024793	33	0	14	0	1	33	2987706	2987674	Coprobacter secundus subsp. similis 2CBH44 DNA, complete genome	blastn	126	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Coprobacter	Coprobacter secundus
5263450	5263450	PRJNA1020641_P_NODE_6385_length_247_cov_0.885057_g6342_i0	PRJNA1020641	6385	247	0.885057	2.18609079	Bacteroidales bacterium SW299	2510306	Bacteria	Bacteria	209	1.25e-49	NTclustered	gi\|2729058721\|emb\|OZ007021.1\|	2510306	g6342	i0	82.114	7.40890688259109	246	42	99	2	2	246	2834466	2834222	MAG: Bacteroidales bacterium SW299 isolate 6755_HET_CTRL_contig_977_metaflye_circ MAG genome assembly, chromosome: 1	blastn	1830	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium SW299
7813171	7813171	PRJNA1020641_P_NODE_3987_length_305_cov_1.056034_g3944_i0	PRJNA1020641	3987	305	1.056034	3.2209037	Xylanibacter ruminicola	839	Bacteria	Bacteria	248	3.38e-61	NTclustered	gi\|2040337580\|gb\|CP071890.1\|	839	g3944	i0	82.796	1.91803278688525	279	46	91	2	2	279	561259	561536	Xylanibacter ruminicola strain KHP1 chromosome, complete genome	blastn	585	248	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Xylanibacter	Xylanibacter ruminicola
11206208	11206208	PRJNA1020641_P_NODE_2929_length_358_cov_1.080702_g2886_i0	PRJNA1020641	2929	358	1.080702	3.86891316	Cloacibacterium	501783	Bacteria	Bacteria	599	9.659999999999997e-167	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g2886	i0	96.927	469.04469273743	358	10	100	1	1	358	1872766	1872410	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	167918	599	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
16737517	16737517	PRJNA1020641_P_NODE_5854_length_250_cov_0.870056_g5811_i0	PRJNA1020641	5854	250	0.870056	2.17514	Flavobacterium sp. KACC 22761	3092665	Bacteria	Bacteria	246	9.679999999999999e-61	NTclustered	gi\|2625491670\|gb\|CP139148.1\|	3092665	g5811	i0	84.4	3.408	250	39	100	0	1	250	4695772	4696021	Flavobacterium sp. KACC 22761 chromosome, complete genome	blastn	852	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. KACC 22761
16737525	16737525	PRJNA1020641_P_NODE_7354_length_241_cov_0.916667_g7311_i0	PRJNA1020641	7354	241	0.916667	2.20916747	Prevotella sp. E9-3	2913621	Bacteria	Bacteria	267	7.12e-67	NTclustered	gi\|2190080074\|gb\|CP091786.1\|	2913621	g7311	i0	86.667	4.0207468879668	240	32	99	0	2	241	1265601	1265840	Prevotella sp. E9-3 chromosome, complete genome	blastn	969	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. E9-3
18012369	18012369	PRJNA1020641_P_NODE_7095_length_243_cov_0.905882_g7052_i0	PRJNA1020641	7095	243	0.905882	2.20129326	Sphingobacterium multivorum	28454	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1986727426\|gb\|CP069793.1\|	28454	g7052	i0	100	1	243	0	100	0	1	243	5783707	5783949	Sphingobacterium multivorum strain FDAARGOS_1203 chromosome	blastn	243	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium multivorum
18854725	18854725	PRJNA1020641_P_NODE_7075_length_243_cov_0.905882_g7032_i0	PRJNA1020641	7075	243	0.905882	2.20129326	Bacteroides	816	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2202814649\|gb\|CP092641.1\|	818	g7032	i0	100	7	243	0	100	0	1	243	5252265	5252507	Bacteroides thetaiotaomicron strain VPI 5482 chromosome, complete genome	blastn	1701	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides thetaiotaomicron
19286255	19286255	PRJNA1020641_P_NODE_5616_length_251_cov_0.865169_g5573_i0	PRJNA1020641	5616	251	0.865169	2.17157419	Dysgonomonas capnocytophagoides	45254	Bacteria	Bacteria	171	6.02e-38	NTclustered	gi\|2574691227\|dbj\|AP028867.1\|	45254	g5573	i0	83.069	10.2988047808765	189	30	75	2	1	188	4676413	4676600	Dysgonomonas capnocytophagoides SMU001 DNA, complete genome	blastn	2585	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas capnocytophagoides
19286260	19286260	PRJNA1020641_P_NODE_6796_length_244_cov_0.900585_g6753_i0	PRJNA1020641	6796	244	0.900585	2.1974274	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g6753	i0	99.59	15.983606557377	244	1	100	0	1	244	293728	293971	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	3900	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
19286261	19286261	PRJNA1020641_P_NODE_6996_length_243_cov_0.905882_g6953_i0	PRJNA1020641	6996	243	0.905882	2.20129326	Prevotella sp. E15-22	2937774	Bacteria	Bacteria	287	5.52e-73	NTclustered	gi\|2232746504\|gb\|CP096247.1\|	2937774	g6953	i0	88.285	7.83950617283951	239	28	98	0	1	239	2657046	2657284	Prevotella sp. E15-22 chromosome, complete genome	blastn	1905	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. E15-22
19286263	19286263	PRJNA1020641_P_NODE_7356_length_241_cov_0.916667_g7313_i0	PRJNA1020641	7356	241	0.916667	2.20916747	Tellurirhabdus rosea	2674997	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|2336996033\|gb\|CP111085.1\|	2674997	g7313	i0	98.755	4.67219917012448	241	3	100	0	1	241	1814482	1814722	Tellurirhabdus rosea strain U15T chromosome, complete genome	blastn	1126	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus rosea
20561726	20561726	PRJNA1020641_P_NODE_1657_length_474_cov_0.750623_g1614_i0	PRJNA1020641	1657	474	0.750623	3.55795302	Prevotella sp. E2-28	2913620	Bacteria	Bacteria	848	0	NTclustered	gi\|2190099531\|gb\|CP091788.1\|	2913620	g1614	i0	98.945	6.59282700421941	474	5	100	0	1	474	2703279	2702806	Prevotella sp. E2-28 chromosome, complete genome	blastn	3125	848	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. E2-28
20561730	20561730	PRJNA1020641_P_NODE_5677_length_251_cov_0.865169_g5634_i0	PRJNA1020641	5677	251	0.865169	2.17157419	Xylanibacter ruminicola	839	Bacteria	Bacteria	202	2.13e-47	NTclustered	gi\|294471613\|gb\|CP002006.1\|	264731	g5634	i0	82.906	9.17529880478088	234	30	91	9	21	249	3022717	3022489	Prevotella ruminicola 23, complete genome	blastn	2303	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Xylanibacter	Xylanibacter ruminicola
21837416	21837416	PRJNA1020641_P_NODE_5618_length_251_cov_0.865169_g5575_i0	PRJNA1020641	5618	251	0.865169	2.17157419	uncultured Flavobacterium sp.	165435	Bacteria	Bacteria	296	9.52e-76	NTclustered	gi\|2513399288\|emb\|OX638201.1\|	165435	g5575	i0	88.259	15.6733067729084	247	29	98	0	5	251	5950437	5950191	MAG: uncultured Flavobacterium sp. isolate ccd45242-ab75-41bb-baf2-9ba9f1fd70fe genome assembly, chromosome: 1	blastn	3934	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium 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);;