metadata: contig_metadata: 5 rows where bioproject = "PRJNA949785", tax_phylum = "Thermodesulfobacteriota" and tax

5 rows where bioproject = "PRJNA949785", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

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
2208468	2208468	PRJNA949785_P_NODE_16942_length_247_cov_0.885057_g16745_i0	PRJNA949785	16942	247	0.885057	2.18609079	Desulfatibacillum aliphaticivorans	218208	Bacteria	Bacteria	206	1.6199999999999998e-48	NTclustered	gi\|218759244\|gb\|CP001322.1\|	218208	g16745	i0	83.333	9.39676113360324	222	37	90	0	6	227	4568541	4568762	Desulfatibacillum aliphaticivorans strain AK-01, complete genome	blastn	2321	206	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
18784922	18784922	PRJNA949785_P_NODE_16135_length_249_cov_0.875000_g15938_i0	PRJNA949785	16135	249	0.875	2.17875	Desulfatibacillum aliphaticivorans	218208	Bacteria	Bacteria	132	2.81e-26	NTclustered	gi\|218759244\|gb\|CP001322.1\|	218208	g15938	i0	76.613	2.39759036144578	248	53	98	5	1	245	5925566	5925811	Desulfatibacillum aliphaticivorans strain AK-01, complete genome	blastn	597	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
29551625	29551625	PRJNA949785_P_NODE_18350_length_243_cov_0.905882_g18153_i0	PRJNA949785	18350	243	0.905882	2.20129326	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	132	7.31e-35	NR	MEF8943003.1	2683721	g18153	i0	85.2	1	81	12	100	0	243	1	328	408	MEF8943003.1 thiamine pyrophosphate-dependent enzyme [Desulfohalobiaceae bacterium]	diamond	243	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
30380063	30380063	PRJNA949785_P_NODE_5692_length_468_cov_1.037975_g5495_i0	PRJNA949785	5692	468	1.037975	4.857723	Pseudomonadati	3379134	Bacteria	Bacteria	134	1.99e-34	NR	WP_035266092.1	933262	g5495	i0	55.8	2.17307692307692	113	49	71.8	1	348	13	9	121	WP_035266092.1 RNA-guided endonuclease InsQ/TnpB family protein [Desulfosarcina sp. BuS5]	diamond	1017	134	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina sp. BuS5
32806773	32806773	PRJNA949785_P_NODE_16980_length_247_cov_0.885057_g16783_i0	PRJNA949785	16980	247	0.885057	2.18609079	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	102	4.28e-26	NR	MEF8823381.1	2683721	g16783	i0	95.8	0.582995951417004	48	2	58.3	0	145	2	1	48	MEF8823381.1 hypothetical protein [Desulfohalobiaceae bacterium]	diamond	144	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae 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);;