metadata: contig_metadata: 5 rows where bioproject = "PRJNA753112", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA753112", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

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_species
26873217	26873217	PRJNA753112_P_NODE_21201_length_295_cov_1.405405_g20859_i0	PRJNA753112	21201	295	1.405405	4.14594475	Bacteria	2	Bacteria	Bacteria	105	1.49e-24	NR	MDA0233251.1	2026724	g20859	i0	60.5	2.48135593220339	81	31	81.4	1	48	287	1	81	MDA0233251.1 ISL3 family transposase [Chloroflexota bacterium]	diamond	732	105	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
29620126	29620126	PRJNA753112_P_NODE_15470_length_345_cov_1.812500_g15128_i0	PRJNA753112	15470	345	1.8125	6.253125	Bacteria	2	Bacteria	Bacteria	55.5	3.27e-6	NR	MCH7738147.1	2026724	g15128	i0	38	2.74782608695652	79	45	65.2	2	226	2	6	84	MCH7738147.1 ImmA/IrrE family metallo-endopeptidase [Chloroflexota bacterium]	diamond	948	55.5	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
30179148	30179148	PRJNA753112_P_NODE_31632_length_246_cov_1.560694_g31290_i0	PRJNA753112	31632	246	1.560694	3.83930724	Anaerolineae bacterium	2052143	Bacteria	Bacteria	43.9	0.00769	NR	MCL4250160.1	2052143	g31290	i0	65.5	0.719512195121951	29	10	35.4	0	242	156	129	157	MCL4250160.1 aspartate ammonia-lyase [Anaerolineae bacterium]	diamond	177	43.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium
30337707	30337707	PRJNA753112_P_NODE_27152_length_261_cov_1.404255_g26810_i0	PRJNA753112	27152	261	1.404255	3.66510555	Anaerolineae bacterium	2052143	Bacteria	Bacteria	46.2	0.00274	NR	MBN1178039.1	2052143	g26810	i0	43.5	0.528735632183908	46	26	52.9	0	61	198	336	381	MBN1178039.1 glycosyltransferase family 2 protein [Anaerolineae bacterium]	diamond	138	46.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineae bacterium
32592124	32592124	PRJNA753112_P_NODE_21839_length_291_cov_1.275229_g21497_i0	PRJNA753112	21839	291	1.275229	3.71091639	FCB group	1783270	Bacteria	Bacteria	157	5.03e-46	NR	HZO25256.1	2026724	g21497	i0	69.8	21.7525773195876	96	29	99	0	3	290	3	98	HZO25256.1 inorganic pyrophosphatase [Chloroflexota bacterium]	diamond	6330	158	0.993670886075949	Bacteria	Bacillati	Chloroflexota		Chloroflexota 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);;