RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA421571" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA421571 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1698771 1698771 PRJNA421571_P_NODE_74662_length_290_cov_1.414747_g72113_i0 PRJNA421571 74662 290 1.414747 4.1027663 Halorubrum ruber 2982524 Archaea Archaea 110 1.5700000000000001e-19   NTclustered gi|2031421124|gb|CP073695.1| 2982524 g72113 i0 83.333 4.0551724137931 126 14 42 7 165 286 2452235 2452357 Halorubrum ruber strain MBLA0099 chromosome, complete genome blastn 1176 110 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum ruber
2972638 2972638 PRJNA421571_P_NODE_108383_length_201_cov_4.812500_g105834_i0 PRJNA421571 108383 201 4.8125 9.673125 Haloplanus halophilus 2949993 Archaea Archaea 52.8 0.017   NTclustered gi|2252468249|gb|CP098514.1| 2949993 g105834 i0 100 0.139303482587065 28 0 14 0 160 187 1816079 1816106 Haloplanus sp. GDY1 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus halophilus
18936839 18936839 PRJNA421571_P_NODE_15535_length_940_cov_1.662053_g13571_i0 PRJNA421571 15535 940 1.662053 15.6232982 Halobacteriales 2235 Archaea Archaea 54.7 0.026   NTclustered gi|1526250537|gb|CP034145.1| 660522 g13571 i0 100 0.0617021276595745 29 0 3 0 488 516 1363964 1363992 Haloplanus aerogenes strain JCM 16430 chromosome, complete genome blastn 58 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus aerogenes
23374007 23374007 PRJNA421571_P_NODE_102919_length_243_cov_1.694118_g100370_i0 PRJNA421571 102919 243 1.694118 4.11670674 Thermococcus barossii 54077 Archaea Archaea 54.7 0.006   NTclustered gi|1214547877|gb|CP015101.1| 54077 g100370 i0 100 0.119341563786008 29 0 12 0 212 240 1149745 1149773 Thermococcus barossii strain SHCK-94 chromosome, complete genome blastn 29 54.7 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus barossii

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