RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA557895" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA557895 · 18 ✖

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
14565193 14565193 PRJNA557895_P_NODE_3152_length_552_cov_37.298211_g2810_i0 PRJNA557895 3152 552 37.298211 205.88612472 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 987 0   NTclustered gi|325194495|emb|FR825318.1| 890382 g2810 i0 98.913 240.791666666667 552 6 100 0 1 552 582 31 Albugo laibachii Nc14, genomic contig CONTIG_2072_NC14_v4_1125_53 blastn 132917 987 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
17113793 17113793 PRJNA557895_P_NODE_24274_length_188_cov_1.215827_g23919_i0 PRJNA557895 24274 188 1.215827 2.28575476 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 115 5.56e-29   NR CEO96949.1 37360 g23919 i0 83.9 6.92553191489362 62 10 98.9 0 3 188 205 266 CEO96949.1 hypothetical protein PBRA_005553 [Plasmodiophora brassicae] diamond 1302 116 0.991379310344828 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
17114148 17114148 PRJNA557895_P_NODE_454_length_1725_cov_3.541766_g174_i1 PRJNA557895 454 1725 3.541766 61.0954635 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 63.9 8.21e-5   NTclustered gi|987228|gb|U20449.1|PTU20449 5888 g174 i1 89.796 0.0852173913043478 49 5 3 0 1127 1175 5996 5948 Paramecium tetraurelia cytoplasmic dynein heavy chain gene, partial cds blastn 147 63.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
17706300 17706300 PRJNA557895_P_NODE_35934_length_163_cov_0.894737_g35579_i0 PRJNA557895 35934 163 0.894737 1.45842131 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|124513751|ref|XM_001350196.1| 36329 g35579 i0 100 0.552147239263804 30 0 18 0 132 161 3811 3840 Plasmodium falciparum 3D7 GTP-binding protein, putative (PF3D7_1352000), partial mRNA blastn 90 56.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
18979662 18979662 PRJNA557895_P_NODE_10735_length_280_cov_0.883117_g10380_i0 PRJNA557895 10735 280 0.883117 2.4727276 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.026   NTclustered gi|2785766952|ref|XM_067218628.1| 5824 g10380 i0 100 0.2 28 0 10 0 253 280 139 166 Plasmodium brasilianum uncharacterized protein (MKS88_005371), partial mRNA blastn 56 52.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium brasilianum
22212799 22212799 PRJNA557895_P_NODE_11698_length_269_cov_2.436364_g11343_i0 PRJNA557895 11698 269 2.436364 6.55381916 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 144 1.46e-41   NR KAE8946087.1 53985 g11343 i0 71.6 16.7509293680297 88 25 98.1 0 1 264 58 145 KAE8946087.1 Ras-related protein [Phytophthora fragariae] diamond 4506 145 0.993103448275862 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
24762300 24762300 PRJNA557895_P_NODE_25940_length_181_cov_1.159091_g25585_i0 PRJNA557895 25940 181 1.159091 2.09795471 Plasmodium reichenowi 5854 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.004   NTclustered gi|1145255972|ref|XM_012905491.2| 5854 g25585 i0 96.875 0.176795580110497 32 1 18 0 150 181 1662 1631 Plasmodium reichenowi hypothetical protein partial mRNA blastn 32 54.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium reichenowi
26825867 26825867 PRJNA557895_P_NODE_17561_length_220_cov_1.070175_g17206_i0 PRJNA557895 17561 220 1.070175 2.354385 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 92 6.77e-20   NR GAX15725.1 1519565 g17206 i0 74.2 5.94545454545455 62 16 84.5 0 1 186 97 158 GAX15725.1 type I protein arginine methyltransferase [Fistulifera solaris] diamond 1308 92 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27236860 27236860 PRJNA557895_P_NODE_34923_length_164_cov_0.886957_g34568_i0 PRJNA557895 34923 164 0.886957 1.45460948 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 83.2 7.09e-17   NR GLE07309.1 114742 g34568 i0 78.8 1.90243902439024 52 11 95.1 0 159 4 2491 2542 GLE07309.1 hypothetical protein PINS_up017439 [Pythium insidiosum] diamond 312 83.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
27661773 27661773 PRJNA557895_P_NODE_19684_length_209_cov_1.075000_g19329_i0 PRJNA557895 19684 209 1.075 2.24675 Triparma 722752 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.15e-4   NR GMH58210.1 1714386 g19329 i0 62.5 1.92344497607656 32 12 45.9 0 114 209 360 391 GMH58210.1 hypothetical protein TL16_g02558 [Triparma laevis f. inornata] diamond 402 49.3 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma laevis
27788029 27788029 PRJNA557895_P_NODE_22184_length_197_cov_1.378378_g21829_i0 PRJNA557895 22184 197 1.378378 2.71540466 root 1 Root_unresolved Root_unresolved 70.9 1.69e-12   NR CAD8074771.1 5886 g21829 i0 47.7 9.77664974619289 65 34 99 0 195 1 54 118 CAD8074771.1 unnamed protein product [Paramecium primaurelia] diamond 1926 71.2 0.995786516853933 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29335055 29335055 PRJNA557895_P_NODE_37269_length_162_cov_0.902655_g36914_i0 PRJNA557895 37269 162 0.902655 1.4623011 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00678   NR XP_067819810.1 4779 g36914 i0 42 2.83333333333333 50 29 92.6 0 1 150 216 265 XP_067819810.1 hypothetical protein CCR75_001658 [Bremia lactucae] diamond 459 43.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
29762821 29762821 PRJNA557895_P_NODE_14911_length_238_cov_2.158730_g14556_i0 PRJNA557895 14911 238 2.15873 5.1377774 Amoebophrya sp. A12 88552 SAR_Eukaryotes SAR_Eukaryotes 54.3 8.32e-7   NR CAD7970531.1 2202890 g14556 i0 45.1 1.57563025210084 71 38 88.2 1 212 3 38 108 CAD7970531.1 unnamed protein product [Amoebophrya sp. A120] diamond 375 54.3 1 Eukaryota Sar     Dinophyceae Syndiniales Amoebophryaceae Amoebophrya Amoebophrya sp. A120
29794418 29794418 PRJNA557895_P_NODE_30331_length_167_cov_0.864407_g29976_i0 PRJNA557895 30331 167 0.864407 1.44355969 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 81.3 2.98e-16   NR SPQ94227.1 37360 g29976 i0 61.8 1.97604790419162 55 21 98.8 0 3 167 354 408 SPQ94227.1 unnamed protein product [Plasmodiophora brassicae] diamond 330 81.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30300457 30300457 PRJNA557895_P_NODE_27792_length_174_cov_1.224000_g27437_i0 PRJNA557895 27792 174 1.224 2.12976 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 53.1 3e-6   NR DAZ99648.1 4803 g27437 i0 40.7 1.86206896551724 54 32 93.1 0 9 170 203 256 DAZ99648.1 TPA: hypothetical protein N0F65_001885 [Lagenidium giganteum] diamond 324 53.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
30584203 30584203 PRJNA557895_P_NODE_31353_length_166_cov_0.871795_g30998_i0 PRJNA557895 31353 166 0.871795 1.4471797 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 75.9 4.49e-15   NR TMW55611.1 41045 g30998 i0 85.1 0.849397590361446 47 6 84.9 1 24 164 1 46 TMW55611.1 hypothetical protein Poli38472_010493 [Pythium oligandrum] diamond 141 75.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
30868655 30868655 PRJNA557895_P_NODE_35154_length_163_cov_1.342105_g34799_i0 PRJNA557895 35154 163 1.342105 2.18763115 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.77e-5   NR KAI2507920.1 210448 g34799 i0 44.4 1.69325153374233 45 25 82.8 0 157 23 412 456 KAI2507920.1 hypothetical protein MHU86_6453 [Fragilaria crotonensis] diamond 276 50.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32369451 32369451 PRJNA557895_P_NODE_22179_length_197_cov_1.378378_g21824_i0 PRJNA557895 22179 197 1.378378 2.71540466 root 1 Root_unresolved Root_unresolved 79 1.98e-15   NR KAF0740755.1 100861 g21824 i0 63.5 5.49746192893401 63 23 95.9 0 2 190 253 315 KAF0740755.1 hypothetical protein Ae201684_003886 [Aphanomyces euteiches] diamond 1083 79.7 0.991217063989962 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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