metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA630877" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA630877" 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
28091500	28091500	PRJNA630877_S_NODE_134445_length_172_cov_3.358779_g115308_i0	PRJNA630877	134445	172	3.358779	5.77709988	Desulfovibrio sp.	885	Bacteria	Bacteria	45.8	0.0012	NR	MBD5608042.1	885	g115308	i0	48	0.872093023255814	50	22	82	2	148	8	62	110	MBD5608042.1 formate dehydrogenase-N subunit alpha [Desulfovibrio sp.]	diamond	150	45.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
28660020	28660020	PRJNA630877_S_NODE_116447_length_195_cov_1.941558_g97310_i0	PRJNA630877	116447	195	1.941558	3.7860381	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	43.1	0.0141	NR	HXI10796.1	2202153	g97310	i0	36.2	0.892307692307692	58	31	80	1	35	190	332	389	HXI10796.1 cytochrome b N-terminal domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	174	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31249865	31249865	PRJNA630877_S_NODE_98315_length_231_cov_2.310526_g79178_i0	PRJNA630877	98315	231	2.310526	5.33731506	Desulfobulbus sp.	895	Bacteria	Bacteria	42.4	0.041	NR	MCL2790296.1	895	g79178	i0	34.9	0.818181818181818	63	35	74	1	33	203	155	217	MCL2790296.1 phosphate/phosphite/phosphonate ABC transporter substrate-binding protein [Desulfobulbus sp.]	diamond	189	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus sp.
32009134	32009134	PRJNA630877_S_NODE_66638_length_377_cov_2.824405_g47502_i0	PRJNA630877	66638	377	2.824405	10.64800685	Desulfosediminicola flagellatus	2569541	Bacteria	Bacteria	46.2	0.0099	NR	WP_136810788.1	2569541	g47502	i0	51.2	0.326259946949602	41	20	32.6	0	276	154	622	662	WP_136810788.1 trypsin-like peptidase domain-containing protein [Desulfosediminicola flagellatus]	diamond	123	46.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfosediminicola	Desulfosediminicola flagellatus
32483838	32483838	PRJNA630877_S_NODE_81059_length_290_cov_1.204819_g61922_i0	PRJNA630877	81059	290	1.204819	3.4939751	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	43.5	0.0342	NR	MCP4744962.1	2049433	g61922	i0	44.1	0.610344827586207	59	31	60	2	45	218	279	336	MCP4744962.1 tetratricopeptide repeat protein [Desulfobacteraceae bacterium]	diamond	177	43.5	1	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);;