RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA395690", 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

  • PRJNA395690 · 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
8065144 8065144 PRJNA395690_P_NODE_4827_length_362_cov_1.214058_g4678_i0 PRJNA395690 4827 362 1.214058 4.39488996 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 303 8.58e-78   NTclustered gi|160337351|gb|EF455772.1| 439948 g4678 i0 81.868 100.085635359116 364 62 100 4 1 362 284 645 Dimorpha sp. ATCC PRA-54 clone 1 actin gene, partial cds blastn 36231 303 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
15714375 15714375 PRJNA395690_P_NODE_2953_length_456_cov_1.813268_g2805_i0 PRJNA395690 2953 456 1.813268 8.26850208 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 141 7.85e-40   NR ADK47156.1 323453 g2805 i0 100 0.447368421052632 68 0 44.7 0 2 205 78 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 204 141 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
15714476 15714476 PRJNA395690_P_NODE_4333_length_379_cov_13.169697_g4184_i0 PRJNA395690 4333 379 13.169697 49.91315163 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 291 7.03e-74   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g4184 i0 83.81 29.8707124010554 315 41 82 10 1 310 3730 4039 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 11321 291 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
16989077 16989077 PRJNA395690_P_NODE_23254_length_179_cov_1.176923_g23102_i0 PRJNA395690 23254 179 1.176923 2.10669217 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 183 5.15e-42   NTclustered gi|160337355|gb|EF455774.1| 439948 g23102 i0 85.632 97.659217877095 174 25 97 0 1 174 18 191 Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds blastn 17481 183 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
18263182 18263182 PRJNA395690_P_NODE_17075_length_196_cov_2.081633_g16923_i0 PRJNA395690 17075 196 2.081633 4.08000068 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 171 4.49e-38   NTclustered gi|238617605|gb|FJ973380.1| 45107 g16923 i0 86.792 30.4540816326531 159 13 79 5 1 155 1641 1795 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 5969 171 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
22088263 22088263 PRJNA395690_P_NODE_3438_length_424_cov_1.522667_g3289_i0 PRJNA395690 3438 424 1.522667 6.45610808 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 167 1.51e-50   NR ADK26622.1 323453 g3289 i0 95.1 0.580188679245283 82 4 58 0 422 177 49 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 246 167 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
22088345 22088345 PRJNA395690_P_NODE_6158_length_324_cov_1.287273_g6008_i0 PRJNA395690 6158 324 1.287273 4.17076452 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 202 4.14e-63   NR ADK26624.1 323453 g6008 i0 88.8 0.990740740740741 107 12 99.1 0 324 4 170 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 321 202 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
23363558 23363558 PRJNA395690_P_NODE_11719_length_237_cov_5.638298_g11567_i0 PRJNA395690 11719 237 5.638298 13.36276626 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 385 1.85e-102   NTclustered gi|238617605|gb|FJ973380.1| 45107 g11567 i0 97.345 94.7341772151899 226 6 95 0 1 226 1551 1326 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 22452 385 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
29285735 29285735 PRJNA395690_P_NODE_28149_length_167_cov_1.381356_g27997_i0 PRJNA395690 28149 167 1.381356 2.30686452 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 62 2.11e-9   NR MES1917054.1 1215613 g27997 i0 49.1 2.10179640718563 55 28 98.8 0 167 3 83 137 MES1917054.1 hypothetical protein [Cercozoa sp. M6MM] diamond 351 62 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31149172 31149172 PRJNA395690_P_NODE_32335_length_164_cov_0.886957_g32183_i0 PRJNA395690 32335 164 0.886957 1.45460948 Lotharella oceanica 641309 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.05e-9   NR AIB09582.1 641309 g32183 i0 57.8 0.823170731707317 45 19 82.3 0 136 2 1 45 AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica] diamond 135 58.2 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella oceanica
31292747 31292747 PRJNA395690_P_NODE_30575_length_165_cov_1.551724_g30423_i0 PRJNA395690 30575 165 1.551724 2.5603446 root 1 Root_unresolved Root_unresolved 58.2 5.12e-9   NR YP_009240352.1 67809 g30423 i0 96.4 102.836363636364 28 1 50.9 0 2 85 95 122 YP_009240352.1 50S ribosomal protein L14 [Gymnochlora stellata] diamond 16968 58.5 0.994871794871795 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
31718890 31718890 PRJNA395690_P_NODE_29557_length_166_cov_0.871795_g29405_i0 PRJNA395690 29557 166 0.871795 1.4471797 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.29e-7   NR MES1912100.1 1215613 g29405 i0 52.8 1.91566265060241 53 25 95.8 0 5 163 468 520 MES1912100.1 hypothetical protein [Cercozoa sp. M6MM] diamond 318 56.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32066755 32066755 PRJNA395690_P_NODE_17858_length_192_cov_1.825175_g17706_i0 PRJNA395690 17858 192 1.825175 3.504336 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.9 5.21e-16   NR MES1912577.1 1215613 g17706 i0 60.9 2 64 24 98.4 1 191 3 112 175 MES1912577.1 hypothetical protein [Cercozoa sp. M6MM] diamond 384 80.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32667434 32667434 PRJNA395690_P_NODE_25520_length_173_cov_1.653226_g25368_i0 PRJNA395690 25520 173 1.653226 2.86008098 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.72e-6   NR MES1913617.1 1215613 g25368 i0 45.6 0.988439306358382 57 30 98.8 1 3 173 107 162 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 171 52.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);;