RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA635397" 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 · 4 ✖

bioproject 1

  • PRJNA635397 · 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
8806664 8806664 PRJNA635397_P_NODE_36627_length_261_cov_1.728723_g36173_i0 PRJNA635397 36627 261 1.728723 4.51196703 Halococcus 2249 Archaea Archaea 422 1.57e-113   NTclustered gi|2221492933|gb|CP095007.1| 179637 g36173 i0 96.825 115.48275862069 252 8 97 0 1 252 129394 129645 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 30141 422 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
15182189 15182189 PRJNA635397_P_NODE_41872_length_248_cov_1.537143_g41418_i0 PRJNA635397 41872 248 1.537143 3.81211464 Halobacteriales 2235 Archaea Archaea 453 5.2600000000000005e-123   NTclustered gi|1675274120|gb|MN000396.1| 2250 g41418 i0 99.597 99.991935483871 248 1 100 0 1 248 674 427 Halococcus morrhuae strain FMK1005 16S ribosomal RNA gene, partial sequence blastn 24798 453 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus morrhuae
15908717 15908717 PRJNA635397_P_NODE_37533_length_258_cov_1.216216_g37079_i0 PRJNA635397 37533 258 1.216216 3.13783728 Halococcus qingdaonensis 224402 Archaea Archaea 462 9.15e-126   NTclustered gi|2281256326|gb|CP101943.1| 224402 g37079 i0 99.219 141.558139534884 256 2 99 0 3 258 2647230 2646975 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 36522 462 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
22831077 22831077 PRJNA635397_P_NODE_18418_length_379_cov_1.379085_g17964_i0 PRJNA635397 18418 379 1.379085 5.22673215 Halobacteriales 2235 Archaea Archaea 645 1.3e-180   NTclustered gi|1675273619|gb|MN000379.1| 29286 g17964 i0 97.361 97.8311345646438 379 10 100 0 1 379 1 379 Halococcus sp. strain IMK087 16S ribosomal RNA gene, partial sequence blastn 37078 645 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus 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);;