RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA635397" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA635397 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
4433628 4433628 PRJNA635397_P_NODE_3884_length_1001_cov_11.760776_g3544_i0 PRJNA635397 3884 1001 11.760776 117.72536776 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 350 1.8299999999999998e-118   NR XP_002181180.1 556484 g3544 i0 79.2 6.03596403596404 212 44 63.5 0 47 682 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 6042 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12085023 12085023 PRJNA635397_P_NODE_21370_length_348_cov_1.043636_g20916_i0 PRJNA635397 21370 348 1.043636 3.63185328 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 98.6 1.1e-21   NR XP_002291609.1 296543 g20916 i0 72.6 1.96551724137931 113 30 96.6 1 12 347 239 351 XP_002291609.1 calreticulin-like protein, partial [Thalassiosira pseudonana CCMP1335] diamond 684 98.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
13360188 13360188 PRJNA635397_P_NODE_4791_length_885_cov_2.317734_g4414_i0 PRJNA635397 4791 885 2.317734 20.5119459 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 257 5.280000000000001e-77   NR KAL3788351.1 29204 g4414 i0 63.2 3.22033898305085 190 69 64.1 1 11 577 478 667 KAL3788351.1 hypothetical protein HJC23_009157 [Cyclotella cryptica] diamond 2850 257 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
14634521 14634521 PRJNA635397_P_NODE_22352_length_340_cov_0.943820_g21898_i0 PRJNA635397 22352 340 0.94382 3.208988 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 226 9.07e-67   NR KAI2512956.1 210448 g21898 i0 96.4 88.9323529411765 112 4 98.8 0 3 338 453 564 KAI2512956.1 Aconitate B N-terminal domain [Fragilaria crotonensis] diamond 30237 226 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26700941 26700941 PRJNA635397_P_NODE_35321_length_266_cov_2.082902_g34867_i0 PRJNA635397 35321 266 2.082902 5.54051932 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00107   NR CAJ1931782.1 2856 g34867 i0 36.5 2.66165413533835 63 38 68.8 1 80 262 193 255 CAJ1931782.1 unnamed protein product [Cylindrotheca closterium] diamond 708 47.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27333994 27333994 PRJNA635397_P_NODE_8783_length_603_cov_2.520755_g8336_i0 PRJNA635397 8783 603 2.520755 15.20015265 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 93.6 2.51e-18   NR CAB9513310.1 568900 g8336 i0 36.6 1.85074626865672 194 112 94.5 4 30 599 93 279 CAB9513310.1 expressed unknown protein [Seminavis robusta] diamond 1116 93.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27409730 27409730 PRJNA635397_P_NODE_38003_length_256_cov_1.562842_g37549_i0 PRJNA635397 38003 256 1.562842 4.00087552 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 130 4.44e-33   NR XP_002182131.1 556484 g37549 i0 75.6 5.7890625 82 20 96.1 0 9 254 863 944 XP_002182131.1 2-oxoglutarate dehydrogenase E1 component [Phaeodactylum tricornutum CCAP 1055/1] diamond 1482 131 0.99236641221374 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27535901 27535901 PRJNA635397_P_NODE_48063_length_228_cov_2.006452_g47609_i0 PRJNA635397 48063 228 2.006452 4.57471056 root 1 Root_unresolved Root_unresolved 117 2.1e-28   NR CAJ1955267.1 2856 g47609 i0 69.3 22.5394736842105 75 23 98.7 0 227 3 389 463 CAJ1955267.1 unnamed protein product [Cylindrotheca closterium] diamond 5139 118 0.991525423728814 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27586538 27586538 PRJNA635397_P_NODE_32084_length_280_cov_1.903382_g31630_i0 PRJNA635397 32084 280 1.903382 5.3294696 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 53.5 8.98e-6   NR GAX18081.1 1519565 g31630 i0 37.3 1.77857142857143 83 44 88.9 1 3 251 549 623 GAX18081.1 two-component system, chemotaxis family, sensor kinase CheA [Fistulifera solaris] diamond 498 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28091590 28091590 PRJNA635397_P_NODE_26585_length_309_cov_1.881356_g26131_i0 PRJNA635397 26585 309 1.881356 5.81339004 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 125 1.19e-31   NR XP_002286538.1 296543 g26131 i0 60.6 0.912621359223301 94 37 91.3 0 3 284 199 292 XP_002286538.1 hypothetical protein THAPSDRAFT_31021, partial [Thalassiosira pseudonana CCMP1335] diamond 282 125 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
28407440 28407440 PRJNA635397_P_NODE_39366_length_252_cov_1.340782_g38912_i0 PRJNA635397 39366 252 1.340782 3.37877064 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 106 1.39e-26   NR KAL3771302.1 2934178 g38912 i0 65.8 2.8452380952381 79 27 94 0 238 2 15 93 KAL3771302.1 LOW QUALITY PROTEIN: hypothetical protein ACHAW5_004511 [Stephanodiscus triporus] diamond 717 106 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
28439111 28439111 PRJNA635397_P_NODE_34066_length_271_cov_2.151515_g33612_i0 PRJNA635397 34066 271 2.151515 5.83060565 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 86.3 3.61e-19   NR XP_002292856.1 296543 g33612 i0 56.7 0.74169741697417 67 29 74.2 0 2 202 78 144 XP_002292856.1 predicted protein, partial [Thalassiosira pseudonana CCMP1335] diamond 201 86.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29575408 29575408 PRJNA635397_P_NODE_38550_length_254_cov_1.685083_g38096_i0 PRJNA635397 38550 254 1.685083 4.28011082 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 54.3 7.13e-7   NR GAX27651.1 1519565 g38096 i0 74.2 0.366141732283465 31 8 36.6 0 162 254 2 32 GAX27651.1 hypothetical protein FisN_13Hh257 [Fistulifera solaris] diamond 93 54.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31262554 31262554 PRJNA635397_P_NODE_19455_length_366_cov_3.344710_g19001_i0 PRJNA635397 19455 366 3.34471 12.2416386 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 242 2.39e-79   NR CAJ1953473.1 2856 g19001 i0 90.8 4.87704918032787 119 11 97.5 0 364 8 98 216 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 1785 242 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31294121 31294121 PRJNA635397_P_NODE_43875_length_245_cov_2.215116_g43421_i0 PRJNA635397 43875 245 2.215116 5.4270342 root 1 Root_unresolved Root_unresolved 154 2.1499999999999994e-42   NR KAI2502664.1 210448 g43421 i0 91.4 14.8775510204082 81 7 99.2 0 1 243 348 428 KAI2502664.1 snoRNA binding protein [Fragilaria crotonensis] diamond 3645 154 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31408272 31408272 PRJNA635397_P_NODE_7496_length_665_cov_4.542230_g7055_i0 PRJNA635397 7496 665 4.54223 30.2058295 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 160 2.54e-45   NR KAI2494838.1 210448 g7055 i0 48 0.902255639097744 200 102 89.8 2 35 631 10 208 KAI2494838.1 ATP synthase delta (OSCP) subunit [Fragilaria crotonensis] diamond 600 160 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31724380 31724380 PRJNA635397_P_NODE_47757_length_231_cov_2.322785_g47303_i0 PRJNA635397 47757 231 2.322785 5.36563335 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 106 1.0099999999999999e-24   NR KAK1745601.1 267567 g47303 i0 66.2 6.74025974025974 74 25 96.1 0 2 223 346 419 KAK1745601.1 sulfite reductase [Skeletonema marinoi] diamond 1557 106 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31736830 31736830 PRJNA635397_P_NODE_22677_length_337_cov_1.170455_g22223_i0 PRJNA635397 22677 337 1.170455 3.94443335 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 86.3 2.08e-18   NR KAK1741114.1 267567 g22223 i0 82.6 4.7893175074184 46 8 40.9 0 337 200 99 144 KAK1741114.1 NFYB/HAP3 family transcription factor subunit [Skeletonema marinoi] diamond 1614 86.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32306788 32306788 PRJNA635397_P_NODE_32699_length_277_cov_2.049020_g32245_i0 PRJNA635397 32699 277 2.04902 5.6757854 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.53e-14   NR KAK1733223.1 267567 g32245 i0 67.2 3.24909747292419 58 18 61.7 1 105 275 140 197 KAK1733223.1 DUF4336 domain-containing protein [Skeletonema marinoi] diamond 900 78.2 0.994884910485933 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32433262 32433262 PRJNA635397_P_NODE_37419_length_258_cov_1.675676_g36965_i0 PRJNA635397 37419 258 1.675676 4.32324408 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 123 1.68e-30   NR KAL3782590.1 382360 g36965 i0 63.5 5.96511627906977 85 31 98.8 0 2 256 332 416 KAL3782590.1 hypothetical protein ACHAWO_008241 [Cyclotella atomus] diamond 1539 123 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);;