RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1011844" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1011844 · 10 ✖

analysis 1

  • diamond · 10 ✖

tax_kingdom 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
156632 156632 PRJNA1011844_P_NODE_17961_length_1335_cov_29.049921_g10580_i2 PRJNA1011844 17961 1335 29.049921 387.81644535 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 7.85e-15   NR MES1908556.1 1215613 g10580 i2 37.3 0.530337078651685 118 68 25.8 3 1176 832 102 216 MES1908556.1 hypothetical protein [Cercozoa sp. M6MM] diamond 708 88.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
6534779 6534779 PRJNA1011844_P_NODE_17926_length_1337_cov_30.992089_g10580_i1 PRJNA1011844 17926 1337 30.992089 414.36422993 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 7.85e-15   NR MES1908556.1 1215613 g10580 i1 37.3 0.529543754674645 118 68 25.8 3 427 771 102 216 MES1908556.1 hypothetical protein [Cercozoa sp. M6MM] diamond 708 88.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
9083929 9083929 PRJNA1011844_P_NODE_160128_length_242_cov_0.911243_g151548_i0 PRJNA1011844 160128 242 0.911243 2.20520806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 124 6.77e-32   NR MES1910618.1 1215613 g151548 i0 82.9 3.76859504132231 76 13 94.2 0 231 4 263 338 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 912 124 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
11635032 11635032 PRJNA1011844_P_NODE_167770_length_232_cov_2.207547_g159189_i0 PRJNA1011844 167770 232 2.207547 5.12150904 Thaumatomonas 45099 SAR_Eukaryotes SAR_Eukaryotes 106 8.3e-25   NR AAP72162.1 188940 g159189 i0 78.6 3.62068965517241 70 15 90.5 0 21 230 440 509 AAP72162.1 heat shock protein 90, partial [Thaumatomonas sp. (SA)] diamond 840 107 0.990654205607477 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
12909477 12909477 PRJNA1011844_P_NODE_1171_length_3933_cov_21.106477_g720_i0 PRJNA1011844 1171 3933 21.106477 830.11774041 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 589 7.059999999999999e-175   NR MES1910123.1 1215613 g720 i0 36.1 0.859649122807018 1127 622 80.2 33 3158 3 135 1238 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 3381 589 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19281752 19281752 PRJNA1011844_P_NODE_14536_length_1497_cov_27.622191_g10580_i0 PRJNA1011844 14536 1497 27.622191 413.50419927 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.1e-14   NR MES1908556.1 1215613 g10580 i0 37.3 0.472945891783567 118 68 23 3 587 931 102 216 MES1908556.1 hypothetical protein [Cercozoa sp. M6MM] diamond 708 88.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27192695 27192695 PRJNA1011844_P_NODE_4022_length_2588_cov_18.984493_g720_i1 PRJNA1011844 4022 2588 18.984493 491.31867884 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 286 8.42e-77   NR MES1910123.1 1215613 g720 i1 31.3 0.85548686244204 738 422 77.8 26 2026 14 135 854 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 2214 286 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31203309 31203309 PRJNA1011844_P_NODE_15155_length_1465_cov_14.145833_g720_i2 PRJNA1011844 15155 1465 14.145833 207.23645345 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 413 6.589999999999998e-125   NR MES1910123.1 1215613 g720 i2 48.1 1.00955631399317 493 241 98.9 8 1451 3 751 1238 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1479 413 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32406040 32406040 PRJNA1011844_P_NODE_37799_length_800_cov_14.004127_g30203_i0 PRJNA1011844 37799 800 14.004127 112.033016 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 55.8 9.06e-5   NR MES1910975.1 1215613 g30203 i0 29.9 0.43875 117 80 43.5 2 359 706 540 655 MES1910975.1 hypothetical protein [Cercozoa sp. M6MM] diamond 351 55.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32902670 32902670 PRJNA1011844_P_NODE_108040_length_307_cov_3.820513_g99467_i0 PRJNA1011844 108040 307 3.820513 11.72897491 Hondaea 2315209 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.07e-10   NR MES1910575.1 1215613 g99467 i0 65.1 1.69055374592834 43 15 42 0 25 153 141 183 MES1910575.1 hypothetical protein [Cercozoa sp. M6MM] diamond 519 65.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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