RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA630162 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
27017427 27017427 PRJNA630162_P_NODE_27622_length_346_cov_1.868687_g26100_i0 PRJNA630162 27622 346 1.868687 6.46565702 Nitrososphaerota archaeon 2026795 Archaea Archaea 187 1.7399999999999998e-56   NR MDG6999169.1 2026795 g26100 i0 80.2 0.96242774566474 111 22 96.2 0 338 6 106 216 MDG6999169.1 hypothetical protein [Nitrososphaerota archaeon] diamond 333 187 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
27630678 27630678 PRJNA630162_P_NODE_76784_length_205_cov_2.525641_g75261_i0 PRJNA630162 76784 205 2.525641 5.17756405 root 1 Root_unresolved Root_unresolved 108 6.78e-27   NR MDG6999169.1 2026795 g75261 i0 78.1 1.88780487804878 64 14 93.7 0 196 5 37 100 MDG6999169.1 hypothetical protein [Nitrososphaerota archaeon] diamond 387 108 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28312477 28312477 PRJNA630162_P_NODE_126866_length_171_cov_1.426230_g125343_i0 PRJNA630162 126866 171 1.42623 2.4388533 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 48.5 4.97e-5   NR HEY9491080.1 2169593 g125343 i0 95 1.05263157894737 20 1 35.1 0 3 62 132 151 HEY9491080.1 anti-sigma factor [Nitrososphaeraceae archaeon] diamond 180 48.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28375443 28375443 PRJNA630162_P_NODE_116366_length_176_cov_2.007874_g114843_i0 PRJNA630162 116366 176 2.007874 3.53385824 Nitrososphaera sp. 1971748 Archaea Archaea 59.3 1.33e-8   NR HEY1248642.1 1971748 g114843 i0 52.8 0.903409090909091 53 25 90.3 0 169 11 36 88 HEY1248642.1 peptidoglycan-binding domain-containing protein [Nitrososphaera sp.] diamond 159 59.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
28754564 28754564 PRJNA630162_P_NODE_79427_length_202_cov_1.326797_g77904_i0 PRJNA630162 79427 202 1.326797 2.68012994 Nitrososphaerota archaeon 2026795 Archaea Archaea 88.2 9.31e-20   NR MDG6999171.1 2026795 g77904 i0 70.2 2.62871287128713 57 17 84.7 0 5 175 22 78 MDG6999171.1 hypothetical protein [Nitrososphaerota archaeon] diamond 531 88.2 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28849021 28849021 PRJNA630162_P_NODE_29208_length_335_cov_3.356643_g27686_i0 PRJNA630162 29208 335 3.356643 11.24475405 Nitrososphaerota archaeon 2026795 Archaea Archaea 87.4 4.68e-19   NR MDG6999173.1 2026795 g27686 i0 40.6 0.949253731343284 106 58 93.1 2 13 324 40 142 MDG6999173.1 hypothetical protein [Nitrososphaerota archaeon] diamond 318 87.4 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29051517 29051517 PRJNA630162_P_NODE_139568_length_167_cov_0.881356_g138045_i0 PRJNA630162 139568 167 0.881356 1.47186452 root 1 Root_unresolved Root_unresolved 107 2.9100000000000003e-27   NR RPI85150.1 2026768 g138045 i0 84.9 2.8562874251497 53 8 95.2 0 7 165 42 94 RPI85150.1 MAG: 2'-5' RNA ligase [Nitrosopumilales archaeon] diamond 477 108 0.990740740740741 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
29417418 29417418 PRJNA630162_P_NODE_25469_length_362_cov_2.626198_g23949_i0 PRJNA630162 25469 362 2.626198 9.50683676 Nitrosarchaeum sp. 2026886 Archaea Archaea 63.5 1.41e-10   NR PHY08285.1 2026886 g23949 i0 59 1.0524861878453 61 24 49.7 1 283 104 11 71 PHY08285.1 MAG: hydrolase [Nitrosarchaeum sp.] diamond 381 63.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
30206930 30206930 PRJNA630162_P_NODE_78012_length_204_cov_1.006452_g76489_i0 PRJNA630162 78012 204 1.006452 2.05316208 Nitrososphaerota archaeon 2026795 Archaea Archaea 119 9.5e-31   NR MDG6999169.1 2026795 g76489 i0 81.8 0.970588235294118 66 12 97.1 0 7 204 27 92 MDG6999169.1 hypothetical protein [Nitrososphaerota archaeon] diamond 198 119 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
30744155 30744155 PRJNA630162_P_NODE_104154_length_183_cov_1.552239_g102631_i0 PRJNA630162 104154 183 1.552239 2.84059737 Nitrososphaerota archaeon 2026795 Archaea Archaea 81.6 1.17e-16   NR MDG6999169.1 2026795 g102631 i0 66.7 1.9672131147541 60 20 98.4 0 182 3 59 118 MDG6999169.1 hypothetical protein [Nitrososphaerota archaeon] diamond 360 81.6 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31850666 31850666 PRJNA630162_P_NODE_161737_length_162_cov_0.920354_g160214_i0 PRJNA630162 161737 162 0.920354 1.49097348 Nitrosarchaeum sp. 2026886 Archaea Archaea 42.7 0.00922   NR MFB5622745.1 2026886 g160214 i0 47.7 0.814814814814815 44 20 81.5 2 149 18 28 68 MFB5622745.1 hypothetical protein [Nitrosarchaeum sp.] diamond 132 42.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
32357267 32357267 PRJNA630162_P_NODE_156339_length_163_cov_0.912281_g154816_i0 PRJNA630162 156339 163 0.912281 1.48701803 Nitrosarchaeum sp. 2026886 Archaea Archaea 92 5.46e-20   NR TAK26648.1 2026886 g154816 i0 86.3 0.938650306748466 51 7 93.9 0 154 2 494 544 TAK26648.1 MAG: hypothetical protein EPO37_01360, partial [Nitrosarchaeum sp.] diamond 153 92 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.

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