metadata: contig_metadata: 8 rows where bioproject = "PRJNA757618", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA757618", 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
4561119	4561119	PRJNA757618_P_NODE_40824_length_245_cov_0.906977_g39772_i0	PRJNA757618	40824	245	0.906977	2.22209365	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	163	9.79e-36	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g39772	i0	80.952	74.4204081632653	210	36	85	2	1	208	3453583	3453376	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	18233	163	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
17310849	17310849	PRJNA757618_P_NODE_46794_length_242_cov_1.390533_g45742_i0	PRJNA757618	46794	242	1.390533	3.36508986	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	101	2.88e-24	NR	MEF8943161.1	2683721	g45742	i0	93.8	0.59504132231405	48	3	59.5	0	238	95	121	168	MEF8943161.1 formate dehydrogenase accessory sulfurtransferase FdhD [Desulfohalobiaceae bacterium]	diamond	144	101	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
22410035	22410035	PRJNA757618_P_NODE_41298_length_245_cov_0.906977_g40246_i0	PRJNA757618	41298	245	0.906977	2.22209365	Desulfovibrio sp. X2	941449	Bacteria	Bacteria	125	3.53e-32	NR	WP_020879517.1	941449	g40246	i0	80.3	1.73877551020408	71	14	86.9	0	2	214	26	96	WP_020879517.1 phenylacetate--CoA ligase family protein [Desulfovibrio sp. X2]	diamond	426	125	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. X2
23685559	23685559	PRJNA757618_P_NODE_32579_length_250_cov_0.864407_g31527_i0	PRJNA757618	32579	250	0.864407	2.1610175	Geobacter sp. DSM 9736	1277350	Bacteria	Bacteria	84.2	8.03e-12	NTclustered	gi\|1210070030\|emb\|LT896716.1\|	1277350	g31527	i0	90.476	2.476	63	6	25	0	27	89	656927	656989	Geobacter sp. DSM 9736 genome assembly, chromosome: I	blastn	619	84.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. DSM 9736
27400733	27400733	PRJNA757618_P_NODE_48663_length_242_cov_0.881657_g47611_i0	PRJNA757618	48663	242	0.881657	2.13360994	Desulfoluna butyratoxydans	231438	Bacteria	Bacteria	80.1	2.65e-15	NR	WP_180141242.1	231438	g47611	i0	54.5	0.954545454545455	77	34	95.5	1	231	1	8715	8790	WP_180141242.1 Ig-like domain-containing protein [Desulfoluna butyratoxydans]	diamond	231	80.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfolunaceae	Desulfoluna	Desulfoluna butyratoxydans
28158623	28158623	PRJNA757618_P_NODE_38985_length_246_cov_0.901734_g37933_i0	PRJNA757618	38985	246	0.901734	2.21826564	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	61.2	9.18e-9	NR	MEF8823417.1	2683721	g37933	i0	88.6	0.426829268292683	35	4	42.7	0	140	244	59	93	MEF8823417.1 AEC family transporter [Desulfohalobiaceae bacterium]	diamond	105	61.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
31316888	31316888	PRJNA757618_P_NODE_46395_length_243_cov_0.900000_g45343_i0	PRJNA757618	46395	243	0.9	2.187	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	162	1.28e-44	NR	MEF8822833.1	2683721	g45343	i0	93.8	1.97530864197531	80	5	98.8	0	241	2	125	204	MEF8822833.1 molybdopterin-dependent oxidoreductase [Desulfohalobiaceae bacterium]	diamond	480	162	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
31348651	31348651	PRJNA757618_P_NODE_44696_length_243_cov_1.376471_g43644_i0	PRJNA757618	44696	243	1.376471	3.34482453	Desulfobulbus sp.	895	Bacteria	Bacteria	60.8	3.07e-9	NR	MBP7926705.1	895	g43644	i0	43	2.06172839506173	86	37	100	4	243	1	10	88	MBP7926705.1 hypothetical protein [Desulfobulbus sp.]	diamond	501	60.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus 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);;