RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1120586 · 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
2303765 2303765 PRJNA1120586_P_NODE_41162_length_234_cov_0.872727_g40971_i0 PRJNA1120586 41162 234 0.872727 2.04218118 Halobacteriales 2235 Archaea Archaea 355 1.43e-93   NTclustered gi|1279136099|gb|CP024845.1| 1073996 g40971 i0 94.017 40.3418803418803 234 14 100 0 1 234 1938723 1938490 Halohasta litchfieldiae strain tADL chromosome, complete genome blastn 9440 355 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halohasta Halohasta litchfieldiae
4103245 4103245 PRJNA1120586_P_NODE_40844_length_234_cov_1.551515_g40653_i0 PRJNA1120586 40844 234 1.551515 3.6305451 Halopiger xanaduensis 387343 Archaea Archaea 322 1.45e-83   NTclustered gi|335336085|gb|CP002839.1| 797210 g40653 i0 91.453 48.4273504273504 234 20 100 0 1 234 527546 527779 Halopiger xanaduensis SH-6, complete genome blastn 11332 322 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halopiger Halopiger xanaduensis
8681616 8681616 PRJNA1120586_P_NODE_39807_length_235_cov_0.867470_g39616_i0 PRJNA1120586 39807 235 0.86747 2.0385545 Halobacteriales 2235 Archaea Archaea 390 3.93e-104   NTclustered gi|1657695474|gb|CP040331.1| 88724 g39616 i0 96.596 21.9659574468085 235 8 100 0 1 235 22708 22942 Natrinema versiforme strain BOL5-4 plasmid pNVE500 blastn 5162 390 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrinema Natrinema versiforme
14305199 14305199 PRJNA1120586_P_NODE_48152_length_229_cov_0.900000_g47961_i0 PRJNA1120586 48152 229 0.9 2.061 Halorubrum sp. DM2 2527867 Archaea Archaea 128 3.3e-25   NTclustered gi|2474087799|emb|LR594487.1| 2527867 g47961 i0 77.928 9.20524017467249 222 37 92 9 19 229 100860 100640 Halorubrum sp. DM2 isolate Halorubrum diamantensis DM21 genome assembly, chromosome: 1 blastn 2108 128 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. DM2
21953100 21953100 PRJNA1120586_P_NODE_46858_length_230_cov_0.894410_g46667_i0 PRJNA1120586 46858 230 0.89441 2.057143 Haloarcula marina 2961574 Archaea Archaea 91.6 4.35e-14   NTclustered gi|2269702775|gb|CP100404.1| 2961574 g46667 i0 92.188 2.15217391304348 64 5 28 0 167 230 1649096 1649159 Haloarcula marina strain DT1 chromosome, complete genome blastn 495 91.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Haloarcula marina

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