RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1041773" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA1041773 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
170971 170971 PRJNA1041773_P_NODE_86861_length_247_cov_0.885057_g86528_i0 PRJNA1041773 86861 247 0.885057 2.18609079 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 159 4.279999999999999e-43   NR KAL3797856.1 29204 g86528 i0 93.9 8.96356275303644 82 5 99.6 0 2 247 848 929 KAL3797856.1 hypothetical protein HJC23_006894 [Cyclotella cryptica] diamond 2214 160 0.99375 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
12923576 12923576 PRJNA1041773_P_NODE_103811_length_233_cov_2.500000_g103478_i0 PRJNA1041773 103811 233 2.5 5.825 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 160 6.4e-48   NR CAJ1953473.1 2856 g103478 i0 94.4 8.34334763948498 72 4 92.7 0 218 3 83 154 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 1944 161 0.993788819875776 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
24396333 24396333 PRJNA1041773_P_NODE_41660_length_329_cov_0.902344_g41327_i0 PRJNA1041773 41660 329 0.902344 2.96871176 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 201 2.14e-63   NR GFH61425.1 426638 g41327 i0 91.7 0.984802431610942 108 9 98.5 0 327 4 17 124 GFH61425.1 hypothetical protein CTEN210_17901 [Chaetoceros tenuissimus] diamond 324 201 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27003380 27003380 PRJNA1041773_P_NODE_25182_length_414_cov_3.313783_g24851_i0 PRJNA1041773 25182 414 3.313783 13.71906162 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 51.2 2.4e-4   NR GAX28153.1 1519565 g24851 i0 61 1.09420289855072 41 13 29.7 1 216 338 440 477 GAX28153.1 ribosome biogenesis protein UTP30 [Fistulifera solaris] diamond 453 51.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27027104 27027104 PRJNA1041773_P_NODE_91722_length_245_cov_0.895349_g91389_i0 PRJNA1041773 91722 245 0.895349 2.19360505 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 138 5.7e-38   NR EJK50366.1 159749 g91389 i0 93.2 4.43265306122449 73 5 89.4 0 244 26 227 299 EJK50366.1 hypothetical protein THAOC_30677 [Thalassiosira oceanica] diamond 1086 138 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27604134 27604134 PRJNA1041773_P_NODE_95164_length_243_cov_1.811765_g94831_i0 PRJNA1041773 95164 243 1.811765 4.40258895 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 153 7.51e-44   NR GFH45299.1 426638 g94831 i0 82.7 1 81 14 100 0 1 243 176 256 GFH45299.1 hypothetical protein CTEN210_01773 [Chaetoceros tenuissimus] diamond 243 153 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27919584 27919584 PRJNA1041773_P_NODE_77885_length_251_cov_0.865169_g77552_i0 PRJNA1041773 77885 251 0.865169 2.17157419 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 119 2.11e-29   NR GFH45820.1 426638 g77552 i0 61.4 2.10358565737052 83 32 99.2 0 251 3 147 229 GFH45820.1 hypothetical protein CTEN210_02294 [Chaetoceros tenuissimus] diamond 528 119 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28669543 28669543 PRJNA1041773_P_NODE_88787_length_246_cov_0.890173_g88454_i0 PRJNA1041773 88787 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 42.7 0.0248   NR KAI2493270.1 210448 g88454 i0 28.9 2.17073170731707 76 44 86.6 2 26 238 2 72 KAI2493270.1 Phytochelatin synthase [Fragilaria crotonensis] diamond 534 43.1 0.990719257540603 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28961842 28961842 PRJNA1041773_P_NODE_95868_length_243_cov_0.905882_g95535_i0 PRJNA1041773 95868 243 0.905882 2.20129326 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 91.7 3.45e-22   NR KAL3815586.1 382380 g95535 i0 84 0.617283950617284 50 8 61.7 0 6 155 34 83 KAL3815586.1 hypothetical protein ACHAXA_001565 [Cyclostephanos tholiformis] diamond 150 91.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
29088043 29088043 PRJNA1041773_P_NODE_86608_length_247_cov_0.885057_g86275_i0 PRJNA1041773 86608 247 0.885057 2.18609079 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 161 2.6499999999999997e-46   NR KAK1735359.1 267567 g86275 i0 97.3 0.898785425101215 74 2 89.9 0 224 3 54 127 KAK1735359.1 hypothetical protein QTG54_013973 [Skeletonema marinoi] diamond 222 161 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29434913 29434913 PRJNA1041773_P_NODE_88750_length_246_cov_0.890173_g88417_i0 PRJNA1041773 88750 246 0.890173 2.18982558 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.68e-6   NR KAL3811651.1 382380 g88417 i0 75.9 0.658536585365854 29 7 35.4 0 246 160 148 176 KAL3811651.1 hypothetical protein ACHAXA_004383 [Cyclostephanos tholiformis] diamond 162 53.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
31741821 31741821 PRJNA1041773_P_NODE_84097_length_248_cov_0.880000_g83764_i0 PRJNA1041773 84097 248 0.88 2.1824 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 147 7.31e-40   NR GFH49800.1 426638 g83764 i0 82.5 0.967741935483871 80 14 96.8 0 7 246 12 91 GFH49800.1 hypothetical protein CTEN210_06276 [Chaetoceros tenuissimus] diamond 240 147 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31836652 31836652 PRJNA1041773_P_NODE_99117_length_242_cov_0.911243_g98784_i0 PRJNA1041773 99117 242 0.911243 2.20520806 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 157 2.5199999999999998e-42   NR KAK1742448.1 267567 g98784 i0 93.8 0.991735537190083 80 5 99.2 0 241 2 656 735 KAK1742448.1 trifunctional enzyme subunit alpha [Skeletonema marinoi] diamond 240 157 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32588266 32588266 PRJNA1041773_P_NODE_95699_length_243_cov_0.905882_g95366_i0 PRJNA1041773 95699 243 0.905882 2.20129326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0266   NR KAL3776965.1 382360 g95366 i0 35.4 3.92592592592593 65 41 79 1 220 29 358 422 KAL3776965.1 hypothetical protein ACHAWO_008745 [Cyclotella atomus] diamond 954 43.5 0.990804597701149 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32658739 32658739 PRJNA1041773_P_NODE_82500_length_249_cov_0.875000_g82167_i0 PRJNA1041773 82500 249 0.875 2.17875 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 169 3.06e-48   NR EJK59849.1 159749 g82167 i0 97.6 2.96385542168675 82 2 98.8 0 3 248 47 128 EJK59849.1 hypothetical protein THAOC_19884 [Thalassiosira oceanica] diamond 738 169 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);;