metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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
3594194	3594194	PRJNA1198392_P_NODE_13043_length_267_cov_1.587629_g12902_i0	PRJNA1198392	13043	267	1.587629	4.23896943	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	1.39e-12	NR	MBO5730434.1	166	g12902	i0	56.3	5.07865168539326	64	28	71.9	0	53	244	180	243	MBO5730434.1 hypothetical protein [Treponema sp.]	diamond	1356	72.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
23276920	23276920	PRJNA1198392_P_NODE_5299_length_346_cov_1.238095_g5158_i0	PRJNA1198392	5299	346	1.238095	4.2838087	Treponema vincentii	69710	Bacteria	Bacteria	188	9.05e-53	NR	WP_385902931.1	69710	g5158	i0	78.1	2.1242774566474	114	25	98.8	0	3	344	281	394	WP_385902931.1 transcription-repair coupling factor [Treponema vincentii]	diamond	735	188	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27704697	27704697	PRJNA1198392_P_NODE_15704_length_251_cov_0.865169_g15563_i0	PRJNA1198392	15704	251	0.865169	2.17157419	Treponema vincentii	69710	Bacteria	Bacteria	105	4.23e-24	NR	WP_016519212.1	69710	g15563	i0	73.7	1.81673306772908	76	20	90.8	0	228	1	1	76	WP_016519212.1 phosphoenolpyruvate--protein phosphotransferase [Treponema vincentii]	diamond	456	105	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27893670	27893670	PRJNA1198392_P_NODE_15905_length_251_cov_0.865169_g15764_i0	PRJNA1198392	15905	251	0.865169	2.17157419	Treponema vincentii	69710	Bacteria	Bacteria	141	1.01e-37	NR	WP_006188422.1	69710	g15764	i0	88.6	1.86454183266932	79	9	94.4	0	3	239	127	205	WP_006188422.1 alanine/glycine:cation symporter family protein [Treponema vincentii]	diamond	468	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28051642	28051642	PRJNA1198392_P_NODE_9005_length_287_cov_1.331776_g8864_i0	PRJNA1198392	9005	287	1.331776	3.82219712	Treponema sp. OMZ 3	166	Bacteria	Bacteria	173	5.030000000000001e-50	NR	WP_253675263.1	1659192	g8864	i0	90.5	1.98606271777003	95	9	99.3	0	286	2	137	231	WP_253675263.1 CobW family GTP-binding protein [Treponema sp. OMZ 305]	diamond	570	173	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
31114949	31114949	PRJNA1198392_P_NODE_17455_length_248_cov_0.880000_g17314_i0	PRJNA1198392	17455	248	0.88	2.1824	Treponema vincentii	69710	Bacteria	Bacteria	148	4.61e-41	NR	WP_006187939.1	69710	g17314	i0	91.4	0.979838709677419	81	7	98	0	245	3	1	81	WP_006187939.1 glycine/sarcosine/betaine reductase complex component C subunit alpha [Treponema vincentii]	diamond	243	148	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
31558107	31558107	PRJNA1198392_P_NODE_6196_length_325_cov_1.384921_g6055_i0	PRJNA1198392	6196	325	1.384921	4.50099325	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	222	6.29e-71	NR	MFA6935580.1	2791017	g6055	i0	99.1	0.987692307692308	107	1	98.8	0	323	3	124	230	MFA6935580.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	321	222	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32412202	32412202	PRJNA1198392_P_NODE_12299_length_271_cov_1.247475_g12158_i0	PRJNA1198392	12299	271	1.247475	3.38065725	Treponema sp.	166	Bacteria	Bacteria	153	8.6e-45	NR	MFC2602358.1	166	g12158	i0	88.8	0.985239852398524	89	9	97.4	1	1	264	117	205	MFC2602358.1 30S ribosomal protein S3 [Treponema sp.]	diamond	267	153	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32507268	32507268	PRJNA1198392_P_NODE_6679_length_314_cov_1.278008_g6538_i0	PRJNA1198392	6679	314	1.278008	4.01294512	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	201	4.3200000000000005e-58	NR	MFA6935539.1	2791017	g6538	i0	97.1	0.974522292993631	102	3	97.5	0	312	7	660	761	MFA6935539.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	306	201	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
32664539	32664539	PRJNA1198392_P_NODE_20620_length_242_cov_0.911243_g20479_i0	PRJNA1198392	20620	242	0.911243	2.20520806	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	90.1	1.52e-21	NR	MFA6935545.1	2791017	g20479	i0	87	0.669421487603306	54	7	66.9	0	240	79	33	86	MFA6935545.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	162	90.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae 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);;