RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA1145997 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
7942569 7942569 PRJNA1145997_P_NODE_37547_length_284_cov_7.597156_g34928_i0 PRJNA1145997 37547 284 7.597156 21.57592304 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 73.9 3.5e-13   NR KAL3776289.1 2934178 g34928 i0 87.5 0.422535211267606 40 5 42.3 0 25 144 268 307 KAL3776289.1 hypothetical protein ACHAW5_002598 [Stephanodiscus triporus] diamond 120 73.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
18141017 18141017 PRJNA1145997_P_NODE_25895_length_490_cov_4.796163_g23279_i0 PRJNA1145997 25895 490 4.796163 23.5011987 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 142 7.34e-39   NR KAF4142888.1 4787 g23279 i0 92.4 3.64285714285714 66 5 40.4 0 11 208 166 231 KAF4142888.1 Rieske [2Fe-2S] domain, partial [Phytophthora infestans] diamond 1785 143 0.993006993006993 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
18884950 18884950 PRJNA1145997_P_NODE_24055_length_550_cov_3.733753_g21444_i0 PRJNA1145997 24055 550 3.733753 20.5356415 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 142 4.9900000000000003e-36   NR KAL3760366.1 259834 g21444 i0 63.7 0.556363636363636 102 37 55.6 0 548 243 354 455 KAL3760366.1 LOW QUALITY PROTEIN: hypothetical protein ACHAWU_000341 [Discostella pseudostelligera] diamond 306 142 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27007135 27007135 PRJNA1145997_P_NODE_24722_length_528_cov_4.540659_g22107_i0 PRJNA1145997 24722 528 4.540659 23.97467952 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 83.6 2.11e-16   NR KAJ8525733.1 4785 g22107 i0 29.9 0.875 154 99 87.5 2 27 488 29 173 KAJ8525733.1 hypothetical protein ON010_g15381 [Phytophthora cinnamomi] diamond 462 83.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
27249099 27249099 PRJNA1145997_P_NODE_26783_length_462_cov_7.336761_g24166_i0 PRJNA1145997 26783 462 7.336761 33.89583582 Dinophyceae 2864 SAR_Eukaryotes SAR_Eukaryotes 50.1 7.42e-4   NR CAE8650303.1 89957 g24166 i0 60 1.15584415584416 45 18 29.2 0 211 77 219 263 CAE8650303.1 unnamed protein product, partial [Polarella glacialis] diamond 534 50.4 0.994047619047619 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
27639423 27639423 PRJNA1145997_P_NODE_41204_length_258_cov_14.210811_g38585_i0 PRJNA1145997 41204 258 14.210811 36.66389238 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 84.3 6.13e-17   NR CAE8593357.1 89957 g38585 i0 74.5 1.18604651162791 51 13 59.3 0 235 83 322 372 CAE8593357.1 unnamed protein product [Polarella glacialis] diamond 306 84.3 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
29470228 29470228 PRJNA1145997_P_NODE_49890_length_236_cov_3.006135_g47271_i0 PRJNA1145997 49890 236 3.006135 7.0944786 Symbiodinium pilosum 2952 SAR_Eukaryotes SAR_Eukaryotes 55.8 8.22e-7   NR CAE7727213.1 2952 g47271 i0 74.3 0.877118644067797 35 9 44.5 0 215 111 294 328 CAE7727213.1 MMDHI [Symbiodinium pilosum] diamond 207 55.8 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium pilosum
29975793 29975793 PRJNA1145997_P_NODE_49691_length_238_cov_4.272727_g47072_i0 PRJNA1145997 49691 238 4.272727 10.16909026 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.22e-4   NR XP_067795723.1 4785 g47072 i0 65.6 1.21008403361345 32 11 40.3 0 236 141 25 56 XP_067795723.1 putative 26S proteasome non-ATPase regulatory subunit [Phytophthora cinnamomi] diamond 288 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
30153980 30153980 PRJNA1145997_P_NODE_22172_length_617_cov_6.452206_g19571_i0 PRJNA1145997 22172 617 6.452206 39.81011102 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 2.53e-26   NR OQS05774.1 74557 g19571 i0 43.8 3.51539708265802 112 43 54.5 3 490 155 8 99 OQS05774.1 RING-box protein 1 [Thraustotheca clavata] diamond 2169 108 0.990740740740741 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
30196782 30196782 PRJNA1145997_P_NODE_51432_length_209_cov_4.580882_g48813_i0 PRJNA1145997 51432 209 4.580882 9.57404338 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.39e-8   NR CAE8699079.1 89957 g48813 i0 78.4 0.5311004784689 37 8 53.1 0 27 137 202 238 CAE8699079.1 unnamed protein product [Polarella glacialis] diamond 111 59.7 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
30312760 30312760 PRJNA1145997_P_NODE_30172_length_381_cov_19.191558_g27554_i0 PRJNA1145997 30172 381 19.191558 73.11983598 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00428   NR CAK0898487.1 89957 g27554 i0 33.3 1.75590551181102 72 48 56.7 0 278 63 2016 2087 CAK0898487.1 unnamed protein product [Polarella glacialis] diamond 669 47.8 0.99163179916318 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
30375854 30375854 PRJNA1145997_P_NODE_25132_length_515_cov_6.436652_g22516_i0 PRJNA1145997 25132 515 6.436652 33.1487578 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 138 9.77e-36   NR POM57551.1 4796 g22516 i0 58.4 2.60970873786408 113 47 65.8 0 437 99 1 113 POM57551.1 Serine protease family S28, partial [Phytophthora palmivora] diamond 1344 138 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
30596432 30596432 PRJNA1145997_P_NODE_23433_length_573_cov_3.592000_g20825_i0 PRJNA1145997 23433 573 3.592 20.58216 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 176 9.84e-53   NR KAJ0392104.1 114742 g20825 i0 50 11.3612565445026 182 82 95.3 1 2 547 4 176 KAJ0392104.1 hypothetical protein P43SY_009801 [Pythium insidiosum] diamond 6510 176 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum

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