metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA177642" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA177642" 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
1055177	1055177	PRJNA177642_P_NODE_6021_length_568_cov_3.239332_g4913_i0	PRJNA177642	6021	568	3.239332	18.39940576	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	152	2.38e-43	NR	TXI78817.1	2021391	g4913	i0	80	0.897887323943662	85	17	44.9	0	1	255	67	151	TXI78817.1 MAG: peptide-methionine (S)-S-oxide reductase MsrA [Flavobacteriales bacterium]	diamond	510	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
4192613	4192613	PRJNA177642_P_NODE_18124_length_164_cov_1.051852_g16899_i0	PRJNA177642	18124	164	1.051852	1.72503728	Bacteria	2	Bacteria	Bacteria	100	1.3799999999999998e-23	NR	PYO67931.1	2026742	g16899	i0	90.6	3.93292682926829	53	5	97	0	163	5	228	280	PYO67931.1 MAG: threonine synthase [Gemmatimonadota bacterium]	diamond	645	100	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
10569522	10569522	PRJNA177642_P_NODE_15769_length_181_cov_1.684211_g14544_i0	PRJNA177642	15769	181	1.684211	3.04842191	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	115	2.8e-30	NR	MBI1968209.1	2026742	g14544	i0	86.7	0.994475138121547	60	8	99.4	0	1	180	48	107	MBI1968209.1 GTP cyclohydrolase I FolE [Gemmatimonadota bacterium]	diamond	180	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
14394607	14394607	PRJNA177642_P_NODE_17652_length_166_cov_1.051095_g16427_i0	PRJNA177642	17652	166	1.051095	1.7448177	Taibaiella	1434702	Bacteria	Bacteria	90.1	2.71e-19	NR	MBX2904774.1	1869185	g16427	i0	77.8	10.2469879518072	54	12	97.6	0	2	163	660	713	MBX2904774.1 alanine--tRNA ligase [Taibaiella sp.]	diamond	1701	90.9	0.991199119911991	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Taibaiella	Taibaiella sp.
26662114	26662114	PRJNA177642_P_NODE_16841_length_170_cov_1.000000_g15616_i0	PRJNA177642	16841	170	1	1.7	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	84.7	2.16e-17	NR	HYT70906.1	2448054	g15616	i0	74.5	6.74117647058824	55	14	97.1	0	4	168	118	172	HYT70906.1 OmpA family protein [Gemmatimonadales bacterium]	diamond	1146	84.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27295193	27295193	PRJNA177642_P_NODE_18383_length_163_cov_1.052239_g17158_i0	PRJNA177642	18383	163	1.052239	1.71514957	Cloacibacterium normanense	237258	Bacteria	Bacteria	113	1.71e-27	NR	MFN8364792.1	237258	g17158	i0	100	1.98773006134969	54	0	99.4	0	163	2	132	185	MFN8364792.1 insulinase family protein [Cloacibacterium normanense]	diamond	324	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
27706145	27706145	PRJNA177642_P_NODE_15284_length_191_cov_1.000000_g14059_i0	PRJNA177642	15284	191	1	1.91	Leyella stercorea	363265	Bacteria	Bacteria	44.7	0.00383	NR	MDD7211033.1	363265	g14059	i0	40.4	0.895287958115183	57	34	89.5	0	2	172	106	162	MDD7211033.1 hypothetical protein [Leyella stercorea]	diamond	171	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Leyella	Leyella stercorea
27912773	27912773	PRJNA177642_P_NODE_17465_length_167_cov_1.007246_g16240_i0	PRJNA177642	17465	167	1.007246	1.68210082	Bacteria	2	Bacteria	Bacteria	92.8	3.06e-20	NR	PYP53242.1	2026742	g16240	i0	78.2	4.94011976047904	55	12	98.8	0	2	166	624	678	PYP53242.1 MAG: SusC/RagA family TonB-linked outer membrane protein [Gemmatimonadota bacterium]	diamond	825	92.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27926773	27926773	PRJNA177642_P_NODE_17745_length_165_cov_2.757353_g16520_i0	PRJNA177642	17745	165	2.757353	4.54963245	Flavobacterium sp.	239	Bacteria	Bacteria	53.5	1.97e-6	NR	MDK2773354.1	239	g16520	i0	57.1	0.890909090909091	49	21	89.1	0	164	18	306	354	MDK2773354.1 transposase [Flavobacterium sp.]	diamond	147	53.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
28779128	28779128	PRJNA177642_P_NODE_18427_length_163_cov_1.029851_g17202_i0	PRJNA177642	18427	163	1.029851	1.67865713	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	95.1	2.5900000000000003e-21	NR	MBA3759617.1	2448054	g17202	i0	81.1	11.6503067484663	53	10	97.5	0	160	2	135	187	MBA3759617.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	1899	95.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29176111	29176111	PRJNA177642_P_NODE_17069_length_168_cov_3.043165_g15844_i0	PRJNA177642	17069	168	3.043165	5.1125172	Cloacibacterium	501783	Bacteria	Bacteria	117	1.2399999999999998e-29	NR	MEN9486694.1	1898104	g15844	i0	100	1.96428571428571	55	0	98.2	0	165	1	70	124	MEN9486694.1 hypothetical protein [Bacteroidota bacterium]	diamond	330	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29884549	29884549	PRJNA177642_P_NODE_13791_length_234_cov_2.253659_g12566_i0	PRJNA177642	13791	234	2.253659	5.27356206	Tenacibaculum polynesiense	3137857	Bacteria	Bacteria	83.2	1.92e-16	NR	WP_348727290.1	3137857	g12566	i0	55.3	0.974358974358974	76	32	96.2	2	3	227	3095	3169	WP_348727290.1 gliding motility-associated C-terminal domain-containing protein [Tenacibaculum polynesiense]	diamond	228	83.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum polynesiense
30168529	30168529	PRJNA177642_P_NODE_17512_length_166_cov_2.036496_g16287_i0	PRJNA177642	17512	166	2.036496	3.38058336	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	91.7	7.44e-20	NR	HEY9383919.1	2448054	g16287	i0	83.3	4.87951807228916	54	9	97.6	0	3	164	177	230	HEY9383919.1 tetratricopeptide repeat protein [Gemmatimonadales bacterium]	diamond	810	91.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30534008	30534008	PRJNA177642_P_NODE_17233_length_168_cov_1.014388_g16008_i0	PRJNA177642	17233	168	1.014388	1.70417184	Bacteria	2	Bacteria	Bacteria	99	6.68e-24	NR	OLC03323.1	1805196	g16008	i0	89.1	2.94642857142857	55	6	98.2	0	2	166	88	142	OLC03323.1 MAG: hypothetical protein AUH45_06265 [Gemmatimonadetes bacterium 13_1_40CM_69_22]	diamond	495	99	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium 13_1_40CM_69_22
31306185	31306185	PRJNA177642_P_NODE_10915_length_336_cov_1.612378_g9691_i0	PRJNA177642	10915	336	1.612378	5.41759008	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	72	9.4e-13	NR	TXI78802.1	2021391	g9691	i0	87.5	1.75	32	4	28.6	0	7	102	62	93	TXI78802.1 MAG: sulfite oxidase-like oxidoreductase [Flavobacteriales bacterium]	diamond	588	72	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
31306188	31306188	PRJNA177642_P_NODE_16695_length_170_cov_1.950355_g15470_i0	PRJNA177642	16695	170	1.950355	3.3156035	Hallella colorans	1703337	Bacteria	Bacteria	115	6.5e-30	NR	WP_116616452.1	1703337	g15470	i0	96.4	0.988235294117647	56	2	98.8	0	168	1	168	223	WP_116616452.1 50S ribosomal protein L11 methyltransferase [Hallella colorans]	diamond	168	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hallella	Hallella colorans

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