RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJEB11523 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
13719 13719 PRJEB11523_P_NODE_2361_length_343_cov_5.653061_g2283_i0 PRJEB11523 2361 343 5.653061 19.38999923 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.51e-15   NR KAL4506716.1 2486642 g2283 i0 81.3 0.419825072886297 48 9 42 0 156 13 422 469 KAL4506716.1 hypothetical protein ABPG72_000287 [Tetrahymena utriculariae] diamond 144 82.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
15315954 15315954 PRJEB11523_P_NODE_2493_length_332_cov_1.441696_g2415_i0 PRJEB11523 2493 332 1.441696 4.78643072 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 117 9.33e-28   NR TNV86781.1 5974 g2415 i0 84.7 1.0933734939759 59 9 53.3 0 12 188 673 731 TNV86781.1 hypothetical protein FGO68_gene10147 [Halteria grandinella] diamond 363 117 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
26652602 26652602 PRJEB11523_P_NODE_5121_length_206_cov_21.089172_g5043_i0 PRJEB11523 5121 206 21.089172 43.44369432 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 47.8 3.96e-4   NR XP_001018217.2 312017 g5043 i0 47.8 0.669902912621359 46 21 64.1 2 73 204 381 425 XP_001018217.2 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 138 47.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26747449 26747449 PRJEB11523_P_NODE_5601_length_196_cov_8.244898_g5523_i0 PRJEB11523 5601 196 8.244898 16.16000008 Uronema marinum 35107 SAR_Eukaryotes SAR_Eukaryotes 87 4.01e-18   NR YP_009512651.1 35107 g5523 i0 73.6 0.811224489795918 53 14 81.1 0 192 34 377 429 YP_009512651.1 NADH dehydrogenase subunit 7 [Uronema marinum] diamond 159 87 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Uronematidae Uronema Uronema marinum
26969365 26969365 PRJEB11523_P_NODE_3482_length_263_cov_2.887850_g3404_i0 PRJEB11523 3482 263 2.88785 7.5950455 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 64.3 6.86e-10   NR CAI2375198.1 5936 g3404 i0 50 2.34980988593156 66 31 75.3 1 239 42 93 156 CAI2375198.1 unnamed protein product [Moneuplotes crassus] diamond 618 64.3 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
27696489 27696489 PRJEB11523_P_NODE_2524_length_329_cov_2.307143_g2446_i0 PRJEB11523 2524 329 2.307143 7.59050047 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0403   NR CAE8711519.1 89957 g2446 i0 65.7 0.319148936170213 35 12 31.9 0 41 145 1088 1122 CAE8711519.1 unnamed protein product [Polarella glacialis] diamond 105 43.9 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
27948793 27948793 PRJEB11523_P_NODE_3265_length_275_cov_2.340708_g3187_i0 PRJEB11523 3265 275 2.340708 6.436947 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 122 1.25e-30   NR CAB9531516.1 568900 g3187 i0 61.9 1.85454545454545 84 32 91.6 0 1 252 148 231 CAB9531516.1 osmC-like protein [Seminavis robusta] diamond 510 122 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28037491 28037491 PRJEB11523_P_NODE_3725_length_251_cov_2.801980_g3647_i0 PRJEB11523 3725 251 2.80198 7.0329698 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 142 1.54e-39   NR KAG7356896.1 303405 g3647 i0 89.9 4.72111553784861 79 8 94.4 0 14 250 230 308 KAG7356896.1 mitochondrial carrier protein [Nitzschia inconspicua] diamond 1185 142 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28043493 28043493 PRJEB11523_P_NODE_1785_length_416_cov_2.275204_g1707_i0 PRJEB11523 1785 416 2.275204 9.46484864 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 46.6 9.11e-4   NR EJK58442.1 159749 g1707 i0 64.9 0.266826923076923 37 13 26.7 0 273 383 24 60 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 111 46.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28675079 28675079 PRJEB11523_P_NODE_2867_length_299_cov_51.976000_g2789_i0 PRJEB11523 2867 299 51.976 155.40824 Hyaloperonospora brassicae 162125 SAR_Eukaryotes SAR_Eukaryotes 80.5 3.27e-15   NR CAI5729246.1 162125 g2789 i0 97.6 0.421404682274247 42 1 42.1 0 13 138 382 423 CAI5729246.1 unnamed protein product [Hyaloperonospora brassicae] diamond 126 80.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora brassicae
28706657 28706657 PRJEB11523_P_NODE_5807_length_192_cov_2.650350_g5729_i0 PRJEB11523 5807 192 2.65035 5.088672 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 65.5 5.84e-11   NR KAG7338838.1 303405 g5729 i0 88.2 1.65625 34 4 53.1 0 160 59 184 217 KAG7338838.1 50S ribosomal protein L10 [Nitzschia inconspicua] diamond 318 65.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28991026 28991026 PRJEB11523_P_NODE_6848_length_175_cov_4.476190_g6770_i0 PRJEB11523 6848 175 4.47619 7.8333325 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 48.9 9.78e-5   NR KAL4490488.1 5901 g6770 i0 46 3.73714285714286 50 25 84 2 27 173 188 236 KAL4490488.1 hypothetical protein ABPG73_009465 [Tetrahymena malaccensis] diamond 654 49.3 0.991886409736308 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29495860 29495860 PRJEB11523_P_NODE_1310_length_508_cov_4.718954_g1232_i0 PRJEB11523 1310 508 4.718954 23.97228632 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 213 5.2e-65   NR KAJ1437197.1 483371 g1232 i0 69.1 0.897637795275591 152 44 89.8 2 458 3 9 157 KAJ1437197.1 hypothetical protein B484DRAFT_392912 [Ochromonadaceae sp. CCMP2298] diamond 456 213 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30569621 30569621 PRJEB11523_P_NODE_233_length_1227_cov_78.300509_g196_i0 PRJEB11523 233 1227 78.300509 960.74724543 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 144 6.459999999999999e-37   NR OMJ91231.1 5963 g196 i0 54.3 0.342298288508557 140 62 34.2 1 1001 582 64 201 OMJ91231.1 hypothetical protein SteCoe_6303 [Stentor coeruleus] diamond 420 144 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31075519 31075519 PRJEB11523_P_NODE_5215_length_204_cov_10.890323_g5137_i0 PRJEB11523 5215 204 10.890323 22.21625892 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 92.8 4.75e-20   NR OMJ82622.1 5963 g5137 i0 78.6 0.823529411764706 56 12 82.4 0 187 20 477 532 OMJ82622.1 hypothetical protein SteCoe_16600 [Stentor coeruleus] diamond 168 92.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31581499 31581499 PRJEB11523_P_NODE_3256_length_275_cov_11.933628_g3178_i0 PRJEB11523 3256 275 11.933628 32.817477 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 87.4 6.59e-19   NR KAL3942254.1 3061772 g3178 i0 57.9 1.64727272727273 76 26 76.4 2 24 233 9 84 KAL3942254.1 MAG: hypothetical protein SGBAC_003524 [Bacillariaceae sp.] diamond 453 87.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31859757 31859757 PRJEB11523_P_NODE_4357_length_227_cov_13.146067_g4279_i0 PRJEB11523 4357 227 13.146067 29.84157209 root 1 Root_unresolved Root_unresolved 50.8 4.33e-5   NR KAF4674482.1 330153 g4279 i0 46.2 1.34801762114537 39 21 51.5 0 84 200 16 54 KAF4674482.1 Rhomboid- protein 2 [Perkinsus chesapeaki] diamond 306 51.2 0.9921875 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
31865787 31865787 PRJEB11523_P_NODE_1217_length_531_cov_2.962656_g1140_i0 PRJEB11523 1217 531 2.962656 15.73170336 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 107 1.69e-23   NR CDW90426.1 5949 g1140 i0 67.2 0.361581920903955 64 21 36.2 0 24 215 753 816 CDW90426.1 transforming growth factor beta regulator 1 [Stylonychia lemnae] diamond 192 107 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31897640 31897640 PRJEB11523_P_NODE_6217_length_185_cov_2.661765_g6139_i0 PRJEB11523 6217 185 2.661765 4.92426525 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.97e-4   NR CAB9514703.1 568900 g6139 i0 74.1 0.437837837837838 27 7 43.8 0 6 86 1271 1297 CAB9514703.1 Coatomer subunit alpha [Seminavis robusta] diamond 81 47.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32119268 32119268 PRJEB11523_P_NODE_1438_length_477_cov_8.649533_g1360_i0 PRJEB11523 1438 477 8.649533 41.25827241 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 293 2.2999999999999998e-89   NR KAL3765181.1 259834 g1360 i0 95.9 1.82389937106918 145 6 91.2 0 22 456 758 902 KAL3765181.1 hypothetical protein ACHAWU_010372 [Discostella pseudostelligera] diamond 870 293 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32246015 32246015 PRJEB11523_P_NODE_2238_length_358_cov_1.812298_g2160_i0 PRJEB11523 2238 358 1.812298 6.48802684 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 229 2.05e-72   NR CAI5732052.1 86335 g2160 i0 98.3 0.963687150837989 115 2 96.4 0 12 356 191 305 CAI5732052.1 unnamed protein product [Peronospora destructor] diamond 345 229 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
32562383 32562383 PRJEB11523_P_NODE_2599_length_322_cov_1.611722_g2521_i0 PRJEB11523 2599 322 1.611722 5.18974484 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 47 0.00141   NR CAI5728514.1 86335 g2521 i0 65.3 0.456521739130435 49 17 45.7 0 23 169 121 169 CAI5728514.1 unnamed protein product [Peronospora destructor] diamond 147 47 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
32845465 32845465 PRJEB11523_P_NODE_4620_length_219_cov_2.617647_g4542_i0 PRJEB11523 4620 219 2.617647 5.73264693 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 55.5 8.74e-7   NR CAI5732052.1 86335 g4542 i0 61.8 0.753424657534247 55 8 57.5 1 1 126 309 363 CAI5732052.1 unnamed protein product [Peronospora destructor] diamond 165 55.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor

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