RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA703759 · 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
3736700 3736700 PRJNA703759_P_NODE_38723_length_250_cov_0.881356_g38247_i0 PRJNA703759 38723 250 0.881356 2.20339 Haladaptatus 367188 Archaea Archaea 108 4.76e-19   NTclustered gi|2471356508|gb|CP120470.1| 3032580 g38247 i0 82.927 1.916 123 18 49 1 1 123 292142 292023 Haladaptatus sp. DYSN1 chromosome, complete genome blastn 479 108 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Haladaptatus Haladaptatus sp. DYSN1
19036724 19036724 PRJNA703759_P_NODE_35875_length_252_cov_0.871508_g35399_i0 PRJNA703759 35875 252 0.871508 2.19620016 Haladaptatus 367188 Archaea Archaea 52.8 0.023   NTclustered gi|2471356512|gb|CP120472.1| 3032580 g35399 i0 100 0.333333333333333 28 0 11 0 215 242 499684 499711 Haladaptatus sp. DYSN1 plasmid unnamed2, complete sequence blastn 84 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Haladaptatus Haladaptatus sp. DYSN1
19811503 19811503 PRJNA703759_P_NODE_39976_length_249_cov_0.886364_g39500_i0 PRJNA703759 39976 249 0.886364 2.20704636 Halalkalicoccus jeotgali 413810 Archaea Archaea 52.8 0.023   NTclustered gi|299123054|gb|CP002062.1| 795797 g39500 i0 96.875 0.1285140562249 32 0 12 1 2 32 2173963 2173994 Halalkalicoccus jeotgali B3, complete genome blastn 32 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
22361850 22361850 PRJNA703759_P_NODE_40878_length_249_cov_0.886364_g40402_i0 PRJNA703759 40878 249 0.886364 2.20704636 Haloplanus sp. GX21 3127120 Archaea Archaea 263 9.56e-66   NTclustered gi|2700851762|gb|CP147874.1| 3127120 g40402 i0 90.547 3.49397590361446 201 16 80 3 52 249 650801 650601 Haloplanus sp. GX21 chromosome, complete genome blastn 870 263 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus sp. GX21
23637131 23637131 PRJNA703759_P_NODE_24979_length_285_cov_1.396226_g24503_i0 PRJNA703759 24979 285 1.396226 3.9792441 Halalkalicoccus jeotgali 413810 Archaea Archaea 222 1.9e-53   NTclustered gi|299123054|gb|CP002062.1| 795797 g24503 i0 80.836 1.00701754385965 287 51 100 4 1 285 1842812 1843096 Halalkalicoccus jeotgali B3, complete genome blastn 287 222 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali

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