RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA893346" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA893346 · 11 ✖

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
21269909 21269909 PRJNA893346_P_NODE_20117_length_344_cov_0.804428_g19628_i0 PRJNA893346 20117 344 0.804428 2.76723232 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 96.3 6.66e-22   NR EJK49021.1 159749 g19628 i0 62 1.45639534883721 79 28 68.9 1 104 340 35 111 EJK49021.1 hypothetical protein THAOC_32138 [Thalassiosira oceanica] diamond 501 96.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
21645449 21645449 PRJNA893346_P_NODE_31657_length_261_cov_1.026596_g31167_i0 PRJNA893346 31657 261 1.026596 2.67941556 root 1 Root_unresolved Root_unresolved 136 2.91e-35   NR EJK52995.1 159749 g31167 i0 77 11 87 20 100 0 261 1 543 629 EJK52995.1 hypothetical protein THAOC_27647 [Thalassiosira oceanica] diamond 2871 137 0.992700729927007 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
25469994 25469994 PRJNA893346_P_NODE_34820_length_249_cov_0.875000_g34330_i0 PRJNA893346 34820 249 0.875 2.17875 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 78.7 3.72e-10   NTclustered gi|2852238308|gb|PQ498360.1| 189737 g34330 i0 94.118 3.11244979919679 51 3 20 0 173 223 33791 33841 Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome blastn 775 78.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
27600677 27600677 PRJNA893346_P_NODE_17004_length_376_cov_1.016502_g16515_i0 PRJNA893346 17004 376 1.016502 3.82204752 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 176 2.92e-50   NR KAG7367217.1 303405 g16515 i0 74.2 1.98670212765957 124 32 98.9 0 374 3 52 175 KAG7367217.1 enolase [Nitzschia inconspicua] diamond 747 177 0.994350282485876 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27821700 27821700 PRJNA893346_P_NODE_39404_length_241_cov_2.291667_g38914_i0 PRJNA893346 39404 241 2.291667 5.52291747 root 1 Root_unresolved Root_unresolved 114 4.64e-29   NR CAJ1941666.1 2856 g38914 i0 60 66.6473029045643 80 32 99.6 0 241 2 103 182 CAJ1941666.1 unnamed protein product [Cylindrotheca closterium] diamond 16062 114 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28350444 28350444 PRJNA893346_P_NODE_32826_length_253_cov_1.711111_g32336_i0 PRJNA893346 32826 253 1.711111 4.32911083 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 130 4.83e-33   NR CAB9503861.1 568900 g32336 i0 77.6 1.99209486166008 85 17 98.4 1 3 251 284 368 CAB9503861.1 expressed unknown protein [Seminavis robusta] diamond 504 130 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28634911 28634911 PRJNA893346_P_NODE_31107_length_264_cov_1.607330_g30617_i0 PRJNA893346 31107 264 1.60733 4.2433512 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 60.8 5.38e-9   NR KAL3796769.1 29204 g30617 i0 41 2.80681818181818 78 43 87.5 2 29 259 26 101 KAL3796769.1 hypothetical protein HJC23_010916 [Cyclotella cryptica] diamond 741 60.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29526588 29526588 PRJNA893346_P_NODE_13550_length_424_cov_1.646724_g13064_i0 PRJNA893346 13550 424 1.646724 6.98210976 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 134 2.0599999999999997e-37   NR KAG7362218.1 303405 g13064 i0 50.4 2.82311320754717 131 53 92.7 1 20 412 3 121 KAG7362218.1 ribosomal L27e protein [Nitzschia inconspicua] diamond 1197 134 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29550117 29550117 PRJNA893346_P_NODE_36610_length_246_cov_0.890173_g36120_i0 PRJNA893346 36610 246 0.890173 2.18982558 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 95.5 6.16e-21   NR XP_002179706.1 556484 g36120 i0 54.3 2.0609756097561 92 29 96.3 2 2 238 43 134 XP_002179706.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 507 95.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30782290 30782290 PRJNA893346_P_NODE_12774_length_437_cov_1.914835_g12288_i0 PRJNA893346 12774 437 1.914835 8.36782895 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 176 3.01e-51   NR CAJ1937478.1 2856 g12288 i0 61.6 1.00228832951945 146 55 99.5 1 435 1 123 268 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 438 176 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32773720 32773720 PRJNA893346_P_NODE_36800_length_246_cov_0.890173_g36310_i0 PRJNA893346 36800 246 0.890173 2.18982558 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 51.6 3.13e-6   NR VEU39107.1 183589 g36310 i0 45.8 0.719512195121951 59 31 70.7 1 211 38 12 70 VEU39107.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 177 51.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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