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

4 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
7221419	7221419	PRJNA857143_S_NODE_145226_length_270_cov_1.979695_g144133_i0	PRJNA857143	145226	270	1.979695	5.3451765	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	327	3.67e-85	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g144133	i0	90.947	20.9703703703704	243	22	90	0	23	265	173361	173603	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	5662	327	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
9771912	9771912	PRJNA857143_S_NODE_21048_length_522_cov_2.485523_g19966_i0	PRJNA857143	21048	522	2.485523	12.97443006	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	695	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g19966	i0	91.984	150.463601532567	499	34	95	6	27	522	2058829	2059324	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	78542	695	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17422657	17422657	PRJNA857143_S_NODE_88234_length_327_cov_3.271654_g87141_i0	PRJNA857143	88234	327	3.271654	10.69830858	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	130	1.38e-25	NTclustered	gi\|559134048\|tpe\|HG788966.1\|	264201	g87141	i0	76.984	3.0519877675841	252	43	74	14	1	243	389	144	TPA: Candidatus Protochlamydia amoebophila UWE25 transfer-messenger mRNA Proto_amoeb_UWE25, single chain mature transcript	blastn	998	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
20361686	20361686	PRJNA857143_S_NODE_73416_length_349_cov_1.405797_g72323_i0	PRJNA857143	73416	349	1.405797	4.90623153	Candidatus Protochlamydia	282132	Bacteria	Bacteria	551	2.669999999999999e-152	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g72323	i0	95.143	169.676217765043	350	15	100	2	1	349	1249939	1249591	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	59217	556	0.991007194244604	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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