RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA890871" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJNA890871 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
2140113 2140113 PRJNA890871_P_NODE_51562_length_264_cov_2.356021_g51427_i0 PRJNA890871 51562 264 2.356021 6.21989544 root 1 Root_unresolved Root_unresolved 135 6.45e-39   NR KAL0582322.1 65357 g51427 i0 100 1.43181818181818 63 0 71.6 0 191 3 1 63 KAL0582322.1 hypothetical protein ABG067_007825, partial [Albugo candida] diamond 378 135 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
7242211 7242211 PRJNA890871_P_NODE_26606_length_325_cov_2.650794_g26471_i0 PRJNA890871 26606 325 2.650794 8.6150805 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 152 4.04e-44   NR KAL0582110.1 65357 g26471 i0 98.8 0.766153846153846 83 1 76.6 0 250 2 1 83 KAL0582110.1 hypothetical protein ABG067_008201, partial [Albugo candida] diamond 249 152 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
27245169 27245169 PRJNA890871_P_NODE_89323_length_234_cov_2.571429_g89188_i0 PRJNA890871 89323 234 2.571429 6.01714386 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 147 2.58e-41   NR KAL0582381.1 65357 g89188 i0 100 1 78 0 100 0 1 234 228 305 KAL0582381.1 hypothetical protein ABG067_007768 [Albugo candida] diamond 234 147 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
28137408 28137408 PRJNA890871_P_NODE_4445_length_717_cov_1.652174_g4311_i0 PRJNA890871 4445 717 1.652174 11.84608758 root 1 Root_unresolved Root_unresolved 348 3.9199999999999986e-119   NR KAL0582177.1 65357 g4311 i0 100 1.46443514644351 175 0 73.2 0 1 525 34 208 KAL0582177.1 hypothetical protein ABG067_008041 [Albugo candida] diamond 1050 348 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
28603112 28603112 PRJNA890871_P_NODE_31827_length_303_cov_4.269565_g31692_i0 PRJNA890871 31827 303 4.269565 12.93678195 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 90.1 1.54e-18   NR KAL0582382.1 65357 g31692 i0 100 0.455445544554455 46 0 45.5 0 3 140 244 289 KAL0582382.1 hypothetical protein ABG067_007769 [Albugo candida] diamond 138 90.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29297682 29297682 PRJNA890871_P_NODE_53089_length_262_cov_2.243386_g52954_i0 PRJNA890871 53089 262 2.243386 5.87767132 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 119 2.1699999999999997e-31   NR KAL0581146.1 65357 g52954 i0 75.9 0.950381679389313 83 20 95 0 14 262 1 83 KAL0581146.1 hypothetical protein ABG067_008475, partial [Albugo candida] diamond 249 119 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29455144 29455144 PRJNA890871_P_NODE_9010_length_510_cov_4.830664_g8875_i0 PRJNA890871 9010 510 4.830664 24.6363864 Cryptosporidium andersoni 117008 SAR_Eukaryotes SAR_Eukaryotes 52 3.17e-4   NR XP_067068997.1 117008 g8875 i0 31.5 1.39411764705882 130 66 70.6 4 131 490 68 184 XP_067068997.1 replication factor C subunit protein [Cryptosporidium andersoni] diamond 711 52 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium andersoni
29486858 29486858 PRJNA890871_P_NODE_17330_length_386_cov_3.431310_g17195_i0 PRJNA890871 17330 386 3.43131 13.2448566 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 137 2.51e-38   NR KAL0579524.1 65357 g17195 i0 100 0.520725388601036 67 0 52.1 0 201 1 1 67 KAL0579524.1 hypothetical protein ABG067_008634, partial [Albugo candida] diamond 201 137 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29486889 29486889 PRJNA890871_P_NODE_75290_length_245_cov_2.854651_g75155_i0 PRJNA890871 75290 245 2.854651 6.99389495 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 162 1.8e-47   NR KAL0582163.1 65357 g75155 i0 98.8 0.991836734693878 81 1 99.2 0 243 1 42 122 KAL0582163.1 hypothetical protein ABG067_008079, partial [Albugo candida] diamond 243 162 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29518573 29518573 PRJNA890871_P_NODE_36330_length_289_cov_1.824074_g36195_i0 PRJNA890871 36330 289 1.824074 5.27157386 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 181 4.599999999999999e-56   NR KAL0582143.1 65357 g36195 i0 100 0.996539792387543 96 0 99.7 0 2 289 61 156 KAL0582143.1 hypothetical protein ABG067_008114, partial [Albugo candida] diamond 288 181 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29613037 29613037 PRJNA890871_P_NODE_26650_length_325_cov_2.023810_g26515_i0 PRJNA890871 26650 325 2.02381 6.5773825 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 212 6.15e-68   NR KAL0580536.1 65357 g26515 i0 100 0.996923076923077 108 0 99.7 0 2 325 70 177 KAL0580536.1 hypothetical protein ABG067_008540, partial [Albugo candida] diamond 324 212 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29676182 29676182 PRJNA890871_P_NODE_14610_length_415_cov_2.538012_g14475_i0 PRJNA890871 14610 415 2.538012 10.5327498 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0465   NR CAG9322379.1 1481888 g14475 i0 37.5 0.636144578313253 88 44 60.7 4 25 276 275 355 CAG9322379.1 unnamed protein product [Blepharisma stoltei] diamond 264 44.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
29707676 29707676 PRJNA890871_P_NODE_71350_length_247_cov_1.741379_g71215_i0 PRJNA890871 71350 247 1.741379 4.30120613 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 150 6.18e-45   NR KAL0580885.1 65357 g71215 i0 100 0.910931174089069 75 0 91.1 0 3 227 63 137 KAL0580885.1 hypothetical protein ABG067_008511, partial [Albugo candida] diamond 225 150 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29968599 29968599 PRJNA890871_P_NODE_2591_length_995_cov_3.645336_g2470_i0 PRJNA890871 2591 995 3.645336 36.2710932 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 183 6.75e-48   NR YP_009029366.1 163516 g2470 i0 39.9 4.97788944723618 263 151 77.2 2 792 25 12 274 YP_009029366.1 preprotein-translocase subunit a [Leptocylindrus danicus] diamond 4953 183 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Leptocylindrus Leptocylindrus danicus
30181829 30181829 PRJNA890871_P_NODE_30752_length_307_cov_4.653846_g30617_i0 PRJNA890871 30752 307 4.653846 14.28730722 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 158 2.21e-48   NR KAL0568007.1 65357 g30617 i0 100 0.771986970684039 79 0 77.2 0 58 294 1 79 KAL0568007.1 hypothetical protein ABG067_009528, partial [Albugo candida] diamond 237 158 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
30813797 30813797 PRJNA890871_P_NODE_3894_length_768_cov_1.995683_g3763_i0 PRJNA890871 3894 768 1.995683 15.32684544 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 269 1.04e-83   NR KAL0582382.1 65357 g3763 i0 100 0.54296875 139 0 54.3 0 768 352 368 506 KAL0582382.1 hypothetical protein ABG067_007769 [Albugo candida] diamond 417 269 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
31509473 31509473 PRJNA890871_P_NODE_9716_length_494_cov_1.717340_g9581_i0 PRJNA890871 9716 494 1.71734 8.4836596 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 306 5.14e-103   NR KAL0582190.1 65357 g9581 i0 100 0.965587044534413 159 0 96.6 0 478 2 1 159 KAL0582190.1 hypothetical protein ABG067_008015, partial [Albugo candida] diamond 477 306 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
31825390 31825390 PRJNA890871_P_NODE_41597_length_279_cov_2.067961_g41462_i0 PRJNA890871 41597 279 2.067961 5.76961119 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 191 6.64e-59   NR KAL0582163.1 65357 g41462 i0 100 0.989247311827957 92 0 98.9 0 2 277 119 210 KAL0582163.1 hypothetical protein ABG067_008079, partial [Albugo candida] diamond 276 191 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32142028 32142028 PRJNA890871_P_NODE_8558_length_522_cov_4.042316_g8423_i0 PRJNA890871 8558 522 4.042316 21.10088952 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 208 2.8e-64   NR KAL0582190.1 65357 g8423 i0 100 0.620689655172414 108 0 62.1 0 522 199 166 273 KAL0582190.1 hypothetical protein ABG067_008015, partial [Albugo candida] diamond 324 208 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32268682 32268682 PRJNA890871_P_NODE_47838_length_269_cov_3.265306_g47703_i0 PRJNA890871 47838 269 3.265306 8.78367314 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 179 1.4399999999999996e-55   NR KAL0582321.1 65357 g47703 i0 100 0.936802973977695 84 0 93.7 0 269 18 90 173 KAL0582321.1 hypothetical protein ABG067_007824, partial [Albugo candida] diamond 252 179 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32300533 32300533 PRJNA890871_P_NODE_7159_length_566_cov_3.478702_g7024_i0 PRJNA890871 7159 566 3.478702 19.68945332 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 101 3.36e-23   NR KAL0582051.1 65357 g7024 i0 100 0.307420494699647 58 0 30.7 0 391 564 1 58 KAL0582051.1 hypothetical protein ABG067_008359, partial [Albugo candida] diamond 174 101 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32836645 32836645 PRJNA890871_P_NODE_36380_length_289_cov_1.546296_g36245_i0 PRJNA890871 36380 289 1.546296 4.46879544 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 186 3.57e-56   NR KAL0582381.1 65357 g36245 i0 100 0.996539792387543 96 0 99.7 0 288 1 122 217 KAL0582381.1 hypothetical protein ABG067_007768 [Albugo candida] diamond 288 186 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida

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