metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA675042" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA675042" 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
4474498	4474498	PRJNA675042_P_NODE_175244_length_241_cov_0.916667_g174794_i0	PRJNA675042	175244	241	0.916667	2.20916747	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621786375\|emb\|OY782833.1\|	2791017	g174794	i0	100	0.116182572614108	28	0	12	0	214	241	2996132	2996159	MAG: Sphaerochaetaceae bacterium isolate 4316afa4-75a5-40cd-90fd-6a37d92e054f genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
7024458	7024458	PRJNA675042_P_NODE_105366_length_251_cov_2.134831_g104916_i0	PRJNA675042	105366	251	2.134831	5.35842581	Treponema denticola	158	Bacteria	Bacteria	368	1.99e-97	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g104916	i0	93.227	191.764940239044	251	16	100	1	1	251	513827	513578	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	48133	368	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
8820805	8820805	PRJNA675042_P_NODE_118987_length_249_cov_1.511364_g118537_i0	PRJNA675042	118987	249	1.511364	3.76329636	Treponema	157	Bacteria	Bacteria	409	1.16e-109	NTclustered	gi\|2586383\|gb\|AF023062.1\|AF023062	67515	g118537	i0	96.386	101	249	8	100	1	1	249	404	651	Treponema sp. I:M:G54 16S ribosomal RNA gene, complete sequence	blastn	25149	411	0.995133819951338	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. I:M:G54
9576017	9576017	PRJNA675042_P_NODE_77808_length_283_cov_1.466667_g77358_i0	PRJNA675042	77808	283	1.466667	4.15066761	Treponema denticola	158	Bacteria	Bacteria	244	4.01e-60	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g77358	i0	83.271	137.985865724382	269	41	99	4	16	283	1664187	1663922	Treponema denticola strain OKA3 chromosome, complete genome	blastn	39050	244	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
10096442	10096442	PRJNA675042_P_NODE_114788_length_250_cov_0.870056_g114338_i0	PRJNA675042	114788	250	0.870056	2.17514	Brachyspira	29521	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2514086334\|gb\|CP098754.1\|	52584	g114338	i0	100	0.672	28	0	11	0	142	169	727614	727641	Brachyspira pilosicoli strain MEI4028 chromosome, complete genome	blastn	168	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli

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