metadata: contig_metadata: 6 rows where bioproject = "PRJNA1144090" and tax

6 rows where bioproject = "PRJNA1144090" and tax_phylum = "Fibrobacterota"

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
1562109	1562109	PRJNA1144090_P_NODE_58462_length_332_cov_1.783784_g57927_i0	PRJNA1144090	58462	332	1.783784	5.92216288	Fibrobacter sp.	35828	Bacteria	Bacteria	153	7.54e-44	NR	NLP03964.1	35828	g57927	i0	70	3.97590361445783	110	32	99.4	1	332	3	1	109	NLP03964.1 phosphoribosylformimino-5-aminoimidazole carboxamide ribotide isomerase [Fibrobacter sp.]	diamond	1320	153	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
27923323	27923323	PRJNA1144090_P_NODE_67865_length_307_cov_2.217949_g67330_i0	PRJNA1144090	67865	307	2.217949	6.80910343	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	60.1	6.71e-8	NR	MBL8026795.1	2052160	g67330	i0	42.9	0.752442996742671	77	41	75.2	2	70	300	981	1054	MBL8026795.1 T9SS type A sorting domain-containing protein [Fibrobacterota bacterium]	diamond	231	60.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
28144584	28144584	PRJNA1144090_P_NODE_74825_length_292_cov_1.561644_g74290_i0	PRJNA1144090	74825	292	1.561644	4.56000048	Fibrobacter sp.	35828	Bacteria	Bacteria	48.5	6.57e-4	NR	MBR6449008.1	35828	g74290	i0	44.7	0.780821917808219	76	31	77.1	3	291	67	516	581	MBR6449008.1 cadherin domain-containing protein [Fibrobacter sp.]	diamond	228	48.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
31112975	31112975	PRJNA1144090_P_NODE_81535_length_279_cov_1.495146_g81000_i0	PRJNA1144090	81535	279	1.495146	4.17145734	Candidatus Fibrimonadaceae bacterium	2872174	Bacteria	Bacteria	141	1.96e-39	NR	MDR3001743.1	2872174	g81000	i0	72	2.97849462365591	93	25	98.9	1	2	277	6	98	MDR3001743.1 phosphoribosylformimino-5-aminoimidazole carboxamide ribotide isomerase [Candidatus Fibrimonadaceae bacterium]	diamond	831	141	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Candidatus Fibrimonadales	Candidatus Fibrimonadaceae		Candidatus Fibrimonadaceae bacterium
31619026	31619026	PRJNA1144090_P_NODE_103776_length_248_cov_1.668571_g103241_i0	PRJNA1144090	103776	248	1.668571	4.13805608	Chitinispirillum alkaliphilum	1008392	Bacteria	Bacteria	47.8	2.85e-4	NR	KMQ51706.1	1008392	g103241	i0	31.1	0.737903225806452	61	42	73.8	0	222	40	79	139	KMQ51706.1 acetyltransferase (GNAT) family protein [Chitinispirillum alkaliphilum]	diamond	183	47.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae	Chitinispirillum	Chitinispirillum alkaliphilum
32651421	32651421	PRJNA1144090_P_NODE_64740_length_315_cov_1.272727_g64205_i0	PRJNA1144090	64740	315	1.272727	4.00909005	Fibrobacter	832	Bacteria	Bacteria	179	1.8e-51	NR	MDR1760508.1	35828	g64205	i0	81	6.90476190476191	105	20	100	0	315	1	110	214	MDR1760508.1 phosphomannomutase [Fibrobacter sp.]	diamond	2175	179	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter 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);;