RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA814235" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 25 ✖

tax_clade 1

bioproject 1

  • PRJNA814235 · 25 ✖

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
2091172 2091172 PRJNA814235_P_NODE_124682_length_201_cov_2.439024_g123287_i0 PRJNA814235 124682 201 2.439024 4.90243824 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 92 9.5e-20   NR CAJ1950090.1 2856 g123287 i0 70.1 15.9850746268657 67 20 100 0 201 1 311 377 CAJ1950090.1 unnamed protein product [Cylindrotheca closterium] diamond 3213 92 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
2502260 2502260 PRJNA814235_P_NODE_24322_length_387_cov_5.380000_g22954_i0 PRJNA814235 24322 387 5.38 20.8206 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 669 0   NTclustered gi|1891520246|gb|MN696750.1| 303402 g22954 i0 98.177 96.5297157622739 384 5 99 2 1 383 26 408 Nitzschia dissipata culture TCC:632 large subunit ribosomal RNA gene, partial sequence blastn 37357 669 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
3369684 3369684 PRJNA814235_P_NODE_92003_length_203_cov_3.072289_g90608_i0 PRJNA814235 92003 203 3.072289 6.23674667 Discostella guiyangensis 3145224 SAR_Eukaryotes SAR_Eukaryotes 97.1 8.06e-16   NTclustered gi|2728413627|gb|OR666655.1| 3145224 g90608 i0 89.474 28.320197044335 76 8 37 0 128 203 51859 51784 Discostella guiyangensis strain GY168 chloroplast, complete genome blastn 5749 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella guiyangensis
3778783 3778783 PRJNA814235_P_NODE_37183_length_313_cov_7.336957_g35793_i0 PRJNA814235 37183 313 7.336957 22.96467541 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 564 3.039999999999999e-156   NTclustered gi|417075293|gb|JX645086.1| 137771 g35793 i0 99.357 99.297124600639 311 2 99 0 3 313 329 19 Uncultured diatom clone Es109 18S ribosomal RNA gene, partial sequence blastn 31080 569 0.991212653778559 Eukaryota Sar   Bacillariophyta         uncultured diatom
7193348 7193348 PRJNA814235_P_NODE_10386_length_586_cov_4.391621_g9228_i0 PRJNA814235 10386 586 4.391621 25.73489906 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 833 0   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g9228 i0 98.721 168.453924914676 469 6 93 0 118 586 68452 68920 Asterionella formosa chloroplast, complete genome blastn 98714 833 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
11021709 11021709 PRJNA814235_P_NODE_52069_length_264_cov_2.546256_g50675_i0 PRJNA814235 52069 264 2.546256 6.72211584 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 368 2.11e-97   NTclustered gi|2202538966|gb|OM891872.1| 3003 g50675 i0 91.76 73.9280303030303 267 19 100 2 1 264 5855 5589 Bacillaria paxillifer small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 19517 368 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
12706491 12706491 PRJNA814235_P_NODE_39330_length_304_cov_14.123596_g37939_i0 PRJNA814235 39330 304 14.123596 42.93573184 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 392 1.4699999999999995e-104   NTclustered gi|1826601749|gb|MT259197.1| 517777 g37939 i0 90.132 100.075657894737 304 26 100 4 1 304 1284 1583 Psammoneis senegalensis voucher AQ7 small subunit ribosomal RNA gene, partial sequence blastn 30423 394 0.99492385786802 Eukaryota Sar   Bacillariophyta Mediophyceae Triceratiales Plagiogrammaceae Psammoneis Psammoneis senegalensis
13980986 13980986 PRJNA814235_P_NODE_48671_length_273_cov_3.614407_g47277_i0 PRJNA814235 48671 273 3.614407 9.86733111 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 472 1.62e-128   NTclustered gi|146762526|gb|EF553458.1| 2850 g47277 i0 97.802 98.7619047619048 273 6 100 0 1 273 3852 3580 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 26962 472 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16120819 16120819 PRJNA814235_P_NODE_64393_length_237_cov_2.740000_g62998_i0 PRJNA814235 64393 237 2.74 6.4938 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 294 3.2e-75   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g62998 i0 88.889 101.666666666667 243 21 100 4 1 237 3678 3920 Nitzschia reversa isolate AGSB0348 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 24095 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
21628612 21628612 PRJNA814235_P_NODE_195657_length_151_cov_1.298246_g194262_i0 PRJNA814235 195657 151 1.298246 1.96035146 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 65.8 1.58e-6   NTclustered gi|1169296928|gb|KY364698.1| 2843 g194262 i0 100 23.3841059602649 35 0 23 0 96 130 4033 4067 Skeletonema costatum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 3531 65.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
22492900 22492900 PRJNA814235_P_NODE_150378_length_174_cov_2.270073_g148983_i0 PRJNA814235 150378 174 2.270073 3.94992702 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 292 7.92e-75   NTclustered gi|2202538966|gb|OM891872.1| 3003 g148983 i0 97.126 57.0057471264368 174 4 100 1 1 174 5855 5683 Bacillaria paxillifer small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 9919 292 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
26651350 26651350 PRJNA814235_P_NODE_151541_length_173_cov_2.227941_g150146_i0 PRJNA814235 151541 173 2.227941 3.85433793 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 66.2 3.12e-12   NR KAL3815907.1 382380 g150146 i0 88.9 1.2485549132948 36 4 62.4 0 3 110 75 110 KAL3815907.1 hypothetical protein ACHAXA_005755 [Cyclostephanos tholiformis] diamond 216 66.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28254425 28254425 PRJNA814235_P_NODE_111346_length_203_cov_2.036145_g109951_i0 PRJNA814235 111346 203 2.036145 4.13337435 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 48.1 2.51e-4   NR KAI2513745.1 210448 g109951 i0 92 0.369458128078818 25 1 35.5 1 3 74 208 232 KAI2513745.1 hypothetical protein MHU86_528 [Fragilaria crotonensis] diamond 75 48.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28294792 28294792 PRJNA814235_P_NODE_95226_length_203_cov_2.740964_g93831_i0 PRJNA814235 95226 203 2.740964 5.56415692 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 42 0.0425   NR KAL3793047.1 29204 g93831 i0 77.3 0.679802955665025 22 5 32.5 0 134 199 1042 1063 KAL3793047.1 hypothetical protein HJC23_003055 [Cyclotella cryptica] diamond 138 42.4 0.990566037735849 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29107088 29107088 PRJNA814235_P_NODE_108488_length_203_cov_2.108434_g107093_i0 PRJNA814235 108488 203 2.108434 4.28012102 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.71e-6   NR EJK58599.1 159749 g107093 i0 88 1.10837438423645 25 3 36.9 0 202 128 65 89 EJK58599.1 hypothetical protein THAOC_21264 [Thalassiosira oceanica] diamond 225 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29580382 29580382 PRJNA814235_P_NODE_63310_length_239_cov_2.603960_g61916_i0 PRJNA814235 63310 239 2.60396 6.2234644 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 99.4 4.74e-24   NR KAI2509358.1 210448 g61916 i0 96 0.627615062761506 50 2 62.8 0 3 152 135 184 KAI2509358.1 chlorophyll A-B binding protein [Fragilaria crotonensis] diamond 150 99.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29611876 29611876 PRJNA814235_P_NODE_106870_length_203_cov_2.162651_g105475_i0 PRJNA814235 106870 203 2.162651 4.3901815300000004 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.39e-6   NR GKY95431.1 2872254 g105475 i0 51.5 0.975369458128079 66 26 97.5 1 2 199 146 205 GKY95431.1 hypothetical protein MPSEU_000504600 [Mayamaea pseudoterrestris] diamond 198 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29833217 29833217 PRJNA814235_P_NODE_112191_length_203_cov_2.012048_g110796_i0 PRJNA814235 112191 203 2.012048 4.08445744 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 76.6 2.07e-14   NR XP_002179484.1 556484 g110796 i0 51.9 2.33497536945813 79 26 99 1 202 2 57 135 XP_002179484.1 chaperone, dnaj-like protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 474 76.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30157662 30157662 PRJNA814235_P_NODE_71372_length_225_cov_3.042553_g69977_i0 PRJNA814235 71372 225 3.042553 6.84574425 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 49.7 7.48e-5   NR KAG7337777.1 303405 g69977 i0 96 1.38666666666667 25 1 33.3 0 1 75 191 215 KAG7337777.1 chlorophyll A-B binding protein [Nitzschia inconspicua] diamond 312 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30916352 30916352 PRJNA814235_P_NODE_197654_length_150_cov_3.814159_g196259_i0 PRJNA814235 197654 150 3.814159 5.7212385 root 1 Root_unresolved Root_unresolved 51.6 4.61e-6   NR CAJ1959983.1 2856 g196259 i0 85.2 16.2 27 4 54 0 150 70 44 70 CAJ1959983.1 unnamed protein product [Cylindrotheca closterium] diamond 2430 51.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32014238 32014238 PRJNA814235_P_NODE_186618_length_151_cov_3.552632_g185223_i0 PRJNA814235 186618 151 3.552632 5.36447432 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00215   NR GKY93946.1 2872254 g185223 i0 50 0.834437086092715 42 21 83.4 0 3 128 248 289 GKY93946.1 hypothetical protein MPSEU_000361500 [Mayamaea pseudoterrestris] diamond 126 44.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32014243 32014243 PRJNA814235_P_NODE_194158_length_151_cov_2.561404_g192763_i0 PRJNA814235 194158 151 2.561404 3.86772004 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00289   NR GFH50352.1 426638 g192763 i0 65.5 1.1523178807947 29 10 57.6 0 149 63 96 124 GFH50352.1 hypothetical protein CTEN210_06828 [Chaetoceros tenuissimus] diamond 174 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32140896 32140896 PRJNA814235_P_NODE_199278_length_150_cov_3.194690_g197883_i0 PRJNA814235 199278 150 3.19469 4.792035 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.52e-12   NR KAI2488604.1 210448 g197883 i0 56.8 1.48 74 2 88 1 19 150 1 74 KAI2488604.1 Eukaryotic porin [Fragilaria crotonensis] diamond 222 69.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32434571 32434571 PRJNA814235_P_NODE_104619_length_203_cov_2.246988_g103224_i0 PRJNA814235 104619 203 2.246988 4.56138564 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.05e-6   NR KAL3788123.1 29204 g103224 i0 95.8 4.25615763546798 24 1 35.5 0 131 202 78 101 KAL3788123.1 hypothetical protein HJC23_005461 [Cyclotella cryptica] diamond 864 53.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32741309 32741309 PRJNA814235_P_NODE_82280_length_209_cov_3.267442_g80885_i0 PRJNA814235 82280 209 3.267442 6.82895378 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 101 4.25e-23   NR AAA80655.1 2850 g80885 i0 78.1 1.83732057416268 64 13 91.9 1 209 18 597 659 AAA80655.1 BiP [Phaeodactylum tricornutum] diamond 384 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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