metadata: contig_metadata: 10 rows where bioproject = "PRJNA330616", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA330616", 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
5493394	5493394	PRJNA330616_P_NODE_3925_length_433_cov_2.270833_g3518_i0	PRJNA330616	3925	433	2.270833	9.83270689	Geopsychrobacteraceae bacterium	3065857	Bacteria	Bacteria	108	8.8e-19	NTclustered	gi\|2621701823\|emb\|OY759353.1\|	3065857	g3518	i0	91.25	1.04387990762125	80	5	18	2	19	97	2088524	2088446	MAG: Geopsychrobacteraceae bacterium isolate b20cad9c-d1d2-40c5-8f7b-178437520c26 genome assembly, chromosome: 1	blastn	452	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae		Geopsychrobacteraceae bacterium
10593361	10593361	PRJNA330616_P_NODE_21049_length_184_cov_1.511111_g20640_i0	PRJNA330616	21049	184	1.511111	2.78044424	Salidesulfovibrio onnuriiensis	2583823	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1725298512\|gb\|CP040751.1\|	2583823	g20640	i0	100	0.152173913043478	28	0	15	0	107	134	1574414	1574387	Salidesulfovibrio onnuriiensis strain IOR2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Salidesulfovibrio	Salidesulfovibrio onnuriiensis
11868205	11868205	PRJNA330616_P_NODE_16090_length_209_cov_0.906250_g15681_i0	PRJNA330616	16090	209	0.90625	1.8940625	Desulfovibrio fairfieldensis	44742	Bacteria	Bacteria	342	9.709999999999999e-90	NTclustered	gi\|987453195\|gb\|CP014229.1\|	44742	g15681	i0	96.19	110.368421052632	210	6	100	2	1	209	165600	165392	Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome	blastn	23067	342	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio fairfieldensis
14418524	14418524	PRJNA330616_P_NODE_24792_length_169_cov_1.758333_g24383_i0	PRJNA330616	24792	169	1.758333	2.97158277	Desulfopila sp. IMCC35008	2653858	Bacteria	Bacteria	141	2.93e-29	NTclustered	gi\|2557433592\|gb\|CP050700.1\|	2653858	g24383	i0	85	124.023668639053	140	20	84	1	15	153	465464	465325	Desulfopila sp. IMCC35008 chromosome, complete genome	blastn	20960	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfopila	Desulfopila sp. IMCC35008
27787043	27787043	PRJNA330616_P_NODE_8524_length_284_cov_1.302128_g8115_i0	PRJNA330616	8524	284	1.302128	3.69804352	Pseudomonadati	3379134	Bacteria	Bacteria	119	8.41e-31	NR	MEN8782234.1	2044940	g8115	i0	70.1	3.83450704225352	87	25	91.9	1	263	3	45	130	MEN8782234.1 carbonic anhydrase family protein [Desulfobacterales bacterium]	diamond	1089	120	0.991666666666667	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
27801259	27801259	PRJNA330616_P_NODE_30364_length_163_cov_0.894737_g29955_i0	PRJNA330616	30364	163	0.894737	1.45842131	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	65.1	1.56e-10	NR	NLZ17799.1	2053307	g29955	i0	58.5	6.57055214723926	53	22	97.5	0	161	3	21	73	NLZ17799.1 DEAD/DEAH box helicase [Desulfobulbaceae bacterium]	diamond	1071	65.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
28401035	28401035	PRJNA330616_P_NODE_26126_length_167_cov_0.864407_g25717_i0	PRJNA330616	26126	167	0.864407	1.44355969	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	46.6	1.88e-4	NR	GJM17742.1	2202153	g25717	i0	47.3	0.988023952095808	55	22	98.8	1	167	3	1	48	GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium]	diamond	165	46.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29081465	29081465	PRJNA330616_P_NODE_14048_length_222_cov_1.242775_g13639_i0	PRJNA330616	14048	222	1.242775	2.7589605	Pseudomonadati	3379134	Bacteria	Bacteria	116	3.41e-30	NR	OQX09806.1	1934250	g13639	i0	70.3	6	74	21	98.6	1	220	2	176	249	OQX09806.1 MAG: cephalosporin hydroxylase [Desulfobulbaceae bacterium A2]	diamond	1332	116	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium A2
29885226	29885226	PRJNA330616_P_NODE_29511_length_163_cov_1.789474_g29102_i0	PRJNA330616	29511	163	1.789474	2.91684262	Syntrophaceae bacterium	2052184	Bacteria	Bacteria	65.1	8.19e-11	NR	MCG2741802.1	2052184	g29102	i0	57.4	1.98773006134969	54	21	99.4	1	1	162	5	56	MCG2741802.1 TIGR04255 family protein [Syntrophaceae bacterium]	diamond	324	65.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium
32747000	32747000	PRJNA330616_P_NODE_17620_length_200_cov_1.350993_g17211_i0	PRJNA330616	17620	200	1.350993	2.701986	Desulfovibrionaceae	194924	Bacteria	Bacteria	73.6	1.85e-13	NR	WP_304088471.1	246191	g17211	i0	56.3	1.95	64	28	96	0	3	194	57	120	WP_304088471.1 N4-gp56 family major capsid protein [Maridesulfovibrio ferrireducens]	diamond	390	73.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio ferrireducens

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