metadata: contig_metadata: 7 rows where bioproject = "PRJNA358009", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA358009", 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_genus	tax_species
4225415	4225415	PRJNA358009_P_NODE_14304_length_164_cov_9.808696_g14235_i0	PRJNA358009	14304	164	9.808696	16.08626144	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	276	7.46e-70	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g14235	i0	96.97	36.2073170731707	165	3	99	1	2	164	1019112	1019276	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	5938	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
9326479	9326479	PRJNA358009_P_NODE_9508_length_185_cov_6.558824_g9439_i0	PRJNA358009	9508	185	6.558824	12.1338244	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	291	3.07e-74	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g9439	i0	95.135	50.0864864864865	185	7	99	2	1	184	1317387	1317570	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	9266	291	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
18249964	18249964	PRJNA358009_P_NODE_4895_length_327_cov_1.946043_g4832_i0	PRJNA358009	4895	327	1.946043	6.36356061	uncultured Neochlamydia sp.	212218	Bacteria	Bacteria	108	6.47e-19	NTclustered	gi\|310755790\|gb\|HQ213680.1\|	212218	g4832	i0	92.208	0.44954128440367	77	4	23	2	5	80	965	1040	Uncultured Neochlamydia sp. clone 4_L12 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	147	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	uncultured Neochlamydia sp.
19524162	19524162	PRJNA358009_P_NODE_6796_length_324_cov_2.196364_g6733_i0	PRJNA358009	6796	324	2.196364	7.11621936	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	139	2.27e-28	NTclustered	gi\|320090089\|gb\|HQ702420.1\|	464461	g6733	i0	93.548	25.4722222222222	93	6	29	0	4	96	195	103	Uncultured Parachlamydiaceae bacterium clone WT46 16S ribosomal RNA gene, partial sequence	blastn	8253	139	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
22749825	22749825	PRJNA358009_P_NODE_2018_length_329_cov_7.325000_g1955_i0	PRJNA358009	2018	329	7.325	24.09925	Simkaniaceae	92712	Bacteria	Bacteria	158	6.38e-34	NTclustered	gi\|31747860\|gb\|AY140911.1\|	206690	g1955	i0	96.809	41.1854103343465	94	3	59	0	228	321	2725	2818	Candidatus Fritschea eriococci strain Elm 16S ribosomal RNA and 23S ribosomal RNA genes, complete sequence	blastn	13550	158	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea eriococci
24024673	24024673	PRJNA358009_P_NODE_12819_length_167_cov_5.033898_g12750_i0	PRJNA358009	12819	167	5.033898	8.40660966	Candidatus Protochlamydia	282132	Bacteria	Bacteria	183	4.759999999999998e-42	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g12750	i0	87.654	54.2215568862275	162	15	96	5	1	160	1251067	1251225	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	9055	183	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
28496153	28496153	PRJNA358009_P_NODE_13867_length_165_cov_3.258621_g13798_i0	PRJNA358009	13867	165	3.258621	5.37672465	Chlamydiales bacterium	2047757	Bacteria	Bacteria	72.8	3.2e-13	NR	HEV7738443.1	2047757	g13798	i0	78.6	0.763636363636364	42	9	76.4	0	26	151	324	365	HEV7738443.1 reverse transcriptase domain-containing protein [Chlamydiales bacterium]	diamond	126	72.8	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);;