metadata: contig_metadata: 20 rows where bioproject = "PRJNA774958" and tax

20 rows where bioproject = "PRJNA774958" 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
752720	752720	PRJNA774958_P_NODE_31041_length_265_cov_1.604167_g30794_i0	PRJNA774958	31041	265	1.604167	4.25104255	Spirosoma taeanense	2735870	Bacteria	Bacteria	285	2.19e-72	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g30794	i0	86.923	202.041509433962	260	27	97	7	1	257	5430504	5430759	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	53541	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
4580911	4580911	PRJNA774958_P_NODE_38024_length_243_cov_0.888235_g37777_i0	PRJNA774958	38024	243	0.888235	2.15841105	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	145	3.51e-30	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g37777	i0	78.696	0.946502057613169	230	39	93	6	18	242	374303	374079	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	230	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21155260	21155260	PRJNA774958_P_NODE_28137_length_286_cov_0.854460_g27890_i0	PRJNA774958	28137	286	0.85446	2.4437556	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1154263508\|gb\|CP014339.1\|	1117645	g27890	i0	100	0.0979020979020979	28	0	10	0	10	37	1965726	1965753	Elizabethkingia anophelis strain E6809 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
23705445	23705445	PRJNA774958_P_NODE_1559_length_1209_cov_2.302817_g1434_i0	PRJNA774958	1559	1209	2.302817	27.84105753	Sphingobacteriia bacterium	2035813	Bacteria	Bacteria	550	3.65e-192	NR	MBN8828671.1	2035813	g1434	i0	70.7	15.2109181141439	382	112	94.8	0	52	1197	79	460	MBN8828671.1 class II fumarate hydratase [Sphingobacteriia bacterium]	diamond	18390	550	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia				Sphingobacteriia bacterium
23705552	23705552	PRJNA774958_P_NODE_23819_length_320_cov_0.951417_g23572_i0	PRJNA774958	23819	320	0.951417	3.0445344	Xylanibacter ruminicola	839	Bacteria	Bacteria	58.4	6.45e-4	NTclustered	gi\|294471613\|gb\|CP002006.1\|	264731	g23572	i0	94.737	0.521875	38	1	12	1	222	259	2062314	2062278	Prevotella ruminicola 23, complete genome	blastn	167	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Xylanibacter	Xylanibacter ruminicola
23705800	23705800	PRJNA774958_P_NODE_8279_length_571_cov_1.919679_g8041_i0	PRJNA774958	8279	571	1.919679	10.96136709	FCB group	1783270	Bacteria	Bacteria	240	5.08e-76	NR	MBO4714008.1	35828	g8041	i0	74	93.015761821366	154	40	80.9	0	108	569	1	154	MBO4714008.1 elongation factor Tu [Fibrobacter sp.]	diamond	53112	242	0.991735537190083	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
26714358	26714358	PRJNA774958_P_NODE_2881_length_938_cov_6.256647_g2711_i0	PRJNA774958	2881	938	6.256647	58.68734886	Bacteroidota	976	Bacteria	Bacteria	211	3.06e-63	NR	RYG06432.1	1869212	g2711	i0	40.8	9.71321961620469	284	152	90.8	5	28	879	3	270	RYG06432.1 MAG: purine-nucleoside phosphorylase [Chitinophagaceae bacterium]	diamond	9111	211	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27401162	27401162	PRJNA774958_P_NODE_33343_length_251_cov_0.865169_g33096_i0	PRJNA774958	33343	251	0.865169	2.17157419	Parapedobacter composti	623281	Bacteria	Bacteria	45.8	0.00338	NR	WP_397236010.1	623281	g33096	i0	38.3	0.717131474103586	60	32	65.7	1	10	174	234	293	WP_397236010.1 penicillin-binding protein 1A [Parapedobacter composti]	diamond	180	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Parapedobacter	Parapedobacter composti
27937910	27937910	PRJNA774958_P_NODE_37445_length_244_cov_0.900585_g37198_i0	PRJNA774958	37445	244	0.900585	2.1974274	Candidatus Zhuqueibacterota bacterium	2172550	Bacteria	Bacteria	91.7	2.23e-19	NR	MBN2013156.1	2172550	g37198	i0	55.7	0.971311475409836	79	35	97.1	0	6	242	492	570	MBN2013156.1 PAS domain S-box protein [Candidatus Zhuqueibacterota bacterium]	diamond	237	91.7	1	Bacteria	FCB group	Pseudomonadati						Candidatus Zhuqueibacterota bacterium
29043077	29043077	PRJNA774958_P_NODE_21388_length_343_cov_0.751852_g21141_i0	PRJNA774958	21388	343	0.751852	2.57885236	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.5	0.0223	NR	MEM8966557.1	1898104	g21141	i0	38.8	0.58600583090379	67	37	56	2	42	233	19	84	MEM8966557.1 helix-turn-helix domain-containing protein [Bacteroidota bacterium]	diamond	201	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29326971	29326971	PRJNA774958_P_NODE_33029_length_252_cov_0.860335_g32782_i0	PRJNA774958	33029	252	0.860335	2.1680442	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	43.5	0.023	NR	TXI84447.1	2026728	g32782	i0	39.7	1.16666666666667	58	33	69	1	177	4	24	79	TXI84447.1 MAG: TonB-dependent receptor [Crocinitomicaceae bacterium]	diamond	294	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
29674059	29674059	PRJNA774958_P_NODE_30030_length_272_cov_2.321608_g29783_i0	PRJNA774958	30030	272	2.321608	6.31477376	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.9	0.0113	NR	MDT8436391.1	2026742	g29783	i0	37.9	0.727941176470588	66	31	71.7	2	259	65	24	80	MDT8436391.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	198	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29958573	29958573	PRJNA774958_P_NODE_28951_length_280_cov_1.410628_g28704_i0	PRJNA774958	28951	280	1.410628	3.9497584	Odoribacter sp.	1965233	Bacteria	Bacteria	43.5	0.0239	NR	MBS1447180.1	1965233	g28704	i0	42.1	0.407142857142857	38	22	40.7	0	168	55	166	203	MBS1447180.1 hypothetical protein [Odoribacter sp.]	diamond	114	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Odoribacteraceae	Odoribacter	Odoribacter sp.
29990225	29990225	PRJNA774958_P_NODE_22431_length_332_cov_3.382239_g22184_i0	PRJNA774958	22431	332	3.382239	11.22903348	Bizionia sp.	1954480	Bacteria	Bacteria	53.5	1.69e-5	NR	MBQ0768748.1	1954480	g22184	i0	29.4	1.96987951807229	109	53	98.5	1	330	4	388	472	MBQ0768748.1 heavy metal translocating P-type ATPase [Bizionia sp.]	diamond	654	53.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Bizionia	Bizionia sp.
31349060	31349060	PRJNA774958_P_NODE_13016_length_451_cov_1.965608_g12769_i0	PRJNA774958	13016	451	1.965608	8.86489208	Mariniphaga sp.	1954475	Bacteria	Bacteria	45.4	0.0348	NR	MEI7525520.1	1954475	g12769	i0	28.8	0.738359201773836	111	67	70.5	3	407	90	696	799	MEI7525520.1 MMPL family transporter [Mariniphaga sp.]	diamond	333	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Mariniphaga	Mariniphaga sp.
31390247	31390247	PRJNA774958_P_NODE_18456_length_375_cov_1.274834_g18209_i0	PRJNA774958	18456	375	1.274834	4.7806275	Pseudomonadati	3379134	Bacteria	Bacteria	75.1	4.35e-13	NR	WP_295202251.1	1917865	g18209	i0	36.2	6	127	73	97.6	5	374	9	199	322	WP_295202251.1 purple acid phosphatase family protein [Sediminibacterium sp.]	diamond	2250	75.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp.
31981463	31981463	PRJNA774958_P_NODE_30018_length_273_cov_0.770000_g29771_i0	PRJNA774958	30018	273	0.77	2.1021	unclassified Sphingobacterium	2609468	Bacteria	Bacteria	43.9	0.0109	NR	WP_254527946.1	2609468	g29771	i0	31.9	0.758241758241758	69	44	75.8	1	240	34	92	157	WP_254527946.1 MULTISPECIES: hypothetical protein [unclassified Sphingobacterium]	diamond	207	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium
32582836	32582836	PRJNA774958_P_NODE_12859_length_454_cov_1.496063_g12612_i0	PRJNA774958	12859	454	1.496063	6.79212602	Balneolaceae bacterium	2053516	Bacteria	Bacteria	95.5	9.56e-20	NR	MEQ9266325.1	2053516	g12612	i0	44.9	0.779735682819383	118	64	77.3	1	44	394	15	132	MEQ9266325.1 aldehyde dehydrogenase [Balneolaceae bacterium]	diamond	354	95.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
32718130	32718130	PRJNA774958_P_NODE_20760_length_349_cov_1.054348_g20513_i0	PRJNA774958	20760	349	1.054348	3.67967452	Bacteroidota	976	Bacteria	Bacteria	146	9.27e-39	NR	MFH1001605.1	1898104	g20513	i0	60.3	30.8853868194842	116	46	99.7	0	349	2	428	543	MFH1001605.1 L-glutamate gamma-semialdehyde dehydrogenase [Bacteroidota bacterium]	diamond	10779	146	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32834510	32834510	PRJNA774958_P_NODE_27460_length_290_cov_1.419355_g27213_i0	PRJNA774958	27460	290	1.419355	4.1161295	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	44.7	0.0137	NR	MBQ4003000.1	2212467	g27213	i0	35.5	1.66551724137931	76	46	75.5	1	219	1	317	392	MBQ4003000.1 DUF3874 domain-containing protein [Bacteroidaceae bacterium]	diamond	483	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium

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