metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax

4 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
3950708	3950708	PRJEB58983_P_NODE_11504_length_371_cov_2.956376_g11089_i0	PRJEB58983	11504	371	2.956376	10.96815496	Estrella lausannensis	483423	Bacteria	Bacteria	174	7.22e-39	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g11089	i0	86.624	99.1320754716981	157	21	42	0	72	228	2446	2290	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	36778	174	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
4820067	4820067	PRJEB58983_P_NODE_24904_length_265_cov_2.822917_g24489_i0	PRJEB58983	24904	265	2.822917	7.48073005	Candidatus Rhabdochlamydia	292833	Bacteria	Bacteria	206	1.76e-48	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g24489	i0	84.906	13.9509433962264	212	23	78	8	1	208	1019605	1019399	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	3697	206	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
9051953	9051953	PRJEB58983_P_NODE_15508_length_325_cov_1.166667_g15093_i0	PRJEB58983	15508	325	1.166667	3.79166775	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	427	4.339999999999999e-115	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g15093	i0	90.462	51.9446153846154	325	29	100	2	1	325	1250733	1250411	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	16882	427	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25218158	25218158	PRJEB58983_P_NODE_16700_length_314_cov_2.078838_g16285_i0	PRJEB58983	16700	314	2.078838	6.52755132	Simkaniaceae	92712	Bacteria	Bacteria	359	1.55e-94	NTclustered	gi\|5042360\|gb\|U68460.2\|SSU68460	83561	g16285	i0	87.342	127.62101910828	316	36	100	4	1	314	4998	4685	Simkania negevensis 16S and 23S ribosomal RNA operon, complete sequence; and putative endonuclease homodimer gene, complete cds	blastn	40073	361	0.994459833795014	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis

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