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

10 rows where bioproject = "PRJNA1196438" 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
1597986	1597986	PRJNA1196438_P_NODE_60662_length_257_cov_2.239130_g60235_i0	PRJNA1196438	60662	257	2.23913	5.7545641	Candidatus Piscichlamydia sp.	1977145	Bacteria	Bacteria	436	5.52e-118	NTclustered	gi\|1175896721\|gb\|KY380088.1\|	1977145	g60235	i0	98.776	95.8287937743191	245	3	95	0	13	257	403	647	Candidatus Piscichlamydia sp. strain EP 16S ribosomal RNA gene, partial sequence	blastn	24628	436	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia sp.
3593878	3593878	PRJNA1196438_P_NODE_67983_length_249_cov_1.750000_g67556_i0	PRJNA1196438	67983	249	1.75	4.3575	PVC group	1783257	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|337292513\|emb\|FR872621.1\|	765953	g67556	i0	100	60.9718875502008	249	0	100	0	1	249	1456	1208	Waddlia chondrophila 2032/99 annotated genome fragment, clone 1103163150273	blastn	15182	460	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
4149925	4149925	PRJNA1196438_P_NODE_35044_length_297_cov_2.558036_g34618_i0	PRJNA1196438	35044	297	2.558036	7.59736692	Chlamydiia bacterium	2052156	Bacteria	Bacteria	62.4	4.09e-9	NR	MCH9614076.1	2052156	g34618	i0	46.9	1.29292929292929	64	32	62.6	1	1	186	149	212	MCH9614076.1 Ribonuclease BN [Chlamydiia bacterium]	diamond	384	62.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
7976334	7976334	PRJNA1196438_P_NODE_27607_length_301_cov_4.179825_g27181_i0	PRJNA1196438	27607	301	4.179825	12.58127325	Chlamydiales bacterium	2047757	Bacteria	Bacteria	95.5	2.07e-20	NR	MBN9378883.1	2047757	g27181	i0	73.5	1.87375415282392	68	17	67.8	1	299	96	107	173	MBN9378883.1 NADH-quinone oxidoreductase subunit L [Chlamydiales bacterium]	diamond	564	95.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
12522067	12522067	PRJNA1196438_P_NODE_59490_length_259_cov_1.672043_g59063_i0	PRJNA1196438	59490	259	1.672043	4.33059137	Neochlamydia	112987	Bacteria	Bacteria	289	1.65e-73	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g59063	i0	86.923	186.393822393822	260	30	99	4	2	259	1439	1182	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	48276	291	0.993127147766323	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
18174472	18174472	PRJNA1196438_P_NODE_10635_length_326_cov_2.339921_g10209_i0	PRJNA1196438	10635	326	2.339921	7.62814246	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	318	2.74e-82	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g10209	i0	84.848	119.546012269939	330	34	99	14	1	325	653427	653745	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	38972	318	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
27293750	27293750	PRJNA1196438_P_NODE_9303_length_345_cov_1.716912_g8879_i0	PRJNA1196438	9303	345	1.716912	5.9233464	Waddlia chondrophila	71667	Bacteria	Bacteria	43.9	0.0425	NR	WP_013182342.1	71667	g8879	i0	66.7	0.234782608695652	27	5	20	1	313	245	131	157	WP_013182342.1 MFS transporter [Waddlia chondrophila]	diamond	81	43.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
27628736	27628736	PRJNA1196438_P_NODE_70404_length_247_cov_0.896552_g69977_i0	PRJNA1196438	70404	247	0.896552	2.21448344	Simkania	34093	Bacteria	Bacteria	111	3.28e-29	NR	MBS3903901.1	34094	g69977	i0	65.9	4.96761133603239	82	28	99.6	0	246	1	22	103	MBS3903901.1 YjdF family protein [Simkania sp.]	diamond	1227	111	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28114611	28114611	PRJNA1196438_P_NODE_4765_length_453_cov_2.731579_g4347_i0	PRJNA1196438	4765	453	2.731579	12.37405287	Chlamydiota bacterium	2081524	Bacteria	Bacteria	46.6	0.0128	NR	MCH9632675.1	2081524	g4347	i0	54.5	0.417218543046358	33	15	21.9	0	101	3	8	40	MCH9632675.1 hypothetical protein [Chlamydiota bacterium]	diamond	189	46.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32538821	32538821	PRJNA1196438_P_NODE_39039_length_290_cov_2.594470_g38612_i0	PRJNA1196438	39039	290	2.59447	7.523963	Chlamydiota bacterium	2081524	Bacteria	Bacteria	138	3.94e-37	NR	MCH9632073.1	2081524	g38612	i0	72.9	0.993103448275862	96	26	99.3	0	1	288	1	96	MCH9632073.1 Peptidoglycan glycosyltransferase MrdB [Chlamydiota bacterium]	diamond	288	138	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;