metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA451191" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA451191" 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
7470597	7470597	PRJNA451191_P_NODE_18406_length_336_cov_4.825455_g18135_i0	PRJNA451191	18406	336	4.825455	16.2135288	Simkaniaceae	92712	Bacteria	Bacteria	499	9.42e-137	NTclustered	gi\|1214145827\|gb\|KY427067.1\|	504270	g18135	i0	93.548	104.125	341	12	100	9	1	336	3421	3756	Candidatus Syngnamydia salmonis isolate H03/14Pp 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer 23S ribosomal RNA and 5S ribosomal RNA genes, complete sequence	blastn	34986	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia salmonis
7470641	7470641	PRJNA451191_P_NODE_28046_length_268_cov_2.502415_g27775_i0	PRJNA451191	28046	268	2.502415	6.7064722	Candidatus Syngnamydia	1803801	Bacteria	Bacteria	451	2.07e-122	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g27775	i0	97.015	137.977611940299	268	8	100	0	1	268	6629	6362	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	36978	451	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
11295810	11295810	PRJNA451191_P_NODE_35289_length_239_cov_3.022472_g35018_i0	PRJNA451191	35289	239	3.022472	7.22370808	Simkaniaceae	92712	Bacteria	Bacteria	350	6.8e-92	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g35018	i0	92.975	217.732217573222	242	13	100	2	1	239	7114	6874	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	52038	350	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae
13846153	13846153	PRJNA451191_P_NODE_17751_length_343_cov_2.450355_g17480_i0	PRJNA451191	17751	343	2.450355	8.40471765	Simkaniaceae	92712	Bacteria	Bacteria	545	1.22e-150	NTclustered	gi\|124021662\|gb\|EF177461.1\|	420390	g17480	i0	95.614	95.2973760932945	342	12	99	3	2	342	3421	3082	Chlamydiales symbiont of Xenoturbella westbladi 16S ribosomal RNA gene, partial sequence; 23S ribosomal RNA gene, complete sequence; and putative homing endonuclease gene, complete cds	blastn	32687	545	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Chlamydiales symbiont of Xenoturbella westbladi
18944095	18944095	PRJNA451191_P_NODE_16415_length_358_cov_2.622896_g16144_i0	PRJNA451191	16415	358	2.622896	9.38996768	Parachlamydia	83551	Bacteria	Bacteria	436	8.01e-118	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g16144	i0	92.739	121.877094972067	303	20	84	2	57	358	402	703	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	43632	440	0.990909090909091	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
24666976	24666976	PRJNA451191_P_NODE_42060_length_219_cov_2.582278_g41789_i0	PRJNA451191	42060	219	2.582278	5.65518882	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|262409996\|gb\|GU074172.1\|	305355	g41789	i0	100	100.114155251142	219	0	100	0	1	219	392	174	Uncultured Chlamydiae bacterium clone 2H69 16S ribosomal RNA gene, partial sequence	blastn	21925	405	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae 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);;