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

7 rows where analysis = "blastn", bioproject = "PRJNA400391" 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
6791873	6791873	PRJNA400391_S_NODE_6_length_1384_cov_5.016308_g3_i0	PRJNA400391	6	1384	5.016308	69.42570272	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1639	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3	i0	88.176	115.013728323699	1387	149	100	15	1	1381	653507	654884	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	159179	1639	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7458993	7458993	PRJNA400391_S_NODE_4866_length_180_cov_47.717241_g4805_i0	PRJNA400391	4866	180	47.717241	85.8910338	Chlamydiia	204429	Bacteria	Bacteria	291	2.9699999999999998e-74	NTclustered	gi\|310755813\|gb\|HQ213703.1\|	174324	g4805	i0	96.571	119.638888888889	175	6	97	0	1	175	319	493	Uncultured Chlamydiales bacterium clone 4_M13 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21535	291	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
10009073	10009073	PRJNA400391_S_NODE_1248_length_332_cov_26.343434_g1187_i0	PRJNA400391	1248	332	26.343434	87.46020088	Parachlamydia	83551	Bacteria	Bacteria	425	1.5999999999999999e-114	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g1187	i0	89.851	208.825301204819	335	29	100	5	1	332	1666	1998	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	69330	425	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
12559709	12559709	PRJNA400391_S_NODE_250_length_553_cov_5.378378_g3_i1	PRJNA400391	250	553	5.378378	29.74243034	Candidatus Syngnamydia	1803801	Bacteria	Bacteria	590	9.329999999999999e-164	NTclustered	gi\|124021662\|gb\|EF177461.1\|	420390	g3	i1	86.556	132.244122965642	543	63	97	9	15	553	2942	2406	Chlamydiales symbiont of Xenoturbella westbladi 16S ribosomal RNA gene, partial sequence; 23S ribosomal RNA gene, complete sequence; and putative homing endonuclease gene, complete cds	blastn	73131	590	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Chlamydiales symbiont of Xenoturbella westbladi
16383420	16383420	PRJNA400391_S_NODE_2373_length_259_cov_6.316964_g2312_i0	PRJNA400391	2373	259	6.316964	16.36093676	Waddlia	71666	Bacteria	Bacteria	233	7.85e-57	NTclustered	gi\|297375547\|gb\|CP001928.1\|	716544	g2312	i0	84.774	113.903474903475	243	25	93	9	2	241	1333878	1334111	Waddlia chondrophila WSU 86-1044, complete genome	blastn	29501	233	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
20815713	20815713	PRJNA400391_S_NODE_317_length_516_cov_4.272349_g263_i0	PRJNA400391	317	516	4.272349	22.04532084	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	593	6.699999999999998e-165	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g263	i0	87.356	159.744186046512	522	60	100	6	1	516	654879	655400	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	82428	593	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
24640523	24640523	PRJNA400391_S_NODE_940_length_363_cov_353.868902_g879_i0	PRJNA400391	940	363	353.868902	1284.54411426	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	468	2.88e-127	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g879	i0	90.305	178.570247933884	361	30	99	5	6	363	652467	652825	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	64821	468	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);;