RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1074408" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA1074408 · 16 ✖

analysis 1

  • blastn · 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
1016445 1016445 PRJNA1074408_S_NODE_2701_length_279_cov_6.512712_g2571_i0 PRJNA1074408 2701 279 6.512712 18.17046648 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 510 3.5299999999999996e-140   NTclustered gi|399764281|gb|JQ271792.1| 1215612 g2571 i0 99.642 38.7204301075269 279 1 100 0 1 279 341 63 Cercozoa sp. 900 18S ribosomal RNA gene, partial sequence blastn 10803 510 1 Eukaryota Sar   Cercozoa         Cercozoa sp. 900
1016455 1016455 PRJNA1074408_S_NODE_8041_length_166_cov_1.016260_g7911_i0 PRJNA1074408 8041 166 1.01626 1.6869916 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 219 1.3e-52   NTclustered gi|1837628855|gb|MN158348.1| 5909 g7911 i0 99.174 62.7048192771084 121 1 73 0 46 166 2787 2907 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 10409 219 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
2741678 2741678 PRJNA1074408_S_NODE_6203_length_186_cov_4.447552_g6073_i0 PRJNA1074408 6203 186 4.447552 8.27244672 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 287 4e-73   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g6073 i0 95.055 104.41935483871 182 9 98 0 1 182 3675 3856 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 19422 287 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
4017535 4017535 PRJNA1074408_S_NODE_6084_length_188_cov_1.531034_g5954_i0 PRJNA1074408 6084 188 1.531034 2.87834392 Tetrahymena chironomi 3034767 SAR_Eukaryotes SAR_Eukaryotes 337 3.97e-88   NTclustered gi|2459327221|gb|OQ626840.1| 3034767 g5954 i0 98.936 87.1702127659574 188 2 100 0 1 188 657 470 Tetrahymena chironomi isolate LLH20220320 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 16388 337 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena chironomi
6568905 6568905 PRJNA1074408_S_NODE_2186_length_308_cov_1.415094_g2056_i0 PRJNA1074408 2186 308 1.415094 4.35848952 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 569 6.419999999999998e-158   NTclustered gi|323690576|gb|GU935635.1| 88167 g2056 i0 100 100.068181818182 308 0 100 0 1 308 1791 1484 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 30821 569 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
10394285 10394285 PRJNA1074408_S_NODE_6789_length_179_cov_1.595588_g6659_i0 PRJNA1074408 6789 179 1.595588 2.85610252 Goussia carpelli 947543 SAR_Eukaryotes SAR_Eukaryotes 259 8.32e-65   NTclustered gi|324022099|gb|GU593716.1| 947543 g6659 i0 92.818 100.111731843575 181 10 100 3 1 179 441 620 Goussia carpelli strain 23 28S ribosomal RNA gene, partial sequence blastn 17920 259 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia carpelli
11669659 11669659 PRJNA1074408_S_NODE_3950_length_233_cov_1.173684_g3820_i0 PRJNA1074408 3950 233 1.173684 2.73468372 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 379 8.419999999999998e-101   NTclustered gi|2651357791|gb|PP174306.1| 41631 g3820 i0 96.137 72.1244635193133 233 8 100 1 1 233 3440 3671 Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 16805 379 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
15044191 15044191 PRJNA1074408_S_NODE_9752_length_152_cov_0.880734_g9622_i0 PRJNA1074408 9752 152 0.880734 1.33871568 root 1 Root_unresolved Root_unresolved 268 1.13e-67   NTclustered gi|833494852|ref|XM_012915026.1| 5866 g9622 i0 98.684 101.473684210526 152 1 100 1 1 152 239 89 Babesia bigemina hypothetical protein, conserved partial mRNA blastn 15424 268 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia bigemina
17594305 17594305 PRJNA1074408_S_NODE_3274_length_255_cov_3.169811_g3144_i0 PRJNA1074408 3274 255 3.169811 8.08301805 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 472 1.5e-128   NTclustered gi|2493707699|dbj|LC764482.1| 45107 g3144 i0 100 100 255 0 100 0 1 255 744 998 Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence blastn 25500 472 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
18042719 18042719 PRJNA1074408_S_NODE_3975_length_232_cov_3.269841_g3845_i0 PRJNA1074408 3975 232 3.269841 7.58603112 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 274 4.07e-69   NTclustered gi|238617605|gb|FJ973380.1| 45107 g3845 i0 87.931 38.2198275862069 232 28 100 0 1 232 1645 1876 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 8867 274 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
19316655 19316655 PRJNA1074408_S_NODE_2116_length_313_cov_3.514815_g1986_i0 PRJNA1074408 2116 313 3.514815 11.00137095 Goussia sp. BMR-2011c 980545 SAR_Eukaryotes SAR_Eukaryotes 545 1.1e-150   NTclustered gi|328460764|gb|GU479639.1| 980545 g1986 i0 98.083 101.680511182109 313 6 100 0 1 313 38 350 Goussia sp. BMR-2011c isolate GCAR812-#812 18S ribosomal RNA gene, partial sequence blastn 31826 545 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia sp. BMR-2011c
21418576 21418576 PRJNA1074408_S_NODE_1757_length_342_cov_5.137124_g1627_i0 PRJNA1074408 1757 342 5.137124 17.56896408 Goussia 169155 SAR_Eukaryotes SAR_Eukaryotes 414 3.58e-111   NTclustered gi|328460778|gb|GU479653.1| 947544 g1627 i0 88.793 79.0233918128655 348 24 98 10 7 342 406 750 Goussia chalupskyi isolate LEC123-#123 18S ribosomal RNA gene, partial sequence blastn 27026 414 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Goussia Goussia chalupskyi
21418589 21418589 PRJNA1074408_S_NODE_8517_length_161_cov_1.813559_g8387_i0 PRJNA1074408 8517 161 1.813559 2.91982999 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 298 1.56e-76   NTclustered gi|323690576|gb|GU935635.1| 88167 g8387 i0 100 99.9937888198758 161 0 100 0 1 161 970 1130 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 16099 298 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
24416920 24416920 PRJNA1074408_S_NODE_4760_length_212_cov_2.272189_g4630_i0 PRJNA1074408 4760 212 2.272189 4.81704068 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 364 2.109999999999999e-96   NTclustered gi|238617605|gb|FJ973380.1| 45107 g4630 i0 97.642 90.7688679245283 212 5 100 0 1 212 1357 1568 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 19243 364 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
25242806 25242806 PRJNA1074408_S_NODE_7600_length_170_cov_2.070866_g7470_i0 PRJNA1074408 7600 170 2.070866 3.5204722 root 1 Root_unresolved Root_unresolved 315 1.64e-81   NTclustered gi|1837628855|gb|MN158348.1| 5909 g7470 i0 100 100.370588235294 170 0 100 0 1 170 5229 5398 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 17063 315 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
25242810 25242810 PRJNA1074408_S_NODE_8600_length_160_cov_5.615385_g8470_i0 PRJNA1074408 8600 160 5.615385 8.984616 root 1 Root_unresolved Root_unresolved 296 5.55e-76   NTclustered gi|10832|emb|X54512.1| 5911 g8470 i0 100 100.1 160 0 100 0 1 160 8273 8114 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 16016 296 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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