metadata: contig_metadata: 7 rows where bioproject = "PRJEB14175" and tax

7 rows where bioproject = "PRJEB14175" 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
32926214	32926214	PRJEB14175_P_NODE_202361_length_226_cov_3.915152_g200094_i0	PRJEB14175	202361	226	3.915152	8.84824352	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	58.5	6.64e-8	NR	MBK9580285.1	2052160	g200094	i0	61.1	0.716814159292035	54	21	71.7	0	162	1	16	69	MBK9580285.1 hypothetical protein [Fibrobacterota bacterium]	diamond	162	58.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
33012255	33012255	PRJEB14175_P_NODE_265388_length_195_cov_6.529851_g263120_i0	PRJEB14175	265388	195	6.529851	12.73320945	Fibrobacter sp.	35828	Bacteria	Bacteria	92.4	2.86e-21	NR	NLL14167.1	35828	g263120	i0	86.3	0.784615384615385	51	7	78.5	0	6	158	91	141	NLL14167.1 OmpA family protein [Fibrobacter sp.]	diamond	153	92.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
33045228	33045228	PRJEB14175_P_NODE_145357_length_282_cov_9.796380_g143090_i0	PRJEB14175	145357	282	9.79638	27.6257916	Fibrobacter sp.	35828	Bacteria	Bacteria	64.7	1.09e-9	NR	NLD94238.1	35828	g143090	i0	66.7	0.542553191489362	51	17	54.3	0	278	126	512	562	NLD94238.1 InlB B-repeat-containing protein [Fibrobacter sp.]	diamond	153	64.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
33062438	33062438	PRJEB14175_P_NODE_160109_length_265_cov_1.524510_g157842_i0	PRJEB14175	160109	265	1.52451	4.0399515	Fibrobacter sp.	35828	Bacteria	Bacteria	45.1	0.00775	NR	MCQ2063018.1	35828	g157842	i0	74.1	0.305660377358491	27	7	30.6	0	2	82	168	194	MCQ2063018.1 hypothetical protein [Fibrobacter sp.]	diamond	81	45.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
33062880	33062880	PRJEB14175_P_NODE_210261_length_220_cov_4.628931_g207994_i0	PRJEB14175	210261	220	4.628931	10.1836482	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	42.7	0.00476	NR	HEX2612685.1	2725311	g207994	i0	81	0.286363636363636	21	4	28.6	0	124	186	4	24	HEX2612685.1 hypothetical protein [Fibrobacteria bacterium]	diamond	63	42.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
33079247	33079247	PRJEB14175_P_NODE_132862_length_299_cov_16.613445_g130595_i0	PRJEB14175	132862	299	16.613445	49.67420055	Fibrobacter sp.	35828	Bacteria	Bacteria	75.5	2.31e-13	NR	NLL14443.1	35828	g130595	i0	68.4	0.57190635451505	57	18	57.2	0	111	281	1	57	NLL14443.1 type VI secretion system membrane subunit TssM [Fibrobacter sp.]	diamond	171	75.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
33079408	33079408	PRJEB14175_P_NODE_147510_length_280_cov_1.168950_g145243_i0	PRJEB14175	147510	280	1.16895	3.27306	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	122	2.6799999999999996e-32	NR	HLU69388.1	2725311	g145243	i0	76.5	0.867857142857143	81	16	83.6	1	46	279	15	95	HLU69388.1 ribonuclease HII [Fibrobacteria bacterium]	diamond	243	122	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria 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);;