RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJDB4470 · 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
16586258 16586258 PRJDB4470_P_NODE_29574_length_424_cov_1.333333_g28433_i0 PRJDB4470 29574 424 1.333333 5.65333192 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 103 8.27e-24   NR KAJ8578052.1 4785 g28433 i0 52 0.870283018867924 123 39 87 3 422 54 159 261 KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] diamond 369 103 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
26614844 26614844 PRJDB4470_P_NODE_54581_length_270_cov_1.687783_g53426_i0 PRJDB4470 54581 270 1.687783 4.5570141 root 1 Root_unresolved Root_unresolved 70.5 3.79e-13   NR KAI2489480.1 210448 g53426 i0 46.6 1.58888888888889 73 39 81.1 0 255 37 7 79 KAI2489480.1 hypothetical protein MHU86_25120 [Fragilaria crotonensis] diamond 429 70.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26652350 26652350 PRJDB4470_P_NODE_91621_length_180_cov_2.717557_g90466_i0 PRJDB4470 91621 180 2.717557 4.8916026 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 98.2 5.87e-24   NR XP_002177601.1 556484 g90466 i0 75.9 0.9 54 13 90 0 18 179 98 151 XP_002177601.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 162 98.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27348758 27348758 PRJDB4470_P_NODE_55023_length_268_cov_1.922374_g53868_i0 PRJDB4470 55023 268 1.922374 5.15196232 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 89.7 6.16e-19   NR CAD8092539.1 65129 g53868 i0 58.6 0.783582089552239 70 29 78.4 0 3 212 257 326 CAD8092539.1 unnamed protein product [Paramecium sonneborni] diamond 210 89.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28637427 28637427 PRJDB4470_P_NODE_53147_length_276_cov_1.145374_g51992_i0 PRJDB4470 53147 276 1.145374 3.16123224 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.021   NR CAD8148685.1 43138 g51992 i0 38.4 1.58695652173913 73 39 79.3 1 275 57 363 429 CAD8148685.1 unnamed protein product [Paramecium pentaurelia] diamond 438 43.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
29211621 29211621 PRJDB4470_P_NODE_34129_length_385_cov_1.505952_g32980_i0 PRJDB4470 34129 385 1.505952 5.7979152 Cafeteria roenbergensis 33653 SAR_Eukaryotes SAR_Eukaryotes 49.3 9.74e-4   NR KAA0147115.1 33653 g32980 i0 51.9 1.04415584415584 52 23 39.7 2 178 26 2435 2485 KAA0147115.1 hypothetical protein FNF29_07605 [Cafeteria roenbergensis] diamond 402 49.3 1 Eukaryota Sar     Bigyra Bicosoecida Cafeteriaceae Cafeteria Cafeteria roenbergensis
29463634 29463634 PRJDB4470_P_NODE_48650_length_296_cov_1.639676_g47497_i0 PRJDB4470 48650 296 1.639676 4.85344096 Gregarina niphandrodes 110365 SAR_Eukaryotes SAR_Eukaryotes 71.2 2.79e-13   NR XP_011134169.1 110365 g47497 i0 39.4 0.952702702702703 94 54 95.3 2 2 283 11 101 XP_011134169.1 hypothetical protein GNI_146750 [Gregarina niphandrodes] diamond 282 71.2 1 Eukaryota Sar   Apicomplexa Conoidasida Eugregarinorida Gregarinidae Gregarina Gregarina niphandrodes
29463644 29463644 PRJDB4470_P_NODE_81470_length_196_cov_1.768707_g80315_i0 PRJDB4470 81470 196 1.768707 3.46666572 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.17e-7   NR KAI2489481.1 210448 g80315 i0 44.4 0.964285714285714 63 27 96.4 2 7 195 214 268 KAI2489481.1 hypothetical protein MHU86_25121 [Fragilaria crotonensis] diamond 189 57.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29937809 29937809 PRJDB4470_P_NODE_81031_length_197_cov_1.405405_g79876_i0 PRJDB4470 81031 197 1.405405 2.76864785 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00117   NR XP_001446247.1 5888 g79876 i0 48.8 0.654822335025381 43 22 65.5 0 32 160 194 236 XP_001446247.1 uncharacterized protein GSPATT00001891001 [Paramecium tetraurelia] diamond 129 46.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30317366 30317366 PRJDB4470_P_NODE_44272_length_319_cov_1.618519_g43119_i0 PRJDB4470 44272 319 1.618519 5.16307561 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 57 8.78e-7   NR KAL3921821.1 3061772 g43119 i0 35 1.12852664576802 120 60 95.9 4 317 12 422 541 KAL3921821.1 MAG: hypothetical protein SGILL_002544, partial [Bacillariaceae sp.] diamond 360 57 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30848048 30848048 PRJDB4470_P_NODE_66714_length_229_cov_1.727778_g65559_i0 PRJDB4470 66714 229 1.727778 3.95661162 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 102 4.029999999999999e-23   NR CAE7471103.1 2951 g65559 i0 71.4 2.44978165938865 63 18 82.5 0 227 39 622 684 CAE7471103.1 FAB1B, partial [Symbiodinium microadriaticum] diamond 561 102 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
31391408 31391408 PRJDB4470_P_NODE_114576_length_164_cov_0.904348_g113421_i0 PRJDB4470 114576 164 0.904348 1.48313072 Ectocarpus sp. CCAP 131 74372 SAR_Eukaryotes SAR_Eukaryotes 55.1 5.69e-7   NR CAB1103919.1 867726 g113421 i0 51.9 5.34146341463415 52 22 89.6 1 10 156 1378 1429 CAB1103919.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 876 55.1 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34
31675833 31675833 PRJDB4470_P_NODE_82237_length_195_cov_1.219178_g81082_i0 PRJDB4470 82237 195 1.219178 2.3773971 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0491   NR KAL3927776.1 3061772 g81082 i0 38.6 0.876923076923077 57 23 83.1 2 14 175 223 270 KAL3927776.1 MAG: hypothetical protein SGBAC_012937 [Bacillariaceae sp.] diamond 171 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32087236 32087236 PRJDB4470_P_NODE_62638_length_241_cov_2.046875_g61483_i0 PRJDB4470 62638 241 2.046875 4.93296875 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.53e-11   NR TNV71297.1 5974 g61483 i0 71.4 0.522821576763486 42 12 52.3 0 25 150 144 185 TNV71297.1 hypothetical protein FGO68_gene13476 [Halteria grandinella] diamond 126 67.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
32176439 32176439 PRJDB4470_P_NODE_34958_length_378_cov_4.714286_g33806_i0 PRJDB4470 34958 378 4.714286 17.82000108 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.3 5.22e-14   NR OQR92236.1 1202772 g33806 i0 64.3 6.11904761904762 56 20 44.4 0 86 253 171 226 OQR92236.1 pre-mRNA-splicing factor syf2 [Achlya hypogyna] diamond 2313 77 0.990909090909091 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
32340554 32340554 PRJDB4470_P_NODE_114219_length_164_cov_1.330435_g113064_i0 PRJDB4470 114219 164 1.330435 2.1819134 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 85.5 2.5e-19   NR KAJ1429398.1 483371 g113064 i0 78.3 0.841463414634146 46 10 84.1 0 164 27 116 161 KAJ1429398.1 Alpha/Beta hydrolase protein [Ochromonadaceae sp. CCMP2298] diamond 138 85.5 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32719280 32719280 PRJDB4470_P_NODE_124540_length_162_cov_0.893805_g123385_i0 PRJDB4470 124540 162 0.893805 1.4479641 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.05e-7   NR CAG9335420.1 1481888 g123385 i0 45.1 1.90740740740741 51 28 94.4 0 158 6 26 76 CAG9335420.1 unnamed protein product [Blepharisma stoltei] diamond 309 55.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32719284 32719284 PRJDB4470_P_NODE_22720_length_499_cov_1.386667_g21599_i0 PRJDB4470 22720 499 1.386667 6.91946833 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.18e-4   NR XP_002179091.1 556484 g21599 i0 28.7 1.68937875751503 188 108 99.8 7 2 499 170 353 XP_002179091.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 843 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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