metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax_phylum = "Chlamydiota"

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
1597986	1597986	PRJNA1196438_P_NODE_60662_length_257_cov_2.239130_g60235_i0	PRJNA1196438	60662	257	2.23913	5.7545641	Candidatus Piscichlamydia sp.	1977145	Bacteria	Bacteria	436	5.52e-118	NTclustered	gi\|1175896721\|gb\|KY380088.1\|	1977145	g60235	i0	98.776	95.8287937743191	245	3	95	0	13	257	403	647	Candidatus Piscichlamydia sp. strain EP 16S ribosomal RNA gene, partial sequence	blastn	24628	436	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia sp.
3593878	3593878	PRJNA1196438_P_NODE_67983_length_249_cov_1.750000_g67556_i0	PRJNA1196438	67983	249	1.75	4.3575	PVC group	1783257	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|337292513\|emb\|FR872621.1\|	765953	g67556	i0	100	60.9718875502008	249	0	100	0	1	249	1456	1208	Waddlia chondrophila 2032/99 annotated genome fragment, clone 1103163150273	blastn	15182	460	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
12522067	12522067	PRJNA1196438_P_NODE_59490_length_259_cov_1.672043_g59063_i0	PRJNA1196438	59490	259	1.672043	4.33059137	Neochlamydia	112987	Bacteria	Bacteria	289	1.65e-73	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g59063	i0	86.923	186.393822393822	260	30	99	4	2	259	1439	1182	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	48276	291	0.993127147766323	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
18174472	18174472	PRJNA1196438_P_NODE_10635_length_326_cov_2.339921_g10209_i0	PRJNA1196438	10635	326	2.339921	7.62814246	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	318	2.74e-82	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g10209	i0	84.848	119.546012269939	330	34	99	14	1	325	653427	653745	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	38972	318	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae 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);;