RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA801875 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
2497279 2497279 PRJNA801875_P_NODE_2382_length_226_cov_1.418848_g2279_i0 PRJNA801875 2382 226 1.418848 3.20659648 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 89 1.13e-18   NR KAI2508213.1 210448 g2279 i0 54.5 5.77433628318584 77 30 95.6 1 221 6 2 78 KAI2508213.1 Type III restriction enzyme [Fragilaria crotonensis] diamond 1305 89 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
7179400 7179400 PRJNA801875_P_NODE_306_length_826_cov_3.996207_g223_i0 PRJNA801875 306 826 3.996207 33.00866982 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 350 2.0699999999999988e-119   NR XP_002181180.1 556484 g223 i0 79.2 7.3002421307506 212 44 77 0 50 685 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 6030 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
15249855 15249855 PRJNA801875_P_NODE_1612_length_300_cov_2.550943_g1509_i0 PRJNA801875 1612 300 2.550943 7.652829 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 123 2.59e-30   NR YP_011057971.1 3082010 g1509 i0 58.4 3.02 101 40 99 1 2 298 41 141 YP_011057971.1 NADH dehydrogenase subunit 5 [Cocconeiopsis kantsiensis] diamond 906 123 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
22478082 22478082 PRJNA801875_P_NODE_1018_length_408_cov_1.654155_g915_i0 PRJNA801875 1018 408 1.654155 6.7489524 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 226 1.89e-70   NR CAJ1952266.1 2856 g915 i0 75.6 56.3897058823529 135 33 99.3 0 3 407 109 243 CAJ1952266.1 unnamed protein product [Cylindrotheca closterium] diamond 23007 228 0.991228070175439 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
22478114 22478114 PRJNA801875_P_NODE_2778_length_202_cov_1.970060_g2675_i0 PRJNA801875 2778 202 1.97006 3.9795212 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 57.8 5.59e-8   NR EJK52515.1 159749 g2675 i0 67.6 1.63366336633663 37 12 55 0 2 112 141 177 EJK52515.1 hypothetical protein THAOC_28194 [Thalassiosira oceanica] diamond 330 57.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
22478120 22478120 PRJNA801875_P_NODE_2998_length_193_cov_1.651899_g2895_i0 PRJNA801875 2998 193 1.651899 3.18816507 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 104 2.6799999999999998e-24   NR XP_002293997.1 296543 g2895 i0 85.7 2.93782383419689 63 9 97.9 0 3 191 510 572 XP_002293997.1 succinate dehydrogenase flavoprotein subunit [Thalassiosira pseudonana CCMP1335] diamond 567 105 0.990476190476191 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27180336 27180336 PRJNA801875_P_NODE_4642_length_152_cov_1.290598_g4539_i0 PRJNA801875 4642 152 1.290598 1.96170896 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 86.3 4.9e-18   NR XP_002295475.1 296543 g4539 i0 77.1 4.73684210526316 48 11 94.7 0 7 150 364 411 XP_002295475.1 valyl-tRNA synthetase [Thalassiosira pseudonana CCMP1335] diamond 720 86.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27338758 27338758 PRJNA801875_P_NODE_1863_length_272_cov_4.274262_g1760_i0 PRJNA801875 1863 272 4.274262 11.62599264 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 127 4.03e-33   NR CAB9519459.1 568900 g1760 i0 66.7 3.77205882352941 84 28 92.6 0 16 267 35 118 CAB9519459.1 Sulfide:quinone oxidoreductase, mitochondrial [Seminavis robusta] diamond 1026 127 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27591463 27591463 PRJNA801875_P_NODE_3104_length_189_cov_0.987013_g3001_i0 PRJNA801875 3104 189 0.987013 1.86545457 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 92.8 7.620000000000001e-21   NR KAL3905633.1 3061772 g3001 i0 66.1 5.84126984126984 62 21 98.4 0 187 2 47 108 KAL3905633.1 MAG: hypothetical protein SGILL_009599, partial [Bacillariaceae sp.] diamond 1104 92.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27686342 27686342 PRJNA801875_P_NODE_2524_length_216_cov_1.867403_g2421_i0 PRJNA801875 2524 216 1.867403 4.03359048 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 59.7 2.65e-8   NR KAI2512337.1 210448 g2421 i0 59.5 1.68055555555556 37 15 51.4 0 104 214 62 98 KAI2512337.1 RNA binding-protein [Fragilaria crotonensis] diamond 363 59.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29012415 29012415 PRJNA801875_P_NODE_2968_length_194_cov_1.729560_g2865_i0 PRJNA801875 2968 194 1.72956 3.3553464 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 61.2 5.88e-9   NR CAB9516888.1 568900 g2865 i0 59 2.11855670103093 39 16 60.3 0 13 129 706 744 CAB9516888.1 oligomeric mucus gel-forming [Seminavis robusta] diamond 411 61.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29399822 29399822 PRJNA801875_P_NODE_1129_length_381_cov_1.127168_g1026_i0 PRJNA801875 1129 381 1.127168 4.29451008 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 103 4.13e-23   NR KAL3801258.1 29204 g1026 i0 77 4.80314960629921 61 14 48 0 1 183 311 371 KAL3801258.1 hypothetical protein HJC23_012658 [Cyclotella cryptica] diamond 1830 104 0.990384615384615 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29873518 29873518 PRJNA801875_P_NODE_331_length_792_cov_1.767503_g245_i0 PRJNA801875 331 792 1.767503 13.99862376 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 262 5.43e-84   NR CAB9508817.1 568900 g245 i0 54.5 3.60606060606061 242 92 90.5 5 792 76 49 275 CAB9508817.1 Quercetin 2,3-dioxygenase [Seminavis robusta] diamond 2856 262 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30220906 30220906 PRJNA801875_P_NODE_2752_length_204_cov_0.893491_g2649_i0 PRJNA801875 2752 204 0.893491 1.82272164 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 71.6 1.09e-12   NR CAJ1927347.1 2856 g2649 i0 56.9 2.92647058823529 51 22 75 0 45 197 292 342 CAJ1927347.1 unnamed protein product [Cylindrotheca closterium] diamond 597 71.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30938999 30938999 PRJNA801875_P_NODE_4354_length_157_cov_0.967213_g4251_i0 PRJNA801875 4354 157 0.967213 1.51852441 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 60.8 4.73e-9   NR CAB9519406.1 568900 g4251 i0 52.1 1.8343949044586 48 23 91.7 0 151 8 209 256 CAB9519406.1 Putative white-brown complex homolog protein 30 [Seminavis robusta] diamond 288 60.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31413005 31413005 PRJNA801875_P_NODE_876_length_447_cov_1.701456_g774_i0 PRJNA801875 876 447 1.701456 7.60550832 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.0274   NR GKY98789.1 2872254 g774 i0 35.4 0.550335570469799 82 50 53 2 17 253 4652 4733 GKY98789.1 hypothetical protein MPSEU_000835100 [Mayamaea pseudoterrestris] diamond 246 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31539627 31539627 PRJNA801875_P_NODE_1256_length_358_cov_3.662539_g1153_i0 PRJNA801875 1256 358 3.662539 13.11188962 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 66.2 7.05e-10   NR GFH44278.1 426638 g1153 i0 65.9 0.368715083798883 44 15 36.9 0 201 70 35 78 GFH44278.1 CHAT domain-containing protein [Chaetoceros tenuissimus] diamond 132 66.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31760852 31760852 PRJNA801875_P_NODE_1577_length_304_cov_1.970260_g1474_i0 PRJNA801875 1577 304 1.97026 5.9895904 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 124 1.85e-30   NR GFH45451.1 426638 g1474 i0 71.3 1.63815789473684 80 23 78.9 0 7 246 546 625 GFH45451.1 PLP-dependent transferase [Chaetoceros tenuissimus] diamond 498 124 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32330759 32330759 PRJNA801875_P_NODE_3919_length_165_cov_1.992308_g3816_i0 PRJNA801875 3919 165 1.992308 3.2873082 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.29e-5   NR KAG7367511.1 303405 g3816 i0 54.5 0.6 33 15 60 0 6 104 44 76 KAG7367511.1 hypothetical protein IV203_030182 [Nitzschia inconspicua] diamond 99 47.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32402675 32402675 PRJNA801875_P_NODE_2279_length_233_cov_1.444444_g2176_i0 PRJNA801875 2279 233 1.444444 3.36555452 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 94.4 2.21e-20   NR XP_002291923.1 296543 g2176 i0 55.3 4.89270386266094 76 34 97.9 0 228 1 54 129 XP_002291923.1 glutamate-cysteine ligase, partial [Thalassiosira pseudonana CCMP1335] diamond 1140 94.7 0.996832101372756 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32497682 32497682 PRJNA801875_P_NODE_419_length_686_cov_3.422427_g324_i0 PRJNA801875 419 686 3.422427 23.47784922 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 316 2.799999999999999e-100   NR CAJ1962677.1 2856 g324 i0 65.6 8.93440233236152 227 78 99.3 0 4 684 401 627 CAJ1962677.1 unnamed protein product [Cylindrotheca closterium] diamond 6129 317 0.996845425867508 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32529364 32529364 PRJNA801875_P_NODE_2859_length_198_cov_2.196319_g2756_i0 PRJNA801875 2859 198 2.196319 4.3487116200000004 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.81e-4   NR KAL3771062.1 259834 g2756 i0 38 1.51515151515152 50 31 75.8 0 6 155 253 302 KAL3771062.1 hypothetical protein ACHAWU_006439 [Discostella pseudostelligera] diamond 300 48.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32583631 32583631 PRJNA801875_P_NODE_1879_length_271_cov_1.538136_g1776_i0 PRJNA801875 1879 271 1.538136 4.16834856 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 49.3 2.52e-4   NR GAX29281.1 1519565 g1776 i0 36.2 1.52767527675277 69 43 76.4 1 236 30 189 256 GAX29281.1 hypothetical protein FisN_16Hu289 [Fistulifera solaris] diamond 414 49.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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