RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 7 ✖

bioproject 1

  • PRJNA605033 · 7 ✖

analysis 1

  • diamond · 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
22823179 22823179 PRJNA605033_P_NODE_718_length_2342_cov_8.273082_g151_i0 PRJNA605033 718 2342 8.273082 193.75558044 root 1 Root_unresolved Root_unresolved 451 4.2599999999999984e-148   NR MCI0556924.1 1971748 g151 i0 54.6 7.47181895815542 441 192 56 4 325 1635 17 453 MCI0556924.1 IS110 family transposase [Nitrososphaera sp.] diamond 17499 454 0.993392070484581 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
26636772 26636772 PRJNA605033_P_NODE_117241_length_222_cov_1.652406_g115672_i0 PRJNA605033 117241 222 1.652406 3.66834132 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 55.1 1.23e-6   NR MDW3611325.1 2169593 g115672 i0 100 0.648648648648649 24 0 32.4 0 149 220 282 305 MDW3611325.1 type I glutamate--ammonia ligase [Nitrososphaeraceae archaeon] diamond 144 55.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27396342 27396342 PRJNA605033_P_NODE_77843_length_222_cov_2.604278_g76274_i0 PRJNA605033 77843 222 2.604278 5.78149716 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 50.1 8.79e-6   NR HEX5977788.1 2169593 g76274 i0 100 0.648648648648649 24 0 32.4 0 220 149 69 92 HEX5977788.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 144 50.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27869582 27869582 PRJNA605033_P_NODE_158365_length_187_cov_4.151316_g156796_i0 PRJNA605033 158365 187 4.151316 7.76296092 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 63.5 1.83e-11   NR HZA64091.1 2169593 g156796 i0 82.9 0.561497326203209 35 6 56.1 0 45 149 42 76 HZA64091.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 105 63.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28924711 28924711 PRJNA605033_P_NODE_141988_length_202_cov_1.802395_g140419_i0 PRJNA605033 141988 202 1.802395 3.6408379 root 1 Root_unresolved Root_unresolved 94 4.569999999999999e-23   NR MCI0562201.1 1971748 g140419 i0 84.9 1.57425742574257 53 8 78.7 0 4 162 53 105 MCI0562201.1 fluoride efflux transporter CrcB [Nitrososphaera sp.] diamond 318 94 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31547191 31547191 PRJNA605033_P_NODE_26656_length_290_cov_1.635294_g25094_i0 PRJNA605033 26656 290 1.635294 4.7423526 root 1 Root_unresolved Root_unresolved 55.8 1.61e-6   NR TRO47018.1 2026714 g25094 i0 55.8 2.23448275862069 43 19 44.5 0 4 132 423 465 TRO47018.1 HAD family hydrolase, partial [Candidatus Bathyarchaeota archaeon] diamond 648 55.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
32892524 32892524 PRJNA605033_P_NODE_228780_length_155_cov_4.200000_g227211_i0 PRJNA605033 228780 155 4.2 6.51 Nitrosopumilus ureiphilus 1470067 Archaea Archaea 44.3 0.00321   NR WP_179372584.1 1470067 g227211 i0 53.6 2.12903225806452 28 13 54.2 0 1 84 439 466 WP_179372584.1 serpin family protein [Nitrosopumilus ureiphilus] diamond 330 44.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus ureiphilus

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