RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA1005695 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
27160626 27160626 PRJNA1005695_P_NODE_38502_length_245_cov_0.906977_g37650_i0 PRJNA1005695 38502 245 0.906977 2.22209365 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 115 1.17e-27   NR KAG7364698.1 303405 g37650 i0 64.2 2.97551020408163 81 29 99.2 0 3 245 488 568 KAG7364698.1 phosphoglycerate kinase [Nitzschia inconspicua] diamond 729 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27223944 27223944 PRJNA1005695_P_NODE_34803_length_253_cov_0.866667_g33951_i0 PRJNA1005695 34803 253 0.866667 2.19266751 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.79e-9   NR CAB9529051.1 568900 g33951 i0 44.9 0.924901185770751 78 37 85.4 1 252 37 1337 1414 CAB9529051.1 WD and tetratricopeptide repeats protein 1 [Seminavis robusta] diamond 234 63.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28013848 28013848 PRJNA1005695_P_NODE_34725_length_253_cov_0.866667_g33873_i0 PRJNA1005695 34725 253 0.866667 2.19266751 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00102   NR CAB9510575.1 568900 g33873 i0 31.7 0.972332015810277 82 54 96 2 249 7 373 453 CAB9510575.1 Gamma-aminobutyric acid (GABA) B receptor [Seminavis robusta] diamond 246 47.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28171466 28171466 PRJNA1005695_P_NODE_13846_length_411_cov_0.923077_g12994_i0 PRJNA1005695 13846 411 0.923077 3.79384647 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 108 5.4600000000000006e-27   NR CAB9522863.1 568900 g12994 i0 45.1 0.824817518248175 113 61 82.5 1 11 349 63 174 CAB9522863.1 N-acetyltransferase [Seminavis robusta] diamond 339 108 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28802745 28802745 PRJNA1005695_P_NODE_39208_length_244_cov_0.883041_g38356_i0 PRJNA1005695 39208 244 0.883041 2.15462004 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 104 6.729999999999999e-24   NR GAX15122.1 1519565 g38356 i0 67.6 0.909836065573771 74 22 91 1 242 21 1 72 GAX15122.1 splicing factor 1 [Fistulifera solaris] diamond 222 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29490037 29490037 PRJNA1005695_P_NODE_39990_length_242_cov_0.923077_g39138_i0 PRJNA1005695 39990 242 0.923077 2.23384634 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 109 1.03e-25   NR QII42406.1 2850 g39138 i0 71.3 2.97520661157025 80 21 99.2 1 2 241 286 363 QII42406.1 NADH dehydrogenase subunit 2 [Phaeodactylum tricornutum] diamond 720 109 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29718387 29718387 PRJNA1005695_P_NODE_35710_length_251_cov_0.876404_g34858_i0 PRJNA1005695 35710 251 0.876404 2.19977404 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.66e-18   NR CAB9498863.1 568900 g34858 i0 57.6 1.01593625498008 85 34 99.2 2 250 2 962 1046 CAB9498863.1 linked kinase-associated serine/threonine phosphatase 2C [Seminavis robusta] diamond 255 89.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29869118 29869118 PRJNA1005695_P_NODE_39571_length_243_cov_0.917647_g38719_i0 PRJNA1005695 39571 243 0.917647 2.22988221 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 70.1 8.97e-12   NR KAL3767572.1 259834 g38719 i0 73.9 2.20987654320988 46 11 56.8 1 106 243 921 965 KAL3767572.1 LOW QUALITY PROTEIN: hypothetical protein ACHAWU_000235 [Discostella pseudostelligera] diamond 537 70.5 0.994326241134752 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
30128958 30128958 PRJNA1005695_P_NODE_36172_length_250_cov_0.881356_g35320_i0 PRJNA1005695 36172 250 0.881356 2.20339 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 92.8 4.97e-21   NR OEU16840.1 635003 g35320 i0 54.8 1.968 84 31 96 3 244 5 60 140 OEU16840.1 hypothetical protein FRACYDRAFT_239433 [Fragilariopsis cylindrus CCMP1102] diamond 492 92.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
30539972 30539972 PRJNA1005695_P_NODE_37513_length_247_cov_0.896552_g36661_i0 PRJNA1005695 37513 247 0.896552 2.21448344 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 52 2.18e-5   NR KAL3766693.1 2934178 g36661 i0 44.8 0.813765182186235 67 34 78.9 2 2 196 15 80 KAL3766693.1 hypothetical protein ACHAW5_006951 [Stephanodiscus triporus] diamond 201 52 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
30761279 30761279 PRJNA1005695_P_NODE_32414_length_262_cov_1.333333_g31562_i0 PRJNA1005695 32414 262 1.333333 3.49333246 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 169 7.209999999999998e-47   NR GAX27776.1 1519565 g31562 i0 98.9 4.98091603053435 87 1 99.6 0 1 261 389 475 GAX27776.1 inorganic pyrophosphatase [Fistulifera solaris] diamond 1305 169 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30950953 30950953 PRJNA1005695_P_NODE_37514_length_247_cov_0.896552_g36662_i0 PRJNA1005695 37514 247 0.896552 2.21448344 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 112 3.66e-29   NR GAX09707.1 1519565 g36662 i0 70.7 0.995951417004049 82 24 99.6 0 2 247 89 170 GAX09707.1 hypothetical protein FisN_19Lh176 [Fistulifera solaris] diamond 246 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31329987 31329987 PRJNA1005695_P_NODE_38656_length_245_cov_0.906977_g37804_i0 PRJNA1005695 38656 245 0.906977 2.22209365 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 102 2.1499999999999994e-23   NR XP_002183329.1 556484 g37804 i0 62.8 0.955102040816327 78 28 95.5 1 245 12 134 210 XP_002183329.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 234 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31354274 31354274 PRJNA1005695_P_NODE_39176_length_244_cov_0.912281_g38324_i0 PRJNA1005695 39176 244 0.912281 2.22596564 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 93.2 5.91e-21   NR KAI2488713.1 210448 g38324 i0 55.7 1.86885245901639 79 32 97.1 1 3 239 112 187 KAI2488713.1 hypothetical protein MHU86_25767 [Fragilaria crotonensis] diamond 456 93.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31986706 31986706 PRJNA1005695_P_NODE_38178_length_246_cov_0.872832_g37326_i0 PRJNA1005695 38178 246 0.872832 2.14716672 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.02e-18   NR KAG7352298.1 303405 g37326 i0 51.3 2.92682926829268 80 38 97.6 1 4 243 165 243 KAG7352298.1 fatty acid desaturase, type 1 [Nitzschia inconspicua] diamond 720 90.5 0.991160220994475 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32025978 32025978 PRJNA1005695_P_NODE_25658_length_296_cov_1.399103_g24806_i0 PRJNA1005695 25658 296 1.399103 4.14134488 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 51.2 7.54e-5   NR ACA60911.1 2850 g24806 i0 55.6 0.456081081081081 45 19 45.6 1 8 142 912 955 ACA60911.1 pol protein, partial [Phaeodactylum tricornutum] diamond 135 51.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32152541 32152541 PRJNA1005695_P_NODE_26818_length_289_cov_1.342593_g25966_i0 PRJNA1005695 26818 289 1.342593 3.88009377 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.048   NR KAL3797796.1 382360 g25966 i0 46.7 0.467128027681661 45 24 46.7 0 286 152 323 367 KAL3797796.1 hypothetical protein ACHAWO_000413 [Cyclotella atomus] diamond 135 43.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32437534 32437534 PRJNA1005695_P_NODE_19179_length_345_cov_0.860294_g18327_i0 PRJNA1005695 19179 345 0.860294 2.9680143 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.93e-7   NR KAI2491484.1 210448 g18327 i0 46 0.547826086956522 63 30 51.3 1 343 167 228 290 KAI2491484.1 hypothetical protein MHU86_23075 [Fragilaria crotonensis] diamond 189 58.9 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32564107 32564107 PRJNA1005695_P_NODE_37179_length_248_cov_0.891429_g36327_i0 PRJNA1005695 37179 248 0.891429 2.21074392 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 85.5 3.5e-17   NR XP_002185452.1 556484 g36327 i0 59.7 0.75 62 25 75 0 244 59 545 606 XP_002185452.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 186 85.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32784126 32784126 PRJNA1005695_P_NODE_37980_length_246_cov_0.901734_g37128_i0 PRJNA1005695 37980 246 0.901734 2.21826564 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 68.9 2.23e-11   NR KAL3781515.1 2934178 g37128 i0 50.8 0.792682926829268 65 28 79.3 2 244 50 437 497 KAL3781515.1 hypothetical protein ACHAW5_000731 [Stephanodiscus triporus] diamond 195 68.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus

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