RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1025141", 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 · 21 ✖

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA1025141 · 21 ✖

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
1437495 1437495 PRJNA1025141_P_NODE_1302_length_724_cov_2.591398_g1246_i0 PRJNA1025141 1302 724 2.591398 18.76172152 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 173 5.73e-51   NR KAK1747636.1 267567 g1246 i0 51.5 1.36740331491713 167 75 68.8 3 686 189 1 162 KAK1747636.1 60S ribosomal protein L21 [Skeletonema marinoi] diamond 990 173 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
7815397 7815397 PRJNA1025141_P_NODE_5967_length_328_cov_1.078431_g5906_i0 PRJNA1025141 5967 328 1.078431 3.53725368 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 106 2.5900000000000003e-27   NR VEU39283.1 183589 g5906 i0 68.7 4.57317073170732 67 21 61.3 0 128 328 20 86 VEU39283.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1500 107 0.990654205607477 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
11641455 11641455 PRJNA1025141_P_NODE_7410_length_291_cov_1.059633_g7349_i0 PRJNA1025141 7410 291 1.059633 3.08353203 Achnanthes kuwaitensis 483531 SAR_Eukaryotes SAR_Eukaryotes 178 4.26e-40   NTclustered gi|225685850|dbj|AB461923.1| 483531 g7349 i0 77.816 78.3161512027491 293 61 100 4 1 291 643 353 Achnanthes kuwaitensis MAT mRNA for methionine S-adenosyl transferase, complete cds blastn 22790 178 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Mastogloiales Achnanthaceae Achnanthes Achnanthes kuwaitensis
14191399 14191399 PRJNA1025141_P_NODE_3732_length_420_cov_3.025937_g3671_i0 PRJNA1025141 3732 420 3.025937 12.7089354 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 8.99e-37   NR EJK75259.1 159749 g3671 i0 63.1 0.735714285714286 103 37 72.9 1 321 16 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
14191408 14191408 PRJNA1025141_P_NODE_4132_length_400_cov_0.917431_g4071_i0 PRJNA1025141 4132 400 0.917431 3.669724 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 494 5.299999999999999e-135   NTclustered gi|657012367|gb|KF302531.1| 2850 g4071 i0 93.175 91.0675 337 21 84 2 65 400 15 350 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 36427 494 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
15465531 15465531 PRJNA1025141_P_NODE_1553_length_664_cov_2.291032_g1494_i0 PRJNA1025141 1553 664 2.291032 15.21245248 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 80.1 1.14e-14   NR GFH54200.1 426638 g1494 i0 47.1 0.469879518072289 104 34 45.2 3 2 301 93 179 GFH54200.1 ribosomal L14e-domain-containing protein [Chaetoceros tenuissimus] diamond 312 80.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
23115065 23115065 PRJNA1025141_P_NODE_4799_length_370_cov_1.707071_g4738_i0 PRJNA1025141 4799 370 1.707071 6.3161627 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 93.6 2.7400000000000004e-21   NR KAL3799988.1 29204 g4738 i0 61.3 0.648648648648649 80 27 64.9 1 6 245 63 138 KAL3799988.1 hypothetical protein HJC23_007461 [Cyclotella cryptica] diamond 240 93.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
24388931 24388931 PRJNA1025141_P_NODE_7500_length_288_cov_1.502326_g7439_i0 PRJNA1025141 7500 288 1.502326 4.32669888 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 145 6.87e-43   NR AID23594.1 2850 g7439 i0 78 1.86458333333333 91 20 94.8 0 1 273 7 97 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 537 145 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27887783 27887783 PRJNA1025141_P_NODE_6105_length_324_cov_1.227092_g6044_i0 PRJNA1025141 6105 324 1.227092 3.97577808 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.37e-4   NR VEU33820.1 183589 g6044 i0 32.9 0.703703703703704 76 51 70.4 0 36 263 192 267 VEU33820.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 228 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
28045704 28045704 PRJNA1025141_P_NODE_4045_length_404_cov_1.422961_g3984_i0 PRJNA1025141 4045 404 1.422961 5.74876244 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 149 1.21e-39   NR KAI2495661.1 210448 g3984 i0 52.2 0.995049504950495 134 64 99.5 0 403 2 332 465 KAI2495661.1 hypothetical protein MHU86_18845 [Fragilaria crotonensis] diamond 402 149 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28551121 28551121 PRJNA1025141_P_NODE_4547_length_381_cov_1.266234_g4486_i0 PRJNA1025141 4547 381 1.266234 4.82435154 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 97.8 7.220000000000001e-21   NR KAL3797363.1 29204 g4486 i0 70.8 1.10236220472441 72 21 56.7 0 216 1 7 78 KAL3797363.1 hypothetical protein HJC23_010489 [Cyclotella cryptica] diamond 420 97.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29364136 29364136 PRJNA1025141_P_NODE_7829_length_281_cov_1.480769_g7768_i0 PRJNA1025141 7829 281 1.480769 4.16096089 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.34e-5   NR KAL3756864.1 259834 g7768 i0 31.6 1.68683274021352 79 52 83.3 2 3 236 55 132 KAL3756864.1 hypothetical protein ACHAWU_005126 [Discostella pseudostelligera] diamond 474 50.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29687277 29687277 PRJNA1025141_P_NODE_7050_length_300_cov_0.770925_g6989_i0 PRJNA1025141 7050 300 0.770925 2.312775 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 118 4.179999999999999e-31   NR KAL3922769.1 3061772 g6989 i0 72 4.57 93 21 92 2 276 1 76 164 KAL3922769.1 MAG: hypothetical protein SGILL_002026 [Bacillariaceae sp.] diamond 1371 118 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30161148 30161148 PRJNA1025141_P_NODE_2312_length_537_cov_1.566810_g2251_i0 PRJNA1025141 2312 537 1.56681 8.4137697 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 85.1 2.34e-17   NR CAB9512996.1 568900 g2251 i0 44.7 1.08938547486034 94 52 52.5 0 56 337 4 97 CAB9512996.1 Polyketide cyclase / dehydrase and lipid transport [Seminavis robusta] diamond 585 85.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30280328 30280328 PRJNA1025141_P_NODE_12652_length_242_cov_0.911243_g12591_i0 PRJNA1025141 12652 242 0.911243 2.20520806 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 99 1.56e-24   NR KAK1740995.1 267567 g12591 i0 50.6 3.24793388429752 89 35 99.2 2 1 240 4 92 KAK1740995.1 hypothetical protein QTG54_008247 [Skeletonema marinoi] diamond 786 99 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30469732 30469732 PRJNA1025141_P_NODE_11733_length_245_cov_0.895349_g11672_i0 PRJNA1025141 11733 245 0.895349 2.19360505 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0105   NR KAI2508958.1 210448 g11672 i0 34.7 4.68979591836735 75 41 91.8 2 3 227 95 161 KAI2508958.1 hypothetical protein MHU86_5453 [Fragilaria crotonensis] diamond 1149 44.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30919873 30919873 PRJNA1025141_P_NODE_5234_length_353_cov_1.046429_g5173_i0 PRJNA1025141 5234 353 1.046429 3.69389437 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 73.9 3.41e-14   NR CAB9509836.1 568900 g5173 i0 44.4 0.611898016997167 72 38 59.5 2 1 210 45 116 CAB9509836.1 expressed unknown protein [Seminavis robusta] diamond 216 73.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31765419 31765419 PRJNA1025141_P_NODE_13217_length_241_cov_0.869048_g13156_i0 PRJNA1025141 13217 241 0.869048 2.09440568 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 120 2.3499999999999998e-32   NR EJK72880.1 159749 g13156 i0 69.7 4.50622406639004 76 23 94.6 0 1 228 62 137 EJK72880.1 hypothetical protein THAOC_05545, partial [Thalassiosira oceanica] diamond 1086 120 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31765420 31765420 PRJNA1025141_P_NODE_5257_length_352_cov_1.032258_g5196_i0 PRJNA1025141 5257 352 1.032258 3.63354816 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 159 1.6699999999999998e-45   NR GFH51783.1 426638 g5196 i0 65.2 7.84943181818182 115 40 98 0 6 350 40 154 GFH51783.1 RL5, ribosomal protein 5, 60S large ribosomal subunit [Chaetoceros tenuissimus] diamond 2763 159 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31860208 31860208 PRJNA1025141_P_NODE_6637_length_310_cov_1.282700_g6576_i0 PRJNA1025141 6637 310 1.2827 3.97637 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 106 1.5499999999999998e-24   NR KAL3800188.1 29204 g6576 i0 59.3 6.96774193548387 81 33 78.4 0 11 253 316 396 KAL3800188.1 hypothetical protein HJC23_001109 [Cyclotella cryptica] diamond 2160 106 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32469663 32469663 PRJNA1025141_P_NODE_4079_length_402_cov_2.106383_g4018_i0 PRJNA1025141 4079 402 2.106383 8.46765966 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 95.5 4.08e-21   NR KAL3782600.1 382360 g4018 i0 47.7 3.37313432835821 130 64 96.3 3 16 402 3 129 KAL3782600.1 hypothetical protein ACHAWO_008251 [Cyclotella atomus] diamond 1356 95.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus

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