RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA703759" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA703759 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
4512388 4512388 PRJNA703759_P_NODE_26584_length_279_cov_1.058252_g26108_i0 PRJNA703759 26584 279 1.058252 2.95252308 Methanococcus maripaludis 39152 Archaea Archaea 58.4 5.52e-4   NTclustered gi|1342459100|gb|CP026606.1| 39152 g26108 i0 94.737 0.136200716845878 38 1 14 1 101 138 324531 324495 Methanococcus maripaludis strain DSM 2067 chromosome, complete genome blastn 38 58.4 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanococcaceae Methanococcus Methanococcus maripaludis
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
22361456 22361456 PRJNA703759_P_NODE_24178_length_288_cov_1.418605_g23702_i0 PRJNA703759 24178 288 1.418605 4.0855824 Methanobacterium sp. ACI-7 3240853 Archaea Archaea 52.8 0.027   NTclustered gi|2904246484|gb|CP166866.1| 3240853 g23702 i0 100 0.0972222222222222 28 0 10 0 181 208 1982143 1982170 Methanobacterium sp. ACI-7 chromosome, complete genome blastn 28 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. ACI-7
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
24910694 24910694 PRJNA703759_P_NODE_29700_length_268_cov_1.225641_g29224_i0 PRJNA703759 29700 268 1.225641 3.28471788 uncultured Methanomassiliicoccales archaeon 1235852 Archaea Archaea 52.8 0.025   NTclustered gi|2874253643|emb|OY968769.1| 1235852 g29224 i0 100 0.104477611940299 28 0 10 0 211 238 2523827 2523800 MAG: uncultured Methanomassiliicoccales archaeon isolate MFD00905.bin.2.112 genome assembly, chromosome: 1 blastn 28 52.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     uncultured Methanomassiliicoccales archaeon

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