RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB14803 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
21454 21454 PRJEB14803_P_NODE_22521_length_239_cov_1.470588_g22055_i0 PRJEB14803 22521 239 1.470588 3.51470532 Halobacterium hubeiense 1407499 Archaea Archaea 54.7 0.006   NTclustered gi|966204314|emb|LN831302.1| 1407499 g22055 i0 100 0.121338912133891 29 0 12 0 42 70 122258 122286 Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I blastn 29 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium hubeiense
1295694 1295694 PRJEB14803_P_NODE_36682_length_175_cov_1.121429_g36216_i0 PRJEB14803 36682 175 1.121429 1.96250075 Natronococcus zhouii 2951804 Archaea Archaea 54.7 0.004   NTclustered gi|2259612910|gb|CP099391.1| 2951804 g36216 i0 96.875 0.182857142857143 32 1 18 0 120 151 3793030 3793061 Natronococcus zhouii strain CG52 chromosome, complete genome blastn 32 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus zhouii
5123808 5123808 PRJEB14803_P_NODE_20325_length_256_cov_1.968326_g19859_i0 PRJEB14803 20325 256 1.968326 5.03891456 Natronomonas marina 2961939 Archaea Archaea 65.8 2.99e-6   NTclustered gi|2273574514|gb|CP101154.1| 2961939 g19859 i0 93.182 0.390625 44 3 17 0 13 56 2308486 2308529 Natronomonas marina strain ZY43 chromosome, complete genome blastn 100 65.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas marina
11499531 11499531 PRJEB14803_P_NODE_3810_length_724_cov_2.506531_g3450_i0 PRJEB14803 3810 724 2.506531 18.14728444 uncultured Methanoregulaceae archaeon 1392423 Archaea Archaea 58.4 0.002   NTclustered gi|2874254037|emb|OY970361.1| 1392423 g3450 i0 92.683 0.102209944751381 41 2 6 1 447 487 589713 589674 MAG: uncultured Methanoregulaceae archaeon isolate MFD01476.bin.2.40 genome assembly, chromosome: 1 blastn 74 58.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   uncultured Methanoregulaceae archaeon
21698076 21698076 PRJEB14803_P_NODE_17278_length_285_cov_1.744000_g16812_i0 PRJEB14803 17278 285 1.744 4.9704 Halogeometricum borinquense 60847 Archaea Archaea 52.8 0.026   NTclustered gi|1810666233|gb|CP048739.1| 60847 g16812 i0 100 0.0982456140350877 28 0 10 0 48 75 1622897 1622924 Halogeometricum borinquense strain wsp4 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halogeometricum Halogeometricum borinquense
21698112 21698112 PRJEB14803_P_NODE_23138_length_234_cov_3.261307_g22672_i0 PRJEB14803 23138 234 3.261307 7.63145838 Salinilacihabitans rarus 2961596 Archaea Archaea 75 4.47e-9   NTclustered gi|2273363716|gb|CP100762.1| 2961596 g22672 i0 95.652 14.9786324786325 46 2 20 0 16 61 2579002 2579047 Salinilacihabitans rarus strain AD-4 chromosome, complete genome blastn 3505 75 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Salinilacihabitans Salinilacihabitans rarus
24247279 24247279 PRJEB14803_P_NODE_28220_length_206_cov_1.280702_g27754_i0 PRJEB14803 28220 206 1.280702 2.63824612 Thermococcus profundus 49899 Archaea Archaea 56.5 0.001   NTclustered gi|1214545799|gb|CP014862.1| 49899 g27754 i0 89.362 0.228155339805825 47 1 22 3 98 142 838812 838856 Thermococcus profundus strain DT 5432, complete genome blastn 47 56.5 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus profundus

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