metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA315399" 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
1660485	1660485	PRJNA315399_S_NODE_90342_length_183_cov_4.239726_g90141_i0	PRJNA315399	90342	183	4.239726	7.75869858	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	274	3.06e-69	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g90141	i0	99.338	0.825136612021858	151	1	83	0	33	183	519948	520098	Parachlamydia acanthamoebae UV-7, complete genome	blastn	151	274	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
8034457	8034457	PRJNA315399_P_NODE_109767_length_197_cov_10.593750_g109319_i0	PRJNA315399	109767	197	10.59375	20.8696875	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	244	2.62e-60	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g109319	i0	91.279	23.0812182741117	172	10	87	2	10	181	1332991	1333157	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	4547	244	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
11864270	11864270	PRJNA315399_S_NODE_72610_length_194_cov_3.738854_g72409_i0	PRJNA315399	72610	194	3.738854	7.25337676	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	351	1.47e-92	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g72409	i0	100	0.979381443298969	190	0	98	0	5	194	3025778	3025589	Parachlamydia acanthamoebae UV-7, complete genome	blastn	190	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
15685297	15685297	PRJNA315399_P_NODE_340573_length_172_cov_3.496296_g340125_i0	PRJNA315399	340573	172	3.496296	6.01362912	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	278	2.19e-70	NTclustered	gi\|219857449\|ref\|NR_025037.1\|	112235	g340125	i0	95.48	104.546511627907	177	2	99	4	2	172	478	654	Neochlamydia hartmannellae strain A1Hsp 16S ribosomal RNA, partial sequence	blastn	17982	278	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
19508221	19508221	PRJNA315399_P_NODE_272536_length_180_cov_4.377622_g272088_i0	PRJNA315399	272536	180	4.377622	7.8797196	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	67.6	5.45e-7	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g272088	i0	84.848	0.366666666666667	66	10	37	0	110	175	204426	204361	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	66	67.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
25291929	25291929	PRJNA315399_P_NODE_281760_length_179_cov_15.619718_g281312_i0	PRJNA315399	281760	179	15.619718	27.95929522	root	1	Root_unresolved	Root_unresolved	76.8	9e-10	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g281312	i0	97.727	3.40782122905028	44	1	25	0	106	149	456248	456291	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	610	76.8	1	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);;