RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where bioproject = "PRJEB12237", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 31 ✖

tax_clade 1

  • Sar · 31 ✖

bioproject 1

  • PRJEB12237 · 31 ✖

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
20702 20702 PRJEB12237_P_NODE_501_length_1000_cov_28.909845_g403_i0 PRJEB12237 501 1000 28.909845 289.09845 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 350 1.8299999999999998e-118   NR XP_002181180.1 556484 g403 i0 79.2 7.671 212 44 63.6 0 954 319 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 7671 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
2570559 2570559 PRJEB12237_P_NODE_1403_length_610_cov_2.554783_g1232_i0 PRJEB12237 1403 610 2.554783 15.5841763 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 115 7.29e-27   NR XP_002291609.1 296543 g1232 i0 77.9 0.555737704918033 113 24 55.1 1 8 343 260 372 XP_002291609.1 calreticulin-like protein, partial [Thalassiosira pseudonana CCMP1335] diamond 339 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
3846925 3846925 PRJEB12237_P_NODE_804_length_806_cov_2.856031_g667_i0 PRJEB12237 804 806 2.856031 23.01960986 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 290 7.319999999999998e-96   NR CAJ1953473.1 2856 g667 i0 88.4 2.73573200992556 147 17 54.7 0 703 263 70 216 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 2205 290 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
7672897 7672897 PRJEB12237_P_NODE_4787_length_284_cov_2.341365_g4591_i0 PRJEB12237 4787 284 2.341365 6.6494766 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 78.7 4.33e-10   NTclustered gi|224000901|ref|XM_002290087.1| 296543 g4591 i0 92.593 0.725352112676056 54 4 19 0 228 281 148 201 Thalassiosira pseudonana CCMP1335 RL4e, ribosomal protein 4e 60S large ribosomal subunit (RL4e), partial mRNA blastn 206 78.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
24246484 24246484 PRJEB12237_P_NODE_3380_length_363_cov_1.109756_g3184_i0 PRJEB12237 3380 363 1.109756 4.02841428 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 302 3.1e-77   NTclustered gi|657012367|gb|KF302531.1| 2850 g3184 i0 89.024 88.4738292011019 246 24 67 3 1 244 276 32 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 32116 302 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26678229 26678229 PRJEB12237_P_NODE_4481_length_299_cov_1.689394_g4285_i0 PRJEB12237 4481 299 1.689394 5.05128806 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 77.4 4.82e-14   NR KAL3801383.1 29204 g4285 i0 53.4 2.19732441471572 73 34 73.2 0 1 219 811 883 KAL3801383.1 hypothetical protein HJC23_006993 [Cyclotella cryptica] diamond 657 77.8 0.994858611825193 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27096150 27096150 PRJEB12237_P_NODE_9722_length_172_cov_1.131387_g9526_i0 PRJEB12237 9722 172 1.131387 1.94598564 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00189   NR KAL3764786.1 259834 g9526 i0 54 0.872093023255814 50 23 87.2 0 2 151 118 167 KAL3764786.1 hypothetical protein ACHAWU_006203 [Discostella pseudostelligera] diamond 150 45.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27159115 27159115 PRJEB12237_P_NODE_10242_length_166_cov_1.221374_g10046_i0 PRJEB12237 10242 166 1.221374 2.02748084 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.7e-5   NR KAG7357263.1 303405 g10046 i0 50.9 1.86144578313253 53 25 95.8 1 1 159 287 338 KAG7357263.1 leucine rich repeat LRR-containing protein [Nitzschia inconspicua] diamond 309 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27444154 27444154 PRJEB12237_P_NODE_6943_length_216_cov_1.447514_g6747_i0 PRJEB12237 6943 216 1.447514 3.12663024 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.69e-5   NR OEU20568.1 635003 g6747 i0 40.7 1.65277777777778 59 31 76.4 1 12 176 215 273 OEU20568.1 hypothetical protein FRACYDRAFT_180788 [Fragilariopsis cylindrus CCMP1102] diamond 357 51.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28201400 28201400 PRJEB12237_P_NODE_4926_length_278_cov_3.596708_g4730_i0 PRJEB12237 4926 278 3.596708 9.99884824 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 122 3.689999999999999e-31   NR GAX15618.1 1519565 g4730 i0 63.6 1.88848920863309 88 32 95 0 276 13 270 357 GAX15618.1 N-ethylmaleimide reductase [Fistulifera solaris] diamond 525 122 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29621994 29621994 PRJEB12237_P_NODE_7970_length_196_cov_0.981366_g7774_i0 PRJEB12237 7970 196 0.981366 1.92347736 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 117 2e-30   NR KAL3903606.1 3061772 g7774 i0 80 2.86224489795918 65 13 99.5 0 1 195 8 72 KAL3903606.1 MAG: hypothetical protein SGARI_005299, partial [Bacillariaceae sp.] diamond 561 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29875154 29875154 PRJEB12237_P_NODE_7571_length_202_cov_2.353293_g7375_i0 PRJEB12237 7571 202 2.353293 4.75365186 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 76.6 2.46e-14   NR GFH45451.1 426638 g7375 i0 66.7 0.757425742574257 51 17 75.7 0 201 49 575 625 GFH45451.1 PLP-dependent transferase [Chaetoceros tenuissimus] diamond 153 76.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29938332 29938332 PRJEB12237_P_NODE_6851_length_218_cov_1.229508_g6655_i0 PRJEB12237 6851 218 1.229508 2.68032744 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 49.3 9.62e-5   NR GKY96518.1 2872254 g6655 i0 57.6 0.454128440366972 33 13 44 1 1 96 162 194 GKY96518.1 hypothetical protein MPSEU_000611400 [Mayamaea pseudoterrestris] diamond 99 49.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29938333 29938333 PRJEB12237_P_NODE_7651_length_201_cov_0.957831_g7455_i0 PRJEB12237 7651 201 0.957831 1.92524031 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 73.2 2.35e-14   NR XP_002286639.1 296543 g7455 i0 58.6 3.56716417910448 58 24 86.6 0 2 175 66 123 XP_002286639.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 717 73.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29995251 29995251 PRJEB12237_P_NODE_2231_length_474_cov_2.296128_g2039_i0 PRJEB12237 2231 474 2.296128 10.88364672 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 162 8.71e-44   NR XP_002288422.1 296543 g2039 i0 48.7 12.1582278481013 156 63 98.7 2 5 472 221 359 XP_002288422.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 5763 163 0.993865030674847 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
30374685 30374685 PRJEB12237_P_NODE_4532_length_296_cov_1.655172_g4336_i0 PRJEB12237 4532 296 1.655172 4.89930912 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 165 6.27e-48   NR CAB9523000.1 568900 g4336 i0 76.3 5.7972972972973 93 22 94.3 0 284 6 183 275 CAB9523000.1 c peroxidase, mitochondrial [Seminavis robusta] diamond 1716 166 0.993975903614458 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30380956 30380956 PRJEB12237_P_NODE_10213_length_166_cov_1.526718_g10017_i0 PRJEB12237 10213 166 1.526718 2.53435188 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.45e-5   NR KAL3790894.1 382360 g10017 i0 70.4 0.487951807228916 27 8 48.8 0 6 86 129 155 KAL3790894.1 hypothetical protein ACHAWO_010891 [Cyclotella atomus] diamond 81 50.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
30437701 30437701 PRJEB12237_P_NODE_6413_length_228_cov_1.450777_g6217_i0 PRJEB12237 6413 228 1.450777 3.30777156 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 97.8 3.96e-22   NR KAL3767548.1 259834 g6217 i0 66.2 1.71052631578947 65 22 85.5 0 1 195 294 358 KAL3767548.1 hypothetical protein ACHAWU_000211 [Discostella pseudostelligera] diamond 390 97.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
30500617 30500617 PRJEB12237_P_NODE_2093_length_493_cov_2.932314_g1905_i0 PRJEB12237 2093 493 2.932314 14.45630802 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 211 5.25e-60   NR KAG7366701.1 303405 g1905 i0 61 4.8498985801217 164 63 99.8 1 2 493 862 1024 KAG7366701.1 2-oxoglutarate dehydrogenase E1 component [Nitzschia inconspicua] diamond 2391 212 0.995283018867924 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31138526 31138526 PRJEB12237_P_NODE_2935_length_402_cov_3.250681_g2739_i0 PRJEB12237 2935 402 3.250681 13.06773762 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 133 3.05e-33   NR KAL3808413.1 382380 g2739 i0 64.4 2.32835820895522 104 37 77.6 0 394 83 606 709 KAL3808413.1 hypothetical protein ACHAXA_001350 [Cyclostephanos tholiformis] diamond 936 133 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
31265317 31265317 PRJEB12237_P_NODE_4315_length_307_cov_3.492647_g4119_i0 PRJEB12237 4315 307 3.492647 10.72242629 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 84.7 5.03e-19   NR KAK1743969.1 267567 g4119 i0 59.7 2.05211726384365 72 29 70.4 0 294 79 17 88 KAK1743969.1 60S ribosomal protein L38 [Skeletonema marinoi] diamond 630 84.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31575422 31575422 PRJEB12237_P_NODE_12116_length_150_cov_1.739130_g11920_i0 PRJEB12237 12116 150 1.73913 2.608695 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 68.6 8.36e-12   NR KAK1743557.1 267567 g11920 i0 70.8 1.8 48 14 96 0 1 144 633 680 KAK1743557.1 RAD23 family protein [Skeletonema marinoi] diamond 270 68.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31606913 31606913 PRJEB12237_P_NODE_2396_length_456_cov_1.707838_g2200_i0 PRJEB12237 2396 456 1.707838 7.78774128 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 134 6.99e-34   NR CAJ1954428.1 2856 g2200 i0 47.3 4.96052631578947 150 76 98.7 2 455 6 229 375 CAJ1954428.1 unnamed protein product [Cylindrotheca closterium] diamond 2262 134 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31866080 31866080 PRJEB12237_P_NODE_6257_length_232_cov_1.558376_g6061_i0 PRJEB12237 6257 232 1.558376 3.61543232 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 136 1.36e-37   NR GAX20133.1 1519565 g6061 i0 80.5 10.9525862068966 77 15 99.6 0 231 1 88 164 GAX20133.1 inorganic pyrophosphatase [Fistulifera solaris] diamond 2541 136 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32151083 32151083 PRJEB12237_P_NODE_8018_length_195_cov_1.250000_g7822_i0 PRJEB12237 8018 195 1.25 2.4375 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 84 7.34e-18   NR GKY98660.1 2872254 g7822 i0 60.9 3.93846153846154 64 24 98.5 1 3 194 31 93 GKY98660.1 hypothetical protein MPSEU_000822400 [Mayamaea pseudoterrestris] diamond 768 84 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32334850 32334850 PRJEB12237_P_NODE_9859_length_170_cov_1.481481_g9663_i0 PRJEB12237 9859 170 1.481481 2.5185177 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 69.7 2.53e-12   NR KAL3759399.1 259834 g9663 i0 81.1 5.80588235294118 37 7 65.3 0 3 113 257 293 KAL3759399.1 hypothetical protein ACHAWU_000698 [Discostella pseudostelligera] diamond 987 70.1 0.994293865905849 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32429561 32429561 PRJEB12237_P_NODE_4799_length_284_cov_1.562249_g4603_i0 PRJEB12237 4799 284 1.562249 4.43678716 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0134   NR KAK1735842.1 267567 g4603 i0 35.7 3.41197183098592 70 34 71.8 2 70 273 1529 1589 KAK1735842.1 histone acetyltransferase [Skeletonema marinoi] diamond 969 45.1 0.991130820399113 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32656497 32656497 PRJEB12237_P_NODE_11600_length_154_cov_1.680672_g11404_i0 PRJEB12237 11600 154 1.680672 2.58823488 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 49.3 9.01e-6   NR GKY93318.1 2872254 g11404 i0 47.9 0.935064935064935 48 25 93.5 0 7 150 50 97 GKY93318.1 hypothetical protein MPSEU_000299400 [Mayamaea pseudoterrestris] diamond 144 49.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32782597 32782597 PRJEB12237_P_NODE_6420_length_228_cov_0.829016_g6224_i0 PRJEB12237 6420 228 0.829016 1.89015648 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 128 1.98e-32   NR GKY94373.1 2872254 g6224 i0 87.8 1.94736842105263 74 9 97.4 0 3 224 1689 1762 GKY94373.1 hypothetical protein MPSEU_000403200 [Mayamaea pseudoterrestris] diamond 444 128 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32814239 32814239 PRJEB12237_P_NODE_2760_length_419_cov_2.166667_g2564_i0 PRJEB12237 2760 419 2.166667 9.07833473 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 78.2 2.5e-14   NR CAB9500076.1 568900 g2564 i0 38.5 1.381861575179 96 57 68.7 1 5 292 162 255 CAB9500076.1 Dienelactone hydrolase family protein [Seminavis robusta] diamond 579 78.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32839358 32839358 PRJEB12237_P_NODE_12000_length_151_cov_1.594828_g11804_i0 PRJEB12237 12000 151 1.594828 2.40819028 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0042   NR KAL3826487.1 382380 g11804 i0 68 5.00662251655629 25 8 49.7 0 75 1 294 318 KAL3826487.1 hypothetical protein ACHAXA_004324 [Cyclostephanos tholiformis] diamond 756 43.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis

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