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

7 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
3298180	3298180	PRJNA770826_P_NODE_7983_length_289_cov_0.908333_g7812_i0	PRJNA770826	7983	289	0.908333	2.62508237	Candidatus Syngnamydia salmonis	504270	Bacteria	Bacteria	342	1.4199999999999997e-89	NTclustered	gi\|1214145827\|gb\|KY427067.1\|	504270	g7812	i0	92.857	251.429065743945	238	13	82	4	1	236	3721	3486	Candidatus Syngnamydia salmonis isolate H03/14Pp 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer 23S ribosomal RNA and 5S ribosomal RNA genes, complete sequence	blastn	72663	342	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia salmonis
4575177	4575177	PRJNA770826_P_NODE_2784_length_521_cov_1.932203_g2615_i0	PRJNA770826	2784	521	1.932203	10.06677763	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	706	0	NTclustered	gi\|18029193\|gb\|AF364564.1\|	174324	g2615	i0	94.348	106.781190019194	460	26	88	0	62	521	173	632	Uncultured Chlamydiales bacterium clone P-4 16S ribosomal RNA gene, partial sequence	blastn	55633	706	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
16049589	16049589	PRJNA770826_P_NODE_7353_length_304_cov_1.560784_g7182_i0	PRJNA770826	7353	304	1.560784	4.74478336	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	337	6.98e-88	NTclustered	gi\|2041291174\|gb\|CP073762.1\|	2698248	g7182	i0	87.713	149.220394736842	293	30	96	6	14	304	517318	517606	MAG: Simkaniaceae bacterium isolate M30B2 chromosome, complete genome	blastn	45363	337	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
16509638	16509638	PRJNA770826_P_NODE_41533_length_162_cov_1.380531_g41362_i0	PRJNA770826	41533	162	1.380531	2.23646022	Candidatus Protochlamydia	282132	Bacteria	Bacteria	267	4.419999999999999e-67	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g41362	i0	96.296	155.37037037037	162	6	100	0	1	162	1248920	1248759	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	25170	267	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
20333158	20333158	PRJNA770826_P_NODE_7336_length_304_cov_2.141176_g7165_i0	PRJNA770826	7336	304	2.141176	6.50917504	Candidatus Protochlamydia	282132	Bacteria	Bacteria	518	2.32e-142	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g7165	i0	97.987	162.582236842105	298	6	98	0	7	304	1249349	1249052	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	49425	518	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
24158344	24158344	PRJNA770826_P_NODE_12739_length_225_cov_1.869318_g12568_i0	PRJNA770826	12739	225	1.869318	4.2059655	Parachlamydia	83551	Bacteria	Bacteria	355	1.36e-93	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g12568	i0	95.133	149.56	226	9	100	2	1	225	953	1177	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	33651	355	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
24973586	24973586	PRJNA770826_P_NODE_5520_length_360_cov_1.633441_g5349_i0	PRJNA770826	5520	360	1.633441	5.8803876	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	455	2.23e-123	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g5349	i0	89.694	167.45	359	33	99	3	2	358	654194	653838	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	60282	455	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);;