metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA975724" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA975724" 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
2542439	2542439	PRJNA975724_S_NODE_18222_length_395_cov_2.062112_g18041_i0	PRJNA975724	18222	395	2.062112	8.1453424	Candidatus Protochlamydia	282132	Bacteria	Bacteria	604	2.309999999999999e-168	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g18041	i0	95.276	186.643037974684	381	18	96	0	15	395	1249125	1249505	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	73724	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
3497271	3497271	PRJNA975724_S_NODE_60783_length_277_cov_2.132353_g60602_i0	PRJNA975724	60783	277	2.132353	5.90661781	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	4.6499999999999983e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g60602	i0	95.341	155.447653429603	279	9	100	3	1	277	654468	654192	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	43059	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7323845	7323845	PRJNA975724_S_NODE_31806_length_342_cov_2.003717_g31625_i0	PRJNA975724	31806	342	2.003717	6.85271214	Estrella lausannensis	483423	Bacteria	Bacteria	302	2.91e-77	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g31625	i0	82.659	169.72514619883	346	54	100	6	1	342	1574	1231	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	58046	302	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
12425695	12425695	PRJNA975724_S_NODE_55050_length_287_cov_42.383178_g54869_i0	PRJNA975724	55050	287	42.383178	121.63972086	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	351	2.34e-92	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g54869	i0	90.84	43.0174216027875	262	24	91	0	1	262	173622	173361	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	12346	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
14974537	14974537	PRJNA975724_S_NODE_6072_length_501_cov_1.619159_g5893_i0	PRJNA975724	6072	501	1.619159	8.11198659	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	604	2.9999999999999985e-168	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g5893	i0	89.979	270.916167664671	469	45	93	2	1	468	2363973	2364440	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	135729	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
16569312	16569312	PRJNA975724_S_NODE_53573_length_290_cov_2.129032_g53392_i0	PRJNA975724	53573	290	2.129032	6.1741928	Parachlamydiales	1963360	Bacteria	Bacteria	331	3.0800000000000006e-86	NTclustered	gi\|5042360\|gb\|U68460.2\|SSU68460	83561	g53392	i0	87.543	108.931034482759	289	32	99	4	3	289	3414	3700	Simkania negevensis 16S and 23S ribosomal RNA operon, complete sequence; and putative endonuclease homodimer gene, complete cds	blastn	31590	333	0.993993993993994	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
17523797	17523797	PRJNA975724_S_NODE_27234_length_357_cov_2.982394_g27053_i0	PRJNA975724	27234	357	2.982394	10.64714658	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	499	1e-136	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g27053	i0	91.899	178.086834733894	358	27	100	2	1	357	2362895	2363251	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	63577	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
17524284	17524284	PRJNA975724_S_NODE_46154_length_305_cov_2.280172_g45973_i0	PRJNA975724	46154	305	2.280172	6.9545246	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	322	1.96e-83	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g45973	i0	87.544	66.0360655737705	281	32	91	3	15	293	1250339	1250618	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	20141	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
18797768	18797768	PRJNA975724_S_NODE_33195_length_338_cov_1.520755_g33014_i0	PRJNA975724	33195	338	1.520755	5.1401519	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	135	3.0800000000000004e-27	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g33014	i0	76.744	2.45562130177515	301	35	86	24	26	315	112016	111740	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	830	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
20073121	20073121	PRJNA975724_S_NODE_53916_length_290_cov_1.018433_g53735_i0	PRJNA975724	53916	290	1.018433	2.9534557	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	329	1.1099999999999998e-85	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g53735	i0	87.119	113.451724137931	295	32	100	5	1	290	654929	655222	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32901	329	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21669159	21669159	PRJNA975724_S_NODE_67577_length_266_cov_1.860104_g67396_i0	PRJNA975724	67577	266	1.860104	4.94787664	Chlamydiia	204429	Bacteria	Bacteria	407	4.509999999999999e-109	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g67396	i0	94.361	114.53007518797	266	14	100	1	1	266	2363602	2363866	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	30465	407	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
23898769	23898769	PRJNA975724_S_NODE_47159_length_303_cov_1.673913_g46978_i0	PRJNA975724	47159	303	1.673913	5.07195639	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	272	1.99e-68	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g46978	i0	84.397	663.425742574257	282	38	92	6	20	297	2364438	2364159	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	201018	272	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales 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);;