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

6 rows where analysis = "blastn", bioproject = "PRJNA1195551" and tax_clade = "PVC group"

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
7421004	7421004	PRJNA1195551_S_NODE_37786_length_167_cov_0.881356_g37433_i0	PRJNA1195551	37786	167	0.881356	1.47186452	Waddlia	71666	Bacteria	Bacteria	113	6.34e-21	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g37433	i0	86.408	171.706586826347	103	14	62	0	65	167	1523	1421	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	28675	113	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
9250483	9250483	PRJNA1195551_S_NODE_26648_length_196_cov_1.523810_g26295_i0	PRJNA1195551	26648	196	1.52381	2.9866676	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	189	1.24e-43	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g26295	i0	93.701	38.1989795918367	127	6	100	2	72	196	2058534	2058660	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	7487	189	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
9250495	9250495	PRJNA1195551_S_NODE_31488_length_181_cov_1.575758_g31135_i0	PRJNA1195551	31488	181	1.575758	2.85212198	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	246	6.57e-61	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g31135	i0	91.667	172.950276243094	180	12	98	3	5	181	7052353	7052174	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	31304	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17620872	17620872	PRJNA1195551_S_NODE_31914_length_180_cov_1.068702_g31561_i0	PRJNA1195551	31914	180	1.068702	1.9236636	Candidatus Protochlamydia	282132	Bacteria	Bacteria	244	2.35e-60	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g31561	i0	91.525	9.92777777777778	177	15	98	0	1	177	1249898	1250074	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	1787	244	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
18894506	18894506	PRJNA1195551_S_NODE_18735_length_230_cov_2.359116_g18382_i0	PRJNA1195551	18735	230	2.359116	5.4259668	Candidatus Protochlamydia	282132	Bacteria	Bacteria	267	6.74e-67	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g18382	i0	88.21	131.265217391304	229	20	98	6	5	230	1251332	1251108	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	30191	267	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
23274767	23274767	PRJNA1195551_S_NODE_1219_length_802_cov_4.159363_g970_i0	PRJNA1195551	1219	802	4.159363	33.35809126	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1142	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g970	i0	92.394	182.493765586035	802	59	100	1	1	802	653856	654655	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	146360	1142	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);;