RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA752278 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2004299 2004299 PRJNA752278_P_NODE_82842_length_249_cov_1.312500_g82639_i0 PRJNA752278 82842 249 1.3125 3.268125 Thaumatomonas sp. (SA) 188940 SAR_Eukaryotes SAR_Eukaryotes 147 1e-30   NTclustered gi|31982985|gb|AY236717.1| 188940 g82639 i0 78.355 6.18072289156626 231 46 92 4 14 242 1670 1442 Thaumatomonas sp. (SA) heat shock protein 90 (Hsp90) gene, partial cds blastn 1539 147 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
7105493 7105493 PRJNA752278_P_NODE_106366_length_238_cov_3.163636_g106163_i0 PRJNA752278 106366 238 3.163636 7.52945368 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 243 1.1800000000000001e-59   NTclustered gi|300676720|gb|GQ377713.1| 323453 g106163 i0 87.981 22.281512605042 208 21 87 4 1 206 251 46 Heteromita sp. PRA-74 gcr5-like mRNA, partial sequence blastn 5303 243 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
7105801 7105801 PRJNA752278_P_NODE_21426_length_347_cov_1.540146_g21223_i0 PRJNA752278 21426 347 1.540146 5.34430662 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 381 3.6899999999999986e-101   NTclustered gi|160337351|gb|EF455772.1| 439948 g21223 i0 86.455 95.2363112391931 347 47 100 0 1 347 334 680 Dimorpha sp. ATCC PRA-54 clone 1 actin gene, partial cds blastn 33047 381 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
7578804 7578804 PRJNA752278_P_NODE_34046_length_296_cov_1.035874_g33843_i0 PRJNA752278 34046 296 1.035874 3.06618704 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 215 3.31e-51   NTclustered gi|15216730|gb|AF363539.1| 45113 g33843 i0 86.294 67.6587837837838 197 27 67 0 98 294 732 536 Cercomonas sp. ATCC 50319 actin (act) gene, partial cds blastn 20027 215 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50319
19855017 19855017 PRJNA752278_P_NODE_66096_length_262_cov_1.460317_g65893_i0 PRJNA752278 66096 262 1.460317 3.82603054 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 459 1.21e-124   NTclustered gi|238617602|gb|FJ973377.1| 188950 g65893 i0 98.106 70.0801526717557 264 3 100 1 1 262 3029 2766 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 18361 459 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);;