RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB66218" and tax_phylum = "Haptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Haptophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJEB66218 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
2684485 2684485 PRJEB66218_P_NODE_79623_length_354_cov_2.276451_g77197_i0 PRJEB66218 79623 354 2.276451 8.05863654 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 268 3.05e-67   NTclustered gi|551616895|ref|XM_005789234.1| 280463 g77197 i0 82.637 12.9039548022599 311 46 87 8 12 318 611 305 Emiliania huxleyi CCMP1516 serine hydroxymethyltransferase mRNA blastn 4568 268 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4822369 4822369 PRJEB66218_P_NODE_157844_length_236_cov_1.114286_g155414_i0 PRJEB66218 157844 236 1.114286 2.62971496 root 1 Root_unresolved Root_unresolved 52.8 0.021   NTclustered gi|551557670|ref|XM_005765795.1| 280463 g155414 i0 100 0.474576271186441 28 0 12 0 187 214 271 298 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 112 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
10333380 10333380 PRJEB66218_P_NODE_100949_length_305_cov_1.372951_g98521_i0 PRJEB66218 100949 305 1.372951 4.18750055 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 63.9 1.31e-5   NTclustered gi|551579782|ref|XM_005775393.1| 280463 g98521 i0 100 11.0852459016393 34 0 11 0 235 268 1158 1191 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 3381 63.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
12884050 12884050 PRJEB66218_P_NODE_10711_length_1330_cov_3.352246_g9233_i0 PRJEB66218 10711 1330 3.352246 44.5848718 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 623 2.3e-173   NTclustered gi|551561030|ref|XM_005767357.1| 280463 g9233 i0 80.285 59.3962406015038 842 152 63 13 1 835 989 1823 Emiliania huxleyi CCMP1516 Adaptor protein 2 beta subunit 1 (AP2B1), partial mRNA blastn 78997 623 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
16297660 16297660 PRJEB66218_P_NODE_62893_length_412_cov_2.213675_g60471_i0 PRJEB66218 62893 412 2.213675 9.120341 Emiliania 2902 Haptophyta other_Eukaryota 195 6.22e-45   NTclustered gi|112143935|gb|DQ658330.1| 2903 g60471 i0 79.562 14.1504854368932 274 54 66 2 73 345 353 81 Emiliania huxleyi clone Plate2_C01_compl;77-2-19-E12 putative small nuclear ribonucleoprotein d2, complete cds blastn 5830 195 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
20531635 20531635 PRJEB66218_P_NODE_117957_length_278_cov_0.870968_g115528_i0 PRJEB66218 117957 278 0.870968 2.42129104 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 56.5 0.002   NTclustered gi|551538456|ref|XM_005757723.1| 280463 g115528 i0 96.97 2.1726618705036 33 1 12 0 30 62 1153 1185 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 604 56.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
20533918 20533918 PRJEB66218_P_NODE_25217_length_753_cov_18.054913_g23000_i0 PRJEB66218 25217 753 18.054913 135.95349489 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 388 5.07e-103   NTclustered gi|551568843|ref|XM_005770320.1| 280463 g23000 i0 82.522 53.9707835325365 452 69 59 10 185 631 134 580 Emiliania huxleyi CCMP1516 peptidyl-prolyl isomerase (CYPB1), mRNA blastn 40640 388 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
25221080 25221080 PRJEB66218_P_NODE_52420_length_464_cov_4.039702_g50001_i0 PRJEB66218 52420 464 4.039702 18.74421728 root 1 Root_unresolved Root_unresolved 289 3.16e-73   NTclustered gi|551544793|ref|XM_005760382.1| 280463 g50001 i0 81.69 73.385775862069 355 57 76 7 113 463 1739 1389 Emiliania huxleyi CCMP1516 fumarate hydratase mRNA blastn 34051 289 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);;