metadata: contig_metadata: 8 rows where bioproject = "PRJNA1041773", tax_phylum = "Spirochaetota" and tax

8 rows where bioproject = "PRJNA1041773", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

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
1444847	1444847	PRJNA1041773_P_NODE_33842_length_361_cov_0.711806_g33509_i0	PRJNA1041773	33842	361	0.711806	2.56961966	Brachyspira murdochii	84378	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g33509	i0	100	0.155124653739612	28	0	8	0	332	359	1506209	1506236	Brachyspira murdochii DSM 12563, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
6548704	6548704	PRJNA1041773_P_NODE_67586_length_266_cov_1.595855_g67253_i0	PRJNA1041773	67586	266	1.595855	4.2449743	Pseudomonadati	3379134	Bacteria	Bacteria	89	2.78e-20	NR	NMC67714.1	2026792	g67253	i0	69.8	2.36842105263158	53	16	59.8	0	262	104	88	140	NMC67714.1 WxcM-like domain-containing protein [Spirochaetales bacterium]	diamond	630	89.7	0.992196209587514	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
27572317	27572317	PRJNA1041773_P_NODE_97444_length_242_cov_2.005917_g97111_i0	PRJNA1041773	97444	242	2.005917	4.85431914	Rectinema sp.	1937017	Bacteria	Bacteria	157	4.98e-46	NR	MCX8013823.1	1937017	g97111	i0	100	4.94628099173554	80	0	99.2	0	241	2	86	165	MCX8013823.1 TraB/VirB10 family protein [Rectinema sp.]	diamond	1197	157	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Rectinemataceae	Rectinema	Rectinema sp.
27698985	27698985	PRJNA1041773_P_NODE_78064_length_251_cov_0.865169_g77731_i0	PRJNA1041773	78064	251	0.865169	2.17157419	spirochete symbiont of Stewartia floridana	1968597	Bacteria	Bacteria	61.6	2.47e-10	NR	RLW70585.1	1968597	g77731	i0	81.8	0.394422310756972	33	6	39.4	0	112	14	18	50	RLW70585.1 MAG: hypothetical protein B6D68_00645, partial [spirochete symbiont of Stewartia floridana]	diamond	99	61.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			spirochete symbiont of Stewartia floridana
27880052	27880052	PRJNA1041773_P_NODE_56245_length_287_cov_1.696262_g55912_i0	PRJNA1041773	56245	287	1.696262	4.86827194	Bacteria	2	Bacteria	Bacteria	84.7	9.15e-17	NR	HQI19057.1	2026757	g55912	i0	43.5	3.55400696864112	85	48	88.9	0	32	286	193	277	HQI19057.1 cbb3-type cytochrome c oxidase subunit I [Leptospiraceae bacterium]	diamond	1020	84.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28266753	28266753	PRJNA1041773_P_NODE_88086_length_246_cov_1.878613_g87753_i0	PRJNA1041773	88086	246	1.878613	4.62138798	Spirochaetia bacterium	2053615	Bacteria	Bacteria	108	8.360000000000001e-29	NR	MFO7729640.1	2053615	g87753	i0	91.5	0.719512195121951	59	3	72	1	68	244	8	64	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	177	108	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30035302	30035302	PRJNA1041773_P_NODE_84491_length_248_cov_0.880000_g84158_i0	PRJNA1041773	84491	248	0.88	2.1824	spirochete symbiont of Stewartia floridana	1968597	Bacteria	Bacteria	67.4	1.25e-12	NR	RLW70585.1	1968597	g84158	i0	90.6	0.387096774193548	32	3	38.7	0	139	44	18	49	RLW70585.1 MAG: hypothetical protein B6D68_00645, partial [spirochete symbiont of Stewartia floridana]	diamond	96	67.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			spirochete symbiont of Stewartia floridana
30438187	30438187	PRJNA1041773_P_NODE_89533_length_246_cov_0.890173_g89200_i0	PRJNA1041773	89533	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	60.8	4.61e-10	NR	RLW70585.1	1968597	g89200	i0	77.4	0.768292682926829	31	7	37.8	0	5	97	1	31	RLW70585.1 MAG: hypothetical protein B6D68_00645, partial [spirochete symbiont of Stewartia floridana]	diamond	189	60.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			spirochete symbiont of Stewartia floridana

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