RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA484127" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA484127 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
2999285 2999285 PRJNA484127_P_NODE_27203_length_261_cov_6.771277_g27054_i0 PRJNA484127 27203 261 6.771277 17.67303297 Kryptoperidinium triquetrum 66468 SAR_Eukaryotes SAR_Eukaryotes 289 1.67e-73   NTclustered gi|157011456|gb|EF640328.1| 66468 g27054 i0 86.59 97.6551724137931 261 35 100 0 1 261 295 555 Heterocapsa triquetra strain CCMP448 actin (Act1) mRNA, partial cds blastn 25488 289 1 Eukaryota Sar     Dinophyceae Peridiniales Kryptoperidiniaceae Kryptoperidinium Kryptoperidinium triquetrum
4275378 4275378 PRJNA484127_P_NODE_16784_length_314_cov_2.879668_g16635_i0 PRJNA484127 16784 314 2.879668 9.04215752 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 486 6.7999999999999986e-133   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g16635 i0 94.207 21.9012738853503 328 4 100 7 1 314 847 1173 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 6877 486 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
10652089 10652089 PRJNA484127_P_NODE_17749_length_308_cov_1.595745_g17600_i0 PRJNA484127 17749 308 1.595745 4.9148946 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 224 5.759999999999999e-54   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g17600 i0 80.511 9.71753246753247 313 44 100 13 1 308 2860 2560 Rosculus vulgaris isolate CCA sequence blastn 2993 224 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
13202153 13202153 PRJNA484127_P_NODE_2651_length_666_cov_4.981450_g2509_i0 PRJNA484127 2651 666 4.98145 33.176457 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 1230 0   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g2509 i0 100 37.6111111111111 666 0 100 0 1 666 2111 1446 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 25049 1230 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
13202475 13202475 PRJNA484127_P_NODE_8691_length_404_cov_1.870091_g8542_i0 PRJNA484127 8691 404 1.870091 7.55516764 Aureococcus anophagefferens 44056 SAR_Eukaryotes SAR_Eukaryotes 180 1.7e-40   NTclustered gi|676397092|ref|XM_009043576.1| 44056 g8542 i0 79.842 6.27970297029703 253 45 62 6 19 268 362 113 Aureococcus anophagefferens 60S ribosomal protein mRNA blastn 2537 180 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
14477166 14477166 PRJNA484127_P_NODE_29392_length_253_cov_3.922222_g29243_i0 PRJNA484127 29392 253 3.922222 9.92322166 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 468 1.92e-127   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g29243 i0 100 19.6916996047431 253 0 100 0 1 253 1421 1169 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 4982 468 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
14477389 14477389 PRJNA484127_P_NODE_6272_length_462_cov_4.151671_g6124_i0 PRJNA484127 6272 462 4.151671 19.18072002 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 854 0   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g6124 i0 100 14.3549783549784 462 0 100 0 1 462 33 494 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 6632 854 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
17025589 17025589 PRJNA484127_P_NODE_14134_length_335_cov_1.767176_g13985_i0 PRJNA484127 14134 335 1.767176 5.9200396 Pfiesteria piscicida 71001 SAR_Eukaryotes SAR_Eukaryotes 257 6.24e-64   NTclustered gi|112253201|gb|DQ864772.1| 71001 g13985 i0 81.613 93.1402985074627 310 57 93 0 8 317 195 504 Pfiesteria piscicida clone ppi-5p-3-3 mRNA sequence blastn 31202 257 1 Eukaryota Sar     Dinophyceae Peridiniales Pfiesteriaceae Pfiesteria Pfiesteria piscicida
17025939 17025939 PRJNA484127_P_NODE_35174_length_246_cov_0.919075_g35025_i0 PRJNA484127 35174 246 0.919075 2.2609245 Lamtostyla sp. LPJ-2005 331616 SAR_Eukaryotes SAR_Eukaryotes 226 1.2399999999999997e-54   NTclustered gi|67462297|gb|DQ062090.1| 331616 g35025 i0 83.817 86.9390243902439 241 35 97 4 4 242 443 205 Lamtostyla sp. LPJ-2005 heta shock protein 70 mRNA, partial cds; macronuclear blastn 21387 226 1 Eukaryota Sar   Ciliophora Spirotrichea Stichotrichida Amphisiellidae Lamtostyla Lamtostyla sp. LPJ-2005
18299845 18299845 PRJNA484127_P_NODE_13135_length_345_cov_1.033088_g12986_i0 PRJNA484127 13135 345 1.033088 3.5641536 Eimeria maxima 5804 SAR_Eukaryotes SAR_Eukaryotes 60.2 1.95e-4   NTclustered gi|915139498|ref|XM_013481713.1| 5804 g12986 i0 100 0.0927536231884058 32 0 9 0 114 145 1456 1487 Eimeria maxima leucine rich repeat family protein, putative partial mRNA blastn 32 60.2 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria maxima
19574269 19574269 PRJNA484127_P_NODE_24256_length_274_cov_1.044776_g24107_i0 PRJNA484127 24256 274 1.044776 2.86268624 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.025   NTclustered gi|698803785|ref|XM_009836620.1| 112090 g24107 i0 96.774 0.113138686131387 31 1 11 0 242 272 963 993 Aphanomyces astaci hypothetical protein mRNA blastn 31 52.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
25323599 25323599 PRJNA484127_P_NODE_9640_length_388_cov_2.161905_g9491_i0 PRJNA484127 9640 388 2.161905 8.3881914 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 178 5.86e-40   NTclustered gi|2795037459|ref|XM_067927134.1| 4785 g9491 i0 77.931 59.4046391752577 290 60 74 4 49 336 321 34 Phytophthora cinnamomi 60S ribosomal protein L22 (IUM83_03150), partial mRNA blastn 23049 178 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);;