RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

bioproject 1

  • PRJNA1063685 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
11215627 11215627 PRJNA1063685_S_NODE_9789_length_632_cov_3.652952_g9277_i0 PRJNA1063685 9789 632 3.652952 23.08665664 Halalkalicoccus 332246 Archaea Archaea 1092 0   NTclustered gi|507148368|ref|NR_103171.1| 413810 g9277 i0 99.015 177.92246835443 609 6 96 0 24 632 631 1239 Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence blastn 112447 1092 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
11657963 11657963 PRJNA1063685_S_NODE_1970_length_909_cov_12.052632_g1640_i0 PRJNA1063685 1970 909 12.052632 109.55842488 Halococcus qingdaonensis 224402 Archaea Archaea 1513 0   NTclustered gi|2281256326|gb|CP101943.1| 224402 g1640 i0 97.216 133.832783278328 898 18 98 5 17 909 2644652 2645547 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 121654 1513 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
14208136 14208136 PRJNA1063685_S_NODE_24652_length_468_cov_29.486076_g24112_i0 PRJNA1063685 24652 468 29.486076 137.99483568 Halococcus qingdaonensis 224402 Archaea Archaea 797 0   NTclustered gi|2281256326|gb|CP101943.1| 224402 g24112 i0 98.879 138.655982905983 446 5 95 0 1 446 2647109 2646664 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 64891 797 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
18031490 18031490 PRJNA1063685_S_NODE_62595_length_271_cov_4.242424_g62052_i0 PRJNA1063685 62595 271 4.242424 11.49696904 Methanobrevibacter arboriphilus 39441 Archaea Archaea 52.8 0.025   NTclustered gi|2047640843|dbj|AP019779.1| 39441 g62052 i0 100 0.103321033210332 28 0 10 0 166 193 1215031 1215058 Methanobrevibacter arboriphilus SA DNA, complete genome blastn 28 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter arboriphilus
21413968 21413968 PRJNA1063685_S_NODE_33677_length_404_cov_6.117825_g33135_i0 PRJNA1063685 33677 404 6.117825 24.716013 Halalkalicoccus 332246 Archaea Archaea 638 2.3399999999999996e-178   NTclustered gi|507148368|ref|NR_103171.1| 413810 g33135 i0 96.85 134.920792079208 381 12 94 0 1 381 383 3 Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence blastn 54508 641 0.995319812792512 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
22689008 22689008 PRJNA1063685_S_NODE_75158_length_238_cov_4.096970_g74615_i0 PRJNA1063685 75158 238 4.09697 9.7507886 Halococcus 2249 Archaea Archaea 440 3.899999999999999e-119   NTclustered gi|43626|emb|X05481.1| 2250 g74615 i0 100 161.852941176471 238 0 100 0 1 238 2859 2622 Halococcus morrhuae 23S ribosomal RNA blastn 38521 440 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus morrhuae

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