RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Haptista · 6 ✖

bioproject 1

  • PRJNA561212 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_phylum 0

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
3096479 3096479 PRJNA561212_P_NODE_6523_length_431_cov_299.810056_g6312_i0 PRJNA561212 6523 431 299.810056 1292.18134136 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 189 3.0399999999999993e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g6312 i0 94.355 31.9976798143852 124 6 43 1 153 276 1977 2099 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 13791 189 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
12024564 12024564 PRJNA561212_P_NODE_3270_length_610_cov_247.489758_g3065_i0 PRJNA561212 3270 610 247.489758 1509.6875238 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 189 4.4199999999999986e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g3065 i0 94.355 22.6081967213115 124 6 30 1 332 455 1977 2099 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 13791 189 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
14574534 14574534 PRJNA561212_P_NODE_5912_length_453_cov_290.423684_g5701_i0 PRJNA561212 5912 453 290.423684 1315.61928852 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 189 3.209999999999999e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g5701 i0 94.355 30.4437086092715 124 6 41 1 175 298 1977 2099 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 13791 189 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
15848362 15848362 PRJNA561212_P_NODE_3533_length_587_cov_254.509728_g3326_i0 PRJNA561212 3533 587 254.509728 1493.97210336 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 189 4.24e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g3326 i0 94.355 23.4940374787053 124 6 32 1 156 279 2099 1977 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 13791 189 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii
15848459 15848459 PRJNA561212_P_NODE_8973_length_367_cov_1.153061_g8762_i0 PRJNA561212 8973 367 1.153061 4.23173387 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 259 1.91e-64   NTclustered gi|159147872|dbj|AB288080.1| 2792838 g8762 i0 80.826 89.6321525885559 339 57 91 7 16 350 1214 880 Raphidocystis contractilis EF2 mRNA for elongation factor 2, partial cds blastn 32895 259 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
18397439 18397439 PRJNA561212_P_NODE_6575_length_429_cov_302.103933_g6364_i0 PRJNA561212 6575 429 302.103933 1296.02587257 Sphaerastrum fockii 299901 Root_unresolved Root_unresolved 189 3.02e-43   NTclustered gi|61187370|gb|AY752991.1| 299901 g6364 i0 94.355 32.1468531468531 124 6 43 1 151 274 1977 2099 Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence blastn 13791 189 1 Eukaryota Haptista     Centroplasthelida Pterocystida Heterophryidae Sphaerastrum Sphaerastrum fockii

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