RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA743294" 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

  • PRJNA743294 · 6 ✖

analysis 1

  • blastn · 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
3273265 3273265 PRJNA743294_P_NODE_18103_length_380_cov_1.377850_g17647_i0 PRJNA743294 18103 380 1.37785 5.23583 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 243 2e-59   NTclustered gi|259475579|emb|FN392387.1| 2792838 g17647 i0 80.374 59.6578947368421 321 61 84 2 1 320 447 766 Raphidiophrys contractilis partial mRNA for 60S ribosomal protein L8, contig 29379 blastn 22670 243 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
5026564 5026564 PRJNA743294_P_NODE_30984_length_299_cov_3.668142_g30528_i0 PRJNA743294 30984 299 3.668142 10.96774458 Acanthocystis 299834 Root_unresolved Root_unresolved 529 1.0499999999999996e-145   NTclustered gi|55469150|gb|AY749623.1| 299873 g30528 i0 98.662 51.7926421404682 299 2 100 1 1 299 5 301 Acanthocystis sp. Oxford6 18S ribosomal RNA gene, partial sequence blastn 15486 529 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. Oxford6
9650369 9650369 PRJNA743294_P_NODE_16968_length_391_cov_2.455975_g16512_i0 PRJNA743294 16968 391 2.455975 9.60286225 Chlamydaster sterni 193542 Root_unresolved Root_unresolved 296 1.56e-75   NTclustered gi|33089907|gb|AY283744.1| 193542 g16512 i0 80.605 95.156010230179 397 65 100 10 1 391 478 88 Chlamydaster sterni isolate Chlam30_2 actin mRNA, partial cds blastn 37206 296 1 Eukaryota Haptista     Centroplasthelida Pterocystida Pterocystidae Chlamydaster Chlamydaster sterni
13475764 13475764 PRJNA743294_P_NODE_16491_length_396_cov_49.712074_g16035_i0 PRJNA743294 16491 396 49.712074 196.85981304 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 230 1.6299999999999996e-55   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g16035 i0 80.323 3.40151515151515 310 56 78 4 49 355 105 412 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1347 230 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23675222 23675222 PRJNA743294_P_NODE_59479_length_227_cov_3.740260_g59023_i0 PRJNA743294 59479 227 3.74026 8.4903902 Meringosphaera mediterranea 2837474 Root_unresolved Root_unresolved 130 9.08e-26   NTclustered gi|2526806211|gb|OR195157.1| 2837474 g59023 i0 83.333 46.3127753303965 144 21 63 3 85 227 2939 2798 Meringosphaera mediterranea isolate S7 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 10513 130 1 Eukaryota Haptista     Centroplasthelida     Meringosphaera Meringosphaera mediterranea
24948479 24948479 PRJNA743294_P_NODE_26660_length_320_cov_1.538462_g26204_i0 PRJNA743294 26660 320 1.538462 4.9230784 Acanthocystis sp. Oxford4 299877 Root_unresolved Root_unresolved 592 1.4299999999999996e-164   NTclustered gi|55469154|gb|AY749627.1| 299877 g26204 i0 100 44.021875 320 0 100 0 1 320 855 1174 Acanthocystis sp. Oxford4 18S ribosomal RNA gene, partial sequence blastn 14087 592 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. Oxford4

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