RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA485080 · 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
2999738 2999738 PRJNA485080_P_NODE_15043_length_292_cov_1.890411_g14949_i0 PRJNA485080 15043 292 1.890411 5.52000012 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 155 5.77e-46   NR GBG25401.1 2315210 g14949 i0 81.3 0.986301369863014 96 18 98.6 0 3 290 16 111 GBG25401.1 60S ribosomal protein L12 [Hondaea fermentalgiana] diamond 288 155 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
14478023 14478023 PRJNA485080_P_NODE_9472_length_341_cov_1.466418_g9378_i0 PRJNA485080 9472 341 1.466418 5.00048538 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 184 1.4799999999999999e-53   NR GBG24259.1 2315210 g9378 i0 82 2.98240469208211 111 20 97.7 0 334 2 7 117 GBG24259.1 Adenosylhomocysteinase [Hondaea fermentalgiana] diamond 1017 184 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
20223761 20223761 PRJNA485080_P_NODE_31816_length_246_cov_1.364162_g31722_i0 PRJNA485080 31816 246 1.364162 3.35583852 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 147 9.79e-40   NR KAG5188500.1 303371 g31722 i0 92.3 1.90243902439024 78 6 95.1 0 11 244 183 260 KAG5188500.1 F-type H-ATPase beta subunit [Tribonema minus] diamond 468 147 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
20850538 20850538 PRJNA485080_P_NODE_11817_length_318_cov_1.257143_g11723_i0 PRJNA485080 11817 318 1.257143 3.99771474 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 170 4.85e-52   NR CAH0363700.1 35677 g11723 i0 80.8 4.82075471698113 104 20 98.1 0 317 6 49 152 CAH0363700.1 unnamed protein product [Pelagomonas calceolata] diamond 1533 171 0.994152046783626 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Pelagomonas Pelagomonas calceolata
26934163 26934163 PRJNA485080_P_NODE_29402_length_248_cov_0.880000_g29308_i0 PRJNA485080 29402 248 0.88 2.1824 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.9 4.57e-6   NR XP_012199487.1 695850 g29308 i0 53.3 1.76612903225806 45 21 54.4 0 88 222 398 442 XP_012199487.1 hypothetical protein SPRG_04959 [Saprolegnia parasitica CBS 223.65] diamond 438 53.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
27487102 27487102 PRJNA485080_P_NODE_22183_length_251_cov_0.865169_g22089_i0 PRJNA485080 22183 251 0.865169 2.17157419 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 104 3.0799999999999994e-24   NR GBG24767.1 2315210 g22089 i0 57.8 1.9840637450199201 83 35 99.2 0 249 1 19 101 GBG24767.1 Coronin-like protein [Hondaea fermentalgiana] diamond 498 104 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
27487107 27487107 PRJNA485080_P_NODE_7343_length_370_cov_2.380471_g7249_i0 PRJNA485080 7343 370 2.380471 8.8077427 Chattonella marina var. antiqua 859642 SAR_Eukaryotes SAR_Eukaryotes 160 2.0499999999999998e-47   NR BBJ30883.1 859642 g7249 i0 65.9 3.93243243243243 123 42 99.7 0 369 1 10 132 BBJ30883.1 ribosomal protein L18 [Chattonella marina var. antiqua] diamond 1455 160 1 Eukaryota Sar     Raphidophyceae Chattonellales Chattonellaceae Chattonella Chattonella marina
27645190 27645190 PRJNA485080_P_NODE_40364_length_242_cov_0.911243_g40270_i0 PRJNA485080 40364 242 0.911243 2.20520806 Cafeteria roenbergensis 33653 SAR_Eukaryotes SAR_Eukaryotes 88.2 3.38e-18   NR KAA0147837.1 33653 g40270 i0 51.3 0.991735537190083 80 38 99.2 1 240 1 197 275 KAA0147837.1 hypothetical protein FNF29_07051 [Cafeteria roenbergensis] diamond 240 88.2 1 Eukaryota Sar     Bigyra Bicosoecida Cafeteriaceae Cafeteria Cafeteria roenbergensis
27708549 27708549 PRJNA485080_P_NODE_10104_length_334_cov_1.770115_g10010_i0 PRJNA485080 10104 334 1.770115 5.9121841 Thraustochytrium sp. LLF1b 1112570 SAR_Eukaryotes SAR_Eukaryotes 119 5.43e-30   NR DAC74097.1 1112570 g10010 i0 66.7 0.808383233532934 90 30 80.8 0 1 270 246 335 DAC74097.1 TPA_exp: malate dehydrogenase [Thraustochytrium sp. LLF1b] diamond 270 119 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Thraustochytrium Thraustochytrium sp. LLF1b
28434361 28434361 PRJNA485080_P_NODE_5866_length_400_cov_1.412844_g5772_i0 PRJNA485080 5866 400 1.412844 5.651376 Durusdinium trenchii 1381693 SAR_Eukaryotes SAR_Eukaryotes 169 5.989999999999999e-52   NR CAK9000885.1 1381693 g5772 i0 77.5 1.5075 102 23 76.5 0 376 71 1 102 CAK9000885.1 Cytochrome c [Durusdinium trenchii] diamond 603 169 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii
28576654 28576654 PRJNA485080_P_NODE_17407_length_276_cov_2.871921_g17313_i0 PRJNA485080 17407 276 2.871921 7.92650196 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.25e-13   NR XP_009033600.1 44056 g17313 i0 62.5 1.39130434782609 64 20 69.6 1 19 210 1 60 XP_009033600.1 ribosomal protein L38 [Aureococcus anophagefferens] diamond 384 70.1 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
28623968 28623968 PRJNA485080_P_NODE_43367_length_241_cov_0.916667_g43273_i0 PRJNA485080 43367 241 0.916667 2.20916747 Saprolegnia diclina VS2 112098 SAR_Eukaryotes SAR_Eukaryotes 82 4.77e-16   NR XP_008615942.1 1156394 g43273 i0 56.8 1.00829875518672 81 33 98.3 1 240 4 267 347 XP_008615942.1 CAMK/CAMKL protein kinase [Saprolegnia diclina VS20] diamond 243 82 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
28971118 28971118 PRJNA485080_P_NODE_37488_length_244_cov_0.900585_g37394_i0 PRJNA485080 37488 244 0.900585 2.1974274 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 47 0.00114   NR OWZ14451.1 4795 g37394 i0 52.3 3.83606557377049 44 20 52.9 1 239 111 182 225 OWZ14451.1 Integrase, catalytic core protein [Phytophthora megakarya] diamond 936 47 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
29318318 29318318 PRJNA485080_P_NODE_27029_length_249_cov_0.875000_g26935_i0 PRJNA485080 27029 249 0.875 2.17875 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.28e-14   NR GBG26426.1 2315210 g26935 i0 46.4 0.831325301204819 69 37 83.1 0 41 247 339 407 GBG26426.1 Cyclin-Y-like protein 1 [Hondaea fermentalgiana] diamond 207 78.2 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
29350037 29350037 PRJNA485080_P_NODE_26429_length_249_cov_0.875000_g26335_i0 PRJNA485080 26429 249 0.875 2.17875 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 50.4 7.56e-5   NR KAG5175872.1 303371 g26335 i0 48.9 1.69879518072289 47 24 56.6 0 100 240 93 139 KAG5175872.1 phosphatidate cytidylyltransferase [Tribonema minus] diamond 423 50.4 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
30266166 30266166 PRJNA485080_P_NODE_26212_length_249_cov_0.875000_g26118_i0 PRJNA485080 26212 249 0.875 2.17875 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 111 1.71e-29   NR CAD8149291.1 43137 g26118 i0 63 0.975903614457831 81 29 97.6 1 243 1 9 88 CAD8149291.1 unnamed protein product [Paramecium octaurelia] diamond 243 111 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30644832 30644832 PRJNA485080_P_NODE_16293_length_284_cov_1.274882_g16199_i0 PRJNA485080 16293 284 1.274882 3.62066488 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 112 1.04e-29   NR GBG25037.1 2315210 g16199 i0 66.7 1.94366197183099 93 31 98.2 0 3 281 12 104 GBG25037.1 40S ribosomal protein S25 [Hondaea fermentalgiana] diamond 552 112 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
31118691 31118691 PRJNA485080_P_NODE_3455_length_500_cov_1.081967_g3361_i0 PRJNA485080 3455 500 1.081967 5.409835 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 146 9.38e-41   NR GBG30432.1 2315210 g3361 i0 50.9 0.966 161 73 94.8 2 482 9 30 187 GBG30432.1 ATP synthase subunit O, mitochondrial [Hondaea fermentalgiana] diamond 483 146 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
31466947 31466947 PRJNA485080_P_NODE_36776_length_244_cov_0.900585_g36682_i0 PRJNA485080 36776 244 0.900585 2.1974274 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0193   NR TMW56309.1 41045 g36682 i0 34.9 0.774590163934426 63 40 77.5 1 236 48 12 73 TMW56309.1 hypothetical protein Poli38472_008957 [Pythium oligandrum] diamond 189 43.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
32511133 32511133 PRJNA485080_P_NODE_40739_length_242_cov_0.911243_g40645_i0 PRJNA485080 40739 242 0.911243 2.20520806 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 80.9 7.75e-16   NR GBG26956.1 2315210 g40645 i0 51.5 0.818181818181818 66 29 78.1 1 191 3 236 301 GBG26956.1 Hypothetical Protein FCC1311_031792 [Hondaea fermentalgiana] diamond 198 80.9 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana

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