metadata: contig_metadata: 9 rows where bioproject = "PRJNA785164", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA785164", 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
7144967	7144967	PRJNA785164_P_NODE_52686_length_250_cov_0.870056_g52221_i0	PRJNA785164	52686	250	0.870056	2.17514	Desulfuromonas versatilis	2802975	Bacteria	Bacteria	82.4	2.89e-11	NTclustered	gi\|2065532709\|dbj\|AP024355.1\|	2802975	g52221	i0	94.34	0.212	53	3	21	0	3	55	4319885	4319833	Desulfuromonas versatilis NIT-T3 DNA, complete genome	blastn	53	82.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas versatilis
27780368	27780368	PRJNA785164_P_NODE_58564_length_244_cov_0.900585_g58099_i0	PRJNA785164	58564	244	0.900585	2.1974274	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	53.9	2e-6	NR	MCJ7663059.1	2044940	g58099	i0	40.6	0.786885245901639	64	37	77.5	1	226	38	80	143	MCJ7663059.1 PD-(D/E)XK nuclease family protein [Desulfobacterales bacterium]	diamond	192	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
28032962	28032962	PRJNA785164_P_NODE_50225_length_253_cov_1.466667_g49760_i0	PRJNA785164	50225	253	1.466667	3.71066751	Smithella sp.	2053614	Bacteria	Bacteria	65.9	2.82e-11	NR	MEN6621308.1	2053614	g49760	i0	53.1	0.758893280632411	64	29	74.7	1	194	6	21	84	MEN6621308.1 hypothetical protein [Smithella sp.]	diamond	192	65.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
29358982	29358982	PRJNA785164_P_NODE_37429_length_295_cov_1.225225_g36964_i0	PRJNA785164	37429	295	1.225225	3.61441375	Desulfobulbus rhabdoformis	34032	Bacteria	Bacteria	75.5	7.53e-16	NR	WP_205227698.1	34032	g36964	i0	82.9	0.416949152542373	41	7	41.7	0	171	293	1	41	WP_205227698.1 hypothetical protein [Desulfobulbus rhabdoformis]	diamond	123	75.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus rhabdoformis
29516653	29516653	PRJNA785164_P_NODE_52810_length_249_cov_2.346591_g52345_i0	PRJNA785164	52810	249	2.346591	5.84301159	Desulfurivibrionaceae bacterium	3024425	Bacteria	Bacteria	47	1.6e-4	NR	MDR9502604.1	3024425	g52345	i0	37.5	0.771084337349398	64	39	75.9	1	247	59	19	82	MDR9502604.1 hypothetical protein [Desulfurivibrionaceae bacterium]	diamond	192	47	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfurivibrionaceae		Desulfurivibrionaceae bacterium
30401691	30401691	PRJNA785164_P_NODE_56373_length_246_cov_0.890173_g55908_i0	PRJNA785164	56373	246	0.890173	2.18982558	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	77.8	1.22e-14	NR	RPI67897.1	2282154	g55908	i0	63.5	0.768292682926829	63	22	75.6	1	186	1	1	63	RPI67897.1 MAG: hypothetical protein EHM38_09180 [Geobacteraceae bacterium]	diamond	189	77.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
30884394	30884394	PRJNA785164_P_NODE_37054_length_296_cov_2.852018_g36589_i0	PRJNA785164	37054	296	2.852018	8.44197328	Pseudomonadati	3379134	Bacteria	Bacteria	114	2.02e-28	NR	OIP87001.1	1805377	g36589	i0	56.7	2.95945945945946	97	42	98.3	0	4	294	204	300	OIP87001.1 MAG: response regulator receiver protein [Syntrophaceae bacterium CG2_30_49_12]	diamond	876	114	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium CG2_30_49_12
31507585	31507585	PRJNA785164_P_NODE_61816_length_241_cov_0.916667_g61351_i0	PRJNA785164	61816	241	0.916667	2.20916747	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	87	2.85e-18	NR	MBT7696315.1	2044940	g61351	i0	73.7	0.70954356846473	57	15	71	0	66	236	248	304	MBT7696315.1 DUF2971 domain-containing protein [Desulfobacterales bacterium]	diamond	171	87	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32465948	32465948	PRJNA785164_P_NODE_46279_length_264_cov_2.214660_g45814_i0	PRJNA785164	46279	264	2.21466	5.8467024	Bacteria	2	Bacteria	Bacteria	46.6	0.0018	NR	MBN1931713.1	2044940	g45814	i0	52.8	0.863636363636364	36	17	40.9	0	128	21	5	40	MBN1931713.1 hypothetical protein [Desulfobacterales bacterium]	diamond	228	47	0.991489361702128	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);;