RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB2368 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_clade 0

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
26653042 26653042 PRJEB2368_P_NODE_10101_length_287_cov_1.304000_g9783_i0 PRJEB2368 10101 287 1.304 3.74248 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 47 0.00115   NR HXV38476.1 2202732 g9783 i0 95.7 0.240418118466899 23 1 24 0 281 213 119 141 HXV38476.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 69 47 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
26805120 26805120 PRJEB2368_P_NODE_10181_length_287_cov_1.288000_g9863_i0 PRJEB2368 10181 287 1.288 3.69656 Nitrosopumilus 338191 Archaea Archaea 43.1 0.0437   NR MDH3618399.1 2024843 g9863 i0 79.2 1.00348432055749 24 5 25.1 0 72 1 294 317 MDH3618399.1 glycosyltransferase family 4 protein [Nitrosopumilus sp.] diamond 288 43.5 0.990804597701149 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
27254294 27254294 PRJEB2368_P_NODE_9863_length_287_cov_1.344000_g9545_i0 PRJEB2368 9863 287 1.344 3.85728 Nitrososphaerota archaeon 2026795 Archaea Archaea 72.4 8.31e-13   NR MDE1814494.1 2026795 g9545 i0 50.5 1.98606271777003 95 37 99.3 1 286 2 78 162 MDE1814494.1 hypothetical protein [Nitrososphaerota archaeon] diamond 570 72.4 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29363708 29363708 PRJEB2368_P_NODE_8529_length_287_cov_1.596000_g8211_i0 PRJEB2368 8529 287 1.596 4.58052 Thermoproteati 1783275 Archaea Archaea 53.1 1.21e-5   NR PIW33344.1 2022694 g8211 i0 96 1.82926829268293 25 1 26.1 0 286 212 253 277 PIW33344.1 MAG: prephenate dehydrogenase/arogenate dehydrogenase family protein [Nitrosopumilales archaeon CG15_BIG_FIL_POST_REV_8_21_14_020_37_12] diamond 525 53.5 0.992523364485981 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon CG15_BIG_FIL_POST_REV_8_21_14_020_37_12
31233653 31233653 PRJEB2368_P_NODE_9675_length_287_cov_1.376000_g9357_i0 PRJEB2368 9675 287 1.376 3.94912 Nitrososphaerota archaeon 2026795 Archaea Archaea 49.3 1.28e-4   NR TLX80400.1 2026795 g9357 i0 88 0.261324041811847 25 3 26.1 0 286 212 108 132 TLX80400.1 MAG: MarR family transcriptional regulator [Nitrososphaerota archaeon] diamond 75 49.3 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota 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);;