RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA1061474 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
177967 177967 PRJNA1061474_P_NODE_18361_length_462_cov_2.107969_g18115_i0 PRJNA1061474 18361 462 2.107969 9.73881678 Achlya ambisexualis 4768 SAR_Eukaryotes SAR_Eukaryotes 252 4.12e-62   NTclustered gi|22086549|gb|AF402100.1| 4768 g18115 i0 77.155 15.047619047619 464 86 98 18 9 462 833 380 Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds blastn 6952 252 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya ambisexualis
3562345 3562345 PRJNA1061474_P_NODE_43103_length_262_cov_3.068783_g42857_i0 PRJNA1061474 43103 262 3.068783 8.04021146 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 481 2.57e-131   NTclustered gi|323690576|gb|GU935635.1| 88167 g42857 i0 100 98.763358778626 260 0 99 0 3 262 1127 868 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 25876 481 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
4004195 4004195 PRJNA1061474_P_NODE_14544_length_535_cov_6.865801_g14300_i0 PRJNA1061474 14544 535 6.865801 36.73203535 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 6.16e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g14300 i0 80.533 63.2299065420561 375 65 69 4 143 510 441 68 Aphanomyces astaci polyubiquitin mRNA blastn 33828 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
4004281 4004281 PRJNA1061474_P_NODE_16924_length_486_cov_2.576271_g16678_i0 PRJNA1061474 16924 486 2.576271 12.52067706 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 446 1.86e-120   NTclustered gi|675199806|ref|XM_008910540.1| 761204 g16678 i0 85 88.5946502057613 440 64 90 2 48 486 129 567 Phytophthora parasitica INRA-310 calmodulin mRNA blastn 43057 446 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
5281407 5281407 PRJNA1061474_P_NODE_40965_length_274_cov_1.532338_g40719_i0 PRJNA1061474 40965 274 1.532338 4.19860612 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 202 2.3599999999999996e-47   NTclustered gi|813133999|ref|XM_012342618.1| 695850 g40719 i0 83.645 22.521897810219 214 35 78 0 58 271 324 111 Saprolegnia parasitica CBS 223.65 ribonucleoprotein-associated protein mRNA blastn 6171 202 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
6555739 6555739 PRJNA1061474_P_NODE_14846_length_528_cov_5.217582_g14602_i0 PRJNA1061474 14846 528 5.217582 27.54883296 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 944 0   NTclustered gi|323690576|gb|GU935635.1| 88167 g14602 i0 99.805 78.4185606060606 514 1 97 0 15 528 1 514 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 41405 944 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
7830352 7830352 PRJNA1061474_P_NODE_14147_length_545_cov_0.788136_g13903_i0 PRJNA1061474 14147 545 0.788136 4.2953412 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 784 0   NTclustered gi|300676719|gb|GQ377693.1| 151077 g13903 i0 92.791 10.6788990825688 541 39 99 0 5 545 558 18 Chilodonella uncinata gcr5-like mRNA, partial sequence blastn 5820 784 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
9939825 9939825 PRJNA1061474_P_NODE_41848_length_269_cov_1.964286_g41602_i0 PRJNA1061474 41848 269 1.964286 5.28392934 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 337 6.069999999999998e-88   NTclustered gi|21215206|gb|AF510205.1| 5947 g41602 i0 89.513 95.9739776951673 267 27 99 1 1 267 1274 1009 Oxytricha granulifera beta-tubulin gene, complete cds blastn 25817 337 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha granulifera
12931642 12931642 PRJNA1061474_P_NODE_1931_length_1488_cov_27.875618_g1836_i0 PRJNA1061474 1931 1488 27.875618 414.78919584 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 2241 0   NTclustered gi|53829555|gb|AY582830.1| 289359 g1836 i0 99.433 87.432123655914 1234 7 83 0 78 1311 5 1238 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds blastn 130099 2241 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
14207234 14207234 PRJNA1061474_P_NODE_37592_length_293_cov_0.900000_g37346_i0 PRJNA1061474 37592 293 0.9 2.637 Opisthonecta henneguyi 6026 SAR_Eukaryotes SAR_Eukaryotes 267 8.909999999999999e-67   NTclustered gi|4063597|gb|AF056109.1| 6026 g37346 i0 85.714 74.4232081911263 252 36 86 0 42 293 1 252 Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds blastn 21806 267 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta henneguyi
14207401 14207401 PRJNA1061474_P_NODE_4252_length_1066_cov_6.942598_g4094_i0 PRJNA1061474 4252 1066 6.942598 74.00809468 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 1567 0   NTclustered gi|53829589|gb|AY582847.1| 289359 g4094 i0 99.421 75.5637898686679 863 5 81 0 1 863 41 903 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds blastn 80551 1567 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
15481232 15481232 PRJNA1061474_P_NODE_33533_length_316_cov_1.502058_g33287_i0 PRJNA1061474 33533 316 1.502058 4.74650328 Opisthonecta henneguyi 6026 SAR_Eukaryotes SAR_Eukaryotes 333 9.439999999999998e-87   NTclustered gi|21429687|gb|AY101352.1| 6026 g33287 i0 86.084 97.1867088607595 309 43 98 0 8 316 994 686 Opisthonecta henneguyi alpha-tubulin gene, partial cds blastn 30711 333 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta henneguyi
19304615 19304615 PRJNA1061474_P_NODE_50096_length_247_cov_0.885057_g49850_i0 PRJNA1061474 50096 247 0.885057 2.18609079 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 348 2.5400000000000004e-91   NTclustered gi|675209236|ref|XM_008915255.1| 761204 g49850 i0 92.245 11.4696356275304 245 19 99 0 3 247 321 565 Phytophthora parasitica INRA-310 archaeal ribosomal protein S17P mRNA blastn 2833 348 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
21855426 21855426 PRJNA1061474_P_NODE_38838_length_286_cov_1.244131_g38592_i0 PRJNA1061474 38838 286 1.244131 3.55821466 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 451 2.23e-122   NTclustered gi|110645063|gb|DQ665311.1| 151077 g38592 i0 98.438 95.8321678321678 256 4 90 0 1 256 256 1 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 27408 451 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
25237968 25237968 PRJNA1061474_P_NODE_48860_length_248_cov_0.880000_g48614_i0 PRJNA1061474 48860 248 0.88 2.1824 Albugo 65356 SAR_Eukaryotes SAR_Eukaryotes 126 1.2999999999999998e-24   NTclustered gi|325190492|emb|FR824314.1| 890382 g48614 i0 96.104 1.875 77 3 31 0 61 137 18379 18303 Albugo laibachii Nc14, genomic contig CONTIG_269_NC14_v4_35463_227 blastn 465 126 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii

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