RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA763243", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 9 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 9 ✖

bioproject 1

  • PRJNA763243 · 9 ✖

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
743530 743530 PRJNA763243_P_NODE_50401_length_253_cov_6.438889_g50055_i0 PRJNA763243 50401 253 6.438889 16.29038917 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 189 1.6799999999999996e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g50055 i0 94.355 51.0948616600791 124 6 49 1 120 243 2099 1977 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 12927 189 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
12222730 12222730 PRJNA763243_P_NODE_31210_length_304_cov_5.484848_g30864_i0 PRJNA763243 31210 304 5.484848 16.67393792 Meringosphaera mediterranea 2837474 Root_unresolved Root_unresolved 102 2.77e-17   NTclustered gi|2526806211|gb|OR195157.1| 2837474 g30864 i0 83.051 24.9473684210526 118 15 38 5 185 301 2939 2826 Meringosphaera mediterranea isolate S7 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 7584 102 1 Eukaryota Haptista     Centroplasthelida     Meringosphaera Meringosphaera mediterranea
28253255 28253255 PRJNA763243_P_NODE_51746_length_251_cov_1.275281_g51400_i0 PRJNA763243 51746 251 1.275281 3.20095531 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 50.4 7.55e-5   NR KAG8465884.1 2081491 g51400 i0 45 0.717131474103586 60 31 69.3 1 181 8 71 130 KAG8465884.1 hypothetical protein KFE25_005454 [Diacronema lutheri] diamond 180 50.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28262810 28262810 PRJNA763243_P_NODE_38686_length_280_cov_2.231884_g38340_i0 PRJNA763243 38686 280 2.231884 6.2492752 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 109 2.39e-25   NR XP_005792020.1 280463 g38340 i0 53.3 1.97142857142857 92 43 98.6 0 5 280 1158 1249 XP_005792020.1 hypothetical protein EMIHUDRAFT_462184 [Emiliania huxleyi CCMP1516] diamond 552 110 0.990909090909091 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28348011 28348011 PRJNA763243_P_NODE_19226_length_359_cov_5.426573_g18881_i0 PRJNA763243 19226 359 5.426573 19.48139707 Prymnesium parvum 97485 Haptophyta other_Eukaryota 155 4.499999999999999e-41   NR KAL1503067.1 97485 g18881 i0 63.6 0.986072423398329 118 41 98.6 1 356 3 2125 2240 KAL1503067.1 hypothetical protein AB1Y20_011133 [Prymnesium parvum] diamond 354 155 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28799502 28799502 PRJNA763243_P_NODE_36187_length_287_cov_1.425234_g35841_i0 PRJNA763243 36187 287 1.425234 4.09042158 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 92.4 4.08e-20   NR KAL1511027.1 97485 g35841 i0 56 3.55400696864112 84 32 87.8 1 252 1 13 91 KAL1511027.1 hypothetical protein AB1Y20_005852 [Prymnesium parvum] diamond 1020 92.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30274615 30274615 PRJNA763243_P_NODE_71932_length_211_cov_6.471014_g71586_i0 PRJNA763243 71932 211 6.471014 13.65383954 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 76.6 2.71e-14   NR KAJ1640261.1 483367 g71586 i0 52.2 0.981042654028436 69 33 98.1 0 3 209 708 776 KAJ1640261.1 RNA polymerase II core subunit [Pavlovales sp. CCMP2436] diamond 207 76.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
31348854 31348854 PRJNA763243_P_NODE_33496_length_295_cov_2.292793_g33150_i0 PRJNA763243 33496 295 2.292793 6.76373935 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 46.6 0.00206   NR KOO23960.1 1460289 g33150 i0 32.3 1.00677966101695 99 54 87.5 3 4 261 105 203 KOO23960.1 hypothetical protein Ctob_011878 [Chrysochromulina tobinii] diamond 297 46.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31516747 31516747 PRJNA763243_P_NODE_59836_length_244_cov_0.900585_g59490_i0 PRJNA763243 59836 244 0.900585 2.1974274 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99.8 5.92e-25   NR KAL1506995.1 97485 g59490 i0 70.3 1.79508196721311 74 22 91 0 22 243 8 81 KAL1506995.1 hypothetical protein AB1Y20_007858 [Prymnesium parvum] diamond 438 100 0.998 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);;