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

5 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax_phylum = "Thermodesulfobacteriota"

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
5514247	5514247	PRJNA393181_S_NODE_30005_length_205_cov_1.577381_g29899_i0	PRJNA393181	30005	205	1.577381	3.23363105	Syntrophales bacterium	2928017	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621706256\|emb\|OY764159.1\|	2928017	g29899	i0	100	0.146341463414634	30	0	15	0	176	205	2196919	2196948	MAG: Syntrophales bacterium isolate 28fc5764-0b9a-428c-a12f-8ca866e14e1d genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
11889233	11889233	PRJNA393181_S_NODE_26210_length_223_cov_1.887097_g26104_i0	PRJNA393181	26210	223	1.887097	4.20822631	Pseudodesulfovibrio aespoeensis	182210	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|316941978\|gb\|CP002431.1\|	643562	g26104	i0	100	0.130044843049327	29	0	13	0	157	185	1362367	1362339	Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio aespoeensis
13164272	13164272	PRJNA393181_S_NODE_29431_length_207_cov_3.923529_g29325_i0	PRJNA393181	29431	207	3.923529	8.12170503	Desulfuromonas sp. DDH964	1823759	Bacteria	Bacteria	135	1.75e-27	NTclustered	gi\|1015516084\|gb\|CP015080.1\|	1823759	g29325	i0	82.781	0.729468599033816	151	26	73	0	1	151	512546	512396	Desulfuromonas sp. DDH964 chromosome, complete genome	blastn	151	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp. DDH964
13164591	13164591	PRJNA393181_S_NODE_42431_length_162_cov_2.288000_g42325_i0	PRJNA393181	42431	162	2.288	3.70656	Desulfarculus baarsii	453230	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|301638057\|gb\|CP002085.1\|	644282	g42325	i0	100	0.172839506172839	28	0	17	0	1	28	859139	859112	Desulfarculus baarsii DSM 2075, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus baarsii
17656177	17656177	PRJNA393181_S_NODE_38414_length_174_cov_1.372263_g38308_i0	PRJNA393181	38414	174	1.372263	2.38773762	Pseudomonadati	3379134	Bacteria	Bacteria	100	5.15e-17	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g38308	i0	86.957	5.17816091954023	92	8	52	4	7	96	853842	853753	Geobacter sulfurreducens strain AM-1 genome	blastn	901	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens

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