RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1095825" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 23 ✖

bioproject 1

  • PRJNA1095825 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
20601871 20601871 PRJNA1095825_P_NODE_247817_length_249_cov_0.875000_g244754_i0 PRJNA1095825 247817 249 0.875 2.17875 Chrysochromulina parva 127563 Haptophyta other_Eukaryota 149 9.99e-40   NR YP_009459216.1 127563 g244754 i0 81.7 1.97590361445783 82 15 98.8 0 2 247 690 771 YP_009459216.1 DNA-directed RNA polymerase beta chain [Chrysochromulina parva] diamond 492 149 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina parva
26592579 26592579 PRJNA1095825_P_NODE_287501_length_242_cov_0.911243_g284438_i0 PRJNA1095825 287501 242 0.911243 2.20520806 Prymnesium parvum 97485 Haptophyta other_Eukaryota 139 5.33e-36   NR KAL1528435.1 97485 g284438 i0 100 0.991735537190083 80 0 99.2 0 2 241 724 803 KAL1528435.1 hypothetical protein AB1Y20_009783 [Prymnesium parvum] diamond 240 139 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26846375 26846375 PRJNA1095825_P_NODE_226961_length_257_cov_1.619565_g223898_i0 PRJNA1095825 226961 257 1.619565 4.16228205 Prymnesium parvum 97485 Haptophyta other_Eukaryota 45.4 0.0048   NR KAL1522337.1 97485 g223898 i0 56 0.583657587548638 50 22 58.4 0 108 257 157 206 KAL1522337.1 hypothetical protein AB1Y20_017329 [Prymnesium parvum] diamond 150 45.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26909482 26909482 PRJNA1095825_P_NODE_296542_length_241_cov_0.916667_g293479_i0 PRJNA1095825 296542 241 0.916667 2.20916747 Prymnesium parvum 97485 Haptophyta other_Eukaryota 118 2.9199999999999998e-31   NR KAL1521512.1 97485 g293479 i0 87.7 0.809128630705394 65 8 80.9 0 196 2 1 65 KAL1521512.1 hypothetical protein AB1Y20_021172 [Prymnesium parvum] diamond 195 118 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27004248 27004248 PRJNA1095825_P_NODE_291702_length_242_cov_0.911243_g288639_i0 PRJNA1095825 291702 242 0.911243 2.20520806 Prymnesium parvum 97485 Haptophyta other_Eukaryota 51.2 3.74e-5   NR KAL1496651.1 97485 g288639 i0 42.6 0.84297520661157 68 31 75.6 3 2 184 556 622 KAL1496651.1 hypothetical protein AB1Y20_014252 [Prymnesium parvum] diamond 204 51.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27067544 27067544 PRJNA1095825_P_NODE_291022_length_242_cov_0.911243_g287959_i0 PRJNA1095825 291022 242 0.911243 2.20520806 Prymnesium parvum 97485 Haptophyta other_Eukaryota 57.4 2.55e-7   NR KAL1515312.1 97485 g287959 i0 36.7 3.91735537190083 79 50 97.9 0 2 238 455 533 KAL1515312.1 hypothetical protein AB1Y20_001944 [Prymnesium parvum] diamond 948 57.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27225463 27225463 PRJNA1095825_P_NODE_193503_length_281_cov_1.480769_g190440_i0 PRJNA1095825 193503 281 1.480769 4.16096089 Prymnesium parvum 97485 Haptophyta other_Eukaryota 149 2.3e-40   NR KAL1522823.1 97485 g190440 i0 100 0.693950177935943 65 0 69.4 0 197 3 367 431 KAL1522823.1 hypothetical protein AB1Y20_017792 [Prymnesium parvum] diamond 195 149 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27352337 27352337 PRJNA1095825_P_NODE_203003_length_274_cov_1.532338_g199940_i0 PRJNA1095825 203003 274 1.532338 4.19860612 Prymnesium parvum 97485 Haptophyta other_Eukaryota 100 1.39e-22   NR KAL1511440.1 97485 g199940 i0 93.5 1.35766423357664 62 3 66.8 1 220 38 1 62 KAL1511440.1 hypothetical protein AB1Y20_006239 [Prymnesium parvum] diamond 372 100 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27668025 27668025 PRJNA1095825_P_NODE_280364_length_244_cov_0.877193_g277301_i0 PRJNA1095825 280364 244 0.877193 2.14035092 Prymnesium parvum 97485 Haptophyta other_Eukaryota 127 6.21e-32   NR KAL1518448.1 97485 g277301 i0 98.4 0.762295081967213 62 1 76.2 0 242 57 937 998 KAL1518448.1 hypothetical protein AB1Y20_002740 [Prymnesium parvum] diamond 186 127 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28015331 28015331 PRJNA1095825_P_NODE_262265_length_247_cov_0.885057_g259202_i0 PRJNA1095825 262265 247 0.885057 2.18609079 Prymnesium parvum 97485 Haptophyta other_Eukaryota 100 4.029999999999999e-23   NR KAL1503506.1 97485 g259202 i0 62.7 1.0080971659919 83 30 99.6 1 2 247 125 207 KAL1503506.1 hypothetical protein AB1Y20_011987 [Prymnesium parvum] diamond 249 100 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28299290 28299290 PRJNA1095825_P_NODE_250666_length_249_cov_0.875000_g247603_i0 PRJNA1095825 250666 249 0.875 2.17875 Prymnesium parvum 97485 Haptophyta other_Eukaryota 69.7 1.24e-11   NR KAL1496544.1 97485 g247603 i0 100 0.421686746987952 35 0 42.2 0 143 247 144 178 KAL1496544.1 hypothetical protein AB1Y20_014150 [Prymnesium parvum] diamond 105 69.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28488864 28488864 PRJNA1095825_P_NODE_265027_length_246_cov_0.890173_g261964_i0 PRJNA1095825 265027 246 0.890173 2.18982558 Prymnesium parvum 97485 Haptophyta other_Eukaryota 119 6.33e-29   NR KAL1495535.1 97485 g261964 i0 81.7 1 82 15 100 0 246 1 1915 1996 KAL1495535.1 hypothetical protein AB1Y20_016899 [Prymnesium parvum] diamond 246 119 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28710000 28710000 PRJNA1095825_P_NODE_292407_length_241_cov_1.833333_g289344_i0 PRJNA1095825 292407 241 1.833333 4.41833253 Prymnesium parvum 97485 Haptophyta other_Eukaryota 161 8.36e-44   NR KAL1503087.1 97485 g289344 i0 100 0.995850622406639 80 0 99.6 0 240 1 1007 1086 KAL1503087.1 hypothetical protein AB1Y20_011151 [Prymnesium parvum] diamond 240 161 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28836051 28836051 PRJNA1095825_P_NODE_257168_length_248_cov_0.880000_g254105_i0 PRJNA1095825 257168 248 0.88 2.1824 Prymnesium parvum 97485 Haptophyta other_Eukaryota 99 3.3100000000000003e-22   NR KAL1512169.1 97485 g254105 i0 59.8 9.91935483870968 82 33 99.2 0 2 247 287 368 KAL1512169.1 hypothetical protein AB1Y20_005435 [Prymnesium parvum] diamond 2460 99 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29309671 29309671 PRJNA1095825_P_NODE_296929_length_241_cov_0.916667_g293866_i0 PRJNA1095825 296929 241 0.916667 2.20916747 Prymnesium parvum 97485 Haptophyta other_Eukaryota 154 4.35e-42   NR KAL1529012.1 97485 g293866 i0 100 0.933609958506224 75 0 93.4 0 241 17 423 497 KAL1529012.1 hypothetical protein AB1Y20_010333 [Prymnesium parvum] diamond 225 154 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29878195 29878195 PRJNA1095825_P_NODE_156571_length_311_cov_4.768908_g153508_i0 PRJNA1095825 156571 311 4.768908 14.83130388 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 85.5 5.25e-19   NR XP_005782836.1 280463 g153508 i0 51.5 0.935691318327974 97 43 92.6 2 301 14 16 109 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 291 85.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30794217 30794217 PRJNA1095825_P_NODE_222314_length_260_cov_2.245989_g219251_i0 PRJNA1095825 222314 260 2.245989 5.8395714 Prymnesium parvum 97485 Haptophyta other_Eukaryota 164 8.489999999999999e-45   NR KAL1525062.1 97485 g219251 i0 100 0.992307692307692 86 0 99.2 0 258 1 582 667 KAL1525062.1 hypothetical protein AB1Y20_019935 [Prymnesium parvum] diamond 258 164 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31015491 31015491 PRJNA1095825_P_NODE_288415_length_242_cov_0.911243_g285352_i0 PRJNA1095825 288415 242 0.911243 2.20520806 Prymnesium parvum 97485 Haptophyta other_Eukaryota 80.9 1.37e-15   NR KAL1514666.1 97485 g285352 i0 66.7 2.08264462809917 84 20 95.5 2 232 2 635 717 KAL1514666.1 hypothetical protein AB1Y20_003754 [Prymnesium parvum] diamond 504 80.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31616214 31616214 PRJNA1095825_P_NODE_280876_length_243_cov_1.747059_g277813_i0 PRJNA1095825 280876 243 1.747059 4.24535337 Prymnesium parvum 97485 Haptophyta other_Eukaryota 85.5 3.48e-17   NR KAL1524883.1 97485 g277813 i0 100 0.432098765432099 35 0 43.2 0 126 22 1864 1898 KAL1524883.1 hypothetical protein AB1Y20_019762 [Prymnesium parvum] diamond 105 85.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31932491 31932491 PRJNA1095825_P_NODE_275317_length_244_cov_1.625731_g272254_i0 PRJNA1095825 275317 244 1.625731 3.96678364 Prymnesium parvum 97485 Haptophyta other_Eukaryota 65.1 3.83e-10   NR KAL1503506.1 97485 g272254 i0 71.4 0.602459016393443 49 14 60.2 0 149 3 2 50 KAL1503506.1 hypothetical protein AB1Y20_011987 [Prymnesium parvum] diamond 147 65.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32059084 32059084 PRJNA1095825_P_NODE_257698_length_247_cov_1.770115_g254635_i0 PRJNA1095825 257698 247 1.770115 4.37218405 Prymnesium parvum 97485 Haptophyta other_Eukaryota 175 1.88e-52   NR KAL1519551.1 97485 g254635 i0 100 0.983805668016194 81 0 98.4 0 247 5 215 295 KAL1519551.1 hypothetical protein AB1Y20_023066 [Prymnesium parvum] diamond 243 175 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32059096 32059096 PRJNA1095825_P_NODE_297598_length_241_cov_0.916667_g294535_i0 PRJNA1095825 297598 241 0.916667 2.20916747 Prymnesium parvum 97485 Haptophyta other_Eukaryota 91.3 6.22e-21   NR KAL1510191.1 97485 g294535 i0 88 0.622406639004149 50 6 62.2 0 239 90 4 53 KAL1510191.1 hypothetical protein AB1Y20_006521 [Prymnesium parvum] diamond 150 91.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32502342 32502342 PRJNA1095825_P_NODE_255739_length_248_cov_0.880000_g252676_i0 PRJNA1095825 255739 248 0.88 2.1824 Prymnesium parvum 97485 Haptophyta other_Eukaryota 95.5 3.2500000000000003e-21   NR KAL1528665.1 97485 g252676 i0 100 0.701612903225806 58 0 70.2 0 246 73 293 350 KAL1528665.1 hypothetical protein AB1Y20_010002 [Prymnesium parvum] diamond 174 95.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum

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