RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA407886" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA407886 · 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
1691966 1691966 PRJNA407886_P_NODE_28142_length_437_cov_1.678571_g26449_i0 PRJNA407886 28142 437 1.678571 7.33535527 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 212 3.96e-68   NR ADK26622.1 323453 g26449 i0 74.6 6.26086956521739 130 33 89.2 0 418 29 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 2736 213 0.995305164319249 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
2967847 2967847 PRJNA407886_P_NODE_26963_length_451_cov_2.349206_g25270_i0 PRJNA407886 26963 451 2.349206 10.59491906 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 158 1.0600000000000001e-44   NR MES1907458.1 1215613 g25270 i0 66.4 1.60975609756098 113 38 75.2 0 58 396 4 116 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 726 158 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
5521283 5521283 PRJNA407886_P_NODE_46865_length_316_cov_1.251029_g45171_i0 PRJNA407886 46865 316 1.251029 3.95325164 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 152 2.6e-42   NR MES1909649.1 1215613 g45171 i0 73.8 2.93354430379747 103 27 97.8 0 310 2 167 269 MES1909649.1 Fructose-bisphosphate aldolase 6, cytosolic [Cercozoa sp. M6MM] diamond 927 152 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
16994677 16994677 PRJNA407886_P_NODE_30694_length_411_cov_2.556213_g29000_i0 PRJNA407886 30694 411 2.556213 10.50603543 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 100 1.26e-22   NR MES1911029.1 1215613 g29000 i0 45.2 0.905109489051095 124 62 87.6 2 410 51 173 294 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 372 100 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
22093466 22093466 PRJNA407886_P_NODE_23698_length_499_cov_5.483568_g22007_i0 PRJNA407886 23698 499 5.483568 27.36300432 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 239 2.19e-78   NR ADK47156.1 323453 g22007 i0 82.8 0.871743486973948 145 25 87.2 0 15 449 1 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 435 239 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
24643749 24643749 PRJNA407886_P_NODE_40720_length_343_cov_1.140741_g39026_i0 PRJNA407886 40720 343 1.140741 3.91274163 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 164 7.199999999999999e-48   NR MES1907458.1 1215613 g39026 i0 73.5 0.988338192419825 113 30 98.8 0 339 1 8 120 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 339 164 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27075505 27075505 PRJNA407886_P_NODE_61242_length_271_cov_1.409091_g59548_i0 PRJNA407886 61242 271 1.409091 3.81863661 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 89.7 2.79e-19   NR AAT09094.1 227086 g59548 i0 55.1 0.985239852398524 89 33 96.3 4 270 10 110 193 AAT09094.1 F-actin capping protein beta subunit [Bigelowiella natans] diamond 267 89.7 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
27170085 27170085 PRJNA407886_P_NODE_48562_length_309_cov_2.580508_g46868_i0 PRJNA407886 48562 309 2.580508 7.97376972 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 83.2 5.33e-18   NR MES1912234.1 1215613 g46868 i0 54.7 1.45631067961165 75 31 72.8 2 26 250 49 120 MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] diamond 450 83.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27328492 27328492 PRJNA407886_P_NODE_52483_length_296_cov_1.309417_g50789_i0 PRJNA407886 52483 296 1.309417 3.87587432 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 48.1 7.28e-4   NR MES1916707.1 1215613 g50789 i0 47.6 0.425675675675676 42 18 42.6 1 294 169 222 259 MES1916707.1 hypothetical protein [Cercozoa sp. M6MM] diamond 126 48.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28654559 28654559 PRJNA407886_P_NODE_38907_length_352_cov_2.498208_g37213_i0 PRJNA407886 38907 352 2.498208 8.79369216 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.6e-10   NR MES1908406.1 1215613 g37213 i0 35.8 0.903409090909091 106 66 89.5 2 37 351 5 109 MES1908406.1 hypothetical protein [Cercozoa sp. M6MM] diamond 318 66.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29380760 29380760 PRJNA407886_P_NODE_81929_length_241_cov_0.916667_g80235_i0 PRJNA407886 81929 241 0.916667 2.20916747 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 54.7 2.29e-6   NR MES1907262.1 1215613 g80235 i0 55.6 0.448132780082988 36 16 44.8 0 134 241 511 546 MES1907262.1 hypothetical protein [Cercozoa sp. M6MM] diamond 108 54.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29632917 29632917 PRJNA407886_P_NODE_26290_length_461_cov_0.992268_g24598_i0 PRJNA407886 26290 461 0.992268 4.57435548 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 89.7 6.23e-18   NR MES1912634.1 1215613 g24598 i0 50.5 1.2885032537961 99 45 62.5 2 293 6 39 136 MES1912634.1 hypothetical protein [Cercozoa sp. M6MM] diamond 594 89.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30580824 30580824 PRJNA407886_P_NODE_65393_length_260_cov_3.475936_g63699_i0 PRJNA407886 65393 260 3.475936 9.0374336 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 86.3 2.71e-20   NR MES1911722.1 1215613 g63699 i0 71.2 0.6 52 15 60 0 245 90 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 86.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30897186 30897186 PRJNA407886_P_NODE_78614_length_243_cov_1.811765_g76920_i0 PRJNA407886 78614 243 1.811765 4.40258895 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.68e-17   NR MES1913460.1 1215613 g76920 i0 45 0.987654320987654 80 43 98.8 1 2 241 46 124 MES1913460.1 hypothetical protein [Cercozoa sp. M6MM] diamond 240 82.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31149342 31149342 PRJNA407886_P_NODE_83935_length_225_cov_6.447368_g82241_i0 PRJNA407886 83935 225 6.447368 14.506578 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 92 8.689999999999999e-23   NR MES1911722.1 1215613 g82241 i0 76.9 0.693333333333333 52 12 69.3 0 12 167 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 92 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31276112 31276112 PRJNA407886_P_NODE_26955_length_451_cov_2.544974_g25262_i0 PRJNA407886 26955 451 2.544974 11.47783274 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 58.5 2.33e-7   NR MES1913617.1 1215613 g25262 i0 33.7 0.611973392461197 92 53 61.2 2 134 409 90 173 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 276 58.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31592668 31592668 PRJNA407886_P_NODE_18496_length_607_cov_1.915730_g16824_i0 PRJNA407886 18496 607 1.91573 11.6284811 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 171 1.75e-48   NR MES1912552.1 1215613 g16824 i0 60.3 0.983525535420099 199 78 98.4 1 599 3 143 340 MES1912552.1 hypothetical protein [Cercozoa sp. M6MM] diamond 597 171 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31877025 31877025 PRJNA407886_P_NODE_82437_length_239_cov_2.168675_g80743_i0 PRJNA407886 82437 239 2.168675 5.18313325 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 42 0.0267   NR AAT09065.1 227086 g80743 i0 72 0.313807531380753 25 7 31.4 0 2 76 104 128 AAT09065.1 dynein outer arm light chain [Bigelowiella natans] diamond 75 42 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans

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