metadata: contig_metadata: 5 rows where bioproject = "PRJNA1180292" and tax

5 rows where bioproject = "PRJNA1180292" and tax_phylum = "Kiritimatiellota"

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
27514603	27514603	PRJNA1180292_P_NODE_11563_length_245_cov_0.906977_g11431_i0	PRJNA1180292	11563	245	0.906977	2.22209365	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	125	2.8799999999999997e-32	NR	MFA7160054.1	2212473	g11431	i0	77.8	0.881632653061225	72	16	88.2	0	218	3	4	75	MFA7160054.1 sialidase family protein [Kiritimatiellia bacterium]	diamond	216	125	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
28462012	28462012	PRJNA1180292_P_NODE_9986_length_249_cov_0.886364_g9854_i0	PRJNA1180292	9986	249	0.886364	2.20704636	Pontiellaceae bacterium	2813032	Bacteria	Bacteria	47.4	5.02e-4	NR	MCU0858839.1	2813032	g9854	i0	54.2	0.578313253012048	48	22	57.8	0	144	1	1	48	MCU0858839.1 GNAT family N-acetyltransferase [Pontiellaceae bacterium]	diamond	144	47.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Pontiellaceae		Pontiellaceae bacterium
28745943	28745943	PRJNA1180292_P_NODE_11007_length_246_cov_0.901734_g10875_i0	PRJNA1180292	11007	246	0.901734	2.21826564	Tichowtungia sp.	2907189	Bacteria	Bacteria	129	1.04e-32	NR	HKL20702.1	2907189	g10875	i0	72.2	1.9390243902439	79	22	96.3	0	237	1	371	449	HKL20702.1 FAD-dependent oxidoreductase [Tichowtungia sp.]	diamond	477	129	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia sp.
31557797	31557797	PRJNA1180292_P_NODE_10416_length_248_cov_0.891429_g10284_i0	PRJNA1180292	10416	248	0.891429	2.21074392	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	105	3.17e-24	NR	HRT30783.1	2212473	g10284	i0	58.5	1.98387096774194	82	31	99.2	1	246	1	425	503	HRT30783.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	492	105	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32317164	32317164	PRJNA1180292_P_NODE_12019_length_244_cov_0.912281_g11887_i0	PRJNA1180292	12019	244	0.912281	2.22596564	Kiritimatiellota bacterium	2599938	Bacteria	Bacteria	51.6	2.71e-5	NR	MCX7007217.1	2599938	g11887	i0	65	0.491803278688525	40	14	49.2	0	244	125	316	355	MCX7007217.1 sulfatase-like hydrolase/transferase [Kiritimatiellota bacterium]	diamond	120	51.6	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota 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);;