RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

  • Archaea · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA695140 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
6285480 6285480 PRJNA695140_S_NODE_10525_length_165_cov_1.492188_g10344_i0 PRJNA695140 10525 165 1.492188 2.4621102 Thermoproteati 1783275 Archaea Archaea 303 3.45e-78   NTclustered gi|22797874|emb|AJ496176.1| 29281 g10344 i0 100 89.4787878787879 164 0 99 0 2 165 8135 8298 Uncultured crenarchaeote 34 kb genomic fragment blastn 14764 305 0.99344262295082 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
13935550 13935550 PRJNA695140_S_NODE_7871_length_188_cov_3.874172_g7690_i0 PRJNA695140 7871 188 3.874172 7.28344336 root 1 Root_unresolved Root_unresolved 348 1.84e-91   NTclustered gi|66794785|emb|AJ831065.1| 13776 g7690 i0 100 100 188 0 100 0 1 188 436 623 Unidentified archaeon partial 16S rRNA gene, clone 257 blastn 18800 348 1 Archaea               unidentified archaeon
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
24133345 24133345 PRJNA695140_S_NODE_11359_length_159_cov_2.918033_g11178_i0 PRJNA695140 11359 159 2.918033 4.63967247 root 1 Root_unresolved Root_unresolved 294 1.98e-75   NTclustered gi|373125855|gb|JN567036.1| 29281 g11178 i0 100 102 159 0 100 0 1 159 771 613 Uncultured crenarchaeote clone DDOUBD11 16S ribosomal RNA gene, partial sequence blastn 16218 294 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote

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