RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA492406" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Haptista · 4 ✖

bioproject 1

  • PRJNA492406 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1727586 1727586 PRJNA492406_P_NODE_7562_length_440_cov_179.416894_g7263_i0 PRJNA492406 7562 440 179.416894 789.4343336 Acanthocystis sp. NZ2 299878 Root_unresolved Root_unresolved 455 2.7700000000000003e-123   NTclustered gi|55469155|gb|AY749628.1| 299878 g7263 i0 85.652 31.7590909090909 460 34 100 21 1 440 685 1132 Acanthocystis sp. NZ2 18S ribosomal RNA gene, partial sequence blastn 13974 455 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. NZ2
3003594 3003594 PRJNA492406_P_NODE_9743_length_393_cov_13.118750_g9444_i0 PRJNA492406 9743 393 13.11875 51.5566875 Acanthocystis sp. NZ2 299878 Root_unresolved Root_unresolved 532 1.0999999999999996e-146   NTclustered gi|55469155|gb|AY749628.1| 299878 g9444 i0 91.133 62.381679389313 406 17 100 13 1 393 35 434 Acanthocystis sp. NZ2 18S ribosomal RNA gene, partial sequence blastn 24516 532 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. NZ2
9380616 9380616 PRJNA492406_P_NODE_4448_length_566_cov_22.805274_g4153_i0 PRJNA492406 4448 566 22.805274 129.07785084 Acanthocystis sp. NZ2 299878 Root_unresolved Root_unresolved 621 3.39e-173   NTclustered gi|55469155|gb|AY749628.1| 299878 g4153 i0 87.612 83.8515901060071 557 41 94 21 1 534 1683 2234 Acanthocystis sp. NZ2 18S ribosomal RNA gene, partial sequence blastn 47460 621 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Acanthocystidae Acanthocystis Acanthocystis sp. NZ2
11930829 11930829 PRJNA492406_P_NODE_11130_length_371_cov_11.573826_g10831_i0 PRJNA492406 11130 371 11.573826 42.93889446 Oxnerella micra 1147772 Root_unresolved Root_unresolved 163 1.5599999999999998e-35   NTclustered gi|375582525|gb|JQ245080.1| 1147772 g10831 i0 96.907 333.175202156334 97 3 26 0 275 371 2146 2242 Oxnerella micra 28S ribosomal RNA gene, partial sequence blastn 123608 163 1 Eukaryota Haptista     Centroplasthelida Pterocystida Oxnerellidae Oxnerella Oxnerella micra

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