RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA421571", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA421571 · 14 ✖

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
5527469 5527469 PRJNA421571_P_NODE_69525_length_305_cov_1.452586_g66976_i0 PRJNA421571 69525 305 1.452586 4.4303873 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 368 2.49e-97   NTclustered gi|160337355|gb|EF455774.1| 439948 g66976 i0 88.487 96.1114754098361 304 35 99 0 1 304 550 247 Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds blastn 29314 368 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
6801287 6801287 PRJNA421571_P_NODE_6126_length_1507_cov_2.684798_g5189_i0 PRJNA421571 6126 1507 2.684798 40.45990586 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 802 0   NTclustered gi|300676723|gb|GQ377712.1| 323453 g5189 i0 84.211 4.13868613138686 836 120 55 11 560 1389 833 4 Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds blastn 6237 802 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
9350652 9350652 PRJNA421571_P_NODE_28788_length_608_cov_3.254206_g26275_i0 PRJNA421571 28788 608 3.254206 19.78557248 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 551 4.869999999999998e-152   NTclustered gi|301014702|gb|GQ377715.1| 323453 g26275 i0 88.791 54.7319078947368 455 44 74 7 22 472 40 491 Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds blastn 33277 551 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
10625730 10625730 PRJNA421571_P_NODE_102729_length_243_cov_3.847059_g100180_i0 PRJNA421571 102729 243 3.847059 9.34835337 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 182 2.68e-41   NTclustered gi|300676720|gb|GQ377713.1| 323453 g100180 i0 92.188 85.3991769547325 128 10 53 0 116 243 4 131 Heteromita sp. PRA-74 gcr5-like mRNA, partial sequence blastn 20752 182 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
11901521 11901521 PRJNA421571_P_NODE_32470_length_553_cov_2.141667_g29934_i0 PRJNA421571 32470 553 2.141667 11.84341851 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 466 1.64e-126   NTclustered gi|300676716|gb|GQ377714.1| 323453 g29934 i0 87.019 62.8408679927667 416 50 75 3 12 427 43 454 Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds blastn 34751 466 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
15725440 15725440 PRJNA421571_P_NODE_35413_length_515_cov_3.375566_g32872_i0 PRJNA421571 35413 515 3.375566 17.3841649 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 168 3.19e-48   NR MES1911029.1 1215613 g32872 i0 58.1 0.932038834951456 160 59 90.9 2 507 40 139 294 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 480 168 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
17001137 17001137 PRJNA421571_P_NODE_69294_length_306_cov_1.313305_g66745_i0 PRJNA421571 69294 306 1.313305 4.0187133 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 154 7.27e-44   NR MES1907458.1 1215613 g66745 i0 75.2 0.990196078431373 101 25 99 0 1 303 34 134 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 303 154 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
20212266 20212266 PRJNA421571_P_NODE_65916_length_317_cov_2.163934_g63367_i0 PRJNA421571 65916 317 2.163934 6.85967078 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 91.7 5.43e-19   NR MES1912100.1 1215613 g63367 i0 40 0.993690851735016 105 63 99.4 0 316 2 396 500 MES1912100.1 hypothetical protein [Cercozoa sp. M6MM] diamond 315 91.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24650643 24650643 PRJNA421571_P_NODE_90780_length_253_cov_1.016667_g88231_i0 PRJNA421571 90780 253 1.016667 2.57216751 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 150 1.0899999999999998e-41   NR MES1910618.1 1215613 g88231 i0 81.9 0.984189723320158 83 15 98.4 0 5 253 166 248 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 249 150 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26695686 26695686 PRJNA421571_P_NODE_32781_length_549_cov_1.464286_g30244_i0 PRJNA421571 32781 549 1.464286 8.03893014 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 107 4.19e-26   NR MES1913255.1 1215613 g30244 i0 45.3 0.519125683060109 95 52 51.9 0 496 212 30 124 MES1913255.1 hypothetical protein [Cercozoa sp. M6MM] diamond 285 107 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29791162 29791162 PRJNA421571_P_NODE_72251_length_297_cov_1.031250_g69702_i0 PRJNA421571 72251 297 1.03125 3.0628125 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 138 4.45e-38   NR ADK26624.1 323453 g69702 i0 67.3 1.97979797979798 98 32 99 0 295 2 101 198 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 588 138 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
30675810 30675810 PRJNA421571_P_NODE_80433_length_276_cov_1.137931_g77884_i0 PRJNA421571 80433 276 1.137931 3.14068956 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 93.2 7.18e-21   NR MES1912965.1 1215613 g77884 i0 48.9 2 92 47 100 0 1 276 34 125 MES1912965.1 hypothetical protein [Cercozoa sp. M6MM] diamond 552 93.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30802342 30802342 PRJNA421571_P_NODE_99154_length_246_cov_0.890173_g96605_i0 PRJNA421571 99154 246 0.890173 2.18982558 Paulinella micropora 1928728 SAR_Eukaryotes SAR_Eukaryotes 82 7.2e-18   NR BBE07976.1 1928728 g96605 i0 47.4 0.926829268292683 76 33 84.1 1 245 39 9 84 BBE07976.1 LIM and SH3 domain protein [Paulinella micropora] diamond 228 82 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella micropora
31023549 31023549 PRJNA421571_P_NODE_78175_length_281_cov_1.918269_g75626_i0 PRJNA421571 78175 281 1.918269 5.39033589 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 79.7 5.87e-15   NR MES1907661.1 1215613 g75626 i0 47.5 0.854092526690391 80 40 83.3 1 11 244 377 456 MES1907661.1 hypothetical protein [Cercozoa sp. M6MM] diamond 240 79.7 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);;