RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJEB14803", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 8 ✖

tax_phylum 1

  • Nitrososphaerota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14803 · 8 ✖

analysis 1

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
28106880 28106880 PRJEB14803_P_NODE_18905_length_269_cov_1.367521_g18439_i0 PRJEB14803 18905 269 1.367521 3.67863149 Nitrosopumilus sp. 2024843 Archaea Archaea 69.7 1.69e-11   NR MBA3284442.1 2024843 g18439 i0 42.5 0.814126394052045 73 42 81.4 0 238 20 352 424 MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] diamond 219 69.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
28605823 28605823 PRJEB14803_P_NODE_47_length_3185_cov_8.444762_g38_i0 PRJEB14803 47 3185 8.444762 268.9656697 Archaea 2157 Archaea Archaea 68.2 2.2e-7   NR MEM3424161.1 2268198 g38 i0 29.8 0.410675039246468 218 117 18.6 10 2277 1687 375 577 MEM3424161.1 hypothetical protein [Nitrososphaeria archaeon] diamond 1308 68.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
28826576 28826576 PRJEB14803_P_NODE_48_length_3181_cov_7.167196_g38_i1 PRJEB14803 48 3181 7.167196 227.98850476 Archaea 2157 Archaea Archaea 68.2 2.2e-7   NR MEM3424161.1 2268198 g38 i1 29.8 0.411191449229802 218 117 18.6 10 909 1499 375 577 MEM3424161.1 hypothetical protein [Nitrososphaeria archaeon] diamond 1308 68.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
29527925 29527925 PRJEB14803_P_NODE_43230_length_158_cov_1.300813_g42764_i0 PRJEB14803 43230 158 1.300813 2.05528454 Nitrosopumilus sp. 2024843 Archaea Archaea 52.4 4.65e-6   NR MBA3284442.1 2024843 g42764 i0 51.3 0.740506329113924 39 19 74.1 0 3 119 149 187 MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] diamond 117 52.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
29773904 29773904 PRJEB14803_P_NODE_31871_length_190_cov_2.580645_g31405_i0 PRJEB14803 31871 190 2.580645 4.9032255 root 1 Root_unresolved Root_unresolved 88.2 6.86e-19   NR HYY39862.1 1971748 g31405 i0 68.9 25.3578947368421 61 19 96.3 0 183 1 167 227 HYY39862.1 integrase [Nitrososphaera sp.] diamond 4818 88.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30254551 30254551 PRJEB14803_P_NODE_17892_length_279_cov_1.340164_g17426_i0 PRJEB14803 17892 279 1.340164 3.73905756 Nitrosopumilus sp. 2024843 Archaea Archaea 74.7 3.31e-13   NR MBA3284442.1 2024843 g17426 i0 46.7 0.989247311827957 92 48 98.9 1 278 3 1180 1270 MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] diamond 276 74.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
31954797 31954797 PRJEB14803_P_NODE_32437_length_188_cov_2.542484_g31971_i0 PRJEB14803 32437 188 2.542484 4.77986992 root 1 Root_unresolved Root_unresolved 59.3 1.29e-8   NR MBI3254777.1 2026886 g31971 i0 53.2 1.9468085106383 62 26 95.7 2 180 1 52 112 MBI3254777.1 Ig-like domain-containing protein [Nitrosarchaeum sp.] diamond 366 59.7 0.993299832495812 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
32587765 32587765 PRJEB14803_P_NODE_17119_length_287_cov_1.416667_g16653_i0 PRJEB14803 17119 287 1.416667 4.06583429 root 1 Root_unresolved Root_unresolved 50.1 1.68e-4   NR MFQ5781903.1 2024843 g16653 i0 40.7 1.43205574912892 54 32 56.4 0 108 269 410 463 MFQ5781903.1 ATP-binding protein [Nitrosopumilus sp.] diamond 411 50.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.

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