RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 6 ✖

bioproject 1

  • PRJNA688655 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27271895 27271895 PRJNA688655_P_NODE_3243_length_338_cov_1.298113_g3178_i0 PRJNA688655 3243 338 1.298113 4.38762194 Nitrosopumilus sp. B 2024843 Archaea Archaea 44.3 0.00365   NR RNJ79202.1 2478553 g3178 i0 28.6 1.36686390532544 77 42 68.3 1 63 293 4 67 RNJ79202.1 MAG: hypothetical protein D9C04_05545 [Nitrosopumilus sp. B06] diamond 462 44.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp. B06
29387637 29387637 PRJNA688655_P_NODE_8789_length_250_cov_0.870056_g8724_i0 PRJNA688655 8789 250 0.870056 2.17514 Sulfolobaceae archaeon 2967306 Archaea Archaea 76.3 4.44e-16   NR MEM0174284.1 2967306 g8724 i0 58.7 0.756 63 26 75.6 0 3 191 20 82 MEM0174284.1 hypothetical protein [Sulfolobaceae archaeon] diamond 189 76.3 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
29987514 29987514 PRJNA688655_P_NODE_9951_length_249_cov_0.875000_g9886_i0 PRJNA688655 9951 249 0.875 2.17875 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 155 2.29e-42   NR MBL7079898.1 2026714 g9886 i0 89.2 3 83 9 100 0 1 249 119 201 MBL7079898.1 beta-CASP ribonuclease aCPSF1 [Candidatus Bathyarchaeota archaeon] diamond 747 155 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
31694096 31694096 PRJNA688655_P_NODE_14597_length_243_cov_0.905882_g14532_i0 PRJNA688655 14597 243 0.905882 2.20129326 Candidatus Bathyarchaeota archaeon A05DMB-2 2709783 Archaea Archaea 152 1.0399999999999997e-42   NR MBT0158588.1 2709783 g14532 i0 85 0.987654320987654 80 12 98.8 0 241 2 166 245 MBT0158588.1 glycosyltransferase family 2 protein [Candidatus Bathyarchaeota archaeon A05DMB-2] diamond 240 152 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon A05DMB-2
32453747 32453747 PRJNA688655_P_NODE_9819_length_249_cov_0.875000_g9754_i0 PRJNA688655 9819 249 0.875 2.17875 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 53.9 2.4e-6   NR MDT8781863.1 2026714 g9754 i0 96.6 0.349397590361446 29 1 34.9 0 247 161 179 207 MDT8781863.1 30S ribosomal protein S3ae [Candidatus Bathyarchaeota archaeon] diamond 87 53.9 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
32674212 32674212 PRJNA688655_P_NODE_10740_length_248_cov_0.880000_g10675_i0 PRJNA688655 10740 248 0.88 2.1824 Candidatus Bathyarchaeum tardum 3042151 Archaea Archaea 137 1.48e-35   NR WGM88650.1 3042151 g10675 i0 81.7 0.991935483870968 82 15 99.2 0 246 1 351 432 WGM88650.1 MAG: PQQ-binding-like beta-propeller repeat protein [Candidatus Bathyarchaeum tardum] diamond 246 137 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia Candidatus Bathyarchaeales Candidatus Bathyarchaeaceae Candidatus Bathyarchaeum Candidatus Bathyarchaeum tardum

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