RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJEB25789" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJEB25789 · 14 ✖

analysis 1

  • blastn · 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
23221 23221 PRJEB25789_S_NODE_20361_length_235_cov_2.395062_g20282_i0 PRJEB25789 20361 235 2.395062 5.6283957 Diplophrys sp. ATCC_50360 138669 SAR_Eukaryotes SAR_Eukaryotes 339 1.4399999999999995e-88   NTclustered gi|10732805|gb|AF304465.1|AF304465 138669 g20282 i0 98.438 3.58297872340426 192 3 82 0 1 192 509 318 Diplophrys sp. ATCC_50360 small subunit ribosomal RNA gene, complete sequence blastn 842 339 1 Eukaryota Sar     Bigyra Amphitremida   Diplophrys Diplophrys sp. ATCC_50360
2572969 2572969 PRJEB25789_S_NODE_12743_length_279_cov_0.883495_g12664_i0 PRJEB25789 12743 279 0.883495 2.46495105 Virgulinella fragilis 243198 SAR_Eukaryotes SAR_Eukaryotes 516 7.58e-142   NTclustered gi|387235418|gb|JN207214.1| 243198 g12664 i0 100 115 279 0 100 0 1 279 652 374 Virgulinella fragilis clone J522-61 16S ribosomal RNA gene, partial sequence; chloroplast blastn 32085 516 1 Eukaryota Sar   Foraminifera   Rotaliida   Virgulinella Virgulinella fragilis
5125523 5125523 PRJEB25789_S_NODE_14745_length_263_cov_1.215789_g14666_i0 PRJEB25789 14745 263 1.215789 3.19752507 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 244 3.69e-60   NTclustered gi|2794921736|ref|XM_067881102.1| 164328 g14666 i0 84.553 5.77186311787072 246 38 94 0 17 262 834 589 Phytophthora ramorum Succinate--CoA ligase [ADP-forming] subunit alpha (KRP23_10630), partial mRNA blastn 1518 244 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
5125531 5125531 PRJEB25789_S_NODE_15245_length_259_cov_2.064516_g15166_i0 PRJEB25789 15245 259 2.064516 5.34709644 Epistylis sp. FG-2015 1607876 SAR_Eukaryotes SAR_Eukaryotes 479 9.13e-131   NTclustered gi|759083557|gb|KM222174.1| 1607876 g15166 i0 100 67.1969111969112 259 0 100 0 1 259 576 318 Epistylis sp. FG-2015 voucher SZ2011052302 large subunit ribosomal RNA gene, partial sequence blastn 17404 479 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. FG-2015
6401355 6401355 PRJEB25789_S_NODE_19886_length_241_cov_1.488095_g19807_i0 PRJEB25789 19886 241 1.488095 3.58630895 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 189 1.58e-43   NTclustered gi|220966760|gb|FJ545743.1| 94289 g19807 i0 97.297 39.4771784232365 111 3 46 0 131 241 6001 5891 Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear blastn 9514 189 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
6401369 6401369 PRJEB25789_S_NODE_20566_length_229_cov_2.961538_g20487_i0 PRJEB25789 20566 229 2.961538 6.78192202 Lamtostyla gui 2678605 SAR_Eukaryotes SAR_Eukaryotes 143 1.18e-29   NTclustered gi|1778223994|gb|MN733822.1| 2678605 g20487 i0 91.346 30.2576419213974 104 9 45 0 1 104 4443 4340 Lamtostyla gui isolate LWY2015111409 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 6929 143 1 Eukaryota Sar   Ciliophora Spirotrichea Stichotrichida Amphisiellidae Lamtostyla Lamtostyla gui
8950111 8950111 PRJEB25789_S_NODE_13468_length_272_cov_3.095477_g13389_i0 PRJEB25789 13468 272 3.095477 8.41969744 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 99 3.16e-16   NTclustered gi|224004779|ref|XM_002296005.1| 296543 g13389 i0 79.856 0.658088235294118 139 24 63 4 65 201 249 113 Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA blastn 179 99 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
14051370 14051370 PRJEB25789_S_NODE_20212_length_239_cov_7.234940_g20133_i0 PRJEB25789 20212 239 7.23494 17.2915066 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 231 2.5699999999999997e-56   NTclustered gi|301098381|ref|XM_002898238.1| 403677 g20133 i0 86.047 85.9874476987448 215 30 90 0 20 234 79 293 Phytophthora infestans T30-4 actin-like protein (PITG_15117), mRNA blastn 20551 231 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
14051480 14051480 PRJEB25789_S_NODE_8492_length_324_cov_1.494024_g8413_i0 PRJEB25789 8492 324 1.494024 4.84063776 Diplophrys sp. ATCC_50360 138669 SAR_Eukaryotes SAR_Eukaryotes 473 5.479999999999998e-129   NTclustered gi|10732805|gb|AF304465.1|AF304465 138669 g8413 i0 93.009 22.4506172839506 329 16 100 5 1 324 1095 769 Diplophrys sp. ATCC_50360 small subunit ribosomal RNA gene, complete sequence blastn 7274 473 1 Eukaryota Sar     Bigyra Amphitremida   Diplophrys Diplophrys sp. ATCC_50360
15325501 15325501 PRJEB25789_S_NODE_7713_length_336_cov_1.600760_g7634_i0 PRJEB25789 7713 336 1.60076 5.3785536 Peridinium willei 142113 SAR_Eukaryotes SAR_Eukaryotes 198 3.85e-46   NTclustered gi|311063250|gb|GU295195.1| 142113 g7634 i0 78.593 68.2470238095238 327 50 94 13 9 323 879 561 Peridinium willei heat shock protein 90 gene, partial cds blastn 22931 198 1 Eukaryota Sar     Dinophyceae Peridiniales Peridiniaceae Peridinium Peridinium willei
17874677 17874677 PRJEB25789_S_NODE_1215_length_742_cov_1.449925_g1145_i0 PRJEB25789 1215 742 1.449925 10.7584435 Pyrocystis lunula 2972 SAR_Eukaryotes SAR_Eukaryotes 867 0   NTclustered gi|27450758|gb|AF508263.1| 2972 g1145 i0 87.736 97.832884097035 742 91 100 0 1 742 1074 333 Pyrocystis lunula actin mRNA, complete cds blastn 72592 867 1 Eukaryota Sar     Dinophyceae Gonyaulacales Pyrocystaceae Pyrocystis Pyrocystis lunula
22663704 22663704 PRJEB25789_S_NODE_7978_length_332_cov_1.428571_g7899_i0 PRJEB25789 7978 332 1.428571 4.74285572 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 608 1.479999999999999e-169   NTclustered gi|1169296927|gb|KY364697.1| 29204 g7899 i0 99.699 99.8373493975904 332 1 100 0 1 332 627 958 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 33146 614 0.990228013029316 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
24249093 24249093 PRJEB25789_S_NODE_4180_length_431_cov_2.310056_g4101_i0 PRJEB25789 4180 431 2.310056 9.95634136 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 243 2.3000000000000002e-59   NTclustered gi|401402052|ref|XM_003881109.1| 572307 g4101 i0 78.364 63.7169373549884 379 78 87 4 55 431 378 2 Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA blastn 27462 243 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
25212754 25212754 PRJEB25789_S_NODE_20760_length_218_cov_5.489655_g20681_i0 PRJEB25789 20760 218 5.489655 11.9674479 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 244 2.96e-60   NTclustered gi|164508134|emb|AM412176.1| 4785 g20681 i0 87.037 99.0871559633027 216 28 99 0 1 216 477 262 Phytophthora cinnamomi act2 gene for actin, strain Pr120 blastn 21601 244 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi

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