metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1240804" 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
4174867	4174867	PRJNA1240804_P_NODE_19364_length_315_cov_9.421053_g18998_i0	PRJNA1240804	19364	315	9.421053	29.67631695	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	372	1.99e-98	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g18998	i0	92.941	124.526984126984	255	18	81	0	54	308	835389	835643	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	39226	372	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
4877937	4877937	PRJNA1240804_P_NODE_102204_length_172_cov_1.260163_g101838_i0	PRJNA1240804	102204	172	1.260163	2.16748036	Parachlamydiales	1963360	Bacteria	Bacteria	243	7.979999999999999e-60	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g101838	i0	94.34	115.354651162791	159	8	92	1	1	158	1250932	1251090	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	19841	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
10551173	10551173	PRJNA1240804_P_NODE_12469_length_374_cov_3.593846_g12104_i0	PRJNA1240804	12469	374	3.593846	13.44098404	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	490	6.36e-134	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g12104	i0	91.761	458.729946524064	352	29	94	0	15	366	653292	652941	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	171565	490	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10552034	10552034	PRJNA1240804_P_NODE_30289_length_265_cov_1.712963_g29923_i0	PRJNA1240804	30289	265	1.712963	4.53935195	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	335	2.149999999999999e-87	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g29923	i0	89.811	178.675471698113	265	22	99	5	4	265	1249428	1249166	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	47349	335	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
11826424	11826424	PRJNA1240804_P_NODE_170_length_1828_cov_4.599775_g92_i0	PRJNA1240804	170	1828	4.599775	84.083887	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	2169	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g92	i0	88.39	184.098468271335	1826	180	99	29	15	1828	655359	653554	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	336532	2169	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14375820	14375820	PRJNA1240804_P_NODE_105892_length_169_cov_2.366667_g105526_i0	PRJNA1240804	105892	169	2.366667	3.99966723	Parachlamydiaceae bacterium CRIB38	553506	Bacteria	Bacteria	196	6.16e-46	NTclustered	gi\|196051291\|gb\|EU683886.1\|	553506	g105526	i0	89.809	88.9763313609467	157	11	92	5	15	169	98	251	Parachlamydiaceae bacterium CRIB38 16S ribosomal RNA gene, partial sequence	blastn	15037	196	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium CRIB38
16925621	16925621	PRJNA1240804_P_NODE_49154_length_220_cov_1.637427_g48788_i0	PRJNA1240804	49154	220	1.637427	3.6023394	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	348	2.2200000000000005e-91	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g48788	i0	97.087	149.063636363636	206	6	94	0	1	206	653893	654098	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32794	348	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21452202	21452202	PRJNA1240804_P_NODE_72897_length_191_cov_1.830986_g72531_i0	PRJNA1240804	72897	191	1.830986	3.49718326	Parachlamydia	83551	Bacteria	Bacteria	287	4.14e-73	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g72531	i0	93.75	118.774869109948	192	11	100	1	1	191	845	1036	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	22686	287	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
22023534	22023534	PRJNA1240804_P_NODE_10318_length_403_cov_2.290960_g9955_i0	PRJNA1240804	10318	403	2.29096	9.2325688	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	508	1.91e-139	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g9955	i0	90.256	96.697270471464	390	37	97	1	1	389	1250660	1250271	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	38969	508	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23301567	23301567	PRJNA1240804_P_NODE_86279_length_182_cov_1.496241_g85913_i0	PRJNA1240804	86279	182	1.496241	2.72315862	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	143	8.93e-30	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g85913	i0	82.927	1.35164835164835	164	22	89	3	7	168	1715	1556	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	246	143	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae

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