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

9 rows where bioproject = "PRJNA615175", 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
11353210	11353210	PRJNA615175_P_NODE_24849_length_272_cov_2.291457_g24681_i0	PRJNA615175	24849	272	2.291457	6.23276304	Pseudomonadati	3379134	Bacteria	Bacteria	359	1.31e-94	NTclustered	gi\|2431398965\|gb\|CP116247.1\|	881	g24681	i0	100	97.5073529411765	194	0	71	0	79	272	99492	99299	Nitratidesulfovibrio vulgaris strain L2 plasmid pDsulf-L2-2, complete sequence	blastn	26522	361	0.994459833795014	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
29227926	29227926	PRJNA615175_P_NODE_5109_length_681_cov_3.409539_g4946_i0	PRJNA615175	5109	681	3.409539	23.21896059	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	68.2	3.01e-9	NR	MDD2898332.1	2099677	g4946	i0	40.4	0.436123348017621	99	56	43.6	2	81	377	424	519	MDD2898332.1 PcfJ domain-containing protein [Desulfuromonadaceae bacterium]	diamond	297	68.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
29479951	29479951	PRJNA615175_P_NODE_2990_length_899_cov_3.941889_g2854_i0	PRJNA615175	2990	899	3.941889	35.43758211	Desulfovibrio sp.	885	Bacteria	Bacteria	47.4	0.0375	NR	MCR5813686.1	885	g2854	i0	30.1	0.410456062291435	123	59	32	4	320	607	121	243	MCR5813686.1 hypothetical protein [Desulfovibrio sp.]	diamond	369	47.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
30901855	30901855	PRJNA615175_P_NODE_14834_length_367_cov_1.846939_g14666_i0	PRJNA615175	14834	367	1.846939	6.7782661299999996	Geomonas sp. Red32	2912856	Bacteria	Bacteria	208	3.82e-66	NR	WP_250676575.1	2912856	g14666	i0	78.3	2.95095367847411	120	26	98.1	0	3	362	44	163	WP_250676575.1 antibiotic biosynthesis monooxygenase [Geomonas sp. Red32]	diamond	1083	208	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas sp. Red32
31198687	31198687	PRJNA615175_P_NODE_8535_length_510_cov_5.038902_g8367_i0	PRJNA615175	8535	510	5.038902	25.6984002	Bacteria	2	Bacteria	Bacteria	118	3.47e-29	NR	MEI7638319.1	48412	g8367	i0	56.5	1.08235294117647	92	40	54.1	0	1	276	166	257	MEI7638319.1 DUF4886 domain-containing protein [Syntrophus sp. (in: bacteria)]	diamond	552	118	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus sp. (in: bacteria)
31376015	31376015	PRJNA615175_P_NODE_2796_length_928_cov_2.947368_g2664_i0	PRJNA615175	2796	928	2.947368	27.35157504	Desulfatitalea tepidiphila	1185843	Bacteria	Bacteria	63.2	6.84e-7	NR	WP_054030898.1	1185843	g2664	i0	24.2	0.908405172413793	281	177	80.8	8	175	924	796	1071	WP_054030898.1 DUF1848 family protein [Desulfatitalea tepidiphila]	diamond	843	63.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfatitalea	Desulfatitalea tepidiphila
31407639	31407639	PRJNA615175_P_NODE_25616_length_266_cov_3.601036_g25448_i0	PRJNA615175	25616	266	3.601036	9.57875576	Desulfovibrio sp.	885	Bacteria	Bacteria	60.1	3.61e-8	NR	MBQ9407129.1	885	g25448	i0	41.6	0.868421052631579	77	41	82.3	2	248	30	252	328	MBQ9407129.1 Flp pilus assembly complex ATPase component TadA [Desulfovibrio sp.]	diamond	231	60.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
31850278	31850278	PRJNA615175_P_NODE_11857_length_419_cov_1.780347_g11689_i0	PRJNA615175	11857	419	1.780347	7.45965393	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	94	1.38e-19	NR	MDQ7832064.1	2049043	g11689	i0	71.9	0.809069212410501	57	16	40.8	0	248	418	3	59	MDQ7832064.1 site-specific DNA-methyltransferase [Desulfovibrionaceae bacterium]	diamond	339	94	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
32735655	32735655	PRJNA615175_P_NODE_24760_length_273_cov_1.540000_g24592_i0	PRJNA615175	24760	273	1.54	4.2042	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	58.2	1.21e-7	NR	MBQ7609139.1	2049043	g24592	i0	42.6	0.67032967032967	61	32	67	1	41	223	84	141	MBQ7609139.1 endonuclease [Desulfovibrionaceae bacterium]	diamond	183	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae 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);;