RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1011833" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA1011833 · 20 ✖

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
1430356 1430356 PRJNA1011833_S_NODE_8002_length_401_cov_4.326816_g7585_i0 PRJNA1011833 8002 401 4.326816 17.35053216 Eimeria tenella 5802 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.003   NTclustered gi|916416283|ref|XM_013373919.1| 5802 g7585 i0 100 0.214463840399002 30 0 7 0 54 83 623 594 Eimeria tenella uncharacterized protein (ETH_00000385), partial mRNA blastn 86 56.5 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria tenella
3981823 3981823 PRJNA1011833_S_NODE_32004_length_207_cov_13.835366_g31584_i0 PRJNA1011833 32004 207 13.835366 28.63920762 Trachelocercidae sp. 3 BS-2022 2930473 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.005   NTclustered gi|2261268975|emb|OX095823.1| 2930473 g31584 i0 100 0.27536231884058 29 0 14 0 1 29 9 37 Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) blastn 57 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Trachelocercidae   Trachelocercidae sp. 3 BS-2022
7807969 7807969 PRJNA1011833_S_NODE_34127_length_200_cov_2.140127_g33707_i0 PRJNA1011833 34127 200 2.140127 4.280254 Phalacroma oxytoxoides 447216 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.017   NTclustered gi|2742502725|gb|PP905714.1| 447216 g33707 i0 100 0.28 28 0 14 0 1 28 1198 1225 Phalacroma oxytoxoides isolate PhaFC3 small subunit ribosomal RNA gene, partial sequence blastn 56 52.8 1 Eukaryota Sar     Dinophyceae Dinophysales Dinophysaceae Phalacroma Phalacroma oxytoxoides
9082822 9082822 PRJNA1011833_S_NODE_15128_length_310_cov_5.595506_g14708_i0 PRJNA1011833 15128 310 5.595506 17.3460686 Plasmodium knowlesi 5850 SAR_Eukaryotes SAR_Eukaryotes 65.8 3.72e-6   NTclustered gi|221052297|ref|XM_002257689.1| 5851 g14708 i0 93.333 5.81612903225806 45 2 14 1 264 307 1291 1247 Plasmodium knowlesi strain H conserved Plasmodium protein, unknown function (PKNH_0205400), partial mRNA blastn 1803 65.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium knowlesi
9082837 9082837 PRJNA1011833_S_NODE_18328_length_282_cov_58.857741_g17908_i0 PRJNA1011833 18328 282 58.857741 165.97882962 Phalacroma oxytoxoides 447216 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.026   NTclustered gi|2742502725|gb|PP905714.1| 447216 g17908 i0 100 0.198581560283688 28 0 10 0 1 28 1198 1225 Phalacroma oxytoxoides isolate PhaFC3 small subunit ribosomal RNA gene, partial sequence blastn 56 52.8 1 Eukaryota Sar     Dinophyceae Dinophysales Dinophysaceae Phalacroma Phalacroma oxytoxoides
11633940 11633940 PRJNA1011833_S_NODE_20410_length_267_cov_1.593750_g19990_i0 PRJNA1011833 20410 267 1.59375 4.2553125 Phalacroma oxytoxoides 447216 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.024   NTclustered gi|2742502725|gb|PP905714.1| 447216 g19990 i0 90.244 0.307116104868914 41 3 15 1 228 267 1238 1198 Phalacroma oxytoxoides isolate PhaFC3 small subunit ribosomal RNA gene, partial sequence blastn 82 52.8 1 Eukaryota Sar     Dinophyceae Dinophysales Dinophysaceae Phalacroma Phalacroma oxytoxoides
18007170 18007170 PRJNA1011833_S_NODE_35255_length_197_cov_1.246753_g34835_i0 PRJNA1011833 35255 197 1.246753 2.45610341 Plasmodium gallinaceum 5849 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.017   NTclustered gi|1620132018|ref|XM_028674360.1| 5849 g34835 i0 96.774 0.157360406091371 31 1 16 0 6 36 1061 1031 Plasmodium gallinaceum aspartate--tRNA ligase, putative (PGAL8A_00035800), partial mRNA blastn 31 52.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium gallinaceum
19280851 19280851 PRJNA1011833_S_NODE_21176_length_261_cov_3.931193_g20756_i0 PRJNA1011833 21176 261 3.931193 10.26041373 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g20756 i0 100 0.440613026819923 30 0 11 0 1 30 12 41 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 115 56.5 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
27129057 27129057 PRJNA1011833_S_NODE_7742_length_406_cov_3.644628_g7326_i0 PRJNA1011833 7742 406 3.644628 14.79718968 Triparma verrucosa 1606542 SAR_Eukaryotes SAR_Eukaryotes 73.6 3.64e-12   NR GMH90071.1 1606542 g7326 i0 41.5 1.95073891625616 82 48 60.6 0 10 255 410 491 GMH90071.1 hypothetical protein TrVE_jg3437 [Triparma verrucosa] diamond 792 73.6 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma verrucosa
27761567 27761567 PRJNA1011833_S_NODE_50704_length_162_cov_2.201681_g50284_i0 PRJNA1011833 50704 162 2.2016810000000002 3.56672322 Bremia lactucae 4779 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.54e-11   NR XP_067817784.1 4779 g50284 i0 63 2.96296296296296 54 19 98.1 1 159 1 256 309 XP_067817784.1 hypothetical protein CCR75_003227 [Bremia lactucae] diamond 480 67.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
29024613 29024613 PRJNA1011833_S_NODE_728_length_967_cov_7.514069_g543_i0 PRJNA1011833 728 967 7.514069 72.66104723 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 213 5.3e-64   NR CAD8068969.1 5886 g543 i0 54 1.88004136504654 202 87 62.7 2 2 607 76 271 CAD8068969.1 unnamed protein product [Paramecium primaurelia] diamond 1818 213 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29087523 29087523 PRJNA1011833_S_NODE_20188_length_268_cov_3.631111_g19768_i0 PRJNA1011833 20188 268 3.631111 9.73137748 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 67 2.82e-11   NR XP_001014252.1 312017 g19768 i0 35.2 4.80223880597015 88 57 98.5 0 266 3 96 183 XP_001014252.1 UMP-CMP kinase [Tetrahymena thermophila SB210] diamond 1287 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29465872 29465872 PRJNA1011833_S_NODE_30770_length_212_cov_1.704142_g30350_i0 PRJNA1011833 30770 212 1.704142 3.6127810400000002 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 62.4 2.9e-9   NR CAD8182867.1 43137 g30350 i0 49.1 0.778301886792453 55 28 77.8 0 29 193 556 610 CAD8182867.1 unnamed protein product [Paramecium octaurelia] diamond 165 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30121701 30121701 PRJNA1011833_S_NODE_15652_length_305_cov_4.270992_g15232_i0 PRJNA1011833 15652 305 4.270992 13.0265256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 72.4 2.32e-12   NR XP_001423282.1 5888 g15232 i0 39.6 1.79016393442623 91 55 89.5 0 8 280 266 356 XP_001423282.1 uncharacterized protein GSPATT00000319001 [Paramecium tetraurelia] diamond 546 72.8 0.994505494505495 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30248463 30248463 PRJNA1011833_S_NODE_3032_length_547_cov_6.744048_g2647_i0 PRJNA1011833 3032 547 6.744048 36.88994256 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 184 3.94e-53   NR GLE08162.1 114742 g2647 i0 67.4 8.47897623400366 172 55 93.8 1 542 30 205 376 GLE08162.1 hypothetical protein PINS_up019168 [Pythium insidiosum] diamond 4638 184 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
30508647 30508647 PRJNA1011833_S_NODE_38273_length_188_cov_2.103448_g37853_i0 PRJNA1011833 38273 188 2.103448 3.95448224 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 60.8 7.19e-9   NR CAI2369316.1 5936 g37853 i0 52.5 2.6968085106383 59 28 94.1 0 3 179 397 455 CAI2369316.1 unnamed protein product [Moneuplotes crassus] diamond 507 60.8 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31014130 31014130 PRJNA1011833_S_NODE_6295_length_434_cov_12.388747_g5882_i0 PRJNA1011833 6295 434 12.388747 53.76716198 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0076   NR GBG31126.1 2315210 g5882 i0 31 0.691244239631336 100 62 65.7 3 46 330 18 115 GBG31126.1 Cystatin-A2 [Hondaea fermentalgiana] diamond 300 45.4 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
31614893 31614893 PRJNA1011833_S_NODE_28696_length_221_cov_1.078652_g28276_i0 PRJNA1011833 28696 221 1.078652 2.38382092 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 52.8 2.64e-6   NR GFH46202.1 426638 g28276 i0 39.7 1.95475113122172 73 41 95 2 212 3 48 120 GFH46202.1 hypothetical protein CTEN210_02676 [Chaetoceros tenuissimus] diamond 432 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31709811 31709811 PRJNA1011833_S_NODE_17277_length_291_cov_1.947581_g16857_i0 PRJNA1011833 17277 291 1.947581 5.66746071 Tetraparma gracilis 2962635 SAR_Eukaryotes SAR_Eukaryotes 89.7 8.08e-20   NR GMI20464.1 2962635 g16857 i0 46.5 0.88659793814433 86 45 88.7 1 290 33 88 172 GMI20464.1 hypothetical protein TeGR_g14236 [Tetraparma gracilis] diamond 258 89.7 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Tetraparma Tetraparma gracilis
32493274 32493274 PRJNA1011833_S_NODE_22139_length_255_cov_1.641509_g21719_i0 PRJNA1011833 22139 255 1.641509 4.18584795 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.4 5.1e-9   NR VEU39726.1 183589 g21719 i0 42.7 9.61176470588235 75 43 88.2 0 23 247 639 713 VEU39726.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 2451 62.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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