metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA946307" 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
1260159	1260159	PRJNA946307_P_NODE_155501_length_163_cov_2.982456_g154627_i0	PRJNA946307	155501	163	2.982456	4.86140328	Bacteria	2	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g154627	i0	96.319	117.815950920245	163	6	100	0	1	163	415012	415174	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	19204	268	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
2535580	2535580	PRJNA946307_P_NODE_119182_length_175_cov_3.055556_g118308_i0	PRJNA946307	119182	175	3.055556	5.347223	Chlamydiia	204429	Bacteria	Bacteria	228	2.2799999999999996e-55	NTclustered	gi\|880804037\|gb\|KT258862.1\|	174324	g118308	i0	92.025	102.771428571429	163	11	93	2	13	175	92	252	Uncultured Chlamydiales bacterium clone CL83 16S ribosomal RNA gene, partial sequence	blastn	17985	230	0.991304347826087	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
3477579	3477579	PRJNA946307_P_NODE_20103_length_285_cov_4.000000_g19231_i0	PRJNA946307	20103	285	4	11.4	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	237	6.77e-58	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g19231	i0	95.302	90.0947368421053	149	7	54	0	130	278	655047	654899	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	25677	237	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
3477783	3477783	PRJNA946307_P_NODE_29923_length_237_cov_7.356383_g29049_i0	PRJNA946307	29923	237	7.356383	17.43462771	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	344	3.13e-90	NTclustered	gi\|320090080\|gb\|HQ702411.1\|	464461	g29049	i0	94.977	95.5105485232068	219	11	92	0	14	232	15	233	Uncultured Parachlamydiaceae bacterium clone WT23 16S ribosomal RNA gene, partial sequence	blastn	22636	344	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
3812225	3812225	PRJNA946307_P_NODE_155843_length_163_cov_2.491228_g154969_i0	PRJNA946307	155843	163	2.491228	4.06070164	Parachlamydia	83551	Bacteria	Bacteria	176	7.73e-40	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g154969	i0	91.538	15.3803680981595	130	8	79	2	35	163	910	1037	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	2507	176	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
3812235	3812235	PRJNA946307_P_NODE_157463_length_163_cov_0.912281_g156589_i0	PRJNA946307	157463	163	0.912281	1.48701803	Candidatus Protochlamydia	282132	Bacteria	Bacteria	159	7.779999999999998e-35	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g156589	i0	86	9.62576687116565	150	20	91	1	15	163	1250045	1249896	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	1569	159	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
5088862	5088862	PRJNA946307_P_NODE_38984_length_214_cov_1.424242_g38110_i0	PRJNA946307	38984	214	1.424242	3.04787788	Candidatus Protochlamydia	282132	Bacteria	Bacteria	311	2.82e-80	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g38110	i0	96.316	144.691588785047	190	6	88	1	11	199	1249315	1249126	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	30964	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
7305657	7305657	PRJNA946307_P_NODE_60846_length_205_cov_7.019231_g59972_i0	PRJNA946307	60846	205	7.0192310000000004	14.38942355	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	198	2.17e-46	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g59972	i0	85.789	244.673170731707	190	23	91	4	5	191	655173	655361	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	50158	198	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
8912756	8912756	PRJNA946307_P_NODE_132627_length_169_cov_4.558333_g131753_i0	PRJNA946307	132627	169	4.558333	7.70358277	Neochlamydia	112987	Bacteria	Bacteria	231	1.6899999999999998e-56	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g131753	i0	94.631	155.923076923077	149	8	88	0	21	169	654691	654543	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	26351	231	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
9853775	9853775	PRJNA946307_P_NODE_114228_length_178_cov_1.224806_g113354_i0	PRJNA946307	114228	178	1.224806	2.18015468	Candidatus Criblamydia sequanensis	340071	Bacteria	Bacteria	207	3.04e-49	NTclustered	gi\|343183577\|gb\|JN201882.1\|	1437425	g113354	i0	89.634	104.724719101124	164	15	91	2	2	163	2215	2378	Criblamydia sequanensis 23S ribosomal RNA gene, complete sequence	blastn	18641	207	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
11130816	11130816	PRJNA946307_P_NODE_36949_length_218_cov_1.023669_g36075_i0	PRJNA946307	36949	218	1.023669	2.23159842	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	276	1.05e-69	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g36075	i0	92.268	84.0045871559633	194	15	89	0	6	199	2361264	2361457	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	18313	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
12405810	12405810	PRJNA946307_P_NODE_166330_length_159_cov_3.000000_g165456_i0	PRJNA946307	166330	159	3	4.77	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	224	2.64e-54	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g165456	i0	94.483	57.8050314465409	145	8	91	0	15	159	2059085	2059229	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	9191	224	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14953818	14953818	PRJNA946307_P_NODE_121552_length_174_cov_2.984000_g120678_i0	PRJNA946307	121552	174	2.984	5.19216	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	147	6.53e-31	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g120678	i0	94.681	77.6954022988506	94	5	54	0	1	94	2626048	2625955	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	13519	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
16228484	16228484	PRJNA946307_P_NODE_105173_length_182_cov_1.451128_g104299_i0	PRJNA946307	105173	182	1.451128	2.64105296	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	174	3.17e-39	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g104299	i0	91.339	45.8791208791209	127	11	70	0	22	148	653832	653706	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	8350	174	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
16229968	16229968	PRJNA946307_P_NODE_30753_length_235_cov_2.032258_g29879_i0	PRJNA946307	30753	235	2.032258	4.7758063	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	329	8.69e-86	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g29879	i0	93.274	242	223	15	95	0	10	232	174603	174825	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	56870	329	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
18779096	18779096	PRJNA946307_P_NODE_46295_length_210_cov_4.565217_g45421_i0	PRJNA946307	46295	210	4.565217	9.5869557	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	147	8.22e-31	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g45421	i0	95.604	57.2714285714286	91	4	43	0	10	100	654055	653965	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	12027	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21662589	21662589	PRJNA946307_P_NODE_173597_length_152_cov_4.242718_g172723_i0	PRJNA946307	173597	152	4.242718	6.44893136	Candidatus Syngnamydia	1803801	Bacteria	Bacteria	139	9.27e-29	NTclustered	gi\|1214145827\|gb\|KY427067.1\|	504270	g172723	i0	85.612	33.7828947368421	139	13	89	6	2	137	3811	3677	Candidatus Syngnamydia salmonis isolate H03/14Pp 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer 23S ribosomal RNA and 5S ribosomal RNA genes, complete sequence	blastn	5135	139	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia salmonis
22604985	22604985	PRJNA946307_P_NODE_8038_length_488_cov_12.473804_g7227_i0	PRJNA946307	8038	488	12.473804	60.87216352	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	617	3.74e-172	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g7227	i0	90.147	87.1844262295082	477	43	97	4	1	475	653402	653876	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	42546	617	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
23878301	23878301	PRJNA946307_P_NODE_111239_length_179_cov_1.507692_g110365_i0	PRJNA946307	111239	179	1.507692	2.69876868	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	259	8.32e-65	NTclustered	gi\|880804036\|gb\|KT258861.1\|	174324	g110365	i0	95.122	98.9106145251397	164	8	92	0	2	165	247	84	Uncultured Chlamydiales bacterium clone CL66 16S ribosomal RNA gene, partial sequence	blastn	17705	259	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
23878532	23878532	PRJNA946307_P_NODE_1239_length_1243_cov_14.198492_g965_i0	PRJNA946307	1239	1243	14.198492	176.48725556	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1605	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g965	i0	92.342	172.189058728882	1136	76	91	9	4	1133	654919	653789	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	214031	1605	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);;