metadata: contig_metadata: 5 rows where bioproject = "PRJNA738523", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA738523", 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
27747671	27747671	PRJNA738523_P_NODE_8564_length_268_cov_2.307692_g8493_i0	PRJNA738523	8564	268	2.307692	6.18461456	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	48.5	4.54e-4	NR	HYS43648.1	2282154	g8493	i0	38.4	0.817164179104478	73	36	77.2	3	248	42	641	708	HYS43648.1 alkaline phosphatase family protein [Geobacteraceae bacterium]	diamond	219	48.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
28820655	28820655	PRJNA738523_P_NODE_11788_length_249_cov_0.875000_g11717_i0	PRJNA738523	11788	249	0.875	2.17875	Desulfococcaceae bacterium	3024398	Bacteria	Bacteria	68.9	9.28e-12	NR	MFP4349783.1	3024398	g11717	i0	44	4.62650602409639	75	42	90.4	0	12	236	3	77	MFP4349783.1 endonuclease/exonuclease/phosphatase family protein [Desulfococcaceae bacterium]	diamond	1152	68.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae		Desulfococcaceae bacterium
30463638	30463638	PRJNA738523_P_NODE_11553_length_249_cov_1.102273_g11482_i0	PRJNA738523	11553	249	1.102273	2.74465977	Desulfobulbus sp. TB	1859132	Bacteria	Bacteria	42.7	0.0414	NR	MCW5213304.1	2821764	g11482	i0	35.2	0.855421686746988	71	38	75.9	3	192	4	549	619	MCW5213304.1 cobyric acid synthase [Desulfobulbus sp. TB]	diamond	213	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus sp. TB
30557783	30557783	PRJNA738523_P_NODE_13793_length_245_cov_0.895349_g13722_i0	PRJNA738523	13793	245	0.895349	2.19360505	Desulfuromonas sp. DDH964	1823759	Bacteria	Bacteria	42.7	0.0361	NR	WP_066726929.1	1823759	g13722	i0	38.6	0.538775510204082	44	27	53.9	0	71	202	104	147	WP_066726929.1 lysophospholipid acyltransferase family protein [Desulfuromonas sp. DDH964]	diamond	132	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp. DDH964
32423690	32423690	PRJNA738523_P_NODE_8119_length_273_cov_1.305000_g8048_i0	PRJNA738523	8119	273	1.305	3.56265	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	41.6	0.0431	NR	MCK7503978.1	2044940	g8048	i0	45.5	0.725274725274725	66	27	68.1	2	240	55	22	82	MCK7503978.1 hypothetical protein [Desulfobacterales bacterium]	diamond	198	41.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales 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);;