metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB28062" 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
2573658	2573658	PRJEB28062_P_NODE_115383_length_272_cov_1.688442_g113020_i0	PRJEB28062	115383	272	1.688442	4.59256224	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	488	1.6099999999999996e-133	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g113020	i0	99.259	15.0919117647059	270	2	99	0	1	270	1107462	1107193	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	4105	488	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
8952156	8952156	PRJEB28062_P_NODE_60428_length_450_cov_7.286472_g58068_i0	PRJEB28062	60428	450	7.286472	32.789124	Treponema medium	58231	Bacteria	Bacteria	174	8.92e-39	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g58068	i0	83.163	2.60888888888889	196	28	43	4	34	227	877449	877257	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	1174	174	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
10227837	10227837	PRJEB28062_P_NODE_56929_length_466_cov_15.613232_g54575_i0	PRJEB28062	56929	466	15.613232	72.75766112	Treponema vincentii	69710	Bacteria	Bacteria	444	6.39e-120	NTclustered	gi\|2265113193\|gb\|CP051148.1\|	69710	g54575	i0	85.446	6.33047210300429	426	62	91	0	23	448	897367	896942	Treponema vincentii strain OMZ 861 chromosome, complete genome	blastn	2950	444	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
11502072	11502072	PRJEB28062_P_NODE_133130_length_232_cov_5.371069_g130766_i0	PRJEB28062	133130	232	5.371069	12.46088008	Treponema denticola	158	Bacteria	Bacteria	233	6.899999999999999e-57	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g130766	i0	86.854	147.560344827586	213	23	91	5	1	211	1101327	1101118	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	34234	233	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
12777779	12777779	PRJEB28062_P_NODE_17371_length_908_cov_13.196407_g15419_i0	PRJEB28062	17371	908	13.196407	119.82337556	Treponema vincentii	69710	Bacteria	Bacteria	1580	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g15419	i0	99.427	13.374449339207	872	2	96	3	19	889	592217	593086	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	12144	1580	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
16289797	16289797	PRJEB28062_P_NODE_136913_length_209_cov_4.948529_g134549_i0	PRJEB28062	136913	209	4.948529	10.34242561	Treponema	157	Bacteria	Bacteria	200	6.18e-47	NTclustered	gi\|332179772\|gb\|CP002696.1\|	906968	g134549	i0	86.316	55.511961722488	190	19	89	7	1	186	430015	429829	Treponema brennaborense DSM 12168, complete genome	blastn	11602	200	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
20425307	20425307	PRJEB28062_P_NODE_35557_length_614_cov_114.334566_g33236_i0	PRJEB28062	35557	614	114.334566	702.01423524	Treponema vincentii	69710	Bacteria	Bacteria	787	0	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g33236	i0	92.559	4.48208469055375	551	38	90	2	23	573	161601	161054	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	2752	787	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
21702498	21702498	PRJEB28062_P_NODE_91858_length_339_cov_4.473684_g89496_i0	PRJEB28062	91858	339	4.473684	15.16578876	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	512	1.22e-140	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g89496	i0	97.039	4.43362831858407	304	9	90	0	13	316	304330	304027	Treponema sp. OMZ 305 chromosome, complete genome	blastn	1503	512	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
22977071	22977071	PRJEB28062_P_NODE_55779_length_472_cov_6.817043_g53425_i0	PRJEB28062	55779	472	6.817043	32.17644296	Spirochaetia bacterium	2053615	Bacteria	Bacteria	285	4.16e-72	NTclustered	gi\|2891482181\|emb\|OZ219914.1\|	2053615	g53425	i0	78.96	2.25635593220339	423	85	89	4	24	444	396400	395980	MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2	blastn	1065	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia 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);;