metadata: contig_metadata: 22 rows where bioproject = "PRJNA928559" and tax

22 rows where bioproject = "PRJNA928559" 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
3804735	3804735	PRJNA928559_P_NODE_139923_length_299_cov_1.646018_g138354_i0	PRJNA928559	139923	299	1.646018	4.92159382	Chlamydia	810	Bacteria	Bacteria	307	5.3700000000000006e-79	NTclustered	gi\|2160499992\|gb\|CP042720.1\|	813	g138354	i0	87.5	182.150501672241	272	27	90	6	15	283	139409	139676	Chlamydia trachomatis strain TC0080-IGR-TC0081::TncL2/tetR-1645 chromosome, complete genome	blastn	54463	307	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
7282010	7282010	PRJNA928559_P_NODE_39106_length_534_cov_3.919740_g37551_i0	PRJNA928559	39106	534	3.91974	20.9314116	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	604	3.2099999999999983e-168	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g37551	i0	87.199	116.988764044944	539	59	99	10	1	532	2059365	2058830	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	62472	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
8555337	8555337	PRJNA928559_P_NODE_143887_length_294_cov_2.832579_g142318_i0	PRJNA928559	143887	294	2.832579	8.32778226	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	276	1.4899999999999998e-69	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g142318	i0	85.768	47.8095238095238	267	31	89	6	30	292	2058860	2059123	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	14056	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
8556535	8556535	PRJNA928559_P_NODE_225287_length_217_cov_4.736111_g223718_i0	PRJNA928559	225287	217	4.736111	10.27736087	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	333	6.109999999999999e-87	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g223718	i0	94.495	53.0506912442396	218	9	100	2	1	217	8204	8419	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	11512	333	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
8557464	8557464	PRJNA928559_P_NODE_87347_length_380_cov_3.260586_g85778_i0	PRJNA928559	87347	380	3.260586	12.3902268	Simkania negevensis	83561	Bacteria	Bacteria	664	0	NTclustered	gi\|559133873\|tpe\|HG788878.1\|	331113	g85778	i0	98.158	11.3763157894737	380	7	100	0	1	380	380	1	TPA: Simkania negevensis Z transfer-messenger mRNA Simka_negev_Z, single chain mature transcript	blastn	4323	664	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
12381346	12381346	PRJNA928559_P_NODE_121930_length_322_cov_2.819277_g120361_i0	PRJNA928559	121930	322	2.819277	9.07807194	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	307	5.840000000000001e-79	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g120361	i0	85.43	119.552795031056	302	36	92	7	20	316	2364135	2364433	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	38496	307	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
13657682	13657682	PRJNA928559_P_NODE_40631_length_526_cov_3.041943_g39075_i0	PRJNA928559	40631	526	3.041943	16.00062018	Simkania negevensis	83561	Bacteria	Bacteria	719	0	NTclustered	gi\|336481279\|emb\|FR872582.1\|	331113	g39075	i0	91.923	89.4467680608365	520	33	97	4	1	511	369950	370469	Simkania negevensis Z main chromosome, complete genome	blastn	47049	719	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
14007079	14007079	PRJNA928559_P_NODE_34551_length_562_cov_2.560327_g33005_i0	PRJNA928559	34551	562	2.560327	14.38903774	Candidatus Neptunichlamydia	1891669	Bacteria	Bacteria	531	5.8399999999999985e-146	NTclustered	gi\|124021662\|gb\|EF177461.1\|	420390	g33005	i0	84.701	76.4893238434164	536	77	95	4	1	534	3627	3095	Chlamydiales symbiont of Xenoturbella westbladi 16S ribosomal RNA gene, partial sequence; 23S ribosomal RNA gene, complete sequence; and putative homing endonuclease gene, complete cds	blastn	42987	536	0.990671641791045	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Chlamydiales symbiont of Xenoturbella westbladi
18753642	18753642	PRJNA928559_P_NODE_113035_length_335_cov_2.851145_g111466_i0	PRJNA928559	113035	335	2.851145	9.55133575	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	525	1.5499999999999995e-144	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g111466	i0	94.94	173.946268656716	336	15	100	2	1	335	652452	652786	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	58272	525	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19104482	19104482	PRJNA928559_P_NODE_2375_length_1872_cov_13.879933_g1894_i0	PRJNA928559	2375	1872	13.879933	259.83234576	Simkania	34093	Bacteria	Bacteria	3435	0	NTclustered	gi\|5042360\|gb\|U68460.2\|SSU68460	83561	g1894	i0	99.786	120.924679487179	1872	4	100	0	1	1872	1842	3713	Simkania negevensis 16S and 23S ribosomal RNA operon, complete sequence; and putative endonuclease homodimer gene, complete cds	blastn	226371	3435	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
20030052	20030052	PRJNA928559_P_NODE_210956_length_243_cov_2.117647_g209387_i0	PRJNA928559	210956	243	2.117647	5.14588221	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	200	7.39e-47	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g209387	i0	84.211	44.522633744856	209	29	84	2	39	243	836761	836969	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	10819	200	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
22581587	22581587	PRJNA928559_P_NODE_79218_length_398_cov_1.935385_g77649_i0	PRJNA928559	79218	398	1.935385	7.7028323	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	440	6.959999999999997e-119	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g77649	i0	87.277	110.329145728643	393	40	97	8	11	398	1249460	1249073	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	43911	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25128602	25128602	PRJNA928559_P_NODE_14620_length_816_cov_5.098250_g13273_i0	PRJNA928559	14620	816	5.09825	41.60172	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	1114	0	NTclustered	gi\|2041291174\|gb\|CP073762.1\|	2698248	g13273	i0	91.432	137.066176470588	817	63	99	6	3	816	517253	518065	MAG: Simkaniaceae bacterium isolate M30B2 chromosome, complete genome	blastn	111846	1114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
25129769	25129769	PRJNA928559_P_NODE_221060_length_232_cov_2.062893_g219491_i0	PRJNA928559	221060	232	2.062893	4.78591176	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	250	6.85e-62	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g219491	i0	86.809	128.875	235	18	99	12	2	230	655125	655352	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	29899	250	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
26961387	26961387	PRJNA928559_P_NODE_71822_length_416_cov_1.288630_g70253_i0	PRJNA928559	71822	416	1.28863	5.3607008	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	46.6	0.00952	NR	HUD01044.1	2047756	g70253	i0	24.1	1.77403846153846	141	96	93.8	3	394	5	219	359	HUD01044.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	738	46.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
27467374	27467374	PRJNA928559_P_NODE_39643_length_531_cov_7.268559_g38087_i0	PRJNA928559	39643	531	7.268559	38.59604829	Chlamydiales bacterium	2047757	Bacteria	Bacteria	197	1.37e-61	NR	MCP5470420.1	2047757	g38087	i0	78.4	0.706214689265537	125	27	70.6	0	17	391	1	125	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	375	197	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28067087	28067087	PRJNA928559_P_NODE_192625_length_251_cov_0.876404_g191056_i0	PRJNA928559	192625	251	0.876404	2.19977404	Chlamydiales bacterium	2047757	Bacteria	Bacteria	95.5	1.68e-21	NR	HLB52200.1	2047757	g191056	i0	55.4	0.99203187250996006	83	33	98	2	2	247	105	184	HLB52200.1 polyamine aminopropyltransferase [Chlamydiales bacterium]	diamond	249	95.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29077687	29077687	PRJNA928559_P_NODE_63828_length_437_cov_6.758242_g62259_i0	PRJNA928559	63828	437	6.758242	29.53351754	Simkania sp.	34094	Bacteria	Bacteria	118	1.13e-29	NR	MCB1084310.1	34094	g62259	i0	57	0.638443935926774	93	40	63.8	0	3	281	104	196	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	279	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29235513	29235513	PRJNA928559_P_NODE_58689_length_453_cov_3.526316_g57122_i0	PRJNA928559	58689	453	3.526316	15.97421148	Chlamydiales bacterium	2047757	Bacteria	Bacteria	47	0.00774	NR	MFN0064848.1	2047757	g57122	i0	34.3	0.655629139072848	99	61	64.2	3	413	123	87	183	MFN0064848.1 toxin-antitoxin system YwqK family antitoxin [Chlamydiales bacterium]	diamond	297	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29424596	29424596	PRJNA928559_P_NODE_119389_length_326_cov_1.509881_g117820_i0	PRJNA928559	119389	326	1.509881	4.92221206	Chlamydiales bacterium	2047757	Bacteria	Bacteria	73.9	2.72e-13	NR	MCP5470430.1	2047757	g117820	i0	52.8	0.819018404907976	89	42	81.9	0	267	1	4	92	MCP5470430.1 hypothetical protein [Chlamydiales bacterium]	diamond	267	73.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30119493	30119493	PRJNA928559_P_NODE_225612_length_214_cov_6.581560_g224043_i0	PRJNA928559	225612	214	6.58156	14.0845384	Simkania sp.	34094	Bacteria	Bacteria	48.9	1.43e-5	NR	MCB1084365.1	34094	g224043	i0	56.8	0.518691588785047	37	16	51.9	0	209	99	39	75	MCB1084365.1 hypothetical protein [Simkania sp.]	diamond	111	48.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30435897	30435897	PRJNA928559_P_NODE_53893_length_469_cov_7.469697_g52327_i0	PRJNA928559	53893	469	7.469697	35.03287893	Chlamydiales bacterium	2047757	Bacteria	Bacteria	133	1.49e-36	NR	MCP5470421.1	2047757	g52327	i0	51.4	4.0682302771855	142	63	89.6	2	469	50	20	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1908	133	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			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);;