RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939369 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
8567263 8567263 PRJNA939369_S_NODE_40287_length_276_cov_1.137931_g39870_i0 PRJNA939369 40287 276 1.137931 3.14068956 Nitrosopumilus sp. 2024843 Archaea Archaea 87.4 1.1e-17   NR MBC8517168.1 2024843 g39870 i0 62.1 0.945652173913043 87 30 94.6 2 9 269 181 264 MBC8517168.1 hypothetical protein [Nitrosopumilus sp.] diamond 261 87.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
22591451 22591451 PRJNA939369_S_NODE_50658_length_257_cov_1.135870_g50241_i0 PRJNA939369 50658 257 1.13587 2.9191859 Archaea 2157 Archaea Archaea 138 9.34e-36   NR WP_179371471.1 1470067 g50241 i0 80 2.97665369649805 85 17 99.2 0 255 1 721 805 WP_179371471.1 hypothetical protein [Nitrosopumilus ureiphilus] diamond 765 138 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus ureiphilus
28699004 28699004 PRJNA939369_S_NODE_907_length_1094_cov_4.144956_g639_i0 PRJNA939369 907 1094 4.144956 45.34581864 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 89 6.12e-18   NR AIF11849.1 1456186 g639 i0 75.9 0.148080438756856 54 13 14.8 0 813 652 40 93 AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08] diamond 162 89 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08
32238236 32238236 PRJNA939369_S_NODE_21498_length_331_cov_0.937984_g21081_i0 PRJNA939369 21498 331 0.937984 3.10472704 Nitrososphaerota archaeon 2026795 Archaea Archaea 188 1.6299999999999997e-57   NR TLX90744.1 2026795 g21081 i0 81.5 0.978851963746224 108 20 97.9 0 329 6 123 230 TLX90744.1 MAG: hypothetical protein E6K93_05615 [Nitrososphaerota archaeon] diamond 324 188 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);;