RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1022139" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1022139 · 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
2712162 2712162 PRJNA1022139_P_NODE_41683_length_242_cov_1.662722_g41578_i0 PRJNA1022139 41683 242 1.662722 4.02378724 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 375 1.14e-99   NTclustered gi|238617605|gb|FJ973380.1| 45107 g41578 i0 94.378 85.5 249 7 100 5 1 242 2467 2219 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 20691 375 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
7814228 7814228 PRJNA1022139_P_NODE_26727_length_278_cov_3.843902_g26622_i0 PRJNA1022139 26727 278 3.843902 10.68604756 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 259 1.4e-64   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g26622 i0 90.452 58.6978417266187 199 15 71 4 1 197 3705 3901 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 16318 259 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
9089172 9089172 PRJNA1022139_P_NODE_208_length_1907_cov_3.570883_g194_i0 PRJNA1022139 208 1907 3.570883 68.09673881 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 839 0   NTclustered gi|300676723|gb|GQ377712.1| 323453 g194 i0 84.994 20.5878342947037 833 117 43 8 942 1770 4 832 Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds blastn 39261 839 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
11640366 11640366 PRJNA1022139_P_NODE_5390_length_557_cov_4.706612_g5286_i0 PRJNA1022139 5390 557 4.706612 26.21582884 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 455 3.5800000000000004e-123   NTclustered gi|300676716|gb|GQ377714.1| 323453 g5286 i0 86.538 60.7091561938959 416 52 75 3 141 556 454 43 Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds blastn 33815 455 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
14190413 14190413 PRJNA1022139_P_NODE_5072_length_572_cov_3.202405_g4968_i0 PRJNA1022139 5072 572 3.202405 18.3177566 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 556 9.81e-154   NTclustered gi|301014702|gb|GQ377715.1| 323453 g4968 i0 89.011 58.7202797202797 455 43 79 7 12 462 40 491 Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds blastn 33588 556 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
16738523 16738523 PRJNA1022139_P_NODE_13134_length_374_cov_0.963455_g13029_i0 PRJNA1022139 13134 374 0.963455 3.6033217 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 686 0   NTclustered gi|300676732|gb|GQ377662.1| 188950 g13029 i0 99.733 91.9625668449198 374 1 100 0 1 374 414 787 Bodomorpha minima alpha-tubulin (Atub) gene, partial cds blastn 34394 686 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima

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