metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB66218" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
994102	994102	PRJEB66218_P_NODE_116541_length_279_cov_5.110092_g114112_i0	PRJEB66218	116541	279	5.110092	14.25715668	Parachlamydiales	1963360	Bacteria	Bacteria	433	7.85e-117	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g114112	i0	95.238	131.885304659498	273	13	98	0	1	273	1018269	1017997	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	36796	433	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
3544837	3544837	PRJEB66218_P_NODE_157783_length_236_cov_1.114286_g155353_i0	PRJEB66218	157783	236	1.114286	2.62971496	Candidatus Protochlamydia	282132	Bacteria	Bacteria	364	2.39e-96	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g155353	i0	94.492	125.313559322034	236	13	100	0	1	236	1250039	1249804	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	29574	364	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
7783446	7783446	PRJEB66218_P_NODE_135627_length_255_cov_3.252577_g133198_i0	PRJEB66218	135627	255	3.252577	8.29407135	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	222	1.67e-53	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g133198	i0	82.625	166.501960784314	259	38	100	7	1	255	2060004	2060259	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	42458	222	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
12472939	12472939	PRJEB66218_P_NODE_104310_length_299_cov_1.088235_g101881_i0	PRJEB66218	104310	299	1.088235	3.25382265	Candidatus Protochlamydia	282132	Bacteria	Bacteria	457	5.039999999999999e-124	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g101881	i0	94.295	171.531772575251	298	17	99	0	2	299	1250355	1250652	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	51288	457	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
15022230	15022230	PRJEB66218_P_NODE_163392_length_232_cov_1.140351_g160962_i0	PRJEB66218	163392	232	1.140351	2.64561432	Pseudomonadati	3379134	Bacteria	Bacteria	340	3.95e-89	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g160962	i0	93.162	164.396551724138	234	13	100	3	1	232	174167	173935	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	38140	342	0.994152046783626	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
20531645	20531645	PRJEB66218_P_NODE_118417_length_277_cov_1.356481_g115988_i0	PRJEB66218	118417	277	1.356481	3.75745237	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	396	1.02e-105	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g115988	i0	92.419	163.176895306859	277	21	100	0	1	277	175494	175770	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	45200	396	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
20533469	20533469	PRJEB66218_P_NODE_221957_length_206_cov_0.896552_g219527_i0	PRJEB66218	221957	206	0.896552	1.84689712	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	246	7.7e-61	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g219527	i0	88.945	7.79126213592233	199	22	97	0	8	206	2060015	2060213	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	1605	246	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);;