RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA695140", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Nitrososphaerota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA695140 · 4 ✖

analysis 1

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
17253911 17253911 PRJNA695140_S_NODE_1734_length_401_cov_4.153846_g1553_i0 PRJNA695140 1734 401 4.153846 16.65692246 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 736 0   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g1553 i0 99.751 37.785536159601 401 1 100 0 1 401 1791337 1790937 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 15152 736 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
17253936 17253936 PRJNA695140_S_NODE_414_length_904_cov_5.011534_g280_i0 PRJNA695140 414 904 5.011534 45.30426736 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 1670 0   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g280 i0 100 87.0309734513274 904 0 100 0 1 904 1789847 1790750 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 78676 1670 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
22353416 22353416 PRJNA695140_S_NODE_3278_length_289_cov_2.503968_g3097_i0 PRJNA695140 3278 289 2.503968 7.23646752 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 529 1.01e-145   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g3097 i0 99.654 159.602076124567 289 1 100 0 1 289 1789449 1789737 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 46125 529 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
22353475 22353475 PRJNA695140_S_NODE_9098_length_176_cov_1.697842_g8917_i0 PRJNA695140 9098 176 1.697842 2.98820192 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 326 7.92e-85   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g8917 i0 100 34.2840909090909 176 0 100 0 1 176 1791570 1791395 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 6034 326 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola

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