RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 5 ✖

bioproject 1

  • PRJEB75230 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
3962828 3962828 PRJEB75230_P_NODE_173624_length_242_cov_0.911243_g173442_i0 PRJEB75230 173624 242 0.911243 2.20520806 Natronomonas moolapensis 416273 Archaea Archaea 99 2.76e-16   NTclustered gi|452081962|emb|HF582854.1| 268739 g173442 i0 84.314 0.421487603305785 102 14 42 2 141 241 1335935 1335835 Natronomonas moolapensis 8.8.11 complete genome blastn 102 99 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
4824204 4824204 PRJEB75230_P_NODE_49124_length_313_cov_1.604167_g48942_i0 PRJEB75230 49124 313 1.604167 5.02104271 root 1 Root_unresolved Root_unresolved 87.9 8.03e-13   NTclustered gi|2388587735|gb|CP113361.1| 2199 g48942 i0 88.732 1.23003194888179 71 8 23 0 194 264 1189421 1189351 Methanogenium organophilum strain DSM 3596 chromosome, complete genome blastn 385 87.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanogenium Methanogenium organophilum
13749554 13749554 PRJEB75230_P_NODE_46511_length_317_cov_1.299180_g46329_i0 PRJEB75230 46511 317 1.29918 4.1184006 root 1 Root_unresolved Root_unresolved 56.5 0.002   NTclustered gi|2324023557|gb|CP109979.1| 2934937 g46329 i0 100 1.12618296529968 30 0 9 0 288 317 1129155 1129184 Halocatena marina strain QDMS1 chromosome, complete genome blastn 357 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halocatena Halocatena marina
19262459 19262459 PRJEB75230_P_NODE_23856_length_369_cov_1.040541_g23674_i0 PRJEB75230 23856 369 1.040541 3.83959629 Halococcus dombrowskii 179637 Archaea Archaea 571 2.1799999999999993e-158   NTclustered gi|2221492933|gb|CP095007.1| 179637 g23674 i0 94.595 148.49864498645 370 19 100 1 1 369 129959 129590 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 54796 571 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
20537466 20537466 PRJEB75230_P_NODE_162437_length_244_cov_0.900585_g162255_i0 PRJEB75230 162437 244 0.900585 2.1974274 Methanosarcina barkeri 2208 Archaea Archaea 52.8 0.022   NTclustered gi|805403216|gb|CP009528.1| 1434108 g162255 i0 94.286 0.14344262295082 35 1 14 1 195 228 1624588 1624622 Methanosarcina barkeri MS, complete genome blastn 35 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina barkeri

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