metadata: contig_metadata: 5 rows where bioproject = "PRJNA1186363", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA1186363", tax_clade = "PVC group" 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_species
7973130	7973130	PRJNA1186363_P_NODE_7547_length_768_cov_2.722302_g6740_i0	PRJNA1186363	7547	768	2.722302	20.90727936	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	234	3.3899999999999997e-69	NR	HSX03888.1	2047756	g6740	i0	54	0.83984375	215	93	82.4	4	766	134	141	353	HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	645	234	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
23271833	23271833	PRJNA1186363_P_NODE_17499_length_462_cov_2.406170_g16612_i0	PRJNA1186363	17499	462	2.40617	11.1165054	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	122	6.17e-29	NR	HSX03888.1	2047756	g16612	i0	46	0.818181818181818	126	58	76.6	3	367	14	29	152	HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	378	122	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
28366988	28366988	PRJNA1186363_P_NODE_14326_length_527_cov_2.121145_g13442_i0	PRJNA1186363	14326	527	2.121145	11.17843415	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	198	1.0499999999999998e-56	NR	HSX03888.1	2047756	g13442	i0	54.9	0.870967741935484	153	69	87.1	0	527	69	467	619	HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	459	198	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
29503666	29503666	PRJNA1186363_P_NODE_13910_length_537_cov_2.043103_g13026_i0	PRJNA1186363	13910	537	2.043103	10.97146311	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	133	1.47e-32	NR	HSX03888.1	2047756	g13026	i0	50.5	0.620111731843575	111	55	62	0	3	335	509	619	HSX03888.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	333	133	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Rhabdochlamydiaceae bacterium
30135169	30135169	PRJNA1186363_P_NODE_41212_length_247_cov_1.321839_g40324_i0	PRJNA1186363	41212	247	1.321839	3.26494233	Chlamydiales bacterium	2047757	Bacteria	Bacteria	44.7	0.00856	NR	MFI5343916.1	2047757	g40324	i0	45.5	0.668016194331984	55	28	66.8	1	83	247	1677	1729	MFI5343916.1 DUF3638 domain-containing protein [Chlamydiales bacterium]	diamond	165	44.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales		Chlamydiales 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);;