RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA950981" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA950981 · 19 ✖

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
2209148 2209148 PRJNA950981_P_NODE_15322_length_263_cov_1.410526_g15146_i0 PRJNA950981 15322 263 1.410526 3.70968338 Achnanthes kuwaitensis 483531 SAR_Eukaryotes SAR_Eukaryotes 241 4.77e-59   NTclustered gi|225685850|dbj|AB461923.1| 483531 g15146 i0 83.206 91.1596958174905 262 44 99 0 1 262 162 423 Achnanthes kuwaitensis MAT mRNA for methionine S-adenosyl transferase, complete cds blastn 23975 241 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Mastogloiales Achnanthaceae Achnanthes Achnanthes kuwaitensis
11137466 11137466 PRJNA950981_P_NODE_14829_length_268_cov_1.200000_g14653_i0 PRJNA950981 14829 268 1.2 3.216 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 92.4 1.72e-19   NR KAL3786977.1 29204 g14653 i0 57.3 5.64179104477612 82 35 91.8 0 20 265 360 441 KAL3786977.1 hypothetical protein HJC23_005488 [Cyclotella cryptica] diamond 1512 92.8 0.995689655172414 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
11137501 11137501 PRJNA950981_P_NODE_6089_length_397_cov_1.685185_g5913_i0 PRJNA950981 6089 397 1.685185 6.69018445 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 103 6.009999999999999e-24   NR KAL3797734.1 29204 g5913 i0 66 4.26196473551637 94 29 71 1 397 116 181 271 KAL3797734.1 hypothetical protein HJC23_000279 [Cyclotella cryptica] diamond 1692 104 0.990384615384615 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
14961681 14961681 PRJNA950981_P_NODE_5172_length_427_cov_1.788136_g4996_i0 PRJNA950981 5172 427 1.788136 7.63534072 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 246 1.76e-60   NTclustered gi|657012465|gb|KF302574.1| 2850 g4996 i0 80.06 3.72131147540984 336 64 79 2 83 418 335 3 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 1589 246 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17512034 17512034 PRJNA950981_P_NODE_20914_length_243_cov_1.835294_g20738_i0 PRJNA950981 20914 243 1.835294 4.45976442 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 140 1.14e-38   NR CAB9501844.1 568900 g20738 i0 81.5 16 81 15 100 0 243 1 50 130 CAB9501844.1 40S ribosomal protein SA [Seminavis robusta] diamond 3888 141 0.99290780141844 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
20060495 20060495 PRJNA950981_P_NODE_16496_length_253_cov_0.866667_g16320_i0 PRJNA950981 16496 253 0.866667 2.19266751 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 107 5.6799999999999995e-25   NR KAI2489142.1 210448 g16320 i0 58.9 6.60474308300395 95 27 98.4 2 253 5 841 935 KAI2489142.1 hypothetical protein MHU86_25458 [Fragilaria crotonensis] diamond 1671 108 0.990740740740741 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26613832 26613832 PRJNA950981_P_NODE_19901_length_246_cov_0.901734_g19725_i0 PRJNA950981 19901 246 0.901734 2.21826564 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0154   NR KAL3924164.1 3061772 g19725 i0 40 0.548780487804878 45 27 54.9 0 136 2 253 297 KAL3924164.1 MAG: hypothetical protein SGILL_001212 [Bacillariaceae sp.] diamond 135 43.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26835809 26835809 PRJNA950981_P_NODE_19041_length_248_cov_0.891429_g18865_i0 PRJNA950981 19041 248 0.891429 2.21074392 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.54e-9   NR GKY92171.1 2872254 g18865 i0 42 2.57661290322581 69 40 83.5 0 230 24 712 780 GKY92171.1 hypothetical protein MPSEU_000188400 [Mayamaea pseudoterrestris] diamond 639 63.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27126505 27126505 PRJNA950981_P_NODE_21282_length_243_cov_0.917647_g21106_i0 PRJNA950981 21282 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 113 1.15e-28   NR XP_002180872.1 556484 g21106 i0 58.2 7.81481481481481 79 33 97.5 0 239 3 72 150 XP_002180872.1 l-ascorbate peroxidase, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 1899 114 0.991228070175439 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27537772 27537772 PRJNA950981_P_NODE_13663_length_279_cov_1.135922_g13487_i0 PRJNA950981 13663 279 1.135922 3.16922238 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 1.06e-24   NR KAL3810100.1 382380 g13487 i0 54.8 2.70967741935484 84 37 89.2 1 29 277 337 420 KAL3810100.1 hypothetical protein ACHAXA_010924 [Cyclostephanos tholiformis] diamond 756 107 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28193975 28193975 PRJNA950981_P_NODE_18786_length_248_cov_0.891429_g18610_i0 PRJNA950981 18786 248 0.891429 2.21074392 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 92.4 4.91e-21   NR KAI2504641.1 210448 g18610 i0 63.2 5.28629032258065 68 25 82.3 0 226 23 47 114 KAI2504641.1 hypothetical protein MHU86_9853 [Fragilaria crotonensis] diamond 1311 92.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29362502 29362502 PRJNA950981_P_NODE_20709_length_244_cov_0.912281_g20533_i0 PRJNA950981 20709 244 0.912281 2.22596564 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.15e-8   NR GFH59231.1 426638 g20533 i0 52.1 1.05737704918033 48 22 59 1 150 7 334 380 GFH59231.1 hypothetical protein CTEN210_15707 [Chaetoceros tenuissimus] diamond 258 61.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29741006 29741006 PRJNA950981_P_NODE_11610_length_301_cov_1.368421_g11434_i0 PRJNA950981 11610 301 1.368421 4.11894721 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 75.5 2.17e-13   NR GFH49260.1 426638 g11434 i0 44.7 0.93687707641196 94 40 93.7 3 298 17 323 404 GFH49260.1 hypothetical protein CTEN210_05736 [Chaetoceros tenuissimus] diamond 282 75.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29962416 29962416 PRJNA950981_P_NODE_15151_length_264_cov_3.335079_g14975_i0 PRJNA950981 15151 264 3.335079 8.80460856 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 64.3 7.05e-11   NR XP_002185506.1 556484 g14975 i0 58.2 0.761363636363636 67 24 76.1 2 62 262 1 63 XP_002185506.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 201 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30032248 30032248 PRJNA950981_P_NODE_7111_length_370_cov_2.057239_g6935_i0 PRJNA950981 7111 370 2.057239 7.6117843 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 127 3.36e-35   NR XP_002287868.1 296543 g6935 i0 64.9 13.727027027027 94 33 76.2 0 283 2 3 96 XP_002287868.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 5079 128 0.9921875 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
30088693 30088693 PRJNA950981_P_NODE_17472_length_251_cov_0.876404_g17296_i0 PRJNA950981 17472 251 0.876404 2.19977404 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 51.2 4.15e-5   NR CAB9498140.1 568900 g17296 i0 45 0.717131474103586 60 33 71.7 0 5 184 173 232 CAB9498140.1 Pyridine nucleotide-disulphide oxidoreductase [Seminavis robusta] diamond 180 51.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31827009 31827009 PRJNA950981_P_NODE_19657_length_246_cov_0.901734_g19481_i0 PRJNA950981 19657 246 0.901734 2.21826564 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.68e-12   NR CAB9501862.1 568900 g19481 i0 50.8 0.792682926829268 65 31 79.3 1 22 216 75 138 CAB9501862.1 CBS [Seminavis robusta] diamond 195 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32555232 32555232 PRJNA950981_P_NODE_19819_length_246_cov_0.901734_g19643_i0 PRJNA950981 19819 246 0.901734 2.21826564 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 78.2 1e-14   NR GFH49118.1 426638 g19643 i0 50.7 0.865853658536585 71 34 85.4 1 210 1 13 83 GFH49118.1 cyclin-domain-containing protein [Chaetoceros tenuissimus] diamond 213 78.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32876336 32876336 PRJNA950981_P_NODE_20780_length_244_cov_0.912281_g20604_i0 PRJNA950981 20780 244 0.912281 2.22596564 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.51e-13   NR EJK46078.1 159749 g20604 i0 52.8 3.50409836065574 72 33 87.3 1 244 32 435 506 EJK46078.1 hypothetical protein THAOC_35276 [Thalassiosira oceanica] diamond 855 75.5 0.994701986754967 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);;