RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA902848 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
11085837 11085837 PRJNA902848_P_NODE_8189_length_309_cov_1.237288_g8139_i0 PRJNA902848 8189 309 1.237288 3.82321992 root 1 Root_unresolved Root_unresolved 106 7.99e-26   NR MRN41656.1 2026768 g8139 i0 53.9 12.6699029126214 102 47 99 0 307 2 69 170 MRN41656.1 glucose 1-dehydrogenase [Nitrosopumilales archaeon] diamond 3915 107 0.990654205607477 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
26612523 26612523 PRJNA902848_P_NODE_16461_length_248_cov_0.891429_g16411_i0 PRJNA902848 16461 248 0.891429 2.21074392 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 57.4 7.01e-9   NR HSF49368.1 2169593 g16411 i0 62.2 0.44758064516129 37 13 44.8 1 238 128 24 59 HSF49368.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 111 57.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27150231 27150231 PRJNA902848_P_NODE_13882_length_252_cov_0.871508_g13832_i0 PRJNA902848 13882 252 0.871508 2.19620016 Nitrosopumilus piranensis 1582439 Archaea Archaea 47.8 7.1e-4   NR WP_148703767.1 1582439 g13832 i0 34.2 1.73809523809524 73 41 78.6 1 34 231 54 126 WP_148703767.1 tyrosine-type recombinase/integrase [Nitrosopumilus piranensis] diamond 438 47.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus piranensis
28003631 28003631 PRJNA902848_P_NODE_13425_length_253_cov_0.866667_g13375_i0 PRJNA902848 13425 253 0.866667 2.19266751 Candidatus Nitrososphaera sp. FF02 3398226 Archaea Archaea 125 1.12e-32   NR WP_415282128.1 3398226 g13375 i0 65.1 0.984189723320158 83 29 98.4 0 251 3 201 283 WP_415282128.1 hypothetical protein [Candidatus Nitrososphaera sp. FF02] diamond 249 125 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera sp. FF02
29992735 29992735 PRJNA902848_P_NODE_13851_length_252_cov_0.871508_g13801_i0 PRJNA902848 13851 252 0.871508 2.19620016 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 47.8 5.89e-4   NR MDW3611701.1 2169593 g13801 i0 96.3 0.321428571428571 27 1 32.1 0 81 1 1 27 MDW3611701.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 81 47.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30411317 30411317 PRJNA902848_P_NODE_7073_length_327_cov_1.535433_g7023_i0 PRJNA902848 7073 327 1.535433 5.02086591 root 1 Root_unresolved Root_unresolved 47.8 0.00169   NR MEK0336544.1 2024843 g7023 i0 55.8 0.788990825688073 43 18 39.4 1 197 325 1 42 MEK0336544.1 hypothetical protein [Nitrosopumilus sp.] diamond 258 47.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
30877308 30877308 PRJNA902848_P_NODE_15034_length_250_cov_0.881356_g14984_i0 PRJNA902848 15034 250 0.881356 2.20339 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 175 1.8399999999999998e-54   NR MCC2648062.1 2169593 g14984 i0 98.8 0.972 81 1 97.2 0 6 248 60 140 MCC2648062.1 mauC [Nitrososphaeraceae archaeon] diamond 243 175 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae 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);;