RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA379145" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA379145 · 19 ✖

analysis 1

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
1675644 1675644 PRJNA379145_P_NODE_46422_length_255_cov_1.522523_g44269_i0 PRJNA379145 46422 255 1.522523 3.88243365 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 133 3.3999999999999997e-35   NR ETO31553.1 46433 g44269 i0 77.4 11.8588235294118 84 19 98.8 0 3 254 226 309 ETO31553.1 26S proteasome regulatory subunit [Reticulomyxa filosa] diamond 3024 133 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27092026 27092026 PRJNA379145_P_NODE_52322_length_221_cov_1.840426_g50168_i0 PRJNA379145 52322 221 1.840426 4.06734146 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.08e-15   NR ETO21586.1 46433 g50168 i0 52.5 6.24434389140271 61 29 82.8 0 214 32 239 299 ETO21586.1 casein kinase I isoform delta-A, partial [Reticulomyxa filosa] diamond 1380 79.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27137772 27137772 PRJNA379145_P_NODE_64282_length_175_cov_1.267606_g62128_i0 PRJNA379145 64282 175 1.267606 2.2183105 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 71.6 1.28e-13   NR ETO09502.1 46433 g62128 i0 61.4 0.977142857142857 57 22 97.7 0 5 175 50 106 ETO09502.1 hypothetical protein RFI_27873, partial [Reticulomyxa filosa] diamond 171 71.6 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27201147 27201147 PRJNA379145_P_NODE_26382_length_472_cov_1.870159_g24329_i0 PRJNA379145 26382 472 1.870159 8.82715048 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 117 4.18e-28   NR ETO33004.1 46433 g24329 i0 43.2 0.75 118 55 67.4 1 340 23 264 381 ETO33004.1 hypothetical protein RFI_04104 [Reticulomyxa filosa] diamond 354 117 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27454394 27454394 PRJNA379145_P_NODE_52903_length_218_cov_1.897297_g50749_i0 PRJNA379145 52903 218 1.897297 4.13610746 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.51e-4   NR ETO30447.1 46433 g50749 i0 43.8 0.880733944954128 64 35 86.7 1 8 196 39 102 ETO30447.1 poly(A)-binding protein [Reticulomyxa filosa] diamond 192 48.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27770164 27770164 PRJNA379145_P_NODE_53084_length_217_cov_2.146739_g50930_i0 PRJNA379145 53084 217 2.146739 4.65842363 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 62 2.07e-9   NR ETO19354.1 46433 g50930 i0 41.4 0.967741935483871 70 41 96.8 0 215 6 79 148 ETO19354.1 hypothetical protein RFI_17876 [Reticulomyxa filosa] diamond 210 62 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28496204 28496204 PRJNA379145_P_NODE_11807_length_862_cov_44.914355_g10472_i0 PRJNA379145 11807 862 44.914355 387.1617401 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 165 3.14e-45   NR ETO28241.1 46433 g10472 i0 37.5 0.873549883990719 251 123 76.2 8 725 69 68 316 ETO28241.1 hypothetical protein RFI_08889 [Reticulomyxa filosa] diamond 753 165 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28544956 28544956 PRJNA379145_P_NODE_57807_length_197_cov_1.975610_g55653_i0 PRJNA379145 57807 197 1.97561 3.8919517 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00793   NR ETO18758.1 46433 g55653 i0 61.1 2.32994923857868 36 13 54.8 1 86 193 38 72 ETO18758.1 hypothetical protein RFI_18497 [Reticulomyxa filosa] diamond 459 44.3 0.99097065462754 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29758969 29758969 PRJNA379145_P_NODE_63951_length_176_cov_1.125874_g61797_i0 PRJNA379145 63951 176 1.125874 1.98153824 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 66.2 5.56e-11   NR ETO16281.1 46433 g61797 i0 58.8 2.40340909090909 51 19 83.5 1 1 147 44 94 ETO16281.1 hypothetical protein RFI_21073 [Reticulomyxa filosa] diamond 423 66.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29839227 29839227 PRJNA379145_P_NODE_48731_length_241_cov_1.307692_g46577_i0 PRJNA379145 48731 241 1.307692 3.15153772 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 98.6 4.539999999999999e-23   NR ETO30560.1 46433 g46577 i0 54.4 2.95020746887967 79 36 98.3 0 3 239 84 162 ETO30560.1 hypothetical protein RFI_06560 [Reticulomyxa filosa] diamond 711 98.6 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30106422 30106422 PRJNA379145_P_NODE_29512_length_423_cov_2.602564_g27401_i0 PRJNA379145 29512 423 2.602564 11.00884572 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 64.7 3.96e-9   NR ETO37012.1 46433 g27401 i0 38.7 1.70921985815603 75 46 53.2 0 3 227 239 313 ETO37012.1 hypothetical protein RFI_00050 [Reticulomyxa filosa] diamond 723 64.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30123453 30123453 PRJNA379145_P_NODE_52592_length_220_cov_1.347594_g50438_i0 PRJNA379145 52592 220 1.347594 2.9647068 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.5 2.24e-12   NR ETO09936.1 46433 g50438 i0 42.3 6.65454545454545 71 41 96.8 0 220 8 186 256 ETO09936.1 hypothetical protein RFI_27442 [Reticulomyxa filosa] diamond 1464 70.9 0.994358251057828 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30439737 30439737 PRJNA379145_P_NODE_23593_length_521_cov_1.907787_g21605_i0 PRJNA379145 23593 521 1.907787 9.93957027 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.37e-11   NR ETO09283.1 46433 g21605 i0 36.7 2.91938579654511 120 68 68.5 2 151 507 225 337 ETO09283.1 hypothetical protein RFI_28107 [Reticulomyxa filosa] diamond 1521 73.6 0.994565217391304 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31307205 31307205 PRJNA379145_P_NODE_27975_length_446_cov_2.634383_g25885_i0 PRJNA379145 27975 446 2.634383 11.74934818 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 102 2.01e-24   NR ETO07726.1 46433 g25885 i0 37.6 0.894618834080718 133 73 85.4 3 403 23 17 145 ETO07726.1 hypothetical protein RFI_29665 [Reticulomyxa filosa] diamond 399 102 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31338825 31338825 PRJNA379145_P_NODE_25036_length_495_cov_2.086580_g23007_i0 PRJNA379145 25036 495 2.08658 10.328571 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 91.7 3.18e-19   NR ETO19354.1 46433 g23007 i0 58.1 0.375757575757576 62 26 37.6 0 7 192 40 101 ETO19354.1 hypothetical protein RFI_17876 [Reticulomyxa filosa] diamond 186 91.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
32020314 32020314 PRJNA379145_P_NODE_59378_length_191_cov_1.721519_g57224_i0 PRJNA379145 59378 191 1.721519 3.28810129 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00952   NR ETO22578.1 46433 g57224 i0 54.3 1.85340314136126 35 16 55 0 60 164 4 38 ETO22578.1 short-chain dehydrogenase/reductase SDR [Reticulomyxa filosa] diamond 354 43.5 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
32351462 32351462 PRJNA379145_P_NODE_50319_length_232_cov_1.140704_g48165_i0 PRJNA379145 50319 232 1.140704 2.64643328 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 73.9 1.18e-14   NR ETO13273.1 46433 g48165 i0 46.9 1.04741379310345 81 34 93.1 1 1 216 29 109 ETO13273.1 hypothetical protein RFI_24099 [Reticulomyxa filosa] diamond 243 73.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
32715641 32715641 PRJNA379145_P_NODE_52880_length_218_cov_2.113514_g50726_i0 PRJNA379145 52880 218 2.113514 4.60746052 root 1 Root_unresolved Root_unresolved 65.9 1.8e-10   NR ETO13146.1 46433 g50726 i0 50 6.61926605504587 72 34 99.1 1 216 1 129 198 ETO13146.1 hypothetical protein RFI_24227, partial [Reticulomyxa filosa] diamond 1443 65.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
32761604 32761604 PRJNA379145_P_NODE_45480_length_261_cov_1.561404_g43328_i0 PRJNA379145 45480 261 1.561404 4.07526444 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 91.3 3.93e-19   NR ETO22086.1 46433 g43328 i0 54.4 0.908045977011494 79 35 90.8 1 21 257 764 841 ETO22086.1 protein serine/threonine phosphatase, partial [Reticulomyxa filosa] diamond 237 91.3 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

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