RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1067370", tax_clade = "Sar" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA1067370 · 14 ✖

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
180524 180524 PRJNA1067370_P_NODE_102461_length_244_cov_1.684211_g101912_i0 PRJNA1067370 102461 244 1.684211 4.10947484 root 1 Root_unresolved Root_unresolved 166 2.4699999999999998e-46   NR ETO35987.1 46433 g101912 i0 91.4 71.9508196721311 81 7 99.6 0 2 244 101 181 ETO35987.1 hypothetical protein RFI_01076 [Reticulomyxa filosa] diamond 17556 167 0.994011976047904 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
1455384 1455384 PRJNA1067370_P_NODE_19762_length_422_cov_2.085960_g19214_i0 PRJNA1067370 19762 422 2.08596 8.8027512 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 186 3.739999999999999e-52   NR ETO10415.1 46433 g19214 i0 79.8 2.77251184834123 129 25 91.7 1 417 31 649 776 ETO10415.1 inorganic pyrophosphatase [Reticulomyxa filosa] diamond 1170 186 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
3563799 3563799 PRJNA1067370_P_NODE_26343_length_374_cov_1.534884_g25795_i0 PRJNA1067370 26343 374 1.534884 5.74046616 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 132 7.88e-36   NR ETO16568.1 46433 g25795 i0 56.3 6.12032085561497 126 52 99.5 3 1 372 30 154 ETO16568.1 14-3-3-like protein [Reticulomyxa filosa] diamond 2289 133 0.992481203007519 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
9108276 9108276 PRJNA1067370_P_NODE_18368_length_436_cov_1.264463_g17820_i0 PRJNA1067370 18368 436 1.264463 5.51305868 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 172 3.58e-49   NR ETO09453.1 46433 g17820 i0 68.2 0.887614678899083 129 38 88.8 2 434 48 197 322 ETO09453.1 hypothetical protein RFI_27925 [Reticulomyxa filosa] diamond 387 172 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
15483350 15483350 PRJNA1067370_P_NODE_111733_length_242_cov_0.911243_g111184_i0 PRJNA1067370 111733 242 0.911243 2.20520806 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 122 2.54e-30   NR ETO28518.1 46433 g111184 i0 67.5 1.98347107438017 80 26 99.2 0 241 2 642 721 ETO28518.1 axonemal dynein gamma heavy chain [Reticulomyxa filosa] diamond 480 122 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
19306559 19306559 PRJNA1067370_P_NODE_52656_length_291_cov_1.059633_g52107_i0 PRJNA1067370 52656 291 1.059633 3.08353203 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 144 5.89e-38   NR ETO16925.1 46433 g52107 i0 83.3 1.97938144329897 96 15 99 1 289 2 511 605 ETO16925.1 hypothetical protein RFI_20413 [Reticulomyxa filosa] diamond 576 144 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27035636 27035636 PRJNA1067370_P_NODE_91622_length_248_cov_0.880000_g91073_i0 PRJNA1067370 91622 248 0.88 2.1824 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 79 7.29e-15   NR ETO26653.1 46433 g91073 i0 54.4 0.955645161290323 79 36 95.6 0 12 248 3360 3438 ETO26653.1 hypothetical protein RFI_10483 [Reticulomyxa filosa] diamond 237 79 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28330417 28330417 PRJNA1067370_P_NODE_3346_length_941_cov_2.602535_g2917_i0 PRJNA1067370 3346 941 2.602535 24.48985435 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 103 1.05e-20   NR ETO01289.1 46433 g2917 i0 30.8 0.921360255047821 289 117 76.5 10 726 7 127 381 ETO01289.1 hypothetical protein RFI_36155 [Reticulomyxa filosa] diamond 867 103 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29056810 29056810 PRJNA1067370_P_NODE_33348_length_342_cov_1.066914_g32800_i0 PRJNA1067370 33348 342 1.066914 3.64884588 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.33e-4   NR ETO10441.1 46433 g32800 i0 32.3 1.16666666666667 133 52 97.4 4 342 10 580 696 ETO10441.1 sorting nexin-29 [Reticulomyxa filosa] diamond 399 49.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29806008 29806008 PRJNA1067370_P_NODE_115551_length_241_cov_0.863095_g115002_i0 PRJNA1067370 115551 241 0.863095 2.08005895 root 1 Root_unresolved Root_unresolved 109 1.24e-25   NR ETO35216.1 46433 g115002 i0 70 1.86721991701245 70 21 87.1 0 30 239 113 182 ETO35216.1 coagulation factor 5/8 type domain-containing protein [Reticulomyxa filosa] diamond 450 109 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29837617 29837617 PRJNA1067370_P_NODE_109091_length_242_cov_2.136095_g108542_i0 PRJNA1067370 109091 242 2.136095 5.1693499 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.3 3.16e-6   NR ETO27415.1 46433 g108542 i0 41.1 2.35537190082645 56 33 69.4 0 194 27 1364 1419 ETO27415.1 hypothetical protein RFI_09718 [Reticulomyxa filosa] diamond 570 54.7 0.992687385740402 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30983647 30983647 PRJNA1067370_P_NODE_46874_length_304_cov_1.541126_g46326_i0 PRJNA1067370 46874 304 1.541126 4.68502304 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.6e-17   NR ETO34511.1 46433 g46326 i0 45.5 2.74342105263158 110 50 98.7 2 302 3 14 123 ETO34511.1 hypothetical protein RFI_02584 [Reticulomyxa filosa] diamond 834 84.3 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
32312203 32312203 PRJNA1067370_P_NODE_88179_length_249_cov_0.875000_g87630_i0 PRJNA1067370 88179 249 0.875 2.17875 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 78.6 9.61e-15   NR ETO10775.1 46433 g87630 i0 42.7 1.97590361445783 82 47 98.8 0 249 4 170 251 ETO10775.1 hypothetical protein RFI_26601, partial [Reticulomyxa filosa] diamond 492 78.6 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
32406882 32406882 PRJNA1067370_P_NODE_87099_length_249_cov_0.875000_g86550_i0 PRJNA1067370 87099 249 0.875 2.17875 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.2e-5   NR ETO14021.1 46433 g86550 i0 34.4 0.734939759036145 61 40 73.5 0 3 185 2179 2239 ETO14021.1 Ubiquitin carboxyl-terminal hydrolase family protein [Reticulomyxa filosa] diamond 183 52.8 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);;