metadata: contig_metadata: 5 rows where bioproject = "PRJNA793147", tax_phylum = "Myxococcota" and tax

5 rows where bioproject = "PRJNA793147", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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
5881629	5881629	PRJNA793147_P_NODE_53985_length_232_cov_2.159509_g53719_i0	PRJNA793147	53985	232	2.159509	5.01006088	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	159	1.87e-43	NR	MBL8921631.1	2484252	g53719	i0	98.7	3.98275862068966	77	1	99.6	0	1	231	453	529	MBL8921631.1 fatty acid oxidation complex subunit alpha FadJ [Myxococcaceae bacterium]	diamond	924	159	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcaceae bacterium
27591100	27591100	PRJNA793147_P_NODE_20164_length_371_cov_13.397351_g19898_i0	PRJNA793147	20164	371	13.397351	49.70417221	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	60.5	1.53e-8	NR	MBI2391685.1	2026735	g19898	i0	36.2	3.64690026954178	105	56	80.1	4	74	370	56	155	MBI2391685.1 C-type lectin domain-containing protein [Deltaproteobacteria bacterium]	diamond	1353	60.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
27622634	27622634	PRJNA793147_P_NODE_28724_length_311_cov_1.785124_g28458_i0	PRJNA793147	28724	311	1.785124	5.55173564	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	75.5	3.23e-14	NR	NOQ86034.1	2026735	g28458	i0	45.7	5.57556270096463	92	47	87.8	3	275	3	89	178	NOQ86034.1 serpin family protein [Deltaproteobacteria bacterium]	diamond	1734	75.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
30022355	30022355	PRJNA793147_P_NODE_31911_length_296_cov_1.903084_g31645_i0	PRJNA793147	31911	296	1.903084	5.63312864	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	44.3	0.0159	NR	MBM4275160.1	2026735	g31645	i0	27.3	0.780405405405405	77	56	78	0	284	54	106	182	MBM4275160.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	231	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
30590844	30590844	PRJNA793147_P_NODE_9673_length_560_cov_3.446029_g9411_i0	PRJNA793147	9673	560	3.446029	19.2977624	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	57.4	5.78e-6	NR	MBI3782678.1	2026735	g9411	i0	36.2	0.621428571428571	116	66	59.5	2	472	140	115	227	MBI3782678.1 trypsin-like serine protease [Deltaproteobacteria bacterium]	diamond	348	57.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria 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);;