metadata: contig_metadata: 30 rows where bioproject = "PRJNA506002" and tax

30 rows where bioproject = "PRJNA506002" 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
13237724	13237724	PRJNA506002_S_NODE_22751_length_333_cov_1.911538_g22505_i0	PRJNA506002	22751	333	1.911538	6.36542154	uncultured Bacteroides sp.	162156	Bacteria	Bacteria	272	2.2099999999999998e-68	NTclustered	gi\|2729058744\|emb\|OZ007034.1\|	162156	g22505	i0	81.846	10.5435435435435	325	57	97	2	10	333	2766033	2766356	MAG: uncultured Bacteroides sp. isolate 6737_HOM_CTRL_s7.ctg000008l_hifiasm_large MAG genome assembly, chromosome: 1	blastn	3511	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	uncultured Bacteroides sp.
17061167	17061167	PRJNA506002_S_NODE_24134_length_328_cov_0.894118_g23888_i0	PRJNA506002	24134	328	0.894118	2.93270704	Marinoscillum sp.	2024838	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2836248207\|gb\|CP121337.1\|	2024838	g23888	i0	100	0.173780487804878	29	0	9	0	226	254	2770392	2770364	MAG: Marinoscillum sp. isolate NCC532_bact_3502 chromosome, complete genome	blastn	57	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Reichenbachiellaceae	Marinoscillum	Marinoscillum sp.
17061381	17061381	PRJNA506002_S_NODE_51154_length_259_cov_1.655914_g50908_i0	PRJNA506002	51154	259	1.655914	4.28881726	Sphingobacterium sp. G1-14	2003121	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|1207396639\|gb\|CP021381.1\|	2003121	g50908	i0	100	16.003861003861	259	0	100	0	1	259	4821639	4821897	Sphingobacterium sp. G1-14, complete genome	blastn	4145	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. G1-14
22160917	22160917	PRJNA506002_S_NODE_65398_length_242_cov_1.189349_g65152_i0	PRJNA506002	65398	242	1.189349	2.87822458	Candidatus Ornithobacterium hominis	2497989	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2502739559\|emb\|OX579588.1\|	2497989	g65152	i0	100	0.462809917355372	28	0	12	0	177	204	1401684	1401657	Candidatus Ornithobacterium hominis strain MSHR-COH1 genome assembly, chromosome: 1	blastn	112	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Ornithobacterium	Candidatus Ornithobacterium hominis
24062475	24062475	PRJNA506002_S_NODE_39279_length_284_cov_0.981043_g39033_i0	PRJNA506002	39279	284	0.981043	2.78616212	Sphingobacterium	28453	Bacteria	Bacteria	514	2.78e-141	NTclustered	gi\|2647208394\|gb\|CP141191.1\|	259	g39033	i0	99.298	438.904929577465	285	1	100	1	1	284	411538	411254	Sphingobacterium thalpophilum strain YX-3 chromosome, complete genome	blastn	124649	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
26602037	26602037	PRJNA506002_S_NODE_441_length_994_cov_1.794788_g293_i0	PRJNA506002	441	994	1.794788	17.84019272	Prevotella sp.	59823	Bacteria	Bacteria	637	1.3899999999999994e-224	NR	MBQ7427913.1	59823	g293	i0	97.9	0.998993963782696	331	7	99.9	0	993	1	241	571	MBQ7427913.1 hypothetical protein [Prevotella sp.]	diamond	993	637	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
26697155	26697155	PRJNA506002_S_NODE_38281_length_286_cov_1.446009_g38035_i0	PRJNA506002	38281	286	1.446009	4.13558574	Chryseobacterium	59732	Bacteria	Bacteria	128	5.72e-35	NR	WP_050378467.1	59732	g38035	i0	89.5	0.797202797202797	76	8	79.7	0	285	58	121	196	WP_050378467.1 MULTISPECIES: recombinase family protein [Chryseobacterium]	diamond	228	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium
26918937	26918937	PRJNA506002_S_NODE_64382_length_243_cov_1.017647_g64136_i0	PRJNA506002	64382	243	1.017647	2.47288221	Prevotella sp.	59823	Bacteria	Bacteria	140	1.49e-36	NR	MBQ7427913.1	59823	g64136	i0	95.7	1.7037037037037	69	3	85.2	0	241	35	217	285	MBQ7427913.1 hypothetical protein [Prevotella sp.]	diamond	414	140	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
27361805	27361805	PRJNA506002_S_NODE_15003_length_372_cov_0.769231_g14757_i0	PRJNA506002	15003	372	0.769231	2.86153932	Prevotella sp.	59823	Bacteria	Bacteria	248	4.05e-78	NR	MBQ7427750.1	59823	g14757	i0	96.8	1	124	4	100	0	1	372	157	280	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	372	248	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
27424981	27424981	PRJNA506002_S_NODE_53783_length_255_cov_0.879121_g53537_i0	PRJNA506002	53783	255	0.879121	2.24175855	Myroides odoratimimus	76832	Bacteria	Bacteria	57.8	1.7e-8	NR	MDM1491106.1	76832	g53537	i0	88.9	0.635294117647059	27	3	31.8	0	173	253	41	67	MDM1491106.1 transposase [Myroides odoratimimus]	diamond	162	57.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
27456514	27456514	PRJNA506002_S_NODE_11943_length_393_cov_1.112500_g11697_i0	PRJNA506002	11943	393	1.1125	4.372125	Prevotella sp.	59823	Bacteria	Bacteria	250	1.36e-78	NR	MBQ7427750.1	59823	g11697	i0	93.9	1	131	8	100	0	1	393	360	490	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	393	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
27614343	27614343	PRJNA506002_S_NODE_33404_length_298_cov_2.395556_g33158_i0	PRJNA506002	33404	298	2.395556	7.13875688	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	81.3	1.67e-15	NR	MDY4881725.1	2498093	g33158	i0	72.2	1.63087248322148	54	15	54.4	0	298	137	356	409	MDY4881725.1 methylmalonyl-CoA mutase family protein [Muribaculaceae bacterium]	diamond	486	81.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
28151133	28151133	PRJNA506002_S_NODE_65785_length_242_cov_0.911243_g65539_i0	PRJNA506002	65785	242	0.911243	2.20520806	Chishuiella changwenlii	1434701	Bacteria	Bacteria	42	0.0195	NR	WP_072930989.1	1434701	g65539	i0	37.8	0.557851239669422	45	28	55.8	0	140	6	6	50	WP_072930989.1 hypothetical protein [Chishuiella changwenlii]	diamond	135	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chishuiella	Chishuiella changwenlii
28656226	28656226	PRJNA506002_S_NODE_35547_length_293_cov_0.800000_g35301_i0	PRJNA506002	35547	293	0.8	2.344	Algibacter sp. L4_22	2942477	Bacteria	Bacteria	69.3	2.72e-13	NR	WP_249755498.1	2942477	g35301	i0	71.7	0.931740614334471	46	13	47.1	0	291	154	19	64	WP_249755498.1 hypothetical protein [Algibacter sp. L4_22]	diamond	273	69.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter sp. L4_22
29413813	29413813	PRJNA506002_S_NODE_46749_length_268_cov_0.846154_g46503_i0	PRJNA506002	46749	268	0.846154	2.26769272	Prevotella sp.	59823	Bacteria	Bacteria	179	4.29e-52	NR	MBQ7427750.1	59823	g46503	i0	97.8	0.996268656716418	89	2	99.6	0	267	1	408	496	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	267	179	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
29634523	29634523	PRJNA506002_S_NODE_46490_length_268_cov_1.456410_g46244_i0	PRJNA506002	46490	268	1.45641	3.9031788	Prevotella sp.	59823	Bacteria	Bacteria	174	3.53e-50	NR	MBQ7427750.1	59823	g46244	i0	98.9	0.996268656716418	89	1	99.6	0	2	268	277	365	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	267	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
29761093	29761093	PRJNA506002_S_NODE_8871_length_420_cov_1.265130_g8625_i0	PRJNA506002	8871	420	1.26513	5.313546	Prevotella sp.	59823	Bacteria	Bacteria	204	7.839999999999999e-61	NR	MBQ7427750.1	59823	g8625	i0	94.9	0.835714285714286	117	6	83.6	0	69	419	1	117	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	351	204	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
30108631	30108631	PRJNA506002_S_NODE_61172_length_246_cov_0.936416_g60926_i0	PRJNA506002	61172	246	0.936416	2.30358336	Myroides odoratimimus	76832	Bacteria	Bacteria	57.4	2.16e-8	NR	MDM1491106.1	76832	g60926	i0	92.6	0.658536585365854	27	2	32.9	0	164	244	41	67	MDM1491106.1 transposase [Myroides odoratimimus]	diamond	162	57.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
30330342	30330342	PRJNA506002_S_NODE_57512_length_250_cov_0.864407_g57266_i0	PRJNA506002	57512	250	0.864407	2.1610175	Prevotella sp.	59823	Bacteria	Bacteria	153	3.1299999999999996e-42	NR	MBQ7427750.1	59823	g57266	i0	85.4	1.068	89	7	99.6	1	2	250	214	302	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	267	153	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
30361910	30361910	PRJNA506002_S_NODE_532_length_930_cov_2.509918_g374_i0	PRJNA506002	532	930	2.509918	23.3422374	Prevotella sp.	59823	Bacteria	Bacteria	610	5.629999999999998e-217	NR	MBQ7427750.1	59823	g374	i0	99	0.996774193548387	309	3	99.7	0	3	929	137	445	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	927	610	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
30393519	30393519	PRJNA506002_S_NODE_4093_length_502_cov_1.426573_g3848_i0	PRJNA506002	4093	502	1.426573	7.16139646	Myroides odoratimimus	76832	Bacteria	Bacteria	129	6.44e-35	NR	WP_286468238.1	76832	g3848	i0	95.5	0.394422310756972	66	3	39.4	0	500	303	18	83	WP_286468238.1 hypothetical protein, partial [Myroides odoratimimus]	diamond	198	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
31088153	31088153	PRJNA506002_S_NODE_6755_length_447_cov_0.890374_g6510_i0	PRJNA506002	6755	447	0.890374	3.97997178	Myroides odoratimimus	76832	Bacteria	Bacteria	214	2.6999999999999993e-68	NR	WP_286434948.1	76832	g6510	i0	94	0.778523489932886	116	7	77.9	0	428	81	2	117	WP_286434948.1 hypothetical protein, partial [Myroides odoratimimus]	diamond	348	214	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
31088154	31088154	PRJNA506002_S_NODE_9675_length_412_cov_1.398230_g9429_i0	PRJNA506002	9675	412	1.39823	5.7607076	Prevotella sp.	59823	Bacteria	Bacteria	264	5.41e-82	NR	MBQ7427913.1	59823	g9429	i0	100	0.997572815533981	137	0	99.8	0	412	2	33	169	MBQ7427913.1 hypothetical protein [Prevotella sp.]	diamond	411	264	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
31467779	31467779	PRJNA506002_S_NODE_52036_length_258_cov_0.972973_g51790_i0	PRJNA506002	52036	258	0.972973	2.51027034	Prevotella sp.	59823	Bacteria	Bacteria	167	2.5999999999999997e-47	NR	MBQ7427750.1	59823	g51790	i0	92.9	0.988372093023256	85	6	98.8	0	257	3	234	318	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	255	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
31625669	31625669	PRJNA506002_S_NODE_65616_length_242_cov_0.911243_g65370_i0	PRJNA506002	65616	242	0.911243	2.20520806	Algibacter sp. L4_22	2942477	Bacteria	Bacteria	84.7	1.38e-18	NR	WP_249755544.1	2942477	g65370	i0	80.4	4.42561983471074	51	9	62	1	93	242	40	90	WP_249755544.1 endonuclease/exonuclease/phosphatase family protein, partial [Algibacter sp. L4_22]	diamond	1071	84.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter sp. L4_22
31720614	31720614	PRJNA506002_S_NODE_57157_length_250_cov_0.870056_g56911_i0	PRJNA506002	57157	250	0.870056	2.17514	Algibacter sp. L4_22	2942477	Bacteria	Bacteria	96.7	2.47e-21	NR	WP_249755517.1	2942477	g56911	i0	88	2.988	50	6	60	0	178	29	141	190	WP_249755517.1 RNA-directed DNA polymerase, partial [Algibacter sp. L4_22]	diamond	747	97.1	0.995880535530381	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter sp. L4_22
31878595	31878595	PRJNA506002_S_NODE_52617_length_257_cov_1.005435_g52371_i0	PRJNA506002	52617	257	1.005435	2.58396795	Prevotella sp.	59823	Bacteria	Bacteria	148	3.7e-40	NR	MBQ7427750.1	59823	g52371	i0	93.3	1.75097276264591	75	5	87.5	0	256	32	410	484	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	450	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
32226980	32226980	PRJNA506002_S_NODE_57118_length_250_cov_0.870056_g56872_i0	PRJNA506002	57118	250	0.870056	2.17514	Prevotella sp.	59823	Bacteria	Bacteria	148	2.34e-40	NR	MBQ7427750.1	59823	g56872	i0	94.6	0.888	74	4	88.8	0	248	27	189	262	MBQ7427750.1 hypothetical protein [Prevotella sp.]	diamond	222	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
32669203	32669203	PRJNA506002_S_NODE_50380_length_261_cov_0.957447_g50134_i0	PRJNA506002	50380	261	0.957447	2.49893667	Myroides odoratimimus	76832	Bacteria	Bacteria	67	4.39e-12	NR	MDM1491106.1	76832	g50134	i0	96.6	0.666666666666667	29	1	33.3	0	89	3	41	69	MDM1491106.1 transposase [Myroides odoratimimus]	diamond	174	67	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
32889522	32889522	PRJNA506002_S_NODE_43340_length_275_cov_1.059406_g43094_i0	PRJNA506002	43340	275	1.059406	2.9133665	Ferruginibacter sp.	1940288	Bacteria	Bacteria	42.4	0.0269	NR	MEP7164265.1	1940288	g43094	i0	38	0.545454545454545	50	31	54.5	0	110	259	60	109	MEP7164265.1 hypothetical protein [Ferruginibacter sp.]	diamond	150	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	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);;