metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
429368	429368	PRJNA432257_S_NODE_22421_length_309_cov_188.242647_g22040_i0	PRJNA432257	22421	309	188.242647	581.66977923	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	505	1.8399999999999998e-138	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g22040	i0	100	1.22330097087379	273	0	88	0	37	309	1848124	1847852	Parachlamydia acanthamoebae UV-7, complete genome	blastn	378	505	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
2979990	2979990	PRJNA432257_S_NODE_20403_length_320_cov_2.406360_g20022_i0	PRJNA432257	20403	320	2.40636	7.700352	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	580	3.099999999999999e-161	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g20022	i0	99.375	1	320	2	100	0	1	320	837948	837629	Parachlamydia acanthamoebae UV-7, complete genome	blastn	320	580	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
6807902	6807902	PRJNA432257_S_NODE_8406_length_434_cov_31.249370_g8073_i0	PRJNA432257	8406	434	31.24937	135.6222658	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	728	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g8073	i0	99.748	0.914746543778802	397	1	91	0	2	398	2360970	2360574	Parachlamydia acanthamoebae UV-7, complete genome	blastn	397	728	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
7466873	7466873	PRJNA432257_S_NODE_59266_length_217_cov_1.850000_g58885_i0	PRJNA432257	59266	217	1.85	4.0145	Parachlamydia	83551	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g58885	i0	100	147.603686635945	217	0	100	0	1	217	245	461	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	32030	401	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
9358167	9358167	PRJNA432257_S_NODE_70488_length_203_cov_1.765060_g70107_i0	PRJNA432257	70488	203	1.76506	3.5830718	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	364	2e-96	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g70107	i0	99.015	1	203	2	100	0	1	203	1691442	1691240	Parachlamydia acanthamoebae UV-7, complete genome	blastn	203	364	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
10016928	10016928	PRJNA432257_S_NODE_64568_length_210_cov_2.098266_g64187_i0	PRJNA432257	64568	210	2.098266	4.4063586	Parachlamydia	83551	Bacteria	Bacteria	361	2.6999999999999998e-95	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g64187	i0	100	112.757142857143	195	0	93	0	1	195	1823	1629	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	23679	361	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
10633485	10633485	PRJNA432257_S_NODE_36829_length_259_cov_2.986486_g36448_i0	PRJNA432257	36829	259	2.986486	7.73499874	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	468	1.98e-127	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g36448	i0	99.228	1	259	2	100	0	1	259	837565	837307	Parachlamydia acanthamoebae UV-7, complete genome	blastn	259	468	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
11907816	11907816	PRJNA432257_S_NODE_11170_length_393_cov_2.171348_g10802_i0	PRJNA432257	11170	393	2.171348	8.53339764	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	713	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g10802	i0	99.49	0.997455470737914	392	2	99	0	2	393	1486928	1486537	Parachlamydia acanthamoebae UV-7, complete genome	blastn	392	713	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
13182742	13182742	PRJNA432257_S_NODE_10731_length_398_cov_7.614958_g10368_i0	PRJNA432257	10731	398	7.614958	30.30753284	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	678	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g10368	i0	100	0.922110552763819	367	0	92	0	1	367	1555286	1554920	Parachlamydia acanthamoebae UV-7, complete genome	blastn	367	678	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
13183212	13183212	PRJNA432257_S_NODE_31631_length_274_cov_2.704641_g31250_i0	PRJNA432257	31631	274	2.704641	7.41071634	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	494	3.48e-135	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g31250	i0	99.267	0.996350364963504	273	2	99	0	2	274	1231272	1231000	Parachlamydia acanthamoebae UV-7, complete genome	blastn	273	494	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
15733011	15733011	PRJNA432257_S_NODE_98093_length_178_cov_1.382979_g97712_i0	PRJNA432257	98093	178	1.382979	2.46170262	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g97712	i0	99.438	1	178	1	100	0	1	178	838104	837927	Parachlamydia acanthamoebae UV-7, complete genome	blastn	178	324	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
18940360	18940360	PRJNA432257_S_NODE_7655_length_448_cov_233.576642_g7336_i0	PRJNA432257	7655	448	233.576642	1046.42335616	Parachlamydia	83551	Bacteria	Bacteria	488	2.7899999999999993e-133	NTclustered	gi\|1491674\|emb\|Y07555.1\|	83552	g7336	i0	98.901	62.2678571428571	273	3	61	0	105	377	306	34	Parachlamydia acanthamoebae genomic LSU rRNA	blastn	27896	488	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
22105844	22105844	PRJNA432257_S_NODE_15478_length_351_cov_10.939490_g15097_i0	PRJNA432257	15478	351	10.93949	38.3976099	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	590	5.6799999999999996e-164	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g15097	i0	100	0.908831908831909	319	0	91	0	1	319	837164	836846	Parachlamydia acanthamoebae UV-7, complete genome	blastn	319	590	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
22106300	22106300	PRJNA432257_S_NODE_45078_length_240_cov_3.300493_g44697_i0	PRJNA432257	45078	240	3.300493	7.9211832	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	167	7.389999999999999e-37	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g44697	i0	81.731	5.25833333333333	208	31	85	7	7	211	1020720	1020923	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	1262	167	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
23381240	23381240	PRJNA432257_S_NODE_112119_length_164_cov_1.842520_g111738_i0	PRJNA432257	112119	164	1.84252	3.0217328	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g111738	i0	99.39	1	164	1	100	0	1	164	838411	838248	Parachlamydia acanthamoebae UV-7, complete genome	blastn	164	298	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
24655403	24655403	PRJNA432257_S_NODE_111980_length_164_cov_2.149606_g111599_i0	PRJNA432257	111980	164	2.149606	3.52535384	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g111599	i0	99.39	1	164	1	100	0	1	164	1585406	1585569	Parachlamydia acanthamoebae UV-7, complete genome	blastn	164	298	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae

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