metadata: contig_metadata: 10 rows where bioproject = "PRJEB6584" and tax

10 rows where bioproject = "PRJEB6584" 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
25933687	25933687	PRJEB6584o_S_NODE_81212_length_151_cov_1.353448_g81104_i0	PRJEB6584	81212	151	1.353448	2.04370648	Syntrophotalea carbinolica DSM 238	19	Bacteria	Bacteria	69.4	1.22e-7	NTclustered	gi\|90823168\|gb\|CP000142.2\|	338963	g81104	i0	93.478	4.59602649006623	46	3	30	0	36	81	897263	897218	Pelobacter carbinolicus DSM 2380, complete genome	blastn	694	69.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea carbinolica
26160288	26160288	PRJEB6584d_S_NODE_13173_length_174_cov_1.568345_g13105_i0	PRJEB6584	13173	174	1.568345	2.7289203	Pseudomonadati	3379134	Bacteria	Bacteria	100	5.15e-17	NTclustered	gi\|2447237393\|gb\|CP087952.1\|	933262	g13105	i0	81.746	132.994252873563	126	18	71	4	52	174	2911766	2911889	Desulfosarcina sp. BuS5 chromosome, complete genome	blastn	23141	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina sp. BuS5
26341542	26341542	PRJEB6584o_S_NODE_58311_length_163_cov_0.937500_g58203_i0	PRJEB6584	58311	163	0.9375	1.528125	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	108	2.86e-19	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g58203	i0	79.012	5.13496932515337	162	31	99	3	1	161	2517199	2517358	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	837	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
26477169	26477169	PRJEB6584o_S_NODE_17872_length_212_cov_2.000000_g17764_i0	PRJEB6584	17872	212	2	4.24	Desulfovibrio piger	901	Bacteria	Bacteria	243	1.03e-59	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g17764	i0	87.264	62.0990566037736	212	27	100	0	1	212	982926	982715	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	13165	243	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
32929315	32929315	PRJEB6584o_S_NODE_14225_length_234_cov_2.246231_g14117_i0	PRJEB6584	14225	234	2.246231	5.25618054	Smithellaceae bacterium	2964540	Bacteria	Bacteria	45.4	6.05e-4	NR	HOC61279.1	2964540	g14117	i0	33.3	0.730769230769231	57	37	71.8	1	183	16	10	66	HOC61279.1 hypothetical protein [Smithellaceae bacterium]	diamond	171	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
32974515	32974515	PRJEB6584e_S_NODE_3146_length_169_cov_5.149254_g3131_i0	PRJEB6584	3146	169	5.149254	8.70223926	root	1	Root_unresolved	Root_unresolved	45.8	0.0011	NR	HIP82064.1	65555	g3131	i0	52.9	3.62130177514793	34	16	60.4	0	104	3	133	166	HIP82064.1 reverse transcriptase-like protein [Desulfocapsa sulfexigens]	diamond	612	45.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sulfexigens
32998008	32998008	PRJEB6584o_S_NODE_7203_length_315_cov_4.017857_g7095_i0	PRJEB6584	7203	315	4.017857	12.65624955	Geobacter argillaceus	345631	Bacteria	Bacteria	86.7	9.44e-18	NR	WP_145026094.1	345631	g7095	i0	44.1	0.971428571428571	102	57	97.1	0	7	312	157	258	WP_145026094.1 hypothetical protein [Geobacter argillaceus]	diamond	306	86.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter argillaceus
33014650	33014650	PRJEB6584o_S_NODE_12964_length_244_cov_3.736842_g12856_i0	PRJEB6584	12964	244	3.736842	9.11789448	Desulfobacterales bacterium RIFOXYA12_FULL_46_15	1797914	Bacteria	Bacteria	70.5	1.37e-12	NR	OGR26158.1	1797914	g12856	i0	53.6	0.848360655737705	69	32	84.8	0	36	242	93	161	OGR26158.1 MAG: hypothetical protein A2277_08190 [Desulfobacterales bacterium RIFOXYA12_FULL_46_15]	diamond	207	70.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium RIFOXYA12_FULL_46_15
33025763	33025763	PRJEB6584o_S_NODE_19492_length_204_cov_4.769231_g19384_i0	PRJEB6584	19492	204	4.7692310000000004	9.72923124	Pseudomonadati	3379134	Bacteria	Bacteria	46.2	0.00138	NR	WP_027369199.1	873	g19384	i0	69	2.55882352941176	29	9	42.6	0	135	49	11	39	WP_027369199.1 EcoAI/FtnUII family type I restriction enzme subunit R [Desulfocurvibacter africanus]	diamond	522	46.6	0.991416309012876	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
33127999	33127999	PRJEB6584o_S_NODE_44727_length_169_cov_1.783582_g44619_i0	PRJEB6584	44727	169	1.783582	3.01425358	Desulfobacter	2289	Bacteria	Bacteria	47.4	2.19e-4	NR	WDP92862.1	2294	g44619	i0	50	2.00591715976331	56	26	97.6	2	4	168	21	75	WDP92862.1 MAG: PEP-CTERM sorting domain-containing protein [Desulfobacter sp.]	diamond	339	47.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter 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);;