metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB11748" 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
16399	16399	PRJEB11748_P_NODE_226601_length_262_cov_16.179104_g224418_i0	PRJEB11748	226601	262	16.179104	42.38925248	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	58.4	5.14e-4	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g224418	i0	100	0.118320610687023	31	0	12	0	171	201	424487	424517	Neochlamydia sp. S13 DNA, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
14047219	14047219	PRJEB11748_P_NODE_39152_length_697_cov_13.166667_g37146_i0	PRJEB11748	39152	697	13.166667	91.77166899	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	1171	0	NTclustered	gi\|219857449\|ref\|NR_025037.1\|	112235	g37146	i0	99.231	105.971305595409	650	4	93	1	17	665	89	738	Neochlamydia hartmannellae strain A1Hsp 16S ribosomal RNA, partial sequence	blastn	73862	1171	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
15321730	15321730	PRJEB11748_P_NODE_52033_length_593_cov_221.687970_g49924_i0	PRJEB11748	52033	593	221.68797	1314.6096621	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	658	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g49924	i0	92.144	103.413153456998	471	30	79	5	78	545	654389	654855	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	61324	658	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17869005	17869005	PRJEB11748_P_NODE_272135_length_234_cov_1.479769_g269952_i0	PRJEB11748	272135	234	1.479769	3.46265946	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	427	2.9799999999999993e-115	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g269952	i0	99.573	1	234	1	100	0	1	234	1364064	1364297	Parachlamydia acanthamoebae UV-7, complete genome	blastn	234	427	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
19144163	19144163	PRJEB11748_P_NODE_353476_length_196_cov_2.896296_g351293_i0	PRJEB11748	353476	196	2.896296	5.67674016	Candidatus Fritschea bemisiae	206681	Bacteria	Bacteria	329	6.99e-86	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g351293	i0	98.396	51.9642857142857	187	3	95	0	10	196	6889	7075	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	10185	329	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae

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