RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA278119", 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 · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA278119 · 16 ✖

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
2921847 2921847 PRJNA278119_P_NODE_2343_length_800_cov_22.834887_g2112_i1 PRJNA278119 2343 800 22.834887 182.679096 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 1044 0   NTclustered gi|238617605|gb|FJ973380.1| 45107 g2112 i1 94.041 68.77625 688 41 100 0 1 688 1194 1881 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 55021 1044 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
2922200 2922200 PRJNA278119_P_NODE_5143_length_527_cov_2.043933_g4899_i0 PRJNA278119 5143 527 2.043933 10.77152691 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 774 0   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g4899 i0 92.844 11.7020872865275 545 21 100 11 1 527 526 1070 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 6167 774 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
4198165 4198165 PRJNA278119_P_NODE_14204_length_292_cov_1.711934_g13955_i0 PRJNA278119 14204 292 1.711934 4.99884728 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 224 5.42e-54   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g13955 i0 81.145 32.9486301369863 297 41 100 12 1 292 2212 2498 Rosculus vulgaris isolate CCA sequence blastn 9621 224 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
6748864 6748864 PRJNA278119_P_NODE_2326_length_803_cov_22.389920_g2112_i0 PRJNA278119 2326 803 22.38992 179.7910576 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 979 0   NTclustered gi|238617605|gb|FJ973380.1| 45107 g2112 i0 92.711 69.2602739726027 686 38 99 7 126 803 1875 1194 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 55616 979 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
11849700 11849700 PRJNA278119_P_NODE_16850_length_255_cov_1.466019_g16601_i0 PRJNA278119 16850 255 1.466019 3.73834845 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 361 3.3899999999999996e-95   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g16601 i0 92.549 3 255 13 99 6 3 255 389 139 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 765 361 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
14400292 14400292 PRJNA278119_P_NODE_31532_length_177_cov_0.828125_g31283_i0 PRJNA278119 31532 177 0.828125 1.46578125 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 327 2.2199999999999996e-85   NTclustered gi|1402550485|gb|MH488771.1| 2231170 g31283 i0 100 80.316384180791 177 0 100 0 1 177 1977 1801 Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 14216 327 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa
14400563 14400563 PRJNA278119_P_NODE_7612_length_431_cov_1.484293_g7365_i0 PRJNA278119 7612 431 1.484293 6.39730283 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 250 2.96e-83   NR ADK26622.1 323453 g7365 i0 94.5 0.890951276102088 128 7 89.1 0 46 429 1 128 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 384 250 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
22047899 22047899 PRJNA278119_P_NODE_3998_length_604_cov_1.025225_g3759_i0 PRJNA278119 3998 604 1.025225 6.192359 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 542 2.91e-149   NTclustered gi|160337355|gb|EF455774.1| 439948 g3759 i0 83.86 99.9850993377483 570 90 94 2 32 600 1 569 Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds blastn 60391 542 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
22048049 22048049 PRJNA278119_P_NODE_7038_length_448_cov_2.932331_g6791_i0 PRJNA278119 7038 448 2.932331 13.13684288 Amorphochlora amoebiformis 1561963 SAR_Eukaryotes SAR_Eukaryotes 254 1.11e-62   NTclustered gi|33346934|gb|AY251797.1| 1561963 g6791 i0 88.517 42.1138392857143 209 24 47 0 44 252 227 435 Lotharella amoeboformis ubiquitin/actin fusion protein 2 gene, partial cds blastn 18867 254 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Amorphochlora Amorphochlora amoebiformis
22735494 22735494 PRJNA278119_P_NODE_11898_length_332_cov_11.929329_g11650_i0 PRJNA278119 11898 332 11.929329 39.60537228 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 590 5.359999999999998e-164   NTclustered gi|33309641|gb|AF411277.1| 188959 g11650 i0 98.792 98.3584337349398 331 4 99 0 1 331 1427 1757 Costa Rica flagellate 18S ribosomal RNA gene, complete sequence blastn 32655 595 0.991596638655462 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae   Costa Rica flagellate
22735531 22735531 PRJNA278119_P_NODE_17018_length_253_cov_1.274510_g16769_i0 PRJNA278119 17018 253 1.27451 3.2245103 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 126 2.16e-33   NR MES1907458.1 1215613 g16769 i0 75 0.99604743083004 84 21 99.6 0 252 1 47 130 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 252 126 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
23323606 23323606 PRJNA278119_P_NODE_8039_length_418_cov_18.785908_g7792_i0 PRJNA278119 8039 418 18.785908 78.52509544 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 418 3.4399999999999996e-112   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g7792 i0 86.563 56.0430622009569 387 42 92 10 1 383 3659 4039 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 23426 418 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
27074045 27074045 PRJNA278119_P_NODE_14962_length_280_cov_3.575758_g14713_i0 PRJNA278119 14962 280 3.575758 10.0121224 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82.4 7.66e-18   NR MES1912234.1 1215613 g14713 i0 53.8 1.67142857142857 78 32 83.6 2 19 252 46 119 MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] diamond 468 82.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30200228 30200228 PRJNA278119_P_NODE_12152_length_327_cov_12.679856_g11904_i0 PRJNA278119 12152 327 12.679856 41.46312912 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 60.5 9.11e-10   NR MES1911722.1 1215613 g11904 i0 70.3 0.339449541284404 37 11 33.9 0 320 210 1 37 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 111 60.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31749075 31749075 PRJNA278119_P_NODE_10697_length_355_cov_4.405229_g10450_i0 PRJNA278119 10697 355 4.405229 15.63856295 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 85.1 2.53e-19   NR MES1911722.1 1215613 g10450 i0 72.5 0.430985915492958 51 14 43.1 0 354 202 2 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 153 85.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32002313 32002313 PRJNA278119_P_NODE_16818_length_255_cov_19.810680_g16569_i0 PRJNA278119 16818 255 19.81068 50.517234 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87.8 6.16e-21   NR MES1911722.1 1215613 g16569 i0 75 0.611764705882353 52 13 61.2 0 8 163 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 87.8 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);;