metadata: contig_metadata: 3 rows where bioproject = "PRJNA1010780" and tax

3 rows where bioproject = "PRJNA1010780" and tax_phylum = "Rhodothermota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27950730	27950730	PRJNA1010780_S_NODE_60185_length_155_cov_1.258333_g58896_i0	PRJNA1010780	60185	155	1.258333	1.95041615	Rhodothermales bacterium	2306054	Bacteria	Bacteria	43.5	0.00598	NR	MEX1055630.1	2306054	g58896	i0	39.1	0.890322580645161	46	25	83.2	1	154	26	117	162	MEX1055630.1 alpha-amylase family glycosyl hydrolase [Rhodothermales bacterium]	diamond	138	43.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
30848567	30848567	PRJNA1010780_S_NODE_33254_length_241_cov_1.854369_g31965_i0	PRJNA1010780	33254	241	1.854369	4.46902929	Bacteria	2	Bacteria	Bacteria	96.3	3.9900000000000005e-21	NR	MDX1429054.1	2306054	g31965	i0	57	1.96680497925311	79	34	98.3	0	5	241	300	378	MDX1429054.1 sodium:solute symporter [Rhodothermales bacterium]	diamond	474	96.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32532564	32532564	PRJNA1010780_S_NODE_379_length_3055_cov_18.580132_g319_i0	PRJNA1010780	379	3055	18.580132	567.6230326	Rhodothermus marinus	29549	Bacteria	Bacteria	939	0	NR	WP_014067301.1	29549	g319	i0	54.3	9.95842880523732	910	373	88.6	11	2786	81	24	898	WP_014067301.1 acetate--CoA ligase alpha subunit [Rhodothermus marinus]	diamond	30423	939	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus

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