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

5 rows where bioproject = "PRJNA741997" and tax_phylum = "Nanobdellota"

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
16023979	16023979	PRJNA741997_P_NODE_32853_length_380_cov_1.254072_g31733_i0	PRJNA741997	32853	380	1.254072	4.7654736	Nanobdellota archaeon	2026764	Archaea	Archaea	177	5.18e-49	NR	MCA9485224.1	2026764	g31733	i0	66.1	0.978947368421053	124	42	97.9	0	2	373	271	394	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	372	177	1	Archaea	Nanobdellati	Nanobdellota					Nanobdellota archaeon
28757826	28757826	PRJNA741997_P_NODE_76727_length_248_cov_1.754286_g75607_i0	PRJNA741997	76727	248	1.754286	4.35062928	Nanobdellota archaeon	2026764	Archaea	Archaea	69.7	2.2e-13	NR	MFH2028798.1	2026764	g75607	i0	46.3	0.810483870967742	67	34	78.6	2	53	247	13	79	MFH2028798.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	201	69.7	1	Archaea	Nanobdellati	Nanobdellota					Nanobdellota archaeon
28884076	28884076	PRJNA741997_P_NODE_25408_length_442_cov_1.246612_g24288_i0	PRJNA741997	25408	442	1.246612	5.51002504	Nanobdellota archaeon	2026764	Archaea	Archaea	123	1.04e-30	NR	MFH1073018.1	2026764	g24288	i0	42.9	3.9027149321267	133	75	89.6	1	47	442	57	189	MFH1073018.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	1725	123	1	Archaea	Nanobdellati	Nanobdellota					Nanobdellota archaeon
31854054	31854054	PRJNA741997_P_NODE_18457_length_540_cov_3.325482_g17344_i0	PRJNA741997	18457	540	3.325482	17.9576028	Nanobdellota archaeon	2026764	Archaea	Archaea	53.1	1.48e-4	NR	MEA2037543.1	2026764	g17344	i0	28.3	0.627777777777778	113	78	61.1	1	423	94	59	171	MEA2037543.1 phage tail tip lysozyme [Nanoarchaeota archaeon]	diamond	339	53.1	1	Archaea	Nanobdellati	Nanobdellota					Nanobdellota archaeon
32392098	32392098	PRJNA741997_P_NODE_43639_length_329_cov_0.847656_g42519_i0	PRJNA741997	43639	329	0.847656	2.78878824	Nanoarchaeum equitans Kin4-M	228908	Archaea	Archaea	62.8	1.05e-9	NR	AAR39227.1	228908	g42519	i0	47.6	0.574468085106383	63	33	57.4	0	319	131	5	67	AAR39227.1 NEQ379 [Nanoarchaeum equitans Kin4-M]	diamond	189	62.8	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Nanoarchaeales	Nanoarchaeaceae	Nanoarchaeum	Nanoarchaeum equitans

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