RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA716463 · 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
2468102 2468102 PRJNA716463_P_NODE_15242_length_312_cov_3.531381_g14825_i0 PRJNA716463 15242 312 3.531381 11.01790872 Colpodidae 5978 SAR_Eukaryotes SAR_Eukaryotes 510 4e-140   NTclustered gi|2166921685|gb|OL894853.1| 63136 g14825 i0 98.294 8.32051282051282 293 2 94 2 1 293 343 54 Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 2596 510 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
3259416 3259416 PRJNA716463_P_NODE_52423_length_289_cov_1.425926_g52006_i0 PRJNA716463 52423 289 1.425926 4.12092614 Gregarina niphandrodes 110365 SAR_Eukaryotes SAR_Eukaryotes 315 3.09e-81   NTclustered gi|749166344|ref|XM_011136499.1| 110365 g52006 i0 100 0.588235294117647 170 0 59 0 1 170 172 3 Gregarina niphandrodes amine-terminal SAM-like domain phage integrase partial mRNA blastn 170 315 1 Eukaryota Sar   Apicomplexa Conoidasida Eugregarinorida Gregarinidae Gregarina Gregarina niphandrodes
4535766 4535766 PRJNA716463_P_NODE_1224_length_812_cov_3.826793_g876_i0 PRJNA716463 1224 812 3.826793 31.07355916 Epispathidium amphoriforme 114794 SAR_Eukaryotes SAR_Eukaryotes 1166 0   NTclustered gi|6980029|gb|AF223570.1|AF223570 114794 g876 i0 92.638 78.2721674876847 815 52 100 7 1 812 2526 1717 Spathidium amphoriforme internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 63557 1166 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida Spathidiidae Epispathidium Epispathidium amphoriforme
4536878 4536878 PRJNA716463_P_NODE_77884_length_270_cov_2.329949_g77467_i0 PRJNA716463 77884 270 2.329949 6.2908623 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 100 8.71e-17   NTclustered gi|118360339|ref|XM_001013407.1| 312017 g77467 i0 86.667 1.98148148148148 90 12 33 0 4 93 304 393 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 535 100 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
7086526 7086526 PRJNA716463_P_NODE_33926_length_299_cov_4.513274_g33509_i0 PRJNA716463 33926 299 4.513274 13.49468926 Plasmodium gallinaceum 5849 SAR_Eukaryotes SAR_Eukaryotes 60.2 1.66e-4   NTclustered gi|1620112862|ref|XM_028674772.1| 5849 g33509 i0 97.222 0.120401337792642 36 0 12 1 241 276 684 650 Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00125500), partial mRNA blastn 36 60.2 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium gallinaceum
8360424 8360424 PRJNA716463_P_NODE_102707_length_249_cov_1.750000_g102290_i0 PRJNA716463 102707 249 1.75 4.3575 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 148 2.7899999999999996e-31   NTclustered gi|1585114938|gb|MG744347.1| 5909 g102290 i0 81.72 44.6746987951807 186 26 73 8 23 204 31222 31403 Tetrahymena rostrata isolate TRO1 mitochondrion blastn 11124 148 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
8360866 8360866 PRJNA716463_P_NODE_15827_length_311_cov_3.470588_g15410_i0 PRJNA716463 15827 311 3.470588 10.79352868 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 507 5.16e-139   NTclustered gi|1402550486|gb|MH488772.1| 2231170 g15410 i0 96.141 8.2443729903537 311 5 100 1 1 311 249 552 Guttulinopsis rogosa isolate T1 small subunit ribosomal RNA gene, partial sequence blastn 2564 507 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa
12186794 12186794 PRJNA716463_P_NODE_126090_length_200_cov_4.181102_g125672_i0 PRJNA716463 126090 200 4.181102 8.362204 Sandona mutans 563755 SAR_Eukaryotes SAR_Eukaryotes 248 2.06e-61   NTclustered gi|224996445|gb|FJ654277.1| 563755 g125672 i0 98.582 106.72 141 0 100 1 1 139 515 655 Cercozoa sp. ATCC50314p145at3 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 21344 248 1 Eukaryota Sar   Cercozoa   Glissomonadida Sandonidae Sandona Sandona mutans
12187220 12187220 PRJNA716463_P_NODE_4030_length_500_cov_3.903981_g3631_i0 PRJNA716463 4030 500 3.903981 19.519905 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 366 1.5399999999999996e-96   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g3631 i0 85.634 67.288 355 44 70 6 1 351 5373 5724 Cryptocaryon irritans mitochondrion, complete genome blastn 33644 366 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
12672224 12672224 PRJNA716463_P_NODE_111950_length_241_cov_1.833333_g111532_i0 PRJNA716463 111950 241 1.833333 4.41833253 Maryna 638344 SAR_Eukaryotes SAR_Eukaryotes 435 1.84e-117   NTclustered gi|332712527|gb|JF747217.1| 638345 g111532 i0 99.17 100.016597510373 241 2 100 0 1 241 710 950 Maryna umbrellata 18S ribosomal RNA gene, partial sequence; macronuclear blastn 24104 435 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Marynidae Maryna Maryna umbrellata
13462249 13462249 PRJNA716463_P_NODE_8151_length_400_cov_2.397554_g7738_i0 PRJNA716463 8151 400 2.397554 9.590216 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 368 3.35e-97   NTclustered gi|2431531581|ref|NC_070360.1| 153251 g7738 i0 85.246 81.23 366 45 91 9 16 379 6366 6008 Cryptocaryon irritans mitochondrion, complete genome blastn 32492 368 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
13946615 13946615 PRJNA716463_P_NODE_1511_length_730_cov_6.613394_g1154_i0 PRJNA716463 1511 730 6.613394 48.2777762 Colpodidae 5978 SAR_Eukaryotes SAR_Eukaryotes 1175 0   NTclustered gi|2166921685|gb|OL894853.1| 63136 g1154 i0 96.374 77.1561643835616 717 20 98 5 16 730 1021 309 Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 56324 1175 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
17286632 17286632 PRJNA716463_P_NODE_834_length_999_cov_6.876890_g515_i0 PRJNA716463 834 999 6.87689 68.7001311 Tetrahymena paravorax 5905 SAR_Eukaryotes SAR_Eukaryotes 281 1.19e-70   NTclustered gi|114329857|ref|NC_008338.1| 5905 g515 i0 76.101 5.91891891891892 636 97 63 41 48 673 3228 2638 Tetrahymena paravorax mitochondrion, complete genome blastn 5913 281 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena paravorax
17770386 17770386 PRJNA716463_P_NODE_121394_length_226_cov_2.771242_g120976_i0 PRJNA716463 121394 226 2.771242 6.26300692 root 1 Root_unresolved Root_unresolved 418 1.7199999999999998e-112   NTclustered gi|166046728|emb|CU367838.1| 100861 g120976 i0 100 99.4469026548673 226 0 100 0 1 226 767 542 Aphanomyces euteiches cDNA blastn 22475 418 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21111104 21111104 PRJNA716463_P_NODE_77697_length_270_cov_2.832487_g77280_i0 PRJNA716463 77697 270 2.832487 7.6477149 Nannochloropsis oceanica 145522 SAR_Eukaryotes SAR_Eukaryotes 494 3.4199999999999996e-135   NTclustered gi|2862228859|gb|PQ645493.1| 145522 g77280 i0 99.63 101.148148148148 270 1 100 0 1 270 4179 3910 Nannochloropsis oceanica isolate AGSB0342 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 27310 494 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis oceanica

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