RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA716463 · 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
10912150 10912150 PRJNA716463_P_NODE_51969_length_289_cov_2.199074_g51552_i0 PRJNA716463 51969 289 2.199074 6.35532386 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 116 1.53e-29   NR XP_001450897.1 5888 g51552 i0 53.1 2.94809688581315 96 45 99.7 0 288 1 100 195 XP_001450897.1 uncharacterized protein GSPATT00017829001 [Paramecium tetraurelia] diamond 852 117 0.991452991452991 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
24933676 24933676 PRJNA716463_P_NODE_102200_length_249_cov_3.073864_g101783_i0 PRJNA716463 102200 249 3.073864 7.65392136 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 135 5.22e-38   NR XP_004034912.1 5932 g101783 i0 73.2 3.92771084337349 82 22 98.8 0 246 1 28 109 XP_004034912.1 hypothetical protein IMG5_109970 [Ichthyophthirius multifiliis] diamond 978 135 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26703617 26703617 PRJNA716463_P_NODE_65121_length_280_cov_1.487923_g64704_i0 PRJNA716463 65121 280 1.487923 4.1661844 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 114 2.3400000000000003e-27   NR XP_001428259.1 5888 g64704 i0 69.8 0.921428571428571 86 26 92.1 0 21 278 485 570 XP_001428259.1 uncharacterized protein GSPATT00031090001 [Paramecium tetraurelia] diamond 258 114 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27115042 27115042 PRJNA716463_P_NODE_68482_length_277_cov_2.916667_g68065_i0 PRJNA716463 68482 277 2.916667 8.07916759 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 79.3 3.61e-15   NR XP_004030170.1 5932 g68065 i0 59.4 0.747292418772563 69 25 74.7 2 214 8 1 66 XP_004030170.1 hypothetical protein IMG5_166540 [Ichthyophthirius multifiliis] diamond 207 79.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27652420 27652420 PRJNA716463_P_NODE_16784_length_310_cov_5.793249_g16367_i0 PRJNA716463 16784 310 5.793249 17.9590719 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 60.1 6.5e-8   NR XP_001450650.1 5888 g16367 i0 71.7 1.78064516129032 46 13 44.5 0 298 161 444 489 XP_001450650.1 uncharacterized protein GSPATT00017597001 [Paramecium tetraurelia] diamond 552 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
28010309 28010309 PRJNA716463_P_NODE_53825_length_288_cov_1.823256_g53408_i0 PRJNA716463 53825 288 1.823256 5.25097728 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 101 1.2800000000000001e-22   NR KRX07259.1 266149 g53408 i0 52.1 1.95833333333333 94 45 97.9 0 287 6 654 747 KRX07259.1 hypothetical protein PPERSA_00416 [Pseudocohnilembus persalinus] diamond 564 102 0.990196078431373 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28315410 28315410 PRJNA716463_P_NODE_68626_length_277_cov_2.617647_g68209_i0 PRJNA716463 68626 277 2.617647 7.25088219 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 53.1 1.18e-5   NR CAI2369314.1 5936 g68209 i0 33 2.04693140794224 97 58 97.5 3 7 276 32 128 CAI2369314.1 unnamed protein product [Moneuplotes crassus] diamond 567 53.1 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
28725793 28725793 PRJNA716463_P_NODE_83067_length_266_cov_2.113990_g82650_i0 PRJNA716463 83067 266 2.11399 5.6232134 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.43e-15   NR KRX03681.1 266149 g82650 i0 67.3 1.29699248120301 55 18 62 0 3 167 135 189 KRX03681.1 hypothetical protein PPERSA_10365 [Pseudocohnilembus persalinus] diamond 345 78.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29073302 29073302 PRJNA716463_P_NODE_76468_length_271_cov_2.636364_g76051_i0 PRJNA716463 76468 271 2.636364 7.14454644 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 48.5 4.76e-4   NR XP_001010207.2 312017 g76051 i0 34.5 0.929889298892989 84 50 88.6 2 1 240 120 202 XP_001010207.2 eukaryotic aspartyl protease [Tetrahymena thermophila SB210] diamond 252 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30093930 30093930 PRJNA716463_P_NODE_106072_length_246_cov_2.208092_g105654_i0 PRJNA716463 106072 246 2.208092 5.43190632 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 82.4 4.22e-16   NR XP_001431029.1 5888 g105654 i0 52.6 2.85365853658537 78 35 95.1 1 244 11 1888 1963 XP_001431029.1 uncharacterized protein GSPATT00033484001 [Paramecium tetraurelia] diamond 702 82.8 0.995169082125604 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30115117 30115117 PRJNA716463_P_NODE_49052_length_291_cov_2.559633_g48635_i0 PRJNA716463 49052 291 2.559633 7.44853203 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 68.9 4.09e-11   NR KAL4479034.1 5901 g48635 i0 64 3.08247422680412 50 18 51.5 0 290 141 915 964 KAL4479034.1 hypothetical protein ABPG73_022152 [Tetrahymena malaccensis] diamond 897 68.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
31600804 31600804 PRJNA716463_P_NODE_92756_length_258_cov_1.664865_g92339_i0 PRJNA716463 92756 258 1.664865 4.2953517 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.95e-20   NR CAD8165381.1 43137 g92339 i0 63.6 0.767441860465116 66 24 76.7 0 256 59 94 159 CAD8165381.1 unnamed protein product [Paramecium octaurelia] diamond 198 89.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31726993 31726993 PRJNA716463_P_NODE_101757_length_250_cov_0.870056_g101340_i0 PRJNA716463 101757 250 0.870056 2.17514 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 70.5 3.66e-12   NR KAL4469075.1 2486642 g101340 i0 37.2 2.064 86 51 99.6 1 250 2 95 180 KAL4469075.1 hypothetical protein ABPG72_007754 [Tetrahymena utriculariae] diamond 516 70.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
32360200 32360200 PRJNA716463_P_NODE_64739_length_280_cov_2.333333_g64322_i0 PRJNA716463 64739 280 2.333333 6.5333324 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 86.7 2.93e-19   NR CAD8050189.1 65129 g64322 i0 77.6 1.08214285714286 49 11 52.5 0 279 133 97 145 CAD8050189.1 unnamed protein product [Paramecium sonneborni] diamond 303 86.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni

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