metadata: contig_metadata: 16 rows where bioproject = "PRJNA407368" and tax

16 rows where bioproject = "PRJNA407368" 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
1689845	1689845	PRJNA407368_S_NODE_1222_length_569_cov_11.087037_g1139_i0	PRJNA407368	1222	569	11.087037	63.08524053	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	431	6.169999999999998e-116	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g1139	i0	80.796	142.483304042179	578	87	99	24	1	565	2623723	2624289	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	81073	431	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
4242290	4242290	PRJNA407368_S_NODE_9324_length_164_cov_2.392593_g9222_i0	PRJNA407368	9324	164	2.392593	3.92385252	Chlamydia serpentis	1967782	Bacteria	Bacteria	198	1.66e-46	NTclustered	gi\|1376449303\|emb\|LT993738.1\|	1967782	g9222	i0	91.156	116.548780487805	147	11	89	2	19	164	976335	976190	Chlamydia sp. H15-1957-10C genome assembly, chromosome: I	blastn	19114	198	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia serpentis
4909656	4909656	PRJNA407368_S_NODE_10484_length_151_cov_14.819672_g10382_i0	PRJNA407368	10484	151	14.819672	22.37770472	Parachlamydia	83551	Bacteria	Bacteria	220	3.19e-53	NTclustered	gi\|1491674\|emb\|Y07555.1\|	83552	g10382	i0	95.652	112.397350993377	138	5	91	1	14	151	1277	1141	Parachlamydia acanthamoebae genomic LSU rRNA	blastn	16972	220	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
10618987	10618987	PRJNA407368_S_NODE_2849_length_354_cov_20.406154_g2747_i0	PRJNA407368	2849	354	20.406154	72.23778516	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	435	2.8500000000000003e-117	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g2747	i0	89.174	106.395480225989	351	34	99	4	5	354	2621915	2621568	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	37664	435	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
10619033	10619033	PRJNA407368_S_NODE_4629_length_263_cov_7.286325_g4527_i0	PRJNA407368	4629	263	7.286325	19.16303475	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	215	2.89e-51	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g4527	i0	85.577	193.007604562738	208	26	78	4	8	213	2632788	2632583	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	50761	215	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
14444002	14444002	PRJNA407368_S_NODE_3752_length_301_cov_20.496324_g3650_i0	PRJNA407368	3752	301	20.496324	61.69393524	Estrella lausannensis	483423	Bacteria	Bacteria	326	1.4899999999999999e-84	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g3650	i0	90.157	167.740863787375	254	20	83	5	51	301	2068	1817	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	50490	326	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
14444044	14444044	PRJNA407368_S_NODE_5792_length_225_cov_3.484694_g5690_i0	PRJNA407368	5792	225	3.484694	7.8405615	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	257	3.95e-64	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g5690	i0	87.446	127.955555555556	231	19	99	10	1	224	654932	655159	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	28790	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19540974	19540974	PRJNA407368_S_NODE_9736_length_159_cov_3.000000_g9634_i0	PRJNA407368	9736	159	3	4.77	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	220	3.4099999999999998e-53	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g9634	i0	91.824	107.446540880503	159	11	99	1	2	158	1334059	1334217	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	17084	220	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
22091533	22091533	PRJNA407368_S_NODE_3418_length_318_cov_5.276817_g3316_i0	PRJNA407368	3418	318	5.276817	16.78027806	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	460	4.1799999999999997e-125	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3316	i0	95.486	76.4245283018868	288	13	91	0	8	295	654162	653875	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	24303	460	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
24641479	24641479	PRJNA407368_S_NODE_2840_length_355_cov_159.739264_g2738_i0	PRJNA407368	2840	355	159.739264	567.0743872	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	545	1.26e-150	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g2738	i0	94.382	156.2	356	18	100	2	1	355	2624158	2624512	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	55451	545	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
24641486	24641486	PRJNA407368_S_NODE_3220_length_328_cov_83.735786_g3118_i0	PRJNA407368	3220	328	83.735786	274.65337808	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	350	9.77e-92	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g3118	i0	86.018	108.283536585366	329	42	100	3	1	328	2624770	2625095	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	35517	350	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
25307877	25307877	PRJNA407368_S_NODE_8140_length_179_cov_3.293333_g8038_i0	PRJNA407368	8140	179	3.293333	5.89506607	Candidatus Protochlamydia	282132	Bacteria	Bacteria	279	6.39e-71	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g8038	i0	95.429	51.2458100558659	175	8	98	0	5	179	1249349	1249175	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	9173	279	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
27296715	27296715	PRJNA407368_S_NODE_2343_length_400_cov_7.722372_g2241_i0	PRJNA407368	2343	400	7.722372	30.889488	Chlamydiales bacterium	2047757	Bacteria	Bacteria	76.3	4.4e-13	NR	MCE5294811.1	2047757	g2241	i0	46.7	0.69	92	48	69	1	327	52	180	270	MCE5294811.1 amino acid adenylation domain-containing protein [Chlamydiales bacterium]	diamond	276	76.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29349194	29349194	PRJNA407368_S_NODE_7749_length_185_cov_2.634615_g7647_i0	PRJNA407368	7749	185	2.634615	4.87403775	Estrella lausannensis	483423	Bacteria	Bacteria	51.6	1.26e-5	NR	WP_098039224.1	483423	g7647	i0	51.7	0.940540540540541	58	27	94.1	1	185	12	279	335	WP_098039224.1 NO-inducible flavohemoprotein [Estrella lausannensis]	diamond	174	51.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
30833740	30833740	PRJNA407368_S_NODE_3554_length_311_cov_4.141844_g3452_i0	PRJNA407368	3554	311	4.141844	12.88113484	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	126	2.94e-33	NR	MFI0435901.1	2052176	g3452	i0	89.7	0.655948553054662	68	7	65.6	0	1	204	117	184	MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	204	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31561016	31561016	PRJNA407368_S_NODE_416_length_987_cov_7.930063_g380_i0	PRJNA407368	416	987	7.930063	78.26972181	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	53.1	5.31e-4	NR	MFI0435897.1	2052176	g380	i0	61.5	0.11854103343465	39	15	11.9	0	134	250	221	259	MFI0435897.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	117	53.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		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);;