metadata: contig_metadata: 21 rows where bioproject = "PRJNA1073005" and tax

21 rows where bioproject = "PRJNA1073005" 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
187001	187001	PRJNA1073005_P_NODE_9581_length_247_cov_0.885057_g9462_i0	PRJNA1073005	9581	247	0.885057	2.18609079	Bacteroides intestinalis	329854	Bacteria	Bacteria	291	4.35e-74	NTclustered	gi\|1707809164\|gb\|CP041379.1\|	329854	g9462	i0	88.211	361.246963562753	246	25	99	4	4	247	444000	444243	Bacteroides intestinalis strain APC919/174 chromosome, complete genome	blastn	89228	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides intestinalis
2737548	2737548	PRJNA1073005_P_NODE_9143_length_250_cov_0.870056_g9024_i0	PRJNA1073005	9143	250	0.870056	2.17514	Cellulophaga sp. TSM-5	3393396	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2900105490\|dbj\|AP039451.1\|	3393396	g9024	i0	100	0.112	28	0	11	0	141	168	2035764	2035791	Cellulophaga sp. TSM-5 DNA, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. TSM-5
4843891	4843891	PRJNA1073005_P_NODE_1984_length_791_cov_0.972145_g1884_i0	PRJNA1073005	1984	791	0.972145	7.68966695	Flavobacteriales	200644	Bacteria	Bacteria	1284	0	NTclustered	gi\|470484592\|ref\|NR_076656.1\|	531844	g1884	i0	96.757	433.361567635904	771	23	97	2	1	770	386	1155	Flavobacteriaceae bacterium 3519-10 strain 3519-10 23S ribosomal RNA, complete sequence	blastn	342789	1290	0.995348837209302	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium 3519-10
4844069	4844069	PRJNA1073005_P_NODE_9784_length_245_cov_0.895349_g9665_i0	PRJNA1073005	9784	245	0.895349	2.19360505	Flavobacterium	237	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2306666110\|emb\|OX336425.1\|	1114861	g9665	i0	99.184	566.991836734694	245	2	100	0	1	245	23952	24196	Flavobacterium collinsii strain TRV642 genome assembly, chromosome: TRV642	blastn	138913	446	0.991031390134529	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium collinsii
7839608	7839608	PRJNA1073005_P_NODE_8647_length_260_cov_1.433155_g8528_i0	PRJNA1073005	8647	260	1.433155	3.726203	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	292	1.28e-74	NTclustered	gi\|2874253714\|emb\|OY969556.1\|	152509	g8528	i0	86.973	243.026923076923	261	32	99	2	2	260	170016	169756	MAG: uncultured Bacteroidetes bacterium isolate MFD09286.bin.c.1 genome assembly, chromosome: 1	blastn	63187	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
11665651	11665651	PRJNA1073005_P_NODE_9470_length_247_cov_1.770115_g9351_i0	PRJNA1073005	9470	247	1.770115	4.37218405	Proteiniphilum saccharofermentans	1642647	Bacteria	Bacteria	357	4.22e-94	NTclustered	gi\|1135440284\|emb\|LT605205.1\|	1642647	g9351	i0	92.713	1	247	18	100	0	1	247	2643905	2643659	Proteiniphilum saccharofermentans isolate M3/6 genome assembly, chromosome: I	blastn	247	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Proteiniphilum	Proteiniphilum saccharofermentans
15489618	15489618	PRJNA1073005_P_NODE_7613_length_297_cov_16.665179_g7494_i0	PRJNA1073005	7613	297	16.665179	49.49558163	uncultured Alkaliflexus sp.	435293	Bacteria	Bacteria	278	4.18e-70	NTclustered	gi\|1079705208\|emb\|LT624091.1\|	435293	g7494	i0	100	82.2222222222222	150	0	97	0	2	151	460	311	Uncultured Alkaliflexus sp. partial 16S rRNA gene, isolate OTU_99	blastn	24420	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Alkaliflexus	uncultured Alkaliflexus sp.
20588046	20588046	PRJNA1073005_P_NODE_7837_length_288_cov_1.181395_g7718_i0	PRJNA1073005	7837	288	1.181395	3.4024176	Bacteroides caecimuris	1796613	Bacteria	Bacteria	366	8.38e-97	NTclustered	gi\|2235377421\|gb\|CP096969.1\|	1796613	g7718	i0	89.86	499.236111111111	286	28	99	1	1	286	3234593	3234877	Bacteroides caecimuris strain I48 chromosome	blastn	143780	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides caecimuris
21863841	21863841	PRJNA1073005_P_NODE_8058_length_281_cov_1.182692_g7939_i0	PRJNA1073005	8058	281	1.182692	3.32336452	Chryseolinea sp.	2059303	Bacteria	Bacteria	155	2.81e-43	NR	HTF17304.1	2059303	g7939	i0	86.8	1.94306049822064	91	12	97.2	0	8	280	288	378	HTF17304.1 histidinol dehydrogenase [Chryseolinea sp.]	diamond	546	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea sp.
22692891	22692891	PRJNA1073005_P_NODE_5638_length_389_cov_1.746835_g5519_i0	PRJNA1073005	5638	389	1.746835	6.79518815	Chryseobacterium	59732	Bacteria	Bacteria	664	0	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g5519	i0	97.429	388.136246786632	389	10	100	0	1	389	2628157	2627769	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	150985	665	0.998496240601504	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
23968401	23968401	PRJNA1073005_P_NODE_8319_length_272_cov_1.115578_g8200_i0	PRJNA1073005	8319	272	1.115578	3.03437216	Flavobacterium	237	Bacteria	Bacteria	475	1.2499999999999999e-129	NTclustered	gi\|1127353223\|gb\|KY419857.1\|	239	g8200	i0	98.162	100	272	5	100	0	1	272	632	361	Flavobacterium sp. strain ICC26 16S ribosomal RNA gene, partial sequence	blastn	27200	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
26846153	26846153	PRJNA1073005_P_NODE_10181_length_242_cov_0.911243_g10062_i0	PRJNA1073005	10181	242	0.911243	2.20520806	Bacteroidales bacterium	2030927	Bacteria	Bacteria	50.4	7.1e-5	NR	MDD2199559.1	2030927	g10062	i0	40.8	0.942148760330578	76	40	93	3	11	235	2	73	MDD2199559.1 AAA family ATPase [Bacteroidales bacterium]	diamond	228	50.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
26846156	26846156	PRJNA1073005_P_NODE_8321_length_272_cov_1.090452_g8202_i0	PRJNA1073005	8321	272	1.090452	2.96602944	Bacteroides nordii	291645	Bacteria	Bacteria	43.9	0.018	NR	WP_278508216.1	291645	g8202	i0	32.5	0.849264705882353	77	50	84.9	1	240	10	23	97	WP_278508216.1 RecB family exonuclease [Bacteroides nordii]	diamond	231	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides nordii
27352102	27352102	PRJNA1073005_P_NODE_9763_length_245_cov_0.895349_g9644_i0	PRJNA1073005	9763	245	0.895349	2.19360505	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	110	6.39e-27	NR	HEY4647647.1	2448054	g9644	i0	59.6	5.02040816326531	89	25	95.5	1	239	6	5	93	HEY4647647.1 NrfD/PsrC family molybdoenzyme membrane anchor subunit [Gemmatimonadales bacterium]	diamond	1230	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27572911	27572911	PRJNA1073005_P_NODE_6704_length_338_cov_0.871698_g6585_i0	PRJNA1073005	6704	338	0.871698	2.94633924	Bacteroidota bacterium	1898104	Bacteria	Bacteria	44.3	0.0292	NR	MFN5181455.1	1898104	g6585	i0	35.4	0.576923076923077	65	41	56.8	1	130	321	298	362	MFN5181455.1 formimidoylglutamase [Bacteroidota bacterium]	diamond	195	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28425542	28425542	PRJNA1073005_P_NODE_4126_length_493_cov_1.021429_g4007_i0	PRJNA1073005	4126	493	1.021429	5.03564497	Candidatus Zhuqueibacterota bacterium	2172550	Bacteria	Bacteria	46.6	0.0199	NR	MDZ7316413.1	2172550	g4007	i0	28.9	1.18052738336714	97	58	54.8	2	491	222	50	142	MDZ7316413.1 DEAD/DEAH box helicase [Candidatus Zhuqueibacterota bacterium]	diamond	582	46.6	1	Bacteria	FCB group	Pseudomonadati						Candidatus Zhuqueibacterota bacterium
28709738	28709738	PRJNA1073005_P_NODE_8087_length_280_cov_1.169082_g7968_i0	PRJNA1073005	8087	280	1.169082	3.2734296	Bernardetiaceae bacterium	2802581	Bacteria	Bacteria	157	2.8e-45	NR	MCU0448677.1	2802581	g7968	i0	83.7	6.9	92	15	98.6	0	3	278	64	155	MCU0448677.1 ABC transporter ATP-binding protein [Bernardetiaceae bacterium]	diamond	1932	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Bernardetiaceae		Bernardetiaceae bacterium
29088545	29088545	PRJNA1073005_P_NODE_7028_length_322_cov_1.236948_g6909_i0	PRJNA1073005	7028	322	1.236948	3.98297256	Flavobacterium sp.	239	Bacteria	Bacteria	94.4	5.76e-20	NR	WP_396190472.1	239	g6909	i0	45.3	0.987577639751553	106	55	98.8	1	3	320	91	193	WP_396190472.1 RNase H family protein [Flavobacterium sp.]	diamond	318	94.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30225321	30225321	PRJNA1073005_P_NODE_6332_length_355_cov_0.776596_g6213_i0	PRJNA1073005	6332	355	0.776596	2.7569158	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	86.3	1.88e-19	NR	MFM7855636.1	2026740	g6213	i0	58.4	0.650704225352113	77	31	64.2	1	312	85	1	77	MFM7855636.1 hypothetical protein [Flammeovirgaceae bacterium]	diamond	231	86.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
31521226	31521226	PRJNA1073005_P_NODE_9856_length_245_cov_0.895349_g9737_i0	PRJNA1073005	9856	245	0.895349	2.19360505	Bacteroidota	976	Bacteria	Bacteria	168	5.03e-51	NR	WP_095161135.1	976	g9737	i0	100	0.991836734693878	81	0	99.2	0	3	245	73	153	WP_095161135.1 MULTISPECIES: c-type cytochrome [Bacteroidota]	diamond	243	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota
32848485	32848485	PRJNA1073005_P_NODE_5260_length_411_cov_1.455621_g5141_i0	PRJNA1073005	5260	411	1.455621	5.98260231	Flagellimonas oceani	2698672	Bacteria	Bacteria	97.8	6.43e-24	NR	WP_220123600.1	2698672	g5141	i0	75	0.985401459854015	64	16	46.7	0	5	196	2	65	WP_220123600.1 hypothetical protein, partial [Flagellimonas oceani]	diamond	405	97.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flagellimonas	Flagellimonas oceani

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