RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA289590" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJNA289590 · 23 ✖

analysis 1

  • blastn · 23 ✖

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
372591 372591 PRJNA289590_P_NODE_24001_length_178_cov_1.612403_g23777_i0 PRJNA289590 24001 178 1.612403 2.87007734 Fallacia monoculata 1003053 SAR_Eukaryotes SAR_Eukaryotes 296 6.3e-76   NTclustered gi|817090803|gb|KM009461.1| 1003053 g23777 i0 96.629 102.595505617978 178 6 100 0 1 178 268 445 Fallacia monoculata isolate FD254 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 18262 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Fallacia Fallacia monoculata
372783 372783 PRJNA289590_P_NODE_5541_length_417_cov_1.225543_g5317_i0 PRJNA289590 5541 417 1.225543 5.11051431 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 309 2.16e-79   NTclustered gi|657012367|gb|KF302531.1| 2850 g5317 i0 83.891 28.2685851318945 329 47 78 6 1 326 341 16 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 11788 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
372835 372835 PRJNA289590_P_NODE_7601_length_344_cov_4.576271_g7377_i0 PRJNA289590 7601 344 4.576271 15.74237224 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 239 2.33e-58   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g7377 i0 79.37 98.0755813953488 349 64 99 4 1 342 415 68 Aphanomyces astaci polyubiquitin mRNA blastn 33738 239 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
1059460 1059460 PRJNA289590_P_NODE_30021_length_164_cov_0.895652_g29797_i0 PRJNA289590 30021 164 0.895652 1.46886928 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 276 7.46e-70   NTclustered gi|375305427|gb|JF975387.1| 1143721 g29797 i0 97.516 10.7378048780488 161 4 98 0 1 161 1675 1835 Plagiopyla sp. QZ-2012 28S ribosomal RNA gene, partial sequence blastn 1761 276 1 Eukaryota Sar   Ciliophora Plagiopylea Plagiopylida Plagiopylidae Plagiopyla Plagiopyla sp. QZ-2012
1647088 1647088 PRJNA289590_P_NODE_13862_length_244_cov_1.528205_g13638_i0 PRJNA289590 13862 244 1.528205 3.7288202 Haslea provincialis 1764367 SAR_Eukaryotes SAR_Eukaryotes 374 4.1399999999999986e-99   NTclustered gi|2328347993|ref|NC_067579.1| 1764367 g13638 i0 94.309 100.094262295082 246 11 100 3 1 244 3254 3498 Haslea provincialis strain NCC 342 mitochondrion, complete genome blastn 24423 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea provincialis
2922929 2922929 PRJNA289590_P_NODE_1003_length_1461_cov_3.798867_g862_i0 PRJNA289590 1003 1461 3.798867 55.50144687 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 2241 0   NTclustered gi|53829555|gb|AY582830.1| 289359 g862 i0 99.433 89.0479123887748 1234 7 84 0 157 1390 1238 5 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds blastn 130099 2241 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
4199982 4199982 PRJNA289590_P_NODE_8164_length_330_cov_2.306050_g7940_i0 PRJNA289590 8164 330 2.30605 7.609965 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 475 1.5599999999999994e-129   NTclustered gi|1735126343|gb|MK335376.1| 88167 g7940 i0 99.615 61.6212121212121 260 1 79 0 71 330 1 260 Poterioochromonas malhamensis strain CMBB-1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial blastn 20335 475 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
4887322 4887322 PRJNA289590_P_NODE_13904_length_244_cov_1.066667_g13680_i0 PRJNA289590 13904 244 1.066667 2.60266748 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 252 2.02e-62   NTclustered gi|10792|emb|X12768.1| 5908 g13680 i0 85.246 97.2540983606557 244 36 100 0 1 244 165 408 Tetrahymena pyriformis beta-tubulin gene 1 (beta-TT1) blastn 23730 252 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
6162230 6162230 PRJNA289590_P_NODE_2725_length_668_cov_78.628433_g2517_i0 PRJNA289590 2725 668 78.628433 525.23793244 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 715 0   NTclustered gi|1409222722|gb|MH536656.1| 88167 g2517 i0 99.744 57.2125748502994 390 1 58 0 1 390 390 1 Poterioochromonas malhamensis strain SAG933-1a small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence blastn 38218 715 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
9300458 9300458 PRJNA289590_P_NODE_14808_length_235_cov_1.102151_g14584_i0 PRJNA289590 14808 235 1.102151 2.59005485 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 429 8.33e-116   NTclustered gi|2088238071|ref|NC_056910.1| 88167 g14584 i0 99.574 95.5702127659575 235 1 100 0 1 235 20344 20110 Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome blastn 22459 429 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
9987594 9987594 PRJNA289590_P_NODE_5628_length_412_cov_8.763085_g5404_i0 PRJNA289590 5628 412 8.763085 36.1039102 Colpomenia 27964 SAR_Eukaryotes SAR_Eukaryotes 222 2.85e-53   NTclustered gi|699256691|ref|NC_025302.1| 27965 g5404 i0 81.295 43.8131067961165 278 49 67 3 101 377 14867 15142 Colpomenia peregrina mitochondrion, complete genome blastn 18051 222 1 Eukaryota Sar     Phaeophyceae Ectocarpales Scytosiphonaceae Colpomenia Colpomenia peregrina
11262645 11262645 PRJNA289590_P_NODE_9289_length_306_cov_1.214008_g9065_i0 PRJNA289590 9289 306 1.214008 3.71486448 Nannochloropsis 5748 SAR_Eukaryotes SAR_Eukaryotes 224 5.709999999999999e-54   NTclustered gi|542687590|ref|NC_022257.1| 43925 g9065 i0 80.836 12.0686274509804 287 53 93 2 15 300 37468 37183 Nannochloropsis oculata strain CCMP525 mitochondrion, complete genome blastn 3693 224 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis oculata
12537930 12537930 PRJNA289590_P_NODE_23110_length_183_cov_1.216418_g22886_i0 PRJNA289590 23110 183 1.216418 2.22604494 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 316 5.009999999999999e-82   NTclustered gi|2325195844|gb|OM494341.1| 186043 g22886 i0 97.826 193.311475409836 184 2 100 2 1 183 89300 89118 Entomoneis sp. isolate C2 plastid, complete genome blastn 35376 316 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
13126349 13126349 PRJNA289590_P_NODE_2151_length_798_cov_2.961282_g1953_i0 PRJNA289590 2151 798 2.961282 23.63103036 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 859 0   NTclustered gi|937630021|gb|KP342046.1| 88167 g1953 i0 99.786 90.609022556391 468 1 59 0 331 798 608 141 Poterioochromonas malhamensis strain GC003 cytochrome oxidase subunit I gene, partial cds; mitochondrial blastn 72306 859 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
14401407 14401407 PRJNA289590_P_NODE_17872_length_212_cov_1.595092_g17648_i0 PRJNA289590 17872 212 1.595092 3.38159504 Achlya bisexualis 4766 SAR_Eukaryotes SAR_Eukaryotes 222 1.34e-53   NTclustered gi|2289|emb|X59936.1| 4766 g17648 i0 88.172 81.0754716981132 186 22 88 0 27 212 1 186 A.bisexualis gene for actin blastn 17188 222 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya bisexualis
16949695 16949695 PRJNA289590_P_NODE_12874_length_254_cov_2.643902_g12650_i0 PRJNA289590 12874 254 2.643902 6.71551108 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 355 1.57e-93   NTclustered gi|53829589|gb|AY582847.1| 289359 g12650 i0 98.99 73.9291338582677 198 2 78 0 57 254 903 706 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds blastn 18778 355 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
16949847 16949847 PRJNA289590_P_NODE_19494_length_202_cov_1.359477_g19270_i0 PRJNA289590 19494 202 1.359477 2.74614354 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 289 1.23e-73   NTclustered gi|1389430805|gb|MH341633.1| 1938391 g19270 i0 92.537 3.17326732673267 201 15 99 0 1 201 1922 2122 Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence blastn 641 289 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
16950095 16950095 PRJNA289590_P_NODE_3314_length_580_cov_854.499058_g3098_i0 PRJNA289590 3314 580 854.499058 4956.0945364 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 1072 0   NTclustered gi|2088238071|ref|NC_056910.1| 88167 g3098 i0 100 88.8310344827586 580 0 100 0 1 580 17145 17724 Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome blastn 51522 1072 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
18224107 18224107 PRJNA289590_P_NODE_18595_length_207_cov_2.867089_g18371_i0 PRJNA289590 18595 207 2.867089 5.93487423 Nitzschia ovalis 908985 SAR_Eukaryotes SAR_Eukaryotes 377 2.63e-100   NTclustered gi|2199203432|ref|NC_061046.1| 908985 g18371 i0 99.517 197.202898550725 207 1 100 0 1 207 60673 60467 Nitzschia ovalis chloroplast, complete genome blastn 40821 377 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia ovalis
18224453 18224453 PRJNA289590_P_NODE_6015_length_395_cov_5.630058_g5791_i0 PRJNA289590 6015 395 5.630058 22.2387291 Ochromonas danica 2986 SAR_Eukaryotes SAR_Eukaryotes 359 1.99e-94   NTclustered gi|11465862|ref|NC_002571.1| 2986 g5791 i0 83.163 44.0860759493671 392 66 99 0 4 395 5382 4991 Ochromonas danica mitochondrion, complete genome blastn 17414 359 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas danica
18910924 18910924 PRJNA289590_P_NODE_8955_length_312_cov_5.631179_g8731_i0 PRJNA289590 8955 312 5.631179 17.56927848 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 571 1.81e-158   NTclustered gi|1409222725|gb|MH536659.1| 88167 g8731 i0 99.679 34.7435897435897 312 1 100 0 1 312 2109 1798 Poterioochromonas malhamensis strain SAG933-1d small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence blastn 10840 571 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
20774238 20774238 PRJNA289590_P_NODE_4557_length_472_cov_1.855792_g4337_i0 PRJNA289590 4557 472 1.855792 8.75933824 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 243 2.54e-59   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g4337 i0 79.05 16.7902542372881 358 71 75 4 60 415 127 482 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 7925 243 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
24598991 24598991 PRJNA289590_P_NODE_9660_length_299_cov_1.244000_g9436_i0 PRJNA289590 9660 299 1.244 3.71956 Synura petersenii 52555 SAR_Eukaryotes SAR_Eukaryotes 209 1.56e-49   NTclustered gi|282936613|gb|GU325030.1| 52555 g9436 i0 80.714 11.7959866220736 280 44 92 7 15 288 518 793 Synura petersenii strain CNU16 cytochrome b (cob) gene, partial cds; mitochondrial blastn 3527 209 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura petersenii

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