RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJEB39643" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 19 ✖

tax_clade 1

bioproject 1

  • PRJEB39643 · 19 ✖

analysis 1

  • diamond · 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
5160540 5160540 PRJEB39643_P_NODE_59965_length_281_cov_1.480769_g59772_i0 PRJEB39643 59965 281 1.480769 4.16096089 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 161 5.03e-49   NR XP_002183070.1 556484 g59772 i0 78.5 1.78291814946619 93 20 99.3 0 3 281 14 106 XP_002183070.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 501 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6436480 6436480 PRJEB39643_P_NODE_61406_length_280_cov_1.487923_g61213_i0 PRJEB39643 61406 280 1.487923 4.1661844 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 159 6.130000000000001e-44   NR KAL3763257.1 259834 g61213 i0 84.1 0.942857142857143 88 14 94.3 0 280 17 263 350 KAL3763257.1 hypothetical protein ACHAWU_008960 [Discostella pseudostelligera] diamond 264 159 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
7710861 7710861 PRJEB39643_P_NODE_8067_length_713_cov_3.146875_g7896_i0 PRJEB39643 8067 713 3.146875 22.43721875 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 244 4.99e-77   NR KAL3797734.1 29204 g7896 i0 59.1 5.84431977559607 232 86 97.6 2 6 701 63 285 KAL3797734.1 hypothetical protein HJC23_000279 [Cyclotella cryptica] diamond 4167 246 0.991869918699187 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
16634817 16634817 PRJEB39643_P_NODE_38134_length_303_cov_6.052174_g37941_i0 PRJEB39643 38134 303 6.052174 18.33808722 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 114 1.39e-29   NR KAI2504009.1 210448 g37941 i0 58.8 5.65346534653465 114 33 99 2 2 301 68 181 KAI2504009.1 ribosomal eL6-like protein [Fragilaria crotonensis] diamond 1713 114 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
19184120 19184120 PRJEB39643_P_NODE_96136_length_263_cov_1.621053_g95943_i0 PRJEB39643 96136 263 1.621053 4.26336939 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 162 4.67e-47   NR GFH59352.1 426638 g95943 i0 83.9 3.96958174904943 87 14 99.2 0 1 261 68 154 GFH59352.1 hypothetical protein CTEN210_15828 [Chaetoceros tenuissimus] diamond 1044 162 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
21734702 21734702 PRJEB39643_P_NODE_37098_length_307_cov_3.470085_g36905_i0 PRJEB39643 37098 307 3.470085 10.65316095 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 173 9.57e-49   NR KAK1745642.1 267567 g36905 i0 75.2 11.8436482084691 101 25 98.7 0 5 307 279 379 KAK1745642.1 hydroxylamine reductase [Skeletonema marinoi] diamond 3636 173 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
26969964 26969964 PRJEB39643_P_NODE_151582_length_239_cov_2.084337_g151389_i0 PRJEB39643 151582 239 2.084337 4.98156543 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 50.1 9.38e-5   NR KAL3811417.1 382380 g151389 i0 35.4 3.41422594142259 79 32 75.3 1 25 204 910 988 KAL3811417.1 LOW QUALITY PROTEIN: hypothetical protein ACHAXA_005318 [Cyclostephanos tholiformis] diamond 816 50.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
27184656 27184656 PRJEB39643_P_NODE_142022_length_244_cov_1.801170_g141829_i0 PRJEB39643 142022 244 1.80117 4.3948548 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.4 3.46e-9   NR CAJ1953448.1 2856 g141829 i0 35.5 9.40573770491803 76 49 93.4 0 229 2 187 262 CAJ1953448.1 unnamed protein product [Cylindrotheca closterium] diamond 2295 62.8 0.993630573248408 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28328150 28328150 PRJEB39643_P_NODE_136646_length_246_cov_1.745665_g136453_i0 PRJEB39643 136646 246 1.745665 4.2943359 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 67.4 1.38e-11   NR CAJ1950078.1 2856 g136453 i0 73.5 1.69512195121951 34 9 41.5 0 10 111 152 185 CAJ1950078.1 unnamed protein product [Cylindrotheca closterium] diamond 417 67.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29117811 29117811 PRJEB39643_P_NODE_116889_length_253_cov_2.566667_g116696_i0 PRJEB39643 116889 253 2.566667 6.49366751 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.79e-18   NR KAI2508236.1 210448 g116696 i0 50 0.99604743083004 84 34 90.1 1 252 25 43 126 KAI2508236.1 dienelactone hydrolase [Fragilaria crotonensis] diamond 252 85.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29559581 29559581 PRJEB39643_P_NODE_67250_length_277_cov_1.509804_g67057_i0 PRJEB39643 67250 277 1.509804 4.18215708 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 133 1.24e-35   NR CAB9517383.1 568900 g67057 i0 66.3 0.931407942238267 86 29 93.1 0 263 6 154 239 CAB9517383.1 Carbon-nitrogen hydrolase [Seminavis robusta] diamond 258 133 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30159540 30159540 PRJEB39643_P_NODE_29212_length_340_cov_3.220974_g29019_i0 PRJEB39643 29212 340 3.220974 10.9513116 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 147 1.3899999999999999e-40   NR KAL3779346.1 29204 g29019 i0 60.2 1.99411764705882 113 45 99.7 0 339 1 165 277 KAL3779346.1 hypothetical protein HJC23_007476 [Cyclotella cryptica] diamond 678 147 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30412869 30412869 PRJEB39643_P_NODE_41173_length_293_cov_2.100000_g40980_i0 PRJEB39643 41173 293 2.1 6.153 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 92.8 1.74e-19   NR GFH53639.1 426638 g40980 i0 47.8 0.921501706484642 90 47 92.2 0 287 18 43 132 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 270 92.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30728436 30728436 PRJEB39643_P_NODE_134774_length_246_cov_1.780347_g134581_i0 PRJEB39643 134774 246 1.780347 4.37965362 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 70.5 6.29e-12   NR KAI2503083.1 210448 g134581 i0 59.6 1.26829268292683 52 21 63.4 0 3 158 361 412 KAI2503083.1 hypothetical protein MHU86_11354 [Fragilaria crotonensis] diamond 312 70.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31392414 31392414 PRJEB39643_P_NODE_37936_length_304_cov_2.666667_g37743_i0 PRJEB39643 37936 304 2.666667 8.10666768 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 73.2 9.79e-13   NR XP_002286220.1 296543 g37743 i0 50.8 3.45394736842105 59 28 57.2 1 21 194 1 59 XP_002286220.1 predicted protein, partial [Thalassiosira pseudonana CCMP1335] diamond 1050 73.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31487322 31487322 PRJEB39643_P_NODE_29236_length_340_cov_2.576779_g29043_i0 PRJEB39643 29236 340 2.576779 8.7610486 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 52 6.68e-5   NR KAL3802374.1 29204 g29043 i0 53.2 1.8 47 22 41.5 0 8 148 395 441 KAL3802374.1 hypothetical protein HJC23_007199 [Cyclotella cryptica] diamond 612 52 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32468053 32468053 PRJEB39643_P_NODE_120779_length_252_cov_1.720670_g120586_i0 PRJEB39643 120779 252 1.72067 4.3360884 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 132 1.96e-38   NR KAK1735274.1 267567 g120586 i0 79.5 0.928571428571429 78 15 92.9 1 251 18 8 84 KAK1735274.1 hypothetical protein QTG54_013888 [Skeletonema marinoi] diamond 234 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32468068 32468068 PRJEB39643_P_NODE_141359_length_244_cov_1.801170_g141166_i0 PRJEB39643 141359 244 1.80117 4.3948548 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0378   NR XP_002290699.1 296543 g141166 i0 36.5 0.774590163934426 63 39 77.5 1 56 244 289 350 XP_002290699.1 WD40-repeat protein [Thalassiosira pseudonana CCMP1335] diamond 189 42.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32556458 32556458 PRJEB39643_P_NODE_159659_length_203_cov_4.738462_g159465_i0 PRJEB39643 159659 203 4.738462 9.61907786 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 58.2 7.97e-8   NR VEU38933.1 183589 g159465 i0 43.8 6.5615763546798 64 35 94.6 1 2 193 328 390 VEU38933.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1332 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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