metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax

11 rows where analysis = "blastn", bioproject = "PRJEB81327" 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
139926	139926	PRJEB81327_P_NODE_45021_length_252_cov_3.189944_g44413_i0	PRJEB81327	45021	252	3.189944	8.03865888	Treponema medium	58231	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g44413	i0	100	195.93253968254	252	0	100	0	1	252	1845860	1845609	Treponema medium strain T19 chromosome, complete genome	blastn	49375	466	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
139969	139969	PRJEB81327_P_NODE_48021_length_250_cov_1.282486_g47413_i0	PRJEB81327	48021	250	1.282486	3.206215	Treponema denticola	158	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|2265190365\|gb\|CP054477.1\|	158	g47413	i0	98.8	31.572	250	3	100	0	1	250	2119243	2119492	Treponema denticola strain OMZ 823 chromosome, complete genome	blastn	7893	446	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
2271994	2271994	PRJEB81327_P_NODE_21682_length_298_cov_2.040000_g21074_i0	PRJEB81327	21682	298	2.04	6.0792	Treponema	157	Bacteria	Bacteria	534	2.26e-147	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g21074	i0	98.993	194.926174496644	298	3	100	0	1	298	2079370	2079667	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	58088	534	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
3547850	3547850	PRJEB81327_P_NODE_7423_length_516_cov_2.952596_g6819_i0	PRJEB81327	7423	516	2.952596	15.23539536	Treponema	157	Bacteria	Bacteria	937	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g6819	i0	99.419	196.085271317829	516	3	100	0	1	516	2739491	2738976	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	101180	937	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
12893108	12893108	PRJEB81327_P_NODE_19411_length_310_cov_3.396624_g18803_i0	PRJEB81327	19411	310	3.396624	10.5295344	Treponema vincentii	69710	Bacteria	Bacteria	187	7.61e-43	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g18803	i0	89.726	3.29354838709677	146	15	95	0	163	308	2489746	2489891	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	1021	187	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
14168099	14168099	PRJEB81327_P_NODE_27372_length_283_cov_1.466667_g26764_i0	PRJEB81327	27372	283	1.466667	4.15066761	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	490	4.67e-134	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g26764	i0	98.214	156.802120141343	280	5	99	0	1	280	2590451	2590730	Treponema sp. Marseille-Q4132 chromosome	blastn	44375	490	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
20123764	20123764	PRJEB81327_P_NODE_65736_length_240_cov_3.203593_g65128_i0	PRJEB81327	65736	240	3.203593	7.6886232	Treponema	157	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g65128	i0	100	184.720833333333	240	0	100	0	1	240	326286	326525	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	44333	444	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
21816415	21816415	PRJEB81327_P_NODE_22198_length_295_cov_5.954955_g21590_i0	PRJEB81327	22198	295	5.954955	17.56711725	Treponema sp.	166	Bacteria	Bacteria	237	7.040000000000001e-58	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g21590	i0	81.915	1.91186440677966	282	49	95	2	7	287	30060	29780	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	564	237	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
21816512	21816512	PRJEB81327_P_NODE_29538_length_279_cov_1.495146_g28930_i0	PRJEB81327	29538	279	1.495146	4.17145734	Brachyspira intermedia	84377	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|343385146\|gb\|CP002874.1\|	1045858	g28930	i0	100	0.100358422939068	28	0	10	0	243	270	2801746	2801773	Brachyspira intermedia PWS/A, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
23949753	23949753	PRJEB81327_P_NODE_9959_length_434_cov_2.351801_g9351_i0	PRJEB81327	9959	434	2.351801	10.20681634	Treponema	157	Bacteria	Bacteria	774	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g9351	i0	98.848	189.267281105991	434	5	100	0	1	434	2078614	2078181	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	82142	780	0.992307692307692	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
24365659	24365659	PRJEB81327_P_NODE_37960_length_264_cov_2.764398_g37352_i0	PRJEB81327	37960	264	2.764398	7.29801072	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g37352	i0	99.621	209.25	264	1	100	0	1	264	1779290	1779027	Treponema sp. Marseille-Q4132 chromosome	blastn	55242	483	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132

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