RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA505329" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJNA505329 · 2 ✖

analysis 1

  • blastn · 2 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
23435724 23435724 PRJNA505329_P_NODE_23859_length_197_cov_3.925676_g23388_i0 PRJNA505329 23859 197 3.925676 7.73358172 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 180 7.499999999999998e-41   NTclustered gi|937513727|gb|CP012850.1| 1353260 g23388 i0 99 14.2842639593909 100 1 98 0 97 196 849303 849402 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 2814 180 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
24709486 24709486 PRJNA505329_P_NODE_44460_length_167_cov_0.881356_g43989_i0 PRJNA505329 44460 167 0.881356 1.47186452 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 270 3.5499999999999993e-68   NTclustered gi|808354332|gb|CP011097.2| 1603555 g43989 i0 96.341 0.982035928143713 164 6 98 0 1 164 1356880 1357043 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 164 270 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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