RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1073712" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 7 ✖

bioproject 1

  • PRJNA1073712 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26940747 26940747 PRJNA1073712_P_NODE_16882_length_241_cov_0.916667_g16799_i0 PRJNA1073712 16882 241 0.916667 2.20916747 Prymnesium parvum 97485 Haptophyta other_Eukaryota 57.4 3.98e-8   NR KAL1515331.1 97485 g16799 i0 49.3 1.63070539419087 69 34 84.6 1 229 26 71 139 KAL1515331.1 hypothetical protein AB1Y20_001962 [Prymnesium parvum] diamond 393 57.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27983353 27983353 PRJNA1073712_P_NODE_15785_length_243_cov_0.905882_g15702_i0 PRJNA1073712 15785 243 0.905882 2.20129326 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 85.9 3.92e-19   NR KOO22770.1 1460289 g15702 i0 68.3 0.777777777777778 63 20 77.8 0 190 2 18 80 KOO22770.1 40s ribosomal protein [Chrysochromulina tobinii] diamond 189 85.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29152002 29152002 PRJNA1073712_P_NODE_11989_length_250_cov_0.870056_g11906_i0 PRJNA1073712 11989 250 0.870056 2.17514 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 84.7 6.86e-17   NR KOO34671.1 1460289 g11906 i0 48.8 1.008 84 40 97.2 2 7 249 460 543 KOO34671.1 hypothetical protein Ctob_009279 [Chrysochromulina tobinii] diamond 252 84.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29719695 29719695 PRJNA1073712_P_NODE_15270_length_244_cov_0.900585_g15187_i0 PRJNA1073712 15270 244 0.900585 2.1974274 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 61.6 4.31e-9   NR KOO21355.1 1460289 g15187 i0 42.1 0.934426229508197 76 40 93.4 1 239 12 108 179 KOO21355.1 hypothetical protein Ctob_003146 [Chrysochromulina tobinii] diamond 228 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29846278 29846278 PRJNA1073712_P_NODE_6511_length_303_cov_1.339130_g6428_i0 PRJNA1073712 6511 303 1.33913 4.0575639 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 159 1.16e-44   NR XP_005764372.1 280463 g6428 i0 76.8 0.98019801980198 99 23 98 0 298 2 277 375 XP_005764372.1 aspartate aminotransferase [Emiliania huxleyi CCMP1516] diamond 297 159 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29909594 29909594 PRJNA1073712_P_NODE_15451_length_243_cov_1.588235_g15368_i0 PRJNA1073712 15451 243 1.588235 3.85941105 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 80.1 7.51e-17   NR KAJ1630956.1 483367 g15368 i0 48.8 1.03703703703704 84 34 95.1 3 12 242 10 91 KAJ1630956.1 hypothetical protein T492DRAFT_592457 [Pavlovales sp. CCMP2436] diamond 252 80.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
31489738 31489738 PRJNA1073712_P_NODE_13076_length_248_cov_0.880000_g12993_i0 PRJNA1073712 13076 248 0.88 2.1824 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 79.3 5.15e-15   NR XP_005765993.1 280463 g12993 i0 58.2 0.810483870967742 67 27 79.8 1 36 233 268 334 XP_005765993.1 hypothetical protein EMIHUDRAFT_103855 [Emiliania huxleyi CCMP1516] diamond 201 79.3 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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