metadata: contig_metadata: 7 rows where bioproject = "PRJNA1104180", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA1104180", 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
2295723	2295723	PRJNA1104180_P_NODE_19662_length_253_cov_1.427778_g19519_i0	PRJNA1104180	19662	253	1.427778	3.61227834	Candidatus Electrothrix	1859128	Bacteria	Bacteria	207	4.63e-49	NTclustered	gi\|2755823080\|gb\|CP159373.1\|	3062594	g19519	i0	81.496	2.96837944664032	254	45	100	2	1	253	5056294	5056546	MAG: Candidatus Electrothrix aestuarii isolate Rat1 chromosome, complete genome	blastn	751	207	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix aestuarii
11223762	11223762	PRJNA1104180_P_NODE_6389_length_376_cov_1.465347_g6247_i0	PRJNA1104180	6389	376	1.465347	5.50970472	Pseudomonadati	3379134	Bacteria	Bacteria	150	1.23e-31	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g6247	i0	77.432	34.1622340425532	257	54	68	4	122	376	1711904	1711650	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	12845	150	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
19338143	19338143	PRJNA1104180_P_NODE_18396_length_259_cov_1.392473_g18254_i0	PRJNA1104180	18396	259	1.392473	3.60650507	Desulfococcus multivorans	897	Bacteria	Bacteria	180	1.04e-40	NTclustered	gi\|84616844\|emb\|CT009609.1\|	897	g18254	i0	85	13.2895752895753	180	24	69	3	1	179	25361	25538	Desulfococcus multivorans vrl island	blastn	3442	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
19338179	19338179	PRJNA1104180_P_NODE_21096_length_250_cov_0.870056_g20953_i0	PRJNA1104180	21096	250	0.870056	2.17514	uncultured Desulfobacterium sp.	201089	Bacteria	Bacteria	361	3.31e-95	NTclustered	gi\|308273377\|emb\|FR695874.1\|	201089	g20953	i0	93.416	3.564	243	16	97	0	1	243	34984	35226	Uncultured Desulfobacterium sp. genomic DNA, clone SelH_gw24b_gw46b	blastn	891	361	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.
26774288	26774288	PRJNA1104180_P_NODE_22741_length_247_cov_0.885057_g22598_i0	PRJNA1104180	22741	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	107	5.39e-26	NR	WP_013705920.1	60893	g22598	i0	65.8	3.86234817813765	79	27	96	0	6	242	87	165	WP_013705920.1 HPr kinase [Desulfobacca acetoxidans]	diamond	954	107	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales	Desulfobaccaceae	Desulfobacca	Desulfobacca acetoxidans
28710053	28710053	PRJNA1104180_P_NODE_20447_length_251_cov_0.865169_g20304_i0	PRJNA1104180	20447	251	0.865169	2.17157419	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	99	6.87e-22	NR	MBN1931790.1	2044940	g20304	i0	56.6	2.97609561752988	83	36	99.2	0	3	251	518	600	MBN1931790.1 ATP-binding protein [Desulfobacterales bacterium]	diamond	747	99	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30004603	30004603	PRJNA1104180_P_NODE_25731_length_242_cov_0.911243_g25588_i0	PRJNA1104180	25731	242	0.911243	2.20520806	Desulfotignum balticum	115781	Bacteria	Bacteria	48.5	5.45e-5	NR	WP_024336686.1	115781	g25588	i0	63.9	0.446280991735537	36	13	44.6	0	10	117	39	74	WP_024336686.1 helix-turn-helix transcriptional regulator [Desulfotignum balticum]	diamond	108	48.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfotignum	Desulfotignum balticum

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