RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA493244", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA493244 · 14 ✖

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
456177 456177 PRJNA493244_P_NODE_1630141_length_214_cov_1.673203_g1607016_i0 PRJNA493244 1630141 214 1.673203 3.58065442 Chaetoceros pseudocurvisetus 426637 SAR_Eukaryotes SAR_Eukaryotes 97.1 8.59e-16   NTclustered gi|2043890829|gb|MZ267684.1| 426637 g1607016 i0 92.537 11.6775700934579 67 5 31 0 70 136 3233 3299 Chaetoceros pseudocurvisetus isolate CNS00390 large subunit ribosomal RNA gene, partial sequence blastn 2499 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros pseudocurvisetus
10658638 10658638 PRJNA493244_P_NODE_1094209_length_367_cov_7.571895_g1071088_i0 PRJNA493244 1094209 367 7.571895 27.78885465 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 270 8.839999999999999e-68   NTclustered gi|2444483253|gb|OP718170.1| 97227 g1071088 i0 82.121 5.11716621253406 330 45 89 12 1 325 4216 3896 Gomphonema parvulum mitochondrion, complete genome blastn 1878 270 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
15758603 15758603 PRJNA493244_P_NODE_1545133_length_232_cov_3.900585_g1522008_i0 PRJNA493244 1545133 232 3.900585 9.0493572 Plagiogrammopsis vanheurckii 1234821 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.021   NTclustered gi|1418587279|ref|NC_037997.1| 1234821 g1522008 i0 96.875 0.137931034482759 32 0 13 1 27 57 93024 92993 Plagiogrammopsis vanheurckii chloroplast, complete genome blastn 32 52.8 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Plagiogrammopsis Plagiogrammopsis vanheurckii
22776711 22776711 PRJNA493244_P_NODE_1191958_length_331_cov_53.551852_g1168834_i0 PRJNA493244 1191958 331 53.551852 177.25663012 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 163 1.3799999999999998e-35   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g1168834 i0 77.739 72.380664652568 283 52 84 10 18 295 55268 55544 Nitzschia reversa mitochondrion, complete genome blastn 23958 163 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
23407958 23407958 PRJNA493244_P_NODE_1456119_length_253_cov_4.833333_g1432994_i0 PRJNA493244 1456119 253 4.833333 12.22833249 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 276 1.2499999999999998e-69   NTclustered gi|657012566|gb|KF302620.1| 2850 g1432994 i0 87.967 1.90513833992095 241 19 92 7 21 253 274 36 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 482 276 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27392669 27392669 PRJNA493244_P_NODE_1399063_length_268_cov_6.425121_g1375938_i0 PRJNA493244 1399063 268 6.425121 17.21932428 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 119 6.97e-29   NR GKY97346.1 2872254 g1375938 i0 66.7 0.906716417910448 81 27 90.7 0 23 265 550 630 GKY97346.1 hypothetical protein MPSEU_000693000 [Mayamaea pseudoterrestris] diamond 243 119 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27408739 27408739 PRJNA493244_P_NODE_1385303_length_272_cov_2.364929_g1362178_i0 PRJNA493244 1385303 272 2.364929 6.43260688 root 1 Root_unresolved Root_unresolved 44.3 0.015   NR KAI2491351.1 210448 g1362178 i0 36.6 3.38602941176471 71 45 78.3 0 256 44 262 332 KAI2491351.1 transposition [Fragilaria crotonensis] diamond 921 44.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28513586 28513586 PRJNA493244_P_NODE_1576787_length_225_cov_2.969512_g1553662_i0 PRJNA493244 1576787 225 2.969512 6.681402 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.58e-10   NR KAG7344113.1 303405 g1553662 i0 55.3 2.50666666666667 47 21 62.7 0 190 50 187 233 KAG7344113.1 proteasome subunit alpha [Nitzschia inconspicua] diamond 564 65.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28750211 28750211 PRJNA493244_P_NODE_1578687_length_225_cov_1.560976_g1555562_i0 PRJNA493244 1578687 225 1.560976 3.512196 Haslea silbo 1146997 SAR_Eukaryotes SAR_Eukaryotes 94.4 1.96e-20   NR QUS63590.1 1146997 g1555562 i0 68.3 0.84 63 20 84 0 218 30 613 675 QUS63590.1 rt-like putative protein [Haslea silbo] diamond 189 94.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea silbo
29286862 29286862 PRJNA493244_P_NODE_543789_length_688_cov_4.290271_g522970_i0 PRJNA493244 543789 688 4.290271 29.51706448 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 75.1 8.58e-12   NR CAB9504729.1 568900 g522970 i0 37.5 0.523255813953488 120 59 52.3 2 67 426 245 348 CAB9504729.1 Mitochondrial aspartate-glutamate transporter AGC1 [Seminavis robusta] diamond 360 75.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29318467 29318467 PRJNA493244_P_NODE_1558269_length_229_cov_5.279762_g1535144_i0 PRJNA493244 1558269 229 5.279762 12.09065498 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 129 7.34e-33   NR GAX29431.1 1519565 g1535144 i0 84.1 0.903930131004367 69 11 90.4 0 14 220 358 426 GAX29431.1 hypothetical protein FisN_16Hh128 [Fistulifera solaris] diamond 207 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29413197 29413197 PRJNA493244_P_NODE_999269_length_407_cov_2.748555_g976182_i0 PRJNA493244 999269 407 2.748555 11.18661885 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0175   NR OEU10709.1 635003 g976182 i0 35.8 0.390663390663391 53 34 39.1 0 236 78 87 139 OEU10709.1 D-aminoacid aminotransferase-like PLP-dependent enzyme [Fragilariopsis cylindrus CCMP1102] diamond 159 45.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
30708293 30708293 PRJNA493244_P_NODE_1315294_length_292_cov_2.216450_g1292170_i0 PRJNA493244 1315294 292 2.21645 6.472034 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.09e-7   NR GKY95217.1 2872254 g1292170 i0 44.3 1.5 70 39 71.9 0 29 238 225 294 GKY95217.1 hypothetical protein MPSEU_000484700 [Mayamaea pseudoterrestris] diamond 438 58.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32636892 32636892 PRJNA493244_P_NODE_1373780_length_275_cov_9.757009_g1350655_i0 PRJNA493244 1373780 275 9.757009 26.83177475 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 60.5 4.45e-9   NR EJK58599.1 159749 g1350655 i0 71.1 0.414545454545455 38 11 41.5 0 21 134 107 144 EJK58599.1 hypothetical protein THAOC_21264 [Thalassiosira oceanica] diamond 114 60.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica

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