RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1073183" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1073183 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1462012 1462012 PRJNA1073183_P_NODE_6842_length_486_cov_1.677966_g6748_i0 PRJNA1073183 6842 486 1.677966 8.15491476 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 425 2.42e-114   NTclustered gi|160337355|gb|EF455774.1| 439948 g6748 i0 84.127 98.9423868312757 441 68 91 2 11 450 440 1 Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds blastn 48086 425 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
4844121 4844121 PRJNA1073183_P_NODE_21904_length_280_cov_1.265700_g21809_i0 PRJNA1073183 21904 280 1.2657 3.5439600000000002 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 222 1.86e-53   NTclustered gi|31982985|gb|AY236717.1| 188940 g21809 i0 83.133 78.3964285714286 249 36 89 3 2 250 1223 1465 Thaumatomonas sp. (SA) heat shock protein 90 (Hsp90) gene, partial cds blastn 21951 224 0.991071428571429 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
5289887 5289887 PRJNA1073183_P_NODE_15845_length_328_cov_1.207843_g15750_i0 PRJNA1073183 15845 328 1.207843 3.96172504 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 156 2.29e-33   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g15750 i0 87.5 27.7256097560976 136 15 41 2 1 136 3719 3852 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 9094 156 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
24412958 24412958 PRJNA1073183_P_NODE_13460_length_353_cov_2.678571_g13365_i0 PRJNA1073183 13460 353 2.678571 9.45535563 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 387 8.06e-103   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g13365 i0 86.761 61.5580736543909 355 37 99 10 4 353 4008 3659 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 21730 387 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis

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