RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA771359" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA771359 · 20 ✖

analysis 1

  • diamond · 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
2023019 2023019 PRJNA771359_S_NODE_1202_length_307_cov_1.225926_g1119_i0 PRJNA771359 1202 307 1.225926 3.76359282 root 1 Root_unresolved Root_unresolved 147 8.719999999999998e-41   NR CAJ1937478.1 2856 g1119 i0 69.3 2.96091205211726 101 31 98.7 0 3 305 231 331 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 909 147 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
8400256 8400256 PRJNA771359_S_NODE_2787_length_201_cov_2.109756_g2704_i0 PRJNA771359 2787 201 2.109756 4.24060956 Pyrocystis lunula 2972 SAR_Eukaryotes SAR_Eukaryotes 132 7.159999999999999e-38   NR AAO14681.1 2972 g2704 i0 98.5 0.985074626865672 66 1 98.5 0 3 200 79 144 AAO14681.1 cytoplasmic ribosomal protein S13 [Pyrocystis lunula] diamond 198 132 1 Eukaryota Sar     Dinophyceae Gonyaulacales Pyrocystaceae Pyrocystis Pyrocystis lunula
16049625 16049625 PRJNA771359_S_NODE_1953_length_237_cov_1.540000_g1870_i0 PRJNA771359 1953 237 1.54 3.6498 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 118 4.55e-32   NR TMW64892.1 41045 g1870 i0 77.9 36.0632911392405 77 17 97.5 0 236 6 72 148 TMW64892.1 hypothetical protein Poli38472_009059 [Pythium oligandrum] diamond 8547 119 0.991596638655462 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
16049633 16049633 PRJNA771359_S_NODE_2613_length_207_cov_1.717647_g2530_i0 PRJNA771359 2613 207 1.717647 3.55552929 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 105 2.46e-26   NR RHY63180.1 112090 g2530 i0 81.4 4.27536231884058 59 11 85.5 0 205 29 135 193 RHY63180.1 hypothetical protein DYB34_003832 [Aphanomyces astaci] diamond 885 106 0.990566037735849 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
27053363 27053363 PRJNA771359_S_NODE_1642_length_264_cov_1.894273_g1559_i0 PRJNA771359 1642 264 1.894273 5.00088072 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 64.3 3.1e-11   NR XP_012651983.1 312017 g1559 i0 50.7 0.806818181818182 71 35 80.7 0 6 218 15 85 XP_012651983.1 hypothetical protein TTHERM_000784569 [Tetrahymena thermophila SB210] diamond 213 64.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27189140 27189140 PRJNA771359_S_NODE_3782_length_173_cov_1.419118_g3699_i0 PRJNA771359 3782 173 1.419118 2.45507414 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00221   NR NP_049598.1 5908 g3699 i0 81.8 0.763005780346821 22 4 38.2 0 172 107 185 206 NP_049598.1 apocytochrome b [Tetrahymena pyriformis] diamond 132 45.4 0.993392070484582 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
27685426 27685426 PRJNA771359_S_NODE_2384_length_217_cov_1.577778_g2301_i0 PRJNA771359 2384 217 1.577778 3.42377826 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 68.6 2.59e-12   NR CAD8155930.1 43138 g2301 i0 55.4 0.898617511520737 65 28 89.9 1 215 21 16 79 CAD8155930.1 unnamed protein product [Paramecium pentaurelia] diamond 195 68.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
28158966 28158966 PRJNA771359_S_NODE_4145_length_166_cov_1.744186_g4062_i0 PRJNA771359 4145 166 1.744186 2.89534876 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 93.6 2.62e-22   NR CAG9318382.1 1481888 g4062 i0 75.9 0.975903614457831 54 13 97.6 0 162 1 52 105 CAG9318382.1 unnamed protein product [Blepharisma stoltei] diamond 162 93.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
28253381 28253381 PRJNA771359_S_NODE_5246_length_150_cov_1.371681_g5163_i0 PRJNA771359 5246 150 1.371681 2.0575215 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.63e-18   NR TYZ67485.1 1485010 g5163 i0 75 5.76 48 12 96 0 145 2 35 82 TYZ67485.1 hypothetical protein PybrP1_008862 [[Pythium] brassicae (nom. inval.)] diamond 864 82.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
28853151 28853151 PRJNA771359_S_NODE_2668_length_205_cov_1.428571_g2585_i0 PRJNA771359 2668 205 1.428571 2.92857055 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.21e-10   NR CAD8069000.1 65129 g2585 i0 61.9 2.75121951219512 63 24 92.2 0 204 16 250 312 CAD8069000.1 unnamed protein product [Paramecium sonneborni] diamond 564 65.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28979834 28979834 PRJNA771359_S_NODE_4268_length_164_cov_1.204724_g4185_i0 PRJNA771359 4268 164 1.204724 1.97574736 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00145   NR CAD8135162.1 43137 g4185 i0 38.5 0.951219512195122 52 30 95.1 1 2 157 736 785 CAD8135162.1 unnamed protein product [Paramecium octaurelia] diamond 156 45.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
29074573 29074573 PRJNA771359_S_NODE_3228_length_187_cov_1.033333_g3145_i0 PRJNA771359 3228 187 1.033333 1.93233271 Thuricola similis 2784598 SAR_Eukaryotes SAR_Eukaryotes 78.2 5.5e-15   NR YP_010147331.1 2784598 g3145 i0 83.3 0.770053475935829 48 8 77 0 3 146 335 382 YP_010147331.1 cytochrome c oxidase subunit 1 [Thuricola similis] diamond 144 78.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vaginicolidae Thuricola Thuricola similis
29178809 29178809 PRJNA771359_S_NODE_3609_length_177_cov_2.492857_g3526_i0 PRJNA771359 3609 177 2.492857 4.41235689 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.2799999999999998e-24   NR KUF91244.1 4792 g3526 i0 74.6 11 59 15 100 0 177 1 47 105 KUF91244.1 hypothetical protein AM588_10004817 [Phytophthora nicotianae] diamond 1947 97.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
29494405 29494405 PRJNA771359_S_NODE_3450_length_181_cov_1.340278_g3367_i0 PRJNA771359 3450 181 1.340278 2.42590318 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 40.8 0.0283   NR XP_012652362.1 312017 g3367 i0 56.8 1.83977900552486 37 16 61.3 0 137 27 17 53 XP_012652362.1 hypothetical protein TTHERM_000294739 [Tetrahymena thermophila SB210] diamond 333 40.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29999817 29999817 PRJNA771359_S_NODE_4271_length_164_cov_1.181102_g4188_i0 PRJNA771359 4271 164 1.181102 1.93700728 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.16e-8   NR CAD8084070.1 65129 g4188 i0 52.9 15.1646341463415 51 24 93.3 0 164 12 206 256 CAD8084070.1 unnamed protein product [Paramecium sonneborni] diamond 2487 60.1 0.993344425956739 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
30347731 30347731 PRJNA771359_S_NODE_2752_length_202_cov_2.109091_g2669_i0 PRJNA771359 2752 202 2.109091 4.26036382 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 95.9 7.409999999999999e-23   NR XP_012893812.1 12968 g2669 i0 61.2 58.6188118811881 67 26 99.5 0 201 1 41 107 XP_012893812.1 uncharacterized protein [Blastocystis hominis] diamond 11841 95.9 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis hominis
30401312 30401312 PRJNA771359_S_NODE_3453_length_181_cov_1.340278_g3370_i0 PRJNA771359 3453 181 1.340278 2.42590318 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 71.6 1.06e-12   NR CAD8044685.1 5886 g3370 i0 61.8 1.8232044198895 55 21 91.2 0 180 16 214 268 CAD8044685.1 unnamed protein product, partial [Paramecium primaurelia] diamond 330 71.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
31823158 31823158 PRJNA771359_S_NODE_3717_length_174_cov_3.051095_g3634_i0 PRJNA771359 3717 174 3.051095 5.3089053 Vitrella brassicaformis CCMP3155 1169540 SAR_Eukaryotes SAR_Eukaryotes 103 2.92e-25   NR CEM21848.1 1169540 g3634 i0 89.5 6.87931034482759 57 6 98.3 0 172 2 88 144 CEM21848.1 unnamed protein product [Vitrella brassicaformis CCMP3155] diamond 1197 103 1 Eukaryota Sar         Vitrellaceae Vitrella Vitrella brassicaformis
32465866 32465866 PRJNA771359_S_NODE_1839_length_246_cov_2.004785_g1756_i0 PRJNA771359 1839 246 2.004785 4.9317711 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 115 4.519999999999999e-31   NR KAJ8524041.1 4785 g1756 i0 69.1 24.6829268292683 81 24 98.8 1 4 246 50 129 KAJ8524041.1 hypothetical protein ON010_g17076 [Phytophthora cinnamomi] diamond 6072 115 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
32592227 32592227 PRJNA771359_S_NODE_3739_length_174_cov_1.686131_g3656_i0 PRJNA771359 3739 174 1.686131 2.93386794 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.01e-18   NR KAJ1461407.1 483370 g3656 i0 68 7.5 50 16 86.2 0 158 9 54 103 KAJ1461407.1 ribosomal protein L6, alpha-beta domain-containing protein [Pelagophyceae sp. CCMP2097] diamond 1305 85.5 0.990643274853801 Eukaryota Sar     Pelagophyceae       Pelagophyceae sp. CCMP2097

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