RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB7799" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB7799 · 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
25526595 25526595 PRJEB7799c_S_NODE_24681_length_158_cov_2.162602_g24658_i0 PRJEB7799 24681 158 2.162602 3.41691116 uncultured Methanoregula sp. 1005933 Archaea Archaea 248 1.55e-61   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g24658 i0 96.053 98.7215189873418 152 6 96 0 7 158 3171518 3171367 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 15598 248 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
25527148 25527148 PRJEB7799g_S_NODE_321_length_468_cov_62.115473_g110_i0 PRJEB7799 321 468 62.115473 290.70041364 uncultured Methanoregula sp. 1005933 Archaea Archaea 329 1.88e-85   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g110 i0 87.5 391.938034188034 296 23 94 13 178 468 3117912 3118198 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 183427 329 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
25662439 25662439 PRJEB7799a_S_NODE_9738_length_185_cov_4.420000_g9703_i0 PRJEB7799 9738 185 4.42 8.177 Methanobacteriota archaeon 2026739 Archaea Archaea 135 1.5200000000000002e-27   NTclustered gi|2874253869|emb|OY969924.1| 2026739 g9703 i0 82.278 51.6702702702703 158 26 85 2 3 159 43408 43564 MAG: Euryarchaeota archaeon isolate MFD04492.bin.2.48 genome assembly, chromosome: 1 blastn 9559 135 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
25801253 25801253 PRJEB7799p_S_NODE_3699_length_260_cov_5.542222_g3676_i0 PRJEB7799 3699 260 5.542222 14.4097772 uncultured Methanoregula sp. 1005933 Archaea Archaea 381 2.659999999999999e-101   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g3676 i0 93.103 100.088461538462 261 16 100 2 1 260 3171623 3171364 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 26023 381 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
26569144 26569144 PRJEB7799i_S_NODE_3824_length_234_cov_45.567839_g3794_i0 PRJEB7799 3824 234 45.567839 106.62874326 root 1 Root_unresolved Root_unresolved 147 9.34e-31   NTclustered gi|2515741548|gb|CP117271.1| 2209 g3794 i0 98.795 35.8247863247863 83 0 35 1 130 212 3941607 3941526 Mutant Methanosarcina mazei strain Mm Mut 208, complete genome blastn 8383 147 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina mazei

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