metadata: contig_metadata: 10 rows where bioproject = "PRJEB6584" and tax

10 rows where bioproject = "PRJEB6584" 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
25525583	25525583	PRJEB6584p_S_NODE_56177_length_155_cov_2.391667_g56146_i0	PRJEB6584	56177	155	2.391667	3.70708385	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	196	5.559999999999999e-46	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g56146	i0	99.083	43.9741935483871	109	1	70	0	1	109	1250300	1250408	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	6816	196	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25661453	25661453	PRJEB6584o_S_NODE_9098_length_286_cov_13.446215_g8990_i0	PRJEB6584	9098	286	13.446215	38.4561749	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	448	2.8899999999999998e-121	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g8990	i0	96	2.57342657342657	275	11	96	0	12	286	2276288	2276562	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	736	448	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25661488	25661488	PRJEB6584o_S_NODE_9810_length_277_cov_12.855372_g9702_i0	PRJEB6584	9810	277	12.855372	35.60938044	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	451	2.15e-122	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g9702	i0	96.029	2	277	11	100	0	1	277	2281350	2281074	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	554	451	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25795778	25795778	PRJEB6584h_S_NODE_2403_length_311_cov_11.217391_g2341_i0	PRJEB6584	2403	311	11.217391	34.88608601	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	399	9.009999999999998e-107	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g2341	i0	92.527	174.189710610932	281	18	93	3	21	299	2058534	2058813	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	54173	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
25932685	25932685	PRJEB6584o_S_NODE_1468_length_525_cov_12.604082_g1392_i0	PRJEB6584	1468	525	12.604082	66.1714305	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	907	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1392	i0	99.205	115.817142857143	503	4	96	0	23	525	1249072	1249574	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	60804	907	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25933326	25933326	PRJEB6584o_S_NODE_4460_length_373_cov_5049.298817_g4352_i0	PRJEB6584	4460	373	5049.298817	18833.88458741	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	475	1.78e-129	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4352	i0	99.615	86.8847184986595	260	1	70	0	114	373	1250408	1250149	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	32408	475	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26067994	26067994	PRJEB6584f_S_NODE_6541_length_156_cov_2.272727_g6535_i0	PRJEB6584	6541	156	2.272727	3.54545412	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	206	9.32e-49	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g6535	i0	99.123	20.75	114	1	73	0	43	156	1267631	1267518	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	3237	206	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26068754	26068754	PRJEB6584o_S_NODE_16669_length_218_cov_2.021858_g16561_i0	PRJEB6584	16669	218	2.021858	4.40765044	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	374	3.62e-99	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g16561	i0	99.043	111.51376146789	209	1	95	1	1	208	1250923	1250715	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	24310	374	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26476429	26476429	PRJEB6584h_S_NODE_392_length_489_cov_575.764317_g342_i0	PRJEB6584	392	489	575.764317	2815.48751013	Parachlamydia acanthamoebae UV-7	765952	Bacteria	Bacteria	414	5.28e-111	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g342	i0	83.553	229.543967280164	456	61	92	13	35	485	770249	770695	Parachlamydia acanthamoebae UV-7, complete genome	blastn	112247	414	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
26477250	26477250	PRJEB6584o_S_NODE_20424_length_201_cov_1.855422_g20316_i0	PRJEB6584	20424	201	1.855422	3.72939822	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	200	5.9e-47	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g20316	i0	86.364	2.11442786069652	198	9	99	6	1	198	1519139	1519318	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	425	200	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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);;