RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120060 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
237650 237650 PRJNA1120060_P_NODE_1420401_length_297_cov_2.754464_g1402419_i0 PRJNA1120060 1420401 297 2.754464 8.18075808 Fervidicoccus fontis 683846 Archaea Archaea 54.7 0.008   NTclustered gi|383794914|gb|CP003423.1| 1163730 g1402419 i0 100 0.0976430976430976 29 0 10 0 115 143 1100159 1100187 Fervidicoccus fontis Kam940, complete genome blastn 29 54.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Fervidicoccales Fervidicoccaceae Fervidicoccus Fervidicoccus fontis
4084713 4084713 PRJNA1120060_P_NODE_2976284_length_242_cov_0.917160_g2958190_i0 PRJNA1120060 2976284 242 0.91716 2.2195272 Saccharolobus sp. E5-1-F 2663019 Archaea Archaea 52.8 0.022   NTclustered gi|1772811436|gb|CP045687.1| 2663019 g2958190 i0 96.875 0.132231404958678 32 0 13 1 174 204 18052 18021 Saccharolobus sp. E5-1-F chromosome, complete genome blastn 32 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Saccharolobus Saccharolobus sp. E5-1-F
4089847 4089847 PRJNA1120060_P_NODE_3416744_length_214_cov_6.652482_g3398622_i0 PRJNA1120060 3416744 214 6.652482 14.23631148 Saccharolobus solfataricus 2287 Archaea Archaea 52.8 0.019   NTclustered gi|1496296112|gb|CP011055.2| 2287 g3398622 i0 100 1.57009345794393 28 0 13 0 165 192 1398679 1398652 Saccharolobus solfataricus strain SARC-B chromosome, complete genome blastn 336 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Saccharolobus Saccharolobus solfataricus
5356875 5356875 PRJNA1120060_P_NODE_2602445_length_251_cov_0.876404_g2584368_i0 PRJNA1120060 2602445 251 0.876404 2.19977404 Acidianus manzaensis 282676 Archaea Archaea 52.8 0.023   NTclustered gi|1188286313|gb|CP020477.1| 282676 g2584368 i0 100 0.111553784860558 28 0 11 0 2 29 1021997 1022024 Acidianus manzaensis strain YN-25 chromosome, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Acidianus Acidianus manzaensis
10451695 10451695 PRJNA1120060_P_NODE_2186729_length_265_cov_3.187500_g2168677_i0 PRJNA1120060 2186729 265 3.1875 8.446875 Pyrobaculum arsenaticum 121277 Archaea Archaea 52.8 0.024   NTclustered gi|145282035|gb|CP000660.1| 340102 g2168677 i0 100 0.105660377358491 28 0 11 0 236 263 1992065 1992092 Pyrobaculum arsenaticum DSM 13514, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum arsenaticum
13778973 13778973 PRJNA1120060_P_NODE_1722271_length_284_cov_1.758294_g1704265_i0 PRJNA1120060 1722271 284 1.758294 4.99355496 Saccharolobus 2100760 Archaea Archaea 52.8 0.026   NTclustered gi|284444302|gb|CP001731.1| 425944 g1704265 i0 100 0.492957746478873 28 0 10 0 240 267 288836 288863 Sulfolobus islandicus L.D.8.5, complete genome blastn 140 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Saccharolobus Saccharolobus islandicus
14295456 14295456 PRJNA1120060_P_NODE_471032_length_372_cov_4.003344_g453462_i0 PRJNA1120060 471032 372 4.003344 14.89243968 Fervidicoccus fontis 683846 Archaea Archaea 52.8 0.035   NTclustered gi|383794914|gb|CP003423.1| 1163730 g453462 i0 100 0.0752688172043011 28 0 8 0 44 71 1100187 1100160 Fervidicoccus fontis Kam940, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Fervidicoccales Fervidicoccaceae Fervidicoccus Fervidicoccus fontis
15541226 15541226 PRJNA1120060_P_NODE_1477993_length_294_cov_3.407240_g1460006_i0 PRJNA1120060 1477993 294 3.40724 10.0172856 Fervidicoccus fontis 683846 Archaea Archaea 52.8 0.027   NTclustered gi|383794914|gb|CP003423.1| 1163730 g1460006 i0 100 0.0952380952380952 28 0 10 0 262 289 1100186 1100159 Fervidicoccus fontis Kam940, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Fervidicoccales Fervidicoccaceae Fervidicoccus Fervidicoccus fontis
23207931 23207931 PRJNA1120060_P_NODE_2773459_length_246_cov_6.635838_g2755373_i0 PRJNA1120060 2773459 246 6.635838 16.32416148 Acidianus manzaensis 282676 Archaea Archaea 52.8 0.022   NTclustered gi|1188286313|gb|CP020477.1| 282676 g2755373 i0 100 0.113821138211382 28 0 11 0 102 129 513533 513560 Acidianus manzaensis strain YN-25 chromosome, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Acidianus Acidianus manzaensis
24470038 24470038 PRJNA1120060_P_NODE_1863480_length_278_cov_2.273171_g1845464_i0 PRJNA1120060 1863480 278 2.273171 6.31941538 Stygiolobus azoricus 41675 Archaea Archaea 52.8 0.026   NTclustered gi|1780179925|gb|CP045483.1| 41675 g1845464 i0 100 0.100719424460432 28 0 10 0 43 70 1367323 1367350 Stygiolobus azoricus strain FC6 chromosome, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Stygiolobus Stygiolobus azoricus

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