RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 8 ✖

bioproject 1

  • PRJNA1237347 · 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
1617363 1617363 PRJNA1237347_P_NODE_41582_length_1180_cov_1.312556_g37171_i0 PRJNA1237347 41582 1180 1.312556 15.4881608 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 257 2.3800000000000002e-63   NTclustered gi|551561464|ref|XM_005767520.1| 280463 g37171 i0 72.203 3.21864406779661 885 230 74 14 17 893 1207 331 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 3798 257 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4165791 4165791 PRJNA1237347_P_NODE_211564_length_418_cov_1.026087_g204992_i0 PRJNA1237347 211564 418 1.026087 4.28904366 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 56.5 0.003   NTclustered gi|551590785|ref|XM_005779672.1| 280463 g204992 i0 94.444 0.311004784688995 36 2 9 0 294 329 350 385 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 130 56.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4167034 4167034 PRJNA1237347_P_NODE_270264_length_357_cov_0.943662_g263691_i0 PRJNA1237347 270264 357 0.943662 3.36887334 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 228 5.229999999999999e-55   NTclustered gi|551588221|ref|XM_005778763.1| 280463 g263691 i0 78.47 72.5714285714286 353 72 98 4 7 357 1020 670 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 25908 228 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
5444611 5444611 PRJNA1237347_P_NODE_335805_length_311_cov_1.617647_g329232_i0 PRJNA1237347 335805 311 1.617647 5.03088217 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 52.8 0.029   NTclustered gi|551589929|ref|XM_005779371.1| 280463 g329232 i0 100 1.2604501607717 28 0 9 0 226 253 1113 1086 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 392 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
7993866 7993866 PRJNA1237347_P_NODE_296227_length_336_cov_18.076046_g289654_i0 PRJNA1237347 296227 336 18.076046 60.73551456 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 187 8.33e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g289654 i0 94.309 40.9523809523809 123 6 37 1 81 203 1977 2098 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 13760 187 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
10550503 10550503 PRJNA1237347_P_NODE_92229_length_717_cov_6.465839_g85945_i0 PRJNA1237347 92229 717 6.465839 46.36006563 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 187 1.8799999999999994e-42   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g85945 i0 80.237 6.68340306834031 253 46 35 2 304 554 401 151 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 4792 187 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
15640631 15640631 PRJNA1237347_P_NODE_163453_length_495_cov_2.289100_g156890_i0 PRJNA1237347 163453 495 2.2891 11.331045 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 56.5 0.004   NTclustered gi|551612603|ref|XM_005787267.1| 280463 g156890 i0 96.97 0.0666666666666667 33 1 7 0 331 363 151 183 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 33 56.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18192886 18192886 PRJNA1237347_P_NODE_339375_length_309_cov_1.661017_g332802_i0 PRJNA1237347 339375 309 1.661017 5.13254253 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 113 1.3e-20   NTclustered gi|551534940|ref|XM_005756239.1| 280463 g332802 i0 83.607 0.394822006472492 122 18 39 2 97 217 340 220 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 122 113 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);;