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

6 rows where analysis = "diamond", bioproject = "PRJNA763243" 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
13497750	13497750	PRJNA763243_P_NODE_70491_length_218_cov_4.068966_g70145_i0	PRJNA763243	70491	218	4.068966	8.87034588	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	97.4	4.68e-24	NR	GJM17744.1	2202153	g70145	i0	69.7	0.908256880733945	66	20	90.8	0	214	17	62	127	GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium]	diamond	198	97.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
19870390	19870390	PRJNA763243_P_NODE_51836_length_251_cov_0.865169_g51490_i0	PRJNA763243	51836	251	0.865169	2.17157419	Candidatus Mailhella excrementigallinarum	2838656	Bacteria	Bacteria	79.7	3.88e-15	NR	HIV65968.1	2838656	g51490	i0	68.4	7.41035856573705	57	18	68.1	0	248	78	116	172	HIV65968.1 FAD-binding protein [Candidatus Mailhella excrementigallinarum]	diamond	1860	79.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	Candidatus Mailhella excrementigallinarum
24970121	24970121	PRJNA763243_P_NODE_49520_length_255_cov_2.318681_g49174_i0	PRJNA763243	49520	255	2.318681	5.91263655	Desulfovibrio sp. OttesenSCG-928-M16	2885171	Bacteria	Bacteria	152	2.34e-42	NR	MDL2207175.1	2885171	g49174	i0	94	0.988235294117647	84	5	98.8	0	252	1	349	432	MDL2207175.1 glycine reductase complex selenoprotein B [Desulfovibrio sp. OttesenSCG-928-M16]	diamond	252	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. OttesenSCG-928-M16
27874424	27874424	PRJNA763243_P_NODE_59225_length_244_cov_4.391813_g58879_i0	PRJNA763243	59225	244	4.391813	10.71602372	Desulfobacteraceae bacterium 4572_187	1971620	Bacteria	Bacteria	119	3.21e-29	NR	OQY09318.1	1971620	g58879	i0	70.5	1.93032786885246	78	23	95.9	0	4	237	898	975	OQY09318.1 MAG: histidine kinase [Desulfobacteraceae bacterium 4572_187]	diamond	471	119	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium 4572_187
28758453	28758453	PRJNA763243_P_NODE_2787_length_803_cov_10.583562_g2522_i0	PRJNA763243	2787	803	10.583562	84.98600286	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	60.8	5.89e-7	NR	PID74746.1	2044940	g2522	i0	47.7	1.18804483188045	65	33	24.3	1	9	203	156	219	PID74746.1 MAG: hypothetical protein CSB28_01595 [Desulfobacterales bacterium]	diamond	954	60.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
28957818	28957818	PRJNA763243_P_NODE_10488_length_465_cov_1.719388_g10145_i0	PRJNA763243	10488	465	1.719388	7.9951542	Pseudomonadati	3379134	Bacteria	Bacteria	177	4.6399999999999994e-48	NR	OQY09318.1	1971620	g10145	i0	56.1	2.9741935483871	157	66	99.4	1	462	1	740	896	OQY09318.1 MAG: histidine kinase [Desulfobacteraceae bacterium 4572_187]	diamond	1383	177	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium 4572_187

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