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

5 rows where bioproject = "PRJNA797655" and tax_phylum = "Gemmatimonadota"

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
784163	784163	PRJNA797655_S_NODE_18321_length_424_cov_2.640420_g17727_i0	PRJNA797655	18321	424	2.64042	11.1953808	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	422	2.6999999999999994e-113	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g17727	i0	86.064	95.3561320754717	409	37	94	16	1	397	3485838	3486238	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	40431	422	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26832438	26832438	PRJNA797655_S_NODE_166661_length_196_cov_1.287582_g166056_i0	PRJNA797655	166661	196	1.287582	2.52366072	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	41.2	0.049	NR	HKV75774.1	2448054	g166056	i0	38.2	0.841836734693878	55	33	84.2	1	31	195	72	125	HKV75774.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	165	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28412021	28412021	PRJNA797655_S_NODE_145226_length_209_cov_2.024096_g144621_i0	PRJNA797655	145226	209	2.024096	4.23036064	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	39.7	0.0429	NR	PYO16808.1	2026742	g144621	i0	45.9	1.0622009569378	37	20	53.1	0	136	26	16	52	PYO16808.1 MAG: hypothetical protein DMD31_01620 [Gemmatimonadota bacterium]	diamond	222	39.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31697396	31697396	PRJNA797655_S_NODE_127397_length_222_cov_1.877095_g126792_i0	PRJNA797655	127397	222	1.877095	4.1671509	Gemmatimonas sp. SM23_52	1703359	Bacteria	Bacteria	42.4	0.038	NR	KPK79791.1	1703359	g126792	i0	50	0.621621621621622	46	23	62.2	0	190	53	194	239	KPK79791.1 MAG: hypothetical protein AMS25_11430 [Gemmatimonas sp. SM23_52]	diamond	138	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SM23_52
32456900	32456900	PRJNA797655_S_NODE_176519_length_190_cov_2.782313_g175914_i0	PRJNA797655	176519	190	2.782313	5.2863947	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	41.2	0.0382	NR	HEX4628716.1	2448054	g175914	i0	34.6	0.821052631578947	52	33	80.5	1	189	37	12	63	HEX4628716.1 cytochrome d ubiquinol oxidase subunit II [Gemmatimonadales bacterium]	diamond	156	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;