metadata: contig_metadata: 5 rows where bioproject = "PRJEB10140" and tax

5 rows where bioproject = "PRJEB10140" and tax_phylum = "Synergistota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
7664783	7664783	PRJEB10140_P_NODE_256387_length_167_cov_0.881356_g239078_i0	PRJEB10140	256387	167	0.881356	1.47186452	Bacteria	2	Bacteria	Bacteria	107	3.04e-25	NR	WP_051682911.1	2754	g239078	i0	98.2	87.9161676646707	55	1	98.8	0	2	166	366	420	WP_051682911.1 excinuclease ABC subunit A [Synergistes jonesii]	diamond	14682	108	0.990740740740741	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Synergistes	Synergistes jonesii
30475016	30475016	PRJEB10140_P_NODE_135793_length_271_cov_1.144144_g118486_i0	PRJEB10140	135793	271	1.144144	3.10063024	Synergistaceae bacterium	2053624	Bacteria	Bacteria	43.1	0.0338	NR	MDR1020058.1	2053624	g118486	i0	41.4	0.642066420664207	58	34	64.2	0	194	21	180	237	MDR1020058.1 tRNA pseudouridine(38-40) synthase TruA [Synergistaceae bacterium]	diamond	174	43.1	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
30532058	30532058	PRJEB10140_P_NODE_83833_length_437_cov_1.443299_g66565_i0	PRJEB10140	83833	437	1.443299	6.30721663	Bacteria	2	Bacteria	Bacteria	46.2	0.0129	NR	HCL80079.1	2053624	g66565	i0	32.4	1.74370709382151	68	41	43.2	1	213	25	24	91	HCL80079.1 endonuclease [Synergistaceae bacterium]	diamond	762	46.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
31012042	31012042	PRJEB10140_P_NODE_21535_length_1439_cov_46.756835_g10342_i1	PRJEB10140	21535	1439	46.756835	672.83085565	Synergistaceae bacterium	2053624	Bacteria	Bacteria	78.6	3.38e-11	NR	MBQ3652924.1	2053624	g10342	i1	37.1	0.583738707435719	140	57	27.5	7	412	807	874	990	MBQ3652924.1 putative Ig domain-containing protein [Synergistaceae bacterium]	diamond	840	78.6	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32087463	32087463	PRJEB10140_P_NODE_90118_length_406_cov_1.949580_g72829_i0	PRJEB10140	90118	406	1.94958	7.9152948	Synergistaceae bacterium	2053624	Bacteria	Bacteria	58.2	7.27e-7	NR	MBQ7216726.1	2053624	g72829	i0	35.4	1.24137931034483	96	49	65	4	44	307	72	162	MBQ7216726.1 C-type lectin domain-containing protein [Synergistaceae bacterium]	diamond	504	58.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;