metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA906294" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA906294" 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_species
26802685	26802685	PRJNA906294_P_NODE_191221_length_264_cov_1.340314_g187105_i0	PRJNA906294	191221	264	1.340314	3.53842896	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	43.1	0.035	NR	HHL34124.1	2053307	g187105	i0	35.7	0.636363636363636	56	36	63.6	0	18	185	545	600	HHL34124.1 response regulator [Desulfobulbaceae bacterium]	diamond	168	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbaceae bacterium
26866358	26866358	PRJNA906294_P_NODE_163841_length_293_cov_2.236364_g159725_i0	PRJNA906294	163841	293	2.236364	6.55254652	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	78.2	7.37e-16	NR	MDX1707214.1	2044940	g159725	i0	50	4.3617747440273	82	39	84	2	249	4	42	121	MDX1707214.1 Hsp20/alpha crystallin family protein [Desulfobacterales bacterium]	diamond	1278	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales		Desulfobacterales bacterium
28161541	28161541	PRJNA906294_P_NODE_121805_length_359_cov_4.230769_g117689_i0	PRJNA906294	121805	359	4.230769	15.18846071	Smithellaceae bacterium	2964540	Bacteria	Bacteria	58.2	4.83e-7	NR	HPD56940.1	2964540	g117689	i0	41	1.38718662952646	83	36	69.4	3	250	2	239	308	HPD56940.1 RHS repeat-associated core domain-containing protein [Smithellaceae bacterium]	diamond	498	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithellaceae bacterium
28168906	28168906	PRJNA906294_P_NODE_51805_length_686_cov_2.381729_g47811_i0	PRJNA906294	51805	686	2.381729	16.33866094	Pseudomonadati	3379134	Bacteria	Bacteria	205	5.4e-63	NR	HEY9161896.1	3041274	g47811	i0	60.5	5.37026239067055	172	68	75.2	0	666	151	30	201	HEY9161896.1 NAD(P)H:quinone oxidoreductase [Desulfomonilia bacterium]	diamond	3684	207	0.990338164251208	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia			Desulfomonilia bacterium
28508767	28508767	PRJNA906294_P_NODE_50867_length_695_cov_4.654341_g46888_i0	PRJNA906294	50867	695	4.654341	32.34766995	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	149	2.49e-40	NR	MCP4692921.1	2044940	g46888	i0	39.5	4.5021582733813	223	125	93.2	4	674	27	30	249	MCP4692921.1 DUF4197 domain-containing protein [Desulfobacterales bacterium]	diamond	3129	149	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales		Desulfobacterales bacterium
31762624	31762624	PRJNA906294_P_NODE_120457_length_362_cov_1.937716_g116342_i0	PRJNA906294	120457	362	1.937716	7.01453192	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	43.9	0.0483	NR	HMK65614.1	2202153	g116342	i0	35.4	0.538674033149171	65	42	53.9	0	35	229	46	110	HMK65614.1 CoA-transferase [Thermodesulfobacteriota bacterium]	diamond	195	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
32371530	32371530	PRJNA906294_P_NODE_210779_length_248_cov_0.868571_g206663_i0	PRJNA906294	210779	248	0.868571	2.15405608	Desulfobacteria	3024418	Bacteria	Bacteria	119	3e-29	NR	MDH3567976.1	2049433	g206663	i0	68.9	17.1895161290323	74	23	89.5	0	227	6	381	454	MDH3567976.1 acyl-CoA synthetase [Desulfobacteraceae bacterium]	diamond	4263	120	0.991666666666667	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacteraceae bacterium

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