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

5 rows where bioproject = "PRJNA781196" and tax_phylum = "Spirochaetota"

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
19886579	19886579	PRJNA781196_P_NODE_65856_length_243_cov_0.858824_g65479_i0	PRJNA781196	65856	243	0.858824	2.08694232	Treponema saccharophilum	165	Bacteria	Bacteria	93.5	1.29e-14	NTclustered	gi\|2581918939\|dbj\|AP025288.1\|	165	g65479	i0	89.189	5.73662551440329	74	8	30	0	19	92	373822	373749	Treponema saccharophilum JCM 32279 DNA, complete genome	blastn	1394	93.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema saccharophilum
22888974	22888974	PRJNA781196_P_NODE_52598_length_251_cov_1.719101_g52221_i0	PRJNA781196	52598	251	1.719101	4.31494351	root	1	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|2620055352\|gb\|CP117021.1\|	159	g52221	i0	100	0.725099601593626	29	0	23	0	14	42	2342474	2342446	Brachyspira hyodysenteriae strain ZH1179 chromosome, complete genome	blastn	182	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
27401277	27401277	PRJNA781196_P_NODE_28543_length_327_cov_0.921260_g28166_i0	PRJNA781196	28543	327	0.92126	3.0125202	Spirochaetia bacterium	2053615	Bacteria	Bacteria	106	2.4199999999999998e-24	NR	MDH5654478.1	2053615	g28166	i0	55.8	0.871559633027523	95	40	85.3	1	325	47	65	159	MDH5654478.1 hypothetical protein [Spirochaetia bacterium]	diamond	285	106	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27558898	27558898	PRJNA781196_P_NODE_66704_length_242_cov_0.923077_g66327_i0	PRJNA781196	66704	242	0.923077	2.23384634	uncultured spirochete	156406	Bacteria	Bacteria	120	1.09e-31	NR	SLM19634.1	156406	g66327	i0	80	0.991735537190083	80	16	99.2	0	240	1	115	194	SLM19634.1 putative TPR repeat-containing protein [uncultured spirochete]	diamond	240	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			uncultured spirochete
31927796	31927796	PRJNA781196_P_NODE_56537_length_249_cov_0.886364_g56160_i0	PRJNA781196	56537	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	73.6	4.05e-13	NR	OHD72849.1	1802194	g56160	i0	50	6.07228915662651	76	30	90.4	2	19	243	3	71	OHD72849.1 MAG: alcohol dehydrogenase [Spirochaetes bacterium RBG_13_68_11]	diamond	1512	74.3	0.990578734858681	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium RBG_13_68_11

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