RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1113956" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA1113956 · 14 ✖

analysis 1

  • diamond · 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
24448156 24448156 PRJNA1113956_P_NODE_2600_length_1151_cov_5.995362_g2398_i0 PRJNA1113956 2600 1151 5.995362 69.00661662 Vitrella brassicaformis CCMP3155 1169540 SAR_Eukaryotes SAR_Eukaryotes 477 2.869999999999999e-165   NR CEM01843.1 1169540 g2398 i0 67 6.32841007819288 345 114 89.9 0 6 1040 1 345 CEM01843.1 unnamed protein product [Vitrella brassicaformis CCMP3155] diamond 7284 481 0.991683991683992 Eukaryota Sar         Vitrellaceae Vitrella Vitrella brassicaformis
27817386 27817386 PRJNA1113956_P_NODE_6244_length_652_cov_12.984456_g5921_i0 PRJNA1113956 6244 652 12.984456 84.65865312 Triparmaceae 722751 SAR_Eukaryotes SAR_Eukaryotes 139 3.81e-37   NR GMI47042.1 722753 g5921 i0 56.4 1.85889570552147 117 50 53.8 1 238 588 57 172 GMI47042.1 hypothetical protein TrCOL_g158 [Triparma columacea] diamond 1212 140 0.992857142857143 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma columacea
27952450 27952450 PRJNA1113956_P_NODE_9505_length_459_cov_3.098446_g9166_i0 PRJNA1113956 9505 459 3.098446 14.22186714 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.62e-17   NR CAD8055348.1 5886 g9166 i0 31.7 1.87581699346405 142 97 92.8 0 431 6 23 164 CAD8055348.1 unnamed protein product [Paramecium primaurelia] diamond 861 85.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
28331192 28331192 PRJNA1113956_P_NODE_22746_length_241_cov_0.916667_g22406_i0 PRJNA1113956 22746 241 0.916667 2.20916747 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00514   NR KUF88924.1 4792 g22406 i0 38.7 0.933609958506224 75 44 93.4 1 15 239 219 291 KUF88924.1 hypothetical protein AM588_10004006 [Phytophthora nicotianae] diamond 225 45.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
28678744 28678744 PRJNA1113956_P_NODE_4587_length_810_cov_9.009498_g4295_i0 PRJNA1113956 4587 810 9.009498 72.9769338 Paramarteilia canceri 2844372 SAR_Eukaryotes SAR_Eukaryotes 62.4 6.71e-8   NR MES1904578.1 2844372 g4295 i0 40.5 1.12592592592593 74 43 27 1 644 426 7 80 MES1904578.1 mediator of RNA polymerase II transcription subunit [Paramarteilia canceri] diamond 912 62.4 1 Eukaryota Sar   Endomyxa Ascetosporea Paramyxida Marteiliidae Paramarteilia Paramarteilia canceri
29427207 29427207 PRJNA1113956_P_NODE_5709_length_698_cov_2.550400_g5398_i0 PRJNA1113956 5709 698 2.5504 17.801792 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 122 2.16e-29   NR XP_004039384.1 5932 g5398 i0 38.8 11.1275071633238 178 95 72.2 3 619 116 138 311 XP_004039384.1 hypothetical protein IMG5_024510 [Ichthyophthirius multifiliis] diamond 7767 122 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30099407 30099407 PRJNA1113956_P_NODE_3552_length_958_cov_15.616949_g3295_i0 PRJNA1113956 3552 958 15.616949 149.61037142 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 258 2.12e-81   NR CAD8068969.1 5886 g3295 i0 50.2 1.7348643006263 277 130 86.4 4 893 66 2 271 CAD8068969.1 unnamed protein product [Paramecium primaurelia] diamond 1662 258 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
30447313 30447313 PRJNA1113956_P_NODE_9133_length_475_cov_14.552239_g8794_i0 PRJNA1113956 9133 475 14.552239 69.12313525 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00721   NR GBG31126.1 2315210 g8794 i0 31 0.631578947368421 100 62 60 3 68 352 18 115 GBG31126.1 Cystatin-A2 [Hondaea fermentalgiana] diamond 300 45.8 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
31458613 31458613 PRJNA1113956_P_NODE_6416_length_639_cov_1.526502_g6093_i0 PRJNA1113956 6416 639 1.526502 9.75434778 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.03   NR XP_001018225.2 312017 g6093 i0 29.9 0.690140845070423 147 78 58.7 6 30 404 1146 1289 XP_001018225.2 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 441 47.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31553565 31553565 PRJNA1113956_P_NODE_21416_length_245_cov_0.895349_g21076_i0 PRJNA1113956 21416 245 0.895349 2.19360505 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 83.2 2.22e-16   NR XP_001013153.2 312017 g21076 i0 72.7 2.69387755102041 55 15 67.3 0 245 81 324 378 XP_001013153.2 kinesin motor catalytic domain protein [Tetrahymena thermophila SB210] diamond 660 83.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31765773 31765773 PRJNA1113956_P_NODE_22937_length_235_cov_2.216049_g22597_i0 PRJNA1113956 22937 235 2.216049 5.20771515 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.3 2.78e-6   NR KAK1937263.1 32595 g22597 i0 48 1.94042553191489 50 25 62.6 1 153 7 64 113 KAK1937263.1 myristoyl-CoA:protein N-myristoyltransferase, N- terminal domain containing protein [Babesia divergens] diamond 456 54.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia divergens
31901280 31901280 PRJNA1113956_P_NODE_6057_length_666_cov_3.649241_g5736_i0 PRJNA1113956 6057 666 3.649241 24.30394506 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 169 5.49e-49   NR XP_001014252.1 312017 g5736 i0 45.3 0.855855855855856 190 103 85.1 1 97 663 1 190 XP_001014252.1 UMP-CMP kinase [Tetrahymena thermophila SB210] diamond 570 169 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31923920 31923920 PRJNA1113956_P_NODE_2997_length_1065_cov_6.726815_g2767_i0 PRJNA1113956 2997 1065 6.726815 71.64057975 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 303 7.48e-95   NR KAK1944753.1 4793 g2767 i0 48.9 30.7859154929577 317 154 87 1 1030 104 19 335 KAK1944753.1 Hydroxymethylglutaryl-CoA lyase [Phytophthora citrophthora] diamond 32787 304 0.996710526315789 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora
32186127 32186127 PRJNA1113956_P_NODE_13718_length_339_cov_2.981203_g13378_i0 PRJNA1113956 13718 339 2.981203 10.10627817 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 122 1.75e-31   NR MES1919395.1 126728 g13378 i0 58 0.884955752212389 100 42 88.5 0 37 336 1 100 MES1919395.1 diphthine synthase [Bonamia ostreae] diamond 300 122 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae

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