RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA533623" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA533623 · 16 ✖

analysis 1

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
26665992 26665992 PRJNA533623_P_NODE_9021_length_779_cov_12.717270_g7512_i0 PRJNA533623 9021 779 12.71727 99.0675333 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 70.9 7.12e-10   NR XP_002184761.1 556484 g7512 i0 42.7 1.52888318356868 89 50 34.3 1 277 543 75 162 XP_002184761.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1191 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26681103 26681103 PRJNA533623_P_NODE_22061_length_494_cov_7.501155_g20308_i0 PRJNA533623 22061 494 7.501155 37.0557057 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 162 5.73e-43   NR KAI2498713.1 210448 g20308 i0 73.5 3.57085020242915 98 26 59.5 0 314 21 72 169 KAI2498713.1 glutamine synthetase [Fragilaria crotonensis] diamond 1764 162 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26951030 26951030 PRJNA533623_P_NODE_35262_length_374_cov_2.447284_g33490_i0 PRJNA533623 35262 374 2.447284 9.15284216 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 122 7.149999999999998e-30   NR GFH59439.1 426638 g33490 i0 48.3 3.64973262032086 116 58 93 1 350 3 79 192 GFH59439.1 hypothetical protein CTEN210_15915 [Chaetoceros tenuissimus] diamond 1365 122 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27330740 27330740 PRJNA533623_P_NODE_1743_length_1552_cov_46.505701_g27_i3 PRJNA533623 1743 1552 46.505701 721.76847952 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 81.3 6.68e-12   NR KAI2491042.1 210448 g27 i3 57.6 0.767396907216495 66 26 12.4 1 325 516 1517 1582 KAI2491042.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 1191 81.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27345793 27345793 PRJNA533623_P_NODE_72583_length_212_cov_1.827815_g70802_i0 PRJNA533623 72583 212 1.827815 3.8749678 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 82 3.61e-16   NR KAL3802219.1 29204 g70802 i0 55.2 6.69339622641509 67 30 94.8 0 9 209 565 631 KAL3802219.1 hypothetical protein HJC23_001763 [Cyclotella cryptica] diamond 1419 82.4 0.995145631067961 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27804447 27804447 PRJNA533623_P_NODE_11924_length_681_cov_22.195161_g10298_i0 PRJNA533623 11924 681 22.195161 151.14904641 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 103 2.9e-23   NR KAL3903526.1 3061772 g10298 i0 43.8 1.07929515418502 121 63 51.1 1 645 298 53 173 KAL3903526.1 MAG: hypothetical protein SGARI_005339, partial [Bacillariaceae sp.] diamond 735 103 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28766418 28766418 PRJNA533623_P_NODE_66187_length_232_cov_3.058480_g64406_i0 PRJNA533623 66187 232 3.05848 7.0956736 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 56.2 5.7e-7   NR CAJ1949588.1 2856 g64406 i0 61.2 2.59913793103448 49 19 63.4 0 200 54 4750 4798 CAJ1949588.1 unnamed protein product [Cylindrotheca closterium] diamond 603 56.6 0.992932862190813 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29666836 29666836 PRJNA533623_P_NODE_51990_length_285_cov_6.941964_g50211_i0 PRJNA533623 51990 285 6.941964 19.7845974 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 58.2 2.43e-7   NR VEU37882.1 183589 g50211 i0 59.1 0.463157894736842 44 17 46.3 1 133 264 738 780 VEU37882.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 132 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29983012 29983012 PRJNA533623_P_NODE_40771_length_340_cov_6.125448_g38997_i0 PRJNA533623 40771 340 6.125448 20.8265232 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 52 6.55e-5   NR KAL3821794.1 382380 g38997 i0 41.2 3.22058823529412 68 31 60 2 88 291 691 749 KAL3821794.1 hypothetical protein ACHAXA_008787 [Cyclostephanos tholiformis] diamond 1095 52 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30282676 30282676 PRJNA533623_P_NODE_53592_length_279_cov_1.788991_g51813_i0 PRJNA533623 53592 279 1.788991 4.99128489 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 68.2 6.64e-11   NR KAG7356465.1 303405 g51813 i0 46.4 4.48387096774194 69 37 74.2 0 257 51 1420 1488 KAG7356465.1 cation-translocating ATPase [Nitzschia inconspicua] diamond 1251 68.6 0.994169096209913 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31151629 31151629 PRJNA533623_P_NODE_7895_length_828_cov_7.767927_g6460_i0 PRJNA533623 7895 828 7.767927 64.31843556 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 51.2 0.00314   NR CAJ1966465.1 2856 g6460 i0 34.2 0.778985507246377 114 73 40.6 2 436 771 434 547 CAJ1966465.1 unnamed protein product [Cylindrotheca closterium] diamond 645 51.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31246799 31246799 PRJNA533623_P_NODE_31795_length_399_cov_13.917160_g30024_i0 PRJNA533623 31795 399 13.91716 55.5294684 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 50.4 4.41e-5   NR VEU33775.1 183589 g30024 i0 54.1 0.834586466165414 37 17 27.8 0 369 259 57 93 VEU33775.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 333 50.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
31657777 31657777 PRJNA533623_P_NODE_17217_length_566_cov_4.851485_g15491_i0 PRJNA533623 17217 566 4.851485 27.4594051 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 58.9 3.82e-7   NR KAI2500573.1 210448 g15491 i0 32.1 0.742049469964664 140 75 70 4 127 522 22 149 KAI2500573.1 ribosome biogenesis protein Nop16 [Fragilaria crotonensis] diamond 420 58.9 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31879265 31879265 PRJNA533623_P_NODE_69597_length_221_cov_2.431250_g67816_i0 PRJNA533623 69597 221 2.43125 5.3730625 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 78.6 1.06e-15   NR XP_002181648.1 556484 g67816 i0 58.7 0.855203619909502 63 25 84.2 1 190 5 158 220 XP_002181648.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 189 78.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32590556 32590556 PRJNA533623_P_NODE_4919_length_1021_cov_36.744792_g3730_i0 PRJNA533623 4919 1021 36.744792 375.16432632 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.99e-5   NR XP_002181457.1 556484 g3730 i0 25.7 0.966699314397649 167 94 49.1 5 15 515 277 413 XP_002181457.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 987 58.9 0.99320882852292 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32764362 32764362 PRJNA533623_P_NODE_61740_length_247_cov_42.381720_g59960_i0 PRJNA533623 61740 247 42.38172 104.6828484 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 67.4 7.58e-11   NR CAJ1961639.1 2856 g59960 i0 39.2 0.898785425101215 74 45 89.9 0 239 18 218 291 CAJ1961639.1 unnamed protein product [Cylindrotheca closterium] diamond 222 67.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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