metadata: contig_metadata: 6 rows where bioproject = "PRJNA826497", tax_phylum = "Thermodesulfobacteriota" and tax

6 rows where bioproject = "PRJNA826497", 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
2503746	2503746	PRJNA826497_S_NODE_2642_length_266_cov_8.991416_g2602_i0	PRJNA826497	2642	266	8.991416	23.91716656	Desulfobacca	60892	Bacteria	Bacteria	191	4.940000000000001e-44	NTclustered	gi\|470488362\|ref\|NR_076865.1\|	60893	g2602	i0	85.263	139.353383458647	190	23	70	4	2	187	558	370	Desulfobacca acetoxidans strain ASRB2 23S ribosomal RNA gene, complete sequence	blastn	37068	191	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales	Desulfobaccaceae	Desulfobacca	Desulfobacca acetoxidans
6332300	6332300	PRJNA826497_S_NODE_1085_length_330_cov_12.340067_g1045_i0	PRJNA826497	1085	330	12.340067	40.7222211	Desulfobulbus	893	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|470487339\|ref\|NR_076814.1\|	894	g1045	i0	96.97	1.1	33	1	10	0	92	124	1623	1655	Desulfobulbus propionicus strain 1pr3 23S ribosomal RNA gene, complete sequence	blastn	363	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
13574207	13574207	PRJNA826497_S_NODE_6931_length_208_cov_2.880000_g6891_i0	PRJNA826497	6931	208	2.88	5.9904	Desulfobulbus propionicus	894	Bacteria	Bacteria	243	1.01e-59	NTclustered	gi\|320120648\|gb\|CP002364.1\|	577650	g6891	i0	88.5	2.78846153846154	200	23	96	0	9	208	3065796	3065597	Desulfobulbus propionicus DSM 2032, complete genome	blastn	580	243	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
20354570	20354570	PRJNA826497_S_NODE_11696_length_179_cov_1.232877_g11656_i0	PRJNA826497	11696	179	1.232877	2.20684983	Candidatus Electrothrix	1859128	Bacteria	Bacteria	158	3.12e-34	NTclustered	gi\|2755823080\|gb\|CP159373.1\|	3062594	g11656	i0	82.955	68.9162011173184	176	28	98	2	1	176	2295742	2295569	MAG: Candidatus Electrothrix aestuarii isolate Rat1 chromosome, complete genome	blastn	12336	158	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix aestuarii
30559752	30559752	PRJNA826497_S_NODE_15273_length_164_cov_3.190840_g15233_i0	PRJNA826497	15273	164	3.19084	5.2329776	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	64.3	9.65e-11	NR	HEY3309762.1	2099677	g15233	i0	67.6	1.35365853658537	37	12	67.7	0	164	54	154	190	HEY3309762.1 YceI family protein [Desulfuromonadaceae bacterium]	diamond	222	64.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
32371194	32371194	PRJNA826497_S_NODE_1799_length_292_cov_2.776062_g1759_i0	PRJNA826497	1799	292	2.776062	8.10610104	Pseudomonadati	3379134	Bacteria	Bacteria	140	2.98e-41	NR	PLX99022.1	892	g1759	i0	77	8.02397260273973	87	20	89.4	0	3	263	10	96	PLX99022.1 MAG: addiction module antitoxin RelB [Desulfuromonas sp.]	diamond	2343	141	0.99290780141844	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp.

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