RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 18 ✖

tax_clade 1

bioproject 1

  • PRJEB14175 · 18 ✖

analysis 1

  • diamond · 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
25648591 25648591 PRJEB14175_P_NODE_98026_length_362_cov_3.893688_g95760_i0 PRJEB14175 98026 362 3.893688 14.09515056 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 116 7.26e-30   NR GKY96848.1 2872254 g95760 i0 92.1 2.08011049723757 63 4 51.4 1 107 292 134 196 GKY96848.1 fucoxanthin chlorophyll a c protein [Mayamaea pseudoterrestris] diamond 753 116 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
26048131 26048131 PRJEB14175_P_NODE_162445_length_262_cov_4.452736_g160178_i0 PRJEB14175 162445 262 4.452736 11.66616832 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 57.8 2.44e-7   NR GKY90626.1 2872254 g160178 i0 67.6 0.423664122137405 37 12 42.4 0 29 139 789 825 GKY90626.1 hypothetical protein MPSEU_000036100 [Mayamaea pseudoterrestris] diamond 111 57.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32926695 32926695 PRJEB14175_P_NODE_257393_length_201_cov_3.757143_g255125_i0 PRJEB14175 257393 201 3.757143 7.55185743 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 115 1.7000000000000003e-28   NR GKY95617.1 2872254 g255125 i0 96.5 0.850746268656716 57 2 85.1 0 201 31 425 481 GKY95617.1 adenosylhomocysteinase 2 [Mayamaea pseudoterrestris] diamond 171 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32926863 32926863 PRJEB14175_P_NODE_30129_length_677_cov_9.969156_g28038_i0 PRJEB14175 30129 677 9.969156 67.49118612 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 55.8 3.93e-5   NR XP_002286589.1 296543 g28038 i0 30.4 0.89069423929099 102 67 43.4 3 115 408 318 419 XP_002286589.1 ferric reductase-like transmembrane component, partial [Thalassiosira pseudonana CCMP1335] diamond 603 55.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32942756 32942756 PRJEB14175_P_NODE_136810_length_294_cov_1.815451_g134543_i0 PRJEB14175 136810 294 1.815451 5.33742594 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 79.3 9.54e-15   NR KAI2494382.1 210448 g134543 i0 44.9 2 98 52 98 1 3 290 867 964 KAI2494382.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 588 79.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32960072 32960072 PRJEB14175_P_NODE_149314_length_277_cov_24.305556_g147047_i0 PRJEB14175 149314 277 24.305556 67.32639012 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 50.8 3.78e-5   NR GKY92625.1 2872254 g147047 i0 91.7 0.259927797833935 24 2 26 0 254 183 128 151 GKY92625.1 hypothetical protein MPSEU_000232600 [Mayamaea pseudoterrestris] diamond 72 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32960206 32960206 PRJEB14175_P_NODE_160682_length_264_cov_4.078818_g158415_i0 PRJEB14175 160682 264 4.078818 10.76807952 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00198   NR CAB9519447.1 568900 g158415 i0 42.5 0.454545454545455 40 23 45.5 0 153 34 206 245 CAB9519447.1 expressed unknown protein [Seminavis robusta] diamond 120 46.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32961171 32961171 PRJEB14175_P_NODE_26666_length_716_cov_8.575573_g24642_i0 PRJEB14175 26666 716 8.575573 61.40110268 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 298 7e-95   NR GKY95796.1 2872254 g24642 i0 98.7 0.636871508379888 152 2 63.7 0 694 239 303 454 GKY95796.1 hypothetical protein MPSEU_000540300 [Mayamaea pseudoterrestris] diamond 456 298 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32961544 32961544 PRJEB14175_P_NODE_64426_length_461_cov_3.835000_g62169_i0 PRJEB14175 64426 461 3.835 17.67935 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 115 1.17e-26   NR GKY92645.1 2872254 g62169 i0 60.5 0.806941431670282 124 36 72.2 2 101 433 457 580 GKY92645.1 hypothetical protein MPSEU_000234600 [Mayamaea pseudoterrestris] diamond 372 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32976875 32976875 PRJEB14175_P_NODE_117179_length_324_cov_9.977186_g114913_i0 PRJEB14175 117179 324 9.977186 32.32608264 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.39e-19   NR KAL3918263.1 3061772 g114913 i0 76.4 1.01851851851852 55 13 50.9 0 17 181 891 945 KAL3918263.1 MAG: hypothetical protein SGILL_004319, partial [Bacillariaceae sp.] diamond 330 93.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32977848 32977848 PRJEB14175_P_NODE_220795_length_213_cov_1.684211_g218527_i0 PRJEB14175 220795 213 1.684211 3.58736943 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 50.4 4.63e-5   NR KAI2489377.1 210448 g218527 i0 58.8 0.47887323943662 34 14 47.9 0 12 113 281 314 KAI2489377.1 protein phosphatase 2A-like protein [Fragilaria crotonensis] diamond 102 50.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32993697 32993697 PRJEB14175_P_NODE_104939_length_347_cov_6.027972_g102673_i0 PRJEB14175 104939 347 6.027972 20.91706284 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 57.4 9.43e-7   NR KAL3921010.1 3061772 g102673 i0 51.1 0.406340057636888 47 23 40.6 0 60 200 1562 1608 KAL3921010.1 MAG: hypothetical protein SGILL_002977 [Bacillariaceae sp.] diamond 141 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
33012236 33012236 PRJEB14175_P_NODE_261644_length_200_cov_3.251799_g259376_i0 PRJEB14175 261644 200 3.251799 6.503598 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.53e-13   NR GKY95389.1 2872254 g259376 i0 82.1 0.585 39 7 58.5 0 1 117 517 555 GKY95389.1 hypothetical protein MPSEU_000500500 [Mayamaea pseudoterrestris] diamond 117 74.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
33027878 33027878 PRJEB14175_P_NODE_106588_length_344_cov_3.159011_g104322_i0 PRJEB14175 106588 344 3.159011 10.86699784 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 102 2.0299999999999998e-24   NR GKY96628.1 2872254 g104322 i0 82.8 0.558139534883721 64 10 55.8 1 22 213 130 192 GKY96628.1 hypothetical protein MPSEU_000622400 [Mayamaea pseudoterrestris] diamond 192 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
33076392 33076392 PRJEB14175_P_NODE_72157_length_433_cov_6.247312_g69898_i0 PRJEB14175 72157 433 6.247312 27.05086096 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 178 4.7700000000000003e-51   NR CAB9516126.1 568900 g69898 i0 88.3 4.69745958429561 94 11 65.1 0 412 131 355 448 CAB9516126.1 Isovaleryl-CoA dehydrogenase, mitochondrial [Seminavis robusta] diamond 2034 179 0.994413407821229 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
33093213 33093213 PRJEB14175_P_NODE_133534_length_298_cov_28.734177_g131267_i0 PRJEB14175 133534 298 28.734177 85.62784746 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 117 4.24e-28   NR KAG7355565.1 303405 g131267 i0 76 4.53020134228188 75 16 73.5 1 25 243 687 761 KAG7355565.1 elongation factor Tu [Nitzschia inconspicua] diamond 1350 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
33097002 33097002 PRJEB14175_P_NODE_205374_length_224_cov_1.877301_g203107_i0 PRJEB14175 205374 224 1.877301 4.20515424 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 52 1.55e-5   NR KAI2508476.1 210448 g203107 i0 45.3 0.709821428571429 53 29 71 0 191 33 381 433 KAI2508476.1 hypothetical protein MHU86_6003 [Fragilaria crotonensis] diamond 159 52 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
33110549 33110549 PRJEB14175_P_NODE_80686_length_406_cov_8.101449_g78424_i0 PRJEB14175 80686 406 8.101449 32.89188294 root 1 Root_unresolved Root_unresolved 54.7 1.35e-5   NR EJK72859.1 159749 g78424 i0 41.3 3.78325123152709 63 36 46.6 1 117 305 343 404 EJK72859.1 hypothetical protein THAOC_05569, partial [Thalassiosira oceanica] diamond 1536 54.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica

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