RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA715462" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA715462 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
21108079 21108079 PRJNA715462_P_NODE_26797_length_347_cov_1.124088_g26001_i0 PRJNA715462 26797 347 1.124088 3.90058536 Nitrosarchaeum sp. 2026886 Archaea Archaea 196 8.66e-57   NR MFB5612793.1 2026886 g26001 i0 86.1 1.98847262247839 115 16 99.4 0 3 347 445 559 MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.] diamond 690 196 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
27904556 27904556 PRJNA715462_P_NODE_63905_length_244_cov_0.900585_g63109_i0 PRJNA715462 63905 244 0.900585 2.1974274 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 162 1.78e-46   NR HZB73908.1 2169593 g63109 i0 93.8 0.983606557377049 80 5 98.4 0 3 242 78 157 HZB73908.1 DUF3179 domain-containing protein [Nitrososphaeraceae archaeon] diamond 240 162 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28946996 28946996 PRJNA715462_P_NODE_52268_length_250_cov_0.870056_g51472_i0 PRJNA715462 52268 250 0.870056 2.17514 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 54.3 3.4e-6   NR MDW0181425.1 2169593 g51472 i0 40.9 3.192 66 39 79.2 0 3 200 665 730 MDW0181425.1 reverse transcriptase domain-containing protein [Nitrososphaeraceae archaeon] diamond 798 54.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31063233 31063233 PRJNA715462_P_NODE_70195_length_231_cov_2.075949_g69399_i0 PRJNA715462 70195 231 2.075949 4.79544219 Nitrososphaerota archaeon 2026795 Archaea Archaea 58.2 9.5e-8   NR RZD32614.1 2026795 g69399 i0 43.6 0.714285714285714 55 31 71.4 0 63 227 66 120 RZD32614.1 MAG: hypothetical protein CXT79_05995 [Nitrososphaerota archaeon] diamond 165 58.2 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31189037 31189037 PRJNA715462_P_NODE_56975_length_248_cov_0.880000_g56179_i0 PRJNA715462 56975 248 0.88 2.1824 Nitrosarchaeum sp. 2026886 Archaea Archaea 112 1.57e-26   NR MFB5612793.1 2026886 g56179 i0 69.5 0.991935483870968 82 25 99.2 0 3 248 512 593 MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.] diamond 246 112 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
31442383 31442383 PRJNA715462_P_NODE_44336_length_268_cov_1.343590_g43540_i0 PRJNA715462 44336 268 1.34359 3.6008212 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 50.4 9.64e-5   NR MDW0252355.1 2169593 g43540 i0 38.8 0.548507462686567 49 30 54.9 0 159 13 457 505 MDW0252355.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] diamond 147 50.4 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);;