contig_metadata
24 rows where bioproject = "PRJEB64798" and tax_phylum = "Foraminifera"
This data as json, CSV (advanced)
| 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 | |||
| 26844127 | 26844127 | PRJEB64798_P_NODE_238921_length_155_cov_8.216981_g237155_i0 | PRJEB64798 | 238921 | 155 | 8.216981 | 12.73632055 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 2.78e-17 | NR | ETO29104.1 | 46433 | g237155 | i0 | 73.5 | 0.948387096774194 | 49 | 13 | 94.8 | 0 | 154 | 8 | 238 | 286 | ETO29104.1 hypothetical protein RFI_08022 [Reticulomyxa filosa] | diamond | 147 | 84 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27279815 | 27279815 | PRJEB64798_P_NODE_222443_length_161_cov_11.803571_g220677_i0 | PRJEB64798 | 222443 | 161 | 11.803571 | 19.00374931 | Ochromonadales | 98652 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 8.18e-5 | NR | ETO06965.1 | 46433 | g220677 | i0 | 54.3 | 1.45341614906832 | 35 | 16 | 65.2 | 0 | 106 | 2 | 109 | 143 | ETO06965.1 hypothetical protein RFI_30425 [Reticulomyxa filosa] | diamond | 234 | 48.1 | 0.993762993762994 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27318285 | 27318285 | PRJEB64798_P_NODE_122223_length_205_cov_2.070513_g120457_i0 | PRJEB64798 | 122223 | 205 | 2.070513 | 4.24455165 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 1.56e-16 | NR | ETO29218.1 | 46433 | g120457 | i0 | 57.4 | 0.892682926829268 | 61 | 26 | 89.3 | 0 | 184 | 2 | 299 | 359 | ETO29218.1 CCR4-NOT transcription complex subunit 8, partial [Reticulomyxa filosa] | diamond | 183 | 82.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27507907 | 27507907 | PRJEB64798_P_NODE_17223_length_480_cov_8.559165_g15516_i0 | PRJEB64798 | 17223 | 480 | 8.559165 | 41.083992 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 2.07e-11 | NR | ETO27996.1 | 46433 | g15516 | i0 | 34.6 | 0.66875 | 107 | 70 | 66.9 | 0 | 476 | 156 | 60 | 166 | ETO27996.1 5'-3' exoribonuclease 1, partial [Reticulomyxa filosa] | diamond | 321 | 72.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28707747 | 28707747 | PRJEB64798_P_NODE_250707_length_151_cov_11.666667_g248941_i0 | PRJEB64798 | 250707 | 151 | 11.666667 | 17.61666717 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 2.42e-7 | NR | ETO10243.1 | 46433 | g248941 | i0 | 53.2 | 3.73509933774834 | 47 | 22 | 93.4 | 0 | 143 | 3 | 26 | 72 | ETO10243.1 hypothetical protein RFI_27134, partial [Reticulomyxa filosa] | diamond | 564 | 55.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30002294 | 30002294 | PRJEB64798_P_NODE_176411_length_176_cov_1.944882_g174645_i0 | PRJEB64798 | 176411 | 176 | 1.944882 | 3.42299232 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 1.3e-12 | NR | ETO23157.1 | 46433 | g174645 | i0 | 63 | 0.920454545454545 | 54 | 20 | 92 | 0 | 10 | 171 | 144 | 197 | ETO23157.1 putative hydrolase [Reticulomyxa filosa] | diamond | 162 | 70.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30128176 | 30128176 | PRJEB64798_P_NODE_124592_length_202_cov_7.771242_g122826_i0 | PRJEB64798 | 124592 | 202 | 7.771242 | 15.69790884 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 2.97e-9 | NR | ETO08387.1 | 46433 | g122826 | i0 | 74.3 | 2.73267326732673 | 35 | 9 | 52 | 0 | 5 | 109 | 55 | 89 | ETO08387.1 S-Adenosyl homocysteine hydrolase [Reticulomyxa filosa] | diamond | 552 | 60.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30563671 | 30563671 | PRJEB64798_P_NODE_213013_length_164_cov_1.391304_g211247_i0 | PRJEB64798 | 213013 | 164 | 1.391304 | 2.28173856 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 5.15e-9 | NR | ETO33799.1 | 46433 | g211247 | i0 | 65 | 2.35975609756098 | 40 | 14 | 73.2 | 0 | 121 | 2 | 192 | 231 | ETO33799.1 Protein kinase domain containing protein [Reticulomyxa filosa] | diamond | 387 | 60.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31107866 | 31107866 | PRJEB64798_P_NODE_185435_length_172_cov_3.406504_g183669_i0 | PRJEB64798 | 185435 | 172 | 3.406504 | 5.85918688 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 6.23e-9 | NR | ETO03611.1 | 46433 | g183669 | i0 | 55.3 | 0.819767441860465 | 47 | 21 | 82 | 0 | 146 | 6 | 176 | 222 | ETO03611.1 translation initiation factor if-2 betam beta subunit ZnR [Reticulomyxa filosa] | diamond | 141 | 60.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa |
Advanced export
JSON shape: default, array, newline-delimited
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);;