RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 15 ✖

tax_clade 1

bioproject 1

  • PRJEB64798 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
2268470 2268470 PRJEB64798_P_NODE_227982_length_159_cov_7.472727_g226216_i0 PRJEB64798 227982 159 7.472727 11.88163593 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 244 2.02e-60   NTclustered gi|89475219|gb|DQ408638.1| 203410 g226216 i0 99.259 84.7169811320755 135 1 85 0 25 159 2096 2230 Islandiella sp. 2643 small subunit ribosomal RNA gene, complete sequence blastn 13470 246 0.991869918699187 Eukaryota Sar   Foraminifera   Rotaliida Cassidulinidae Islandiella Islandiella sp. 2643
2678693 2678693 PRJEB64798_P_NODE_25143_length_392_cov_48.507289_g23394_i0 PRJEB64798 25143 392 48.507289 190.14857288 Rotaliella elatiana 35210 SAR_Eukaryotes SAR_Eukaryotes 161 5.969999999999999e-35   NTclustered gi|643022|emb|X78521.1| 35210 g23394 i0 83.978 4.21173469387755 181 16 43 5 125 293 1999 1820 R.elatiana complete gene of large subunit rRNA blastn 1651 161 1 Eukaryota Sar   Foraminifera   Rotaliida Rotaliidae Rotaliella Rotaliella elatiana
3953464 3953464 PRJEB64798_P_NODE_167924_length_179_cov_18.976923_g166158_i0 PRJEB64798 167924 179 18.976923 33.96869217 Trochammina sp. 37356 SAR_Eukaryotes SAR_Eukaryotes 257 2.99e-64   NTclustered gi|619567|emb|Z30147.1| 37356 g166158 i0 95.122 71.6368715083799 164 7 91 1 1 163 1720 1557 T.sp. gene for 28S ribosomal RNA blastn 12823 257 1 Eukaryota Sar   Foraminifera   Textulariida Trochamminidae Trochammina Trochammina sp.
6096254 6096254 PRJEB64798_P_NODE_189345_length_170_cov_10.719008_g187579_i0 PRJEB64798 189345 170 10.719008 18.2223136 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 145 2.28e-30   NTclustered gi|998623043|dbj|LC049322.1| 51039 g187579 i0 90.826 11.4823529411765 109 8 64 2 63 170 3107 3214 Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89 blastn 1952 145 1 Eukaryota Sar   Foraminifera   Rotaliida Globorotaliidae Neogloboquadrina Neogloboquadrina dutertrei
6506852 6506852 PRJEB64798_P_NODE_27466_length_375_cov_16.773006_g25711_i0 PRJEB64798 27466 375 16.773006 62.8987725 Foraminifera environmental sample 185789 SAR_Eukaryotes SAR_Eukaryotes 370 8.679999999999999e-98   NTclustered gi|1132112364|emb|LT671580.1| 185789 g25711 i0 85.675 39.3653333333333 363 26 96 10 1 360 696 357 Foraminifera environmental sample partial 18S rRNA gene, isolate OTU33 blastn 14762 370 1 Eukaryota Sar   Foraminifera         Foraminifera environmental sample
9054790 9054790 PRJEB64798_P_NODE_177448_length_175_cov_6.833333_g175682_i0 PRJEB64798 177448 175 6.833333 11.95833275 Foraminifera sp. chocolate silver saccamminid 1415197 SAR_Eukaryotes SAR_Eukaryotes 187 3.8699999999999985e-43   NTclustered gi|745794572|gb|KF728632.1| 1415197 g175682 i0 87.654 77.36 162 18 92 2 1 161 347 187 Foraminifera sp. chocolate silver saccamminid clone CSS9 actin (act) gene, partial cds blastn 13538 187 1 Eukaryota Sar   Foraminifera         Foraminifera sp. chocolate silver saccamminid
10329613 10329613 PRJEB64798_P_NODE_115089_length_208_cov_26.031447_g113323_i0 PRJEB64798 115089 208 26.031447 54.14540976 Pulleniatina obliquiloculata 225066 SAR_Eukaryotes SAR_Eukaryotes 122 1.37e-23   NTclustered gi|998623046|dbj|LC049325.1| 225066 g113323 i0 94.937 8.67788461538461 79 3 38 1 125 202 1795 1717 Pulleniatina obliquiloculata gene for 28S rRNA, partial sequence, isolate: KH284 blastn 1805 122 1 Eukaryota Sar   Foraminifera   Rotaliida Pulleniatinidae Pulleniatina Pulleniatina obliquiloculata
11605696 11605696 PRJEB64798_P_NODE_157430_length_184_cov_22.407407_g155664_i0 PRJEB64798 157430 184 22.407407 41.22962888 Neoassilina ammonoides 378197 SAR_Eukaryotes SAR_Eukaryotes 167 5.37e-37   NTclustered gi|873754158|emb|LN851734.1| 378197 g155664 i0 94.545 49.0271739130435 110 3 59 3 59 166 416 524 Operculina ammonoides partial 28S rRNA gene, isolate 494, clone 1 blastn 9021 167 1 Eukaryota Sar   Foraminifera   Rotaliida Nummulitidae Neoassilina Neoassilina ammonoides
14158143 14158143 PRJEB64798_P_NODE_87052_length_212_cov_14.785276_g85286_i0 PRJEB64798 87052 212 14.785276 31.34478512 Neogloboquadrina dutertrei 51039 SAR_Eukaryotes SAR_Eukaryotes 76.8 1.11e-9   NTclustered gi|998623043|dbj|LC049322.1| 51039 g85286 i0 87.143 17.6792452830189 70 5 31 3 147 212 4447 4516 Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89 blastn 3748 76.8 1 Eukaryota Sar   Foraminifera   Rotaliida Globorotaliidae Neogloboquadrina Neogloboquadrina dutertrei
15431870 15431870 PRJEB64798_P_NODE_70053_length_231_cov_4.340659_g68288_i0 PRJEB64798 70053 231 4.340659 10.02692229 uncultured soil foraminiferan 760941 SAR_Eukaryotes SAR_Eukaryotes 206 1.5e-48   NTclustered gi|295640952|gb|GU433652.1| 760941 g68288 i0 99.123 49.7965367965368 114 1 49 0 118 231 719 832 Uncultured soil foraminiferan clone A3 small subunit ribosomal RNA gene, partial sequence blastn 11503 206 1 Eukaryota Sar   Foraminifera         uncultured soil foraminiferan
16296267 16296267 PRJEB64798_P_NODE_54593_length_264_cov_7.223256_g52828_i0 PRJEB64798 54593 264 7.223256 19.06939584 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 233 8.02e-57   NTclustered gi|998623043|dbj|LC049322.1| 51039 g52828 i0 91.667 42.5757575757576 168 14 64 0 20 187 4199 4032 Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89 blastn 11240 233 1 Eukaryota Sar   Foraminifera   Rotaliida Globorotaliidae Neogloboquadrina Neogloboquadrina dutertrei
18844822 18844822 PRJEB64798_P_NODE_206435_length_165_cov_354.870690_g204669_i0 PRJEB64798 206435 165 354.87069 585.5366385 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 250 4.5599999999999996e-62   NTclustered gi|550600769|gb|KF042530.1| 45993 g204669 i0 94.969 96.3090909090909 159 8 96 0 7 165 433 591 Haynesina germanica isolate 2733.1 small subunit ribosomal RNA gene, partial sequence blastn 15891 250 1 Eukaryota Sar   Foraminifera   Rotaliida Nonionidae Haynesina Haynesina germanica
21806468 21806468 PRJEB64798_P_NODE_86398_length_212_cov_50.576687_g84632_i0 PRJEB64798 86398 212 50.576687 107.22257644 Rotaliella elatiana 35210 SAR_Eukaryotes SAR_Eukaryotes 206 1.3499999999999999e-48   NTclustered gi|643022|emb|X78521.1| 35210 g84632 i0 95.349 20.6792452830189 129 6 61 0 7 135 2727 2855 R.elatiana complete gene of large subunit rRNA blastn 4384 206 1 Eukaryota Sar   Foraminifera   Rotaliida Rotaliidae Rotaliella Rotaliella elatiana
23079102 23079102 PRJEB64798_P_NODE_151839_length_187_cov_8.152174_g150073_i0 PRJEB64798 151839 187 8.152174 15.24456538 Vellaria sp. 12192 1238464 SAR_Eukaryotes SAR_Eukaryotes 152 1.5299999999999998e-32   NTclustered gi|559105585|emb|HE998684.1| 1238464 g150073 i0 90 66.2887700534759 120 9 64 2 67 186 1094 1210 Vellaria sp. 12192 partial 18s rRNA gene, isolate 12192 blastn 12396 152 1 Eukaryota Sar   Foraminifera     Allogromiidae Vellaria Vellaria sp. 12192
23945124 23945124 PRJEB64798_P_NODE_126119_length_200_cov_46.105960_g124353_i0 PRJEB64798 126119 200 46.10596 92.21192 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 185 1.64e-42   NTclustered gi|157850718|gb|EU019718.1| 212506 g124353 i0 93.548 62.41 124 8 62 0 64 187 408 285 Bulimina aculeata clone BAE006 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 12482 185 1 Eukaryota Sar   Foraminifera   Rotaliida Buliminidae Bulimina Bulimina aculeata

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