RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1112809" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA1112809 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
221389 221389 PRJNA1112809_P_NODE_77941_length_390_cov_1.432177_g74666_i0 PRJNA1112809 77941 390 1.432177 5.5854903 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 72.4 8.67e-14   NR YP_010131744.1 376140 g74666 i0 44.2 2.84615384615385 77 43 59.2 0 5 235 10 86 YP_010131744.1 ribosomal protein S19 [Thalassiosira profunda] diamond 1110 72.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira profunda
8676521 8676521 PRJNA1112809_P_NODE_152407_length_261_cov_1.638298_g149132_i0 PRJNA1112809 152407 261 1.638298 4.27595778 Parmales sp. scaly parma 2962637 SAR_Eukaryotes SAR_Eukaryotes 95.5 1.09e-20   NR GMI50102.1 2962637 g149132 i0 75 0.735632183908046 64 14 73.6 1 3 194 379 440 GMI50102.1 hypothetical protein ScalyP_jg4347 [Parmales sp. scaly parma] diamond 192 95.5 1 Eukaryota Sar     Bolidophyceae Parmales     Parmales sp. scaly parma
27194173 27194173 PRJNA1112809_P_NODE_129642_length_285_cov_1.226415_g126367_i0 PRJNA1112809 129642 285 1.226415 3.49528275 Nannochloropsis gaditana CCMP526 1093141 SAR_Eukaryotes SAR_Eukaryotes 50.1 1.14e-4   NR XP_005856115.1 1093141 g126367 i0 58.7 0.968421052631579 46 18 48.4 1 5 142 98 142 XP_005856115.1 chaperone -domain containing protein [Nannochloropsis gaditana CCMP526] diamond 276 50.1 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
27415767 27415767 PRJNA1112809_P_NODE_128363_length_286_cov_1.981221_g125088_i0 PRJNA1112809 128363 286 1.981221 5.66629206 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 64.3 1.65e-9   NR KAK1743974.1 267567 g125088 i0 42.9 0.881118881118881 84 44 85 3 271 29 107 189 KAK1743974.1 hypothetical protein QTG54_005571 [Skeletonema marinoi] diamond 252 64.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27691233 27691233 PRJNA1112809_P_NODE_201624_length_197_cov_4.701613_g198349_i0 PRJNA1112809 201624 197 4.701613 9.26217761 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 90.5 1.22e-19   NR KAL4470278.1 5901 g198349 i0 70 2.74111675126904 60 18 91.4 0 195 16 87 146 KAL4470278.1 hypothetical protein ABPG74_011889 [Tetrahymena malaccensis] diamond 540 90.9 0.995599559955996 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28362641 28362641 PRJNA1112809_P_NODE_181146_length_245_cov_0.895349_g177871_i0 PRJNA1112809 181146 245 0.895349 2.19360505 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.97e-20   NR TNV74736.1 5974 g177871 i0 65.2 2.38775510204082 69 24 84.5 0 241 35 1623 1691 TNV74736.1 hypothetical protein FGO68_gene13770 [Halteria grandinella] diamond 585 94.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
28426020 28426020 PRJNA1112809_P_NODE_136706_length_277_cov_1.509804_g133431_i0 PRJNA1112809 136706 277 1.509804 4.18215708 Plasmodium knowlesi strain H 5851 SAR_Eukaryotes SAR_Eukaryotes 65.9 3.96e-10   NR XP_002257651.1 5851 g133431 i0 55.1 4.77617328519856 49 21 53.1 1 275 129 130 177 XP_002257651.1 serine/threonine protein phosphatase 2B catalytic subunit A, putative [Plasmodium knowlesi strain H] diamond 1323 65.9 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium knowlesi
28795778 28795778 PRJNA1112809_P_NODE_30047_length_830_cov_1.961691_g27023_i0 PRJNA1112809 30047 830 1.961691 16.2820353 root 1 Root_unresolved Root_unresolved 64.7 6.41e-9   NR GLD91986.1 114742 g27023 i0 33.1 1.22530120481928 118 79 42.7 0 395 748 16 133 GLD91986.1 hypothetical protein PINS_up000519 [Pythium insidiosum] diamond 1017 64.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28859003 28859003 PRJNA1112809_P_NODE_175888_length_247_cov_0.885057_g172613_i0 PRJNA1112809 175888 247 0.885057 2.18609079 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 58.9 7.97e-8   NR KAG3012218.1 29920 g172613 i0 84.8 3.60728744939271 33 5 40.1 0 148 246 258 290 KAG3012218.1 hypothetical protein PC119_g12930 [Phytophthora cactorum] diamond 891 58.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
29175034 29175034 PRJNA1112809_P_NODE_126129_length_289_cov_1.296296_g122854_i0 PRJNA1112809 126129 289 1.296296 3.74629544 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 105 5.81e-24   NR CAB9501297.1 568900 g122854 i0 55.8 2.95847750865052 95 32 98.6 2 1 285 538 622 CAB9501297.1 Sulfate transporter 4.1, chloroplastic [Seminavis robusta] diamond 855 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29215455 29215455 PRJNA1112809_P_NODE_128589_length_286_cov_1.446009_g125314_i0 PRJNA1112809 128589 286 1.446009 4.13558574 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 97.1 8.27e-24   NR CEP02593.1 37360 g125314 i0 57.3 4.35314685314685 82 35 86 0 246 1 11 92 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 1245 97.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29373183 29373183 PRJNA1112809_P_NODE_184109_length_244_cov_0.900585_g180834_i0 PRJNA1112809 184109 244 0.900585 2.1974274 Durusdinium trenchii 1381693 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0198   NR CAK9102919.1 1381693 g180834 i0 39.1 0.786885245901639 64 30 71.3 2 51 224 565 625 CAK9102919.1 unnamed protein product [Durusdinium trenchii] diamond 192 43.5 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii
29435990 29435990 PRJNA1112809_P_NODE_188910_length_242_cov_1.781065_g185635_i0 PRJNA1112809 188910 242 1.781065 4.3101773 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 100 2.36e-22   NR KAJ1438115.1 483371 g185635 i0 53.8 0.991735537190083 80 37 99.2 0 241 2 488 567 KAJ1438115.1 hypothetical protein B484DRAFT_428161 [Ochromonadaceae sp. CCMP2298] diamond 240 100 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29531088 29531088 PRJNA1112809_P_NODE_186650_length_243_cov_1.011765_g183375_i0 PRJNA1112809 186650 243 1.011765 2.45858895 Triparma strigata 1606541 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0368   NR GMH86879.1 1606541 g183375 i0 35.5 0.938271604938272 76 45 92.6 2 226 2 106 178 GMH86879.1 hypothetical protein TrST_g12258 [Triparma strigata] diamond 228 42.7 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma strigata
29720202 29720202 PRJNA1112809_P_NODE_172450_length_248_cov_0.880000_g169175_i0 PRJNA1112809 172450 248 0.88 2.1824 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.59e-18   NR KAL3827268.1 382380 g169175 i0 59.2 1.71774193548387 71 27 83.5 1 41 247 191 261 KAL3827268.1 hypothetical protein ACHAXA_004743 [Cyclostephanos tholiformis] diamond 426 89.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
29846809 29846809 PRJNA1112809_P_NODE_181271_length_245_cov_0.895349_g177996_i0 PRJNA1112809 181271 245 0.895349 2.19360505 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 111 1.14e-29   NR KAJ1394928.1 483371 g177996 i0 70.7 0.918367346938776 75 22 91.8 0 226 2 1 75 KAJ1394928.1 ribosomal protein L34 [Ochromonadaceae sp. CCMP2298] diamond 225 111 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29846820 29846820 PRJNA1112809_P_NODE_200211_length_226_cov_2.013072_g196936_i0 PRJNA1112809 200211 226 2.013072 4.54954272 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 111 2.14e-26   NR XP_001012955.1 312017 g196936 i0 94.4 0.716814159292035 54 3 71.7 0 226 65 299 352 XP_001012955.1 glycoside hydrolase family 35 protein [Tetrahymena thermophila SB210] diamond 162 111 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31259749 31259749 PRJNA1112809_P_NODE_36815_length_694_cov_2.111111_g33645_i0 PRJNA1112809 36815 694 2.111111 14.65111034 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.5 0.0103   NR CAH0364282.1 35677 g33645 i0 39.4 0.959654178674352 94 38 37.2 3 268 11 72 154 CAH0364282.1 unnamed protein product [Pelagomonas calceolata] diamond 666 48.5 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Pelagomonas Pelagomonas calceolata

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