metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA330616" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA330616" 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
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);;