RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB673", 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

  • PRJEB673 · 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
134981 134981 PRJEB673_P_NODE_9861_length_185_cov_2.153333_g9512_i0 PRJEB673 9861 185 2.153333 3.98366605 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 309 8.49e-80   NTclustered gi|238617602|gb|FJ973377.1| 188950 g9512 i0 96.757 99.4486486486486 185 6 100 0 1 185 1314 1498 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 18398 309 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
3545858 3545858 PRJEB673_P_NODE_3583_length_528_cov_1.803245_g3260_i0 PRJEB673 3583 528 1.803245 9.5211336 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 215 1.15e-65   NR AAO89069.1 227086 g3260 i0 63.3 3.02272727272727 177 59 97.2 1 515 3 103 279 AAO89069.1 cytosolic class I fructose-1,6-bisphosphate aldolase [Bigelowiella natans] diamond 1596 216 0.99537037037037 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
10337927 10337927 PRJEB673_P_NODE_12689_length_152_cov_1.350427_g12340_i0 PRJEB673 12689 152 1.350427 2.05264904 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 172 9.14e-39   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g12340 i0 87.919 47.8815789473684 149 14 97 4 1 147 3742 3888 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 7278 172 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
11613381 11613381 PRJEB673_P_NODE_12630_length_152_cov_1.709402_g12281_i0 PRJEB673 12630 152 1.709402 2.59829104 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 265 1.47e-66   NTclustered gi|238617605|gb|FJ973380.1| 45107 g12281 i0 98.026 100.960526315789 152 3 100 0 1 152 1188 1037 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 15346 265 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
12888465 12888465 PRJEB673_P_NODE_171_length_1920_cov_4.931034_g118_i0 PRJEB673 171 1920 4.931034 94.6758528 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 521 1.36e-177   NR MES1909605.1 1215613 g118 i0 50.8 1.746875 557 147 86.3 6 1871 216 3 437 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 3354 521 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
14163341 14163341 PRJEB673_P_NODE_8032_length_299_cov_1.803030_g7683_i0 PRJEB673 8032 299 1.80303 5.3910597 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 156 2.06e-33   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g7683 i0 79.237 4.45150501672241 236 39 78 9 1 232 2607 2836 Rosculus vulgaris isolate CCA sequence blastn 1331 156 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
15437392 15437392 PRJEB673_P_NODE_2773_length_596_cov_1.541889_g2470_i0 PRJEB673 2773 596 1.541889 9.18965844 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 604 3.609999999999999e-168   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g2470 i0 99.697 10.7080536912752 330 1 91 0 267 596 830 501 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 6382 604 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
20535878 20535878 PRJEB673_P_NODE_9217_length_206_cov_1.385965_g8868_i0 PRJEB673 9217 206 1.385965 2.8550879 Phytocercomonas venanatans 2065209 SAR_Eukaryotes SAR_Eukaryotes 244 2.7699999999999997e-60   NTclustered gi|1315527746|gb|MF034898.1| 2065209 g8868 i0 88.235 96.9611650485437 204 24 99 0 1 204 805 1008 Phytocercomonas venanatans actin gene, complete cds blastn 19974 244 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Phytocercomonas Phytocercomonas venanatans
21811649 21811649 PRJEB673_P_NODE_12798_length_151_cov_1.724138_g12449_i0 PRJEB673 12798 151 1.724138 2.60344838 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 261 1.88e-65   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g12449 i0 98.013 8.08609271523179 151 1 100 1 1 151 1342 1194 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 1221 261 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
27097258 27097258 PRJEB673_P_NODE_922_length_968_cov_2.975348_g739_i0 PRJEB673 922 968 2.975348 28.80136864 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 212 3.94e-59   NR MES1911124.1 1215613 g739 i0 52 3.48037190082645 227 95 68.5 5 190 852 484 702 MES1911124.1 hypothetical protein [Cercozoa sp. M6MM] diamond 3369 212 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28265672 28265672 PRJEB673_P_NODE_11846_length_158_cov_1.300813_g11497_i0 PRJEB673 11846 158 1.300813 2.05528454 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 76.3 4.55e-16   NR ADK26622.1 323453 g11497 i0 92.7 0.778481012658228 41 3 77.8 0 35 157 1 41 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 123 76.3 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
28550243 28550243 PRJEB673_P_NODE_9807_length_187_cov_1.052632_g9458_i0 PRJEB673 9807 187 1.052632 1.96842184 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.74e-13   NR ADK26622.1 323453 g9458 i0 90.6 0.513368983957219 32 3 51.3 0 185 90 99 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 96 70.1 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29118612 29118612 PRJEB673_P_NODE_249_length_1655_cov_2.428395_g177_i0 PRJEB673 249 1655 2.428395 40.18993725 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 100 3.13e-18   NR MES1913811.1 1215613 g177 i0 35.1 0.279154078549849 154 84 25.6 4 1653 1231 51 201 MES1913811.1 hypothetical protein [Cercozoa sp. M6MM] diamond 462 100 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30255613 30255613 PRJEB673_P_NODE_792_length_1029_cov_1.875252_g624_i0 PRJEB673 792 1029 1.875252 19.29634308 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 160 1.16e-39   NR MES1910588.1 1215613 g624 i0 40.9 1.47230320699708 259 116 68.8 6 1 708 412 656 MES1910588.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1515 160 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30887214 30887214 PRJEB673_P_NODE_254_length_1643_cov_2.347015_g177_i1 PRJEB673 254 1643 2.347015 38.56145645 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 100 3.06e-18   NR MES1913811.1 1215613 g177 i1 35.1 0.28119293974437 154 84 25.7 4 1641 1219 51 201 MES1913811.1 hypothetical protein [Cercozoa sp. M6MM] diamond 462 100 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32405359 32405359 PRJEB673_P_NODE_7959_length_302_cov_1.389513_g7610_i0 PRJEB673 7959 302 1.389513 4.19632926 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 51.2 2.99e-6   NR MES1911722.1 1215613 g7610 i0 75 0.278145695364238 28 7 27.8 0 294 211 1 28 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 84 51.2 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);;