RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1196384" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 6 ✖

bioproject 1

  • PRJNA1196384 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
1043175 1043175 PRJNA1196384_S_NODE_5881_length_171_cov_1.432836_g5817_i0 PRJNA1196384 5881 171 1.432836 2.45014956 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 119 3.6499999999999997e-32   NR KAG8463376.1 2081491 g5817 i0 84.2 2 57 9 100 0 1 171 113 169 KAG8463376.1 hypothetical protein KFE25_004887 [Diacronema lutheri] diamond 342 119 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
5425874 5425874 PRJNA1196384_S_NODE_4165_length_195_cov_1.474684_g4101_i0 PRJNA1196384 4165 195 1.474684 2.8756338 Prymnesium parvum 97485 Haptophyta other_Eukaryota 108 1.8000000000000002e-28   NR KAL1515397.1 97485 g4101 i0 76.2 2.93846153846154 63 15 96.9 0 193 5 22 84 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 573 108 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
16899814 16899814 PRJNA1196384_S_NODE_4954_length_182_cov_2.979310_g4890_i0 PRJNA1196384 4954 182 2.97931 5.4223442 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 111 8.4e-28   NR KAL1524389.1 97485 g4890 i0 83.3 7.91208791208791 60 10 98.9 0 3 182 182 241 KAL1524389.1 hypothetical protein AB1Y20_019284 [Prymnesium parvum] diamond 1440 111 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26629276 26629276 PRJNA1196384_S_NODE_1541_length_314_cov_2.689531_g1477_i0 PRJNA1196384 1541 314 2.689531 8.44512734 Prymnesium parvum 97485 Haptophyta other_Eukaryota 95.5 1.71e-20   NR KAL1524241.1 97485 g1477 i0 50 0.974522292993631 102 51 97.5 0 7 312 265 366 KAL1524241.1 hypothetical protein AB1Y20_019146 [Prymnesium parvum] diamond 306 95.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27786563 27786563 PRJNA1196384_S_NODE_7544_length_156_cov_1.630252_g7480_i0 PRJNA1196384 7544 156 1.630252 2.54319312 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99 9.75e-23   NR KAL1528873.1 97485 g7480 i0 90.2 40.2115384615385 51 5 98.1 0 154 2 324 374 KAL1528873.1 hypothetical protein AB1Y20_010196 [Prymnesium parvum] diamond 6273 99 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28165308 28165308 PRJNA1196384_S_NODE_2245_length_259_cov_1.923423_g2181_i0 PRJNA1196384 2245 259 1.923423 4.98166557 Diacronema 70451 Haptophyta other_Eukaryota 110 7.77e-28   NR KAJ1635632.1 483367 g2181 i0 63.1 4.86486486486486 84 31 97.3 0 8 259 53 136 KAJ1635632.1 ribosomal protein L30, ferredoxin-like fold domain-containing protein [Pavlovales sp. CCMP2436] diamond 1260 111 0.990990990990991 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436

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