RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1255065" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA1255065 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
2911107 2911107 PRJNA1255065_P_NODE_51303_length_283_cov_1.089744_g49077_i0 PRJNA1255065 51303 283 1.089744 3.08397552 Ectocarpus 2879 SAR_Eukaryotes SAR_Eukaryotes 152 2.4599999999999998e-40   NR CBN78325.1 2880 g49077 i0 72.3 1.99293286219081 94 26 99.6 0 282 1 624 717 CBN78325.1 Proline--tRNA ligase [Ectocarpus siliculosus] diamond 564 152 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
27042221 27042221 PRJNA1255065_P_NODE_132802_length_165_cov_0.896552_g130574_i0 PRJNA1255065 132802 165 0.896552 1.4793108 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.73e-5   NR TMW59608.1 41045 g130574 i0 42.9 1.87272727272727 49 28 89.1 0 4 150 239 287 TMW59608.1 hypothetical protein Poli38472_004677 [Pythium oligandrum] diamond 309 49.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
28052872 28052872 PRJNA1255065_P_NODE_127105_length_166_cov_0.888889_g124877_i0 PRJNA1255065 127105 166 0.888889 1.47555574 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 79 5.24e-16   NR KAJ1415376.1 483371 g124877 i0 66.7 0.975903614457831 54 18 97.6 0 3 164 85 138 KAJ1415376.1 hypothetical protein B484DRAFT_401465 [Ochromonadaceae sp. CCMP2298] diamond 162 79 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29189771 29189771 PRJNA1255065_P_NODE_147009_length_163_cov_0.903509_g144781_i0 PRJNA1255065 147009 163 0.903509 1.47271967 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 64.7 1.37e-11   NR CDW88910.1 5949 g144781 i0 57.4 0.993865030674847 54 23 99.4 0 2 163 22 75 CDW88910.1 60s acidic ribosomal protein p1 [Stylonychia lemnae] diamond 162 64.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29365419 29365419 PRJNA1255065_P_NODE_113829_length_168_cov_0.873950_g111601_i0 PRJNA1255065 113829 168 0.87395 1.468236 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 57 1.23e-7   NR YP_008519472.1 145522 g111601 i0 50.9 3.92857142857143 55 27 98.2 0 166 2 176 230 YP_008519472.1 NADH dehydrogenase subunit 5 [Nannochloropsis oceanica] diamond 660 57.4 0.993031358885017 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis oceanica
29916045 29916045 PRJNA1255065_P_NODE_85091_length_193_cov_0.861111_g82863_i0 PRJNA1255065 85091 193 0.861111 1.66194423 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 75.1 7.06e-14   NR KAJ1441503.1 483371 g82863 i0 58.1 1.92746113989637 62 26 96.4 0 6 191 220 281 KAJ1441503.1 sulfate transporter family-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 372 75.1 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31875319 31875319 PRJNA1255065_P_NODE_54357_length_268_cov_3.086758_g52129_i0 PRJNA1255065 54357 268 3.086758 8.27251144 Plasmodium sp. DRC-Itaito 720590 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0379   NR SPJ13112.1 720590 g52129 i0 32.8 0.75 67 45 75 0 203 3 652 718 SPJ13112.1 cysteine repeat modular protein 4 [Plasmodium sp. DRC-Itaito] diamond 201 43.1 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium sp. DRC-Itaito
31893339 31893339 PRJNA1255065_P_NODE_134137_length_165_cov_0.879310_g131909_i0 PRJNA1255065 134137 165 0.87931 1.4508615 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.5 3.21e-8   NR CCI49143.1 65357 g131909 i0 45.3 5.78181818181818 53 29 96.4 0 161 3 290 342 CCI49143.1 unnamed protein product [Albugo candida] diamond 954 58.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32255560 32255560 PRJNA1255065_P_NODE_91758_length_184_cov_1.066667_g89530_i0 PRJNA1255065 91758 184 1.066667 1.96266728 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 81.3 7.33e-18   NR GBG32342.1 2315210 g89530 i0 67.2 0.994565217391304 61 20 99.5 0 184 2 29 89 GBG32342.1 Cytochrome c oxidase subunit 5B, mitochondrial [Hondaea fermentalgiana] diamond 183 81.3 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
32571787 32571787 PRJNA1255065_P_NODE_139379_length_164_cov_0.904348_g137151_i0 PRJNA1255065 139379 164 0.904348 1.48313072 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 49.3 6.21e-5   NR CAJ1440547.1 2562239 g137151 i0 52.6 1.39024390243902 38 18 69.5 0 43 156 36 73 CAJ1440547.1 unnamed protein product [Effrenium voratum] diamond 228 49.3 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
32791771 32791771 PRJNA1255065_P_NODE_127860_length_166_cov_0.863248_g125632_i0 PRJNA1255065 127860 166 0.863248 1.43299168 Durusdinium trenchii 1381693 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.58e-15   NR CAK8989958.1 1381693 g125632 i0 60.7 1.01204819277108 56 21 99.4 1 2 166 350 405 CAK8989958.1 Serine carboxypeptidase-like 33 [Durusdinium trenchii] diamond 168 79.3 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii

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