RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA977246 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
13704604 13704604 PRJNA977246_S_NODE_18351_length_329_cov_2.830000_g17359_i0 PRJNA977246 18351 329 2.83 9.3107 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 184 1.9999999999999998e-54   NR KAG7370735.1 303405 g17359 i0 86.9 1.80547112462006 99 13 90.3 0 327 31 286 384 KAG7370735.1 S-adenosylmethionine synthetase [Nitzschia inconspicua] diamond 594 184 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
14979652 14979652 PRJNA977246_S_NODE_6312_length_636_cov_3.197694_g5559_i0 PRJNA977246 6312 636 3.197694 20.33733384 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 308 5.28e-102   NR KAI2513911.1 210448 g5559 i0 75.8 2.64622641509434 186 45 87.7 0 613 56 164 349 KAI2513911.1 C1 peptidase-like protein [Fragilaria crotonensis] diamond 1683 308 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
21671199 21671199 PRJNA977246_S_NODE_22897_length_280_cov_7803.155378_g21905_i0 PRJNA977246 22897 280 7803.155378 21848.8350584 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 100 2.9e-23   NR KAG7341687.1 303405 g21905 i0 75.9 1.24285714285714 58 14 62.1 0 52 225 252 309 KAG7341687.1 mitochondrial carrier protein [Nitzschia inconspicua] diamond 348 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
25177586 25177586 PRJNA977246_S_NODE_35740_length_198_cov_2.923077_g34748_i0 PRJNA977246 35740 198 2.923077 5.78769246 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 122 8.54e-32   NR XP_002290502.1 296543 g34748 i0 87.7 1.96969696969697 65 8 98.5 0 197 3 203 267 XP_002290502.1 gdp-d-mannose 4,6-dehydratase [Thalassiosira pseudonana CCMP1335] diamond 390 122 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29047355 29047355 PRJNA977246_S_NODE_20948_length_299_cov_3.214815_g19956_i0 PRJNA977246 20948 299 3.214815 9.61229685 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 113 1.01e-27   NR GKY99472.1 2872254 g19956 i0 98.1 0.531772575250836 53 1 53.2 0 298 140 302 354 GKY99472.1 hypothetical protein MPSEU_000901500 [Mayamaea pseudoterrestris] diamond 159 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29457389 29457389 PRJNA977246_S_NODE_17130_length_344_cov_3.971429_g16138_i0 PRJNA977246 17130 344 3.971429 13.66171576 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 161 1.08e-43   NR GKY92789.1 2872254 g16138 i0 86 0.811046511627907 93 13 81.1 0 342 64 573 665 GKY92789.1 hypothetical protein MPSEU_000248600 [Mayamaea pseudoterrestris] diamond 279 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29741596 29741596 PRJNA977246_S_NODE_17110_length_344_cov_7.342857_g16118_i0 PRJNA977246 17110 344 7.342857 25.25942808 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 131 1.12e-32   NR KAG7352534.1 303405 g16118 i0 75 2.01453488372093 76 19 66.3 0 320 93 1293 1368 KAG7352534.1 family 3 adenylate cyclase [Nitzschia inconspicua] diamond 693 131 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29836536 29836536 PRJNA977246_S_NODE_25011_length_262_cov_2.858369_g24019_i0 PRJNA977246 25011 262 2.858369 7.48892678 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 99.4 2.19e-23   NR GKY96218.1 2872254 g24019 i0 85.7 1.25954198473282 56 8 64.1 0 261 94 179 234 GKY96218.1 hypothetical protein MPSEU_000581700 [Mayamaea pseudoterrestris] diamond 330 99.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30380206 30380206 PRJNA977246_S_NODE_21992_length_289_cov_3.150000_g21000_i0 PRJNA977246 21992 289 3.15 9.1035 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 154 3.67e-44   NR KAK1744741.1 267567 g21000 i0 82.8 7.76470588235294 93 16 96.5 0 286 8 206 298 KAK1744741.1 ADP/ATP carrier protein [Skeletonema marinoi] diamond 2244 155 0.993548387096774 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31321614 31321614 PRJNA977246_S_NODE_34635_length_203_cov_2.586207_g33643_i0 PRJNA977246 34635 203 2.586207 5.25000021 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 84.7 3.09e-17   NR WPV76442.1 2126271 g33643 i0 68.3 0.931034482758621 63 20 93.1 0 203 15 95 157 WPV76442.1 DNA-replication helicase subunit [Naviculales sp.] diamond 189 84.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
31454455 31454455 PRJNA977246_S_NODE_44176_length_168_cov_3.633094_g43184_i0 PRJNA977246 44176 168 3.633094 6.10359792 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 112 5.11e-28   NR CAJ1955351.1 2856 g43184 i0 96.4 10.9285714285714 55 2 98.2 0 165 1 127 181 CAJ1955351.1 unnamed protein product [Cylindrotheca closterium] diamond 1836 113 0.991150442477876 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32365843 32365843 PRJNA977246_S_NODE_15579_length_368_cov_3.551622_g14589_i0 PRJNA977246 15579 368 3.551622 13.06996896 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 170 3.75e-46   NR GFH52902.1 426638 g14589 i0 81.3 2.61684782608696 107 20 87.2 0 355 35 1287 1393 GFH52902.1 hypothetical protein CTEN210_09378 [Chaetoceros tenuissimus] diamond 963 170 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus

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