metadata: contig_metadata: 6 rows where bioproject = "PRJNA1186363", tax_kingdom = "Pseudomonadati" and tax

6 rows where bioproject = "PRJNA1186363", tax_kingdom = "Pseudomonadati" 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
18171397	18171397	PRJNA1186363_P_NODE_38015_length_254_cov_1.436464_g37127_i0	PRJNA1186363	38015	254	1.436464	3.64861856	Desulfomicrobium sp. ZS1	2952228	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2269306666\|gb\|CP100351.1\|	2952228	g37127	i0	100	1.14566929133858	30	0	12	0	174	203	340628	340599	Desulfomicrobium sp. ZS1 chromosome, complete genome	blastn	291	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium sp. ZS1
27483156	27483156	PRJNA1186363_P_NODE_9843_length_662_cov_1.456706_g8969_i0	PRJNA1186363	9843	662	1.456706	9.64339372	Desulfobulbaceae bacterium AR3	2202841	Bacteria	Bacteria	107	7.01e-24	NR	MCI5146061.1	2202841	g8969	i0	44.9	0.575528700906344	127	65	56.6	4	661	287	191	314	MCI5146061.1 hypothetical protein [Candidatus Electrothrix sp. AR3]	diamond	381	107	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium AR3
28020047	28020047	PRJNA1186363_P_NODE_43265_length_243_cov_0.917647_g42377_i0	PRJNA1186363	43265	243	0.917647	2.22988221	Pseudodesulfovibrio	2035811	Bacteria	Bacteria	45.8	0.0031	NR	WP_273435567.1	2035811	g42377	i0	41.2	2.22222222222222	51	30	63	0	213	61	104	154	WP_273435567.1 MULTISPECIES: hypothetical protein [Pseudodesulfovibrio]	diamond	540	45.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio
28967235	28967235	PRJNA1186363_P_NODE_34328_length_282_cov_1.210526_g33440_i0	PRJNA1186363	34328	282	1.210526	3.41368332	Desulfosarcinaceae bacterium	3036616	Bacteria	Bacteria	65.1	7.77e-11	NR	MEJ2639887.1	3036616	g33440	i0	48.4	2.32978723404255	62	32	66	0	280	95	83	144	MEJ2639887.1 Hsp20/alpha crystallin family protein [Desulfosarcinaceae bacterium]	diamond	657	65.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae		Desulfosarcinaceae bacterium
29946022	29946022	PRJNA1186363_P_NODE_28571_length_329_cov_1.218750_g27683_i0	PRJNA1186363	28571	329	1.21875	4.0096875	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	50.1	2.4e-4	NR	MCP3953123.1	2044940	g27683	i0	35.1	0.857142857142857	94	57	84.8	3	50	328	9	99	MCP3953123.1 hypothetical protein [Desulfobacterales bacterium]	diamond	282	50.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30893960	30893960	PRJNA1186363_P_NODE_34054_length_284_cov_1.109005_g33166_i0	PRJNA1186363	34054	284	1.109005	3.1495742	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	87.8	8.73e-18	NR	HEY5973117.1	2282154	g33166	i0	53.8	0.982394366197183	93	39	97.2	4	5	280	310	399	HEY5973117.1 Ig-like domain-containing protein [Geobacteraceae bacterium]	diamond	279	87.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae 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);;