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

7 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
4490366	4490366	PRJNA682078_P_NODE_297024_length_229_cov_2.807692_g295247_i0	PRJNA682078	297024	229	2.807692	6.42961468	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	204	5.33e-48	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g295247	i0	83.262	425.152838427948	233	28	100	11	1	229	2631847	2632072	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	97360	204	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
7039947	7039947	PRJNA682078_P_NODE_253626_length_246_cov_1.763006_g251849_i0	PRJNA682078	253626	246	1.763006	4.33699476	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	95.3	3.64e-15	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g251849	i0	95	1.78861788617886	60	3	24	0	185	244	1923494	1923435	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	440	95.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
8311643	8311643	PRJNA682078_P_NODE_138487_length_305_cov_2.396552_g136710_i0	PRJNA682078	138487	305	2.396552	7.3094836	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	322	1.96e-83	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g136710	i0	86.824	117.744262295082	296	29	97	9	6	295	2058561	2058852	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	35912	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10100091	10100091	PRJNA682078_P_NODE_100448_length_351_cov_1.327338_g98672_i0	PRJNA682078	100448	351	1.327338	4.65895638	Parachlamydia	83551	Bacteria	Bacteria	289	2.32e-73	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g98672	i0	86.397	145.487179487179	272	28	76	9	29	296	1496	1762	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	51066	289	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
14688314	14688314	PRJNA682078_P_NODE_170052_length_281_cov_0.961538_g168275_i0	PRJNA682078	170052	281	0.961538	2.70192178	Candidatus Euplotechlamydia quinta	2936506	Bacteria	Bacteria	399	8.029999999999998e-107	NTclustered	gi\|2226301499\|gb\|ON271409.1\|	2936506	g168275	i0	92.553	96.0284697508897	282	16	99	5	1	279	292	13	Chlamydiia bacterium (ex Euplotes octocarinatus) isolate Zam5b-1 16S ribosomal RNA gene, partial sequence	blastn	26984	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Euplotechlamydia	Candidatus Euplotechlamydia quinta
22337840	22337840	PRJNA682078_P_NODE_218658_length_252_cov_2.268156_g216881_i0	PRJNA682078	218658	252	2.268156	5.71575312	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	449	6.94e-122	NTclustered	gi\|565666443\|emb\|HG726047.1\|	1444712	g216881	i0	98.81	97.2103174603175	252	3	100	0	1	252	403	152	Candidatus Rubidus massiliensis partial 16S rRNA gene, strain Rubis	blastn	24497	449	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
22340902	22340902	PRJNA682078_P_NODE_7998_length_1270_cov_2.502089_g6865_i0	PRJNA682078	7998	1270	2.502089	31.7765303	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1735	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g6865	i0	91.366	173.476377952756	1274	100	100	7	1	1270	653436	654703	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	220315	1735	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);;