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

5 rows where bioproject = "PRJNA575566", 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
3110794	3110794	PRJNA575566_P_NODE_11403_length_310_cov_1.582329_g11206_i0	PRJNA575566	11403	310	1.582329	4.9052199	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	499	8.6e-137	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g11206	i0	95.806	156.21935483871	310	12	100	1	1	310	629327	629019	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	48428	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
3110911	3110911	PRJNA575566_P_NODE_18323_length_246_cov_1.037838_g18126_i0	PRJNA575566	18323	246	1.037838	2.55308148	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	361	3.25e-95	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g18126	i0	93.117	21.8048780487805	247	15	100	2	1	246	627471	627716	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	5364	361	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
19686727	19686727	PRJNA575566_P_NODE_5456_length_449_cov_1.154639_g5259_i0	PRJNA575566	5456	449	1.154639	5.18432911	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	697	0	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g5259	i0	94.678	169.080178173719	451	21	100	3	1	449	626941	627390	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	75917	697	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
20962433	20962433	PRJNA575566_P_NODE_6097_length_423_cov_3.303867_g5900_i0	PRJNA575566	6097	423	3.303867	13.97535741	Candidatus Fritschea bemisiae	206681	Bacteria	Bacteria	75	8.7e-9	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g5900	i0	79.091	2.725768321513	110	21	26	2	73	180	6821	6712	Candidatus Fritschea bemisiae strain Falk YaeL (yaeL) gene, partial cds; putative glycosylhydrolase and putative transposase genes, complete cds; 16S ribosomal RNA and 23S ribosomal RNA genes, complete sequence; putative endonuclease gene, complete cds; 5S ribosomal RNA gene, complete sequence; argynyl tRNA synthetase (argS), YjeE (yjeE), probable GTP-binding protein, DNA polymerase III epsilon subunit, and phosphoglycerate kinase (pgk) genes, complete cds; and unknown gene	blastn	1153	75	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae
29069202	29069202	PRJNA575566_P_NODE_24548_length_209_cov_0.864865_g24351_i0	PRJNA575566	24548	209	0.864865	1.80756785	Simkania sp.	34094	Bacteria	Bacteria	48.1	2.98e-4	NR	MBS3903878.1	34094	g24351	i0	43.5	0.990430622009569	69	38	99	1	1	207	257	324	MBS3903878.1 PDZ domain-containing protein [Simkania sp.]	diamond	207	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.

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