RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1120586" 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

  • PRJNA1120586 · 5 ✖

analysis 1

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
275884 275884 PRJNA1120586_P_NODE_22181_length_289_cov_1.113636_g21990_i0 PRJNA1120586 22181 289 1.113636 3.21840804 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 244 4.11e-60   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g21990 i0 82.877 27.7543252595156 292 30 99 11 2 289 3719 3994 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 8021 244 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
7929221 7929221 PRJNA1120586_P_NODE_47467_length_229_cov_1.800000_g47276_i0 PRJNA1120586 47467 229 1.8 4.122 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 135 1.97e-27   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g47276 i0 91.089 24.4541484716157 101 8 44 1 129 229 3873 3774 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 5600 135 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
15578624 15578624 PRJNA1120586_P_NODE_17213_length_314_cov_92.191837_g17022_i0 PRJNA1120586 17213 314 92.191837 289.48236818 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 448 3.2099999999999996e-121   NTclustered gi|238617605|gb|FJ973380.1| 45107 g17022 i0 92.357 93.9140127388535 314 24 100 0 1 314 1276 1589 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 29489 448 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
18128172 18128172 PRJNA1120586_P_NODE_54975_length_206_cov_16.036496_g54784_i0 PRJNA1120586 54975 206 16.036496 33.03518176 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 209 1.01e-49   NTclustered gi|238617605|gb|FJ973380.1| 45107 g54784 i0 88.202 18.5970873786408 178 18 99 3 1 176 2187 2363 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 3831 209 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
24502441 24502441 PRJNA1120586_P_NODE_8800_length_401_cov_86.954819_g8609_i0 PRJNA1120586 8800 401 86.954819 348.68882419 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 379 1.55e-100   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g8609 i0 86.226 47.3416458852868 363 34 90 9 41 401 4039 3691 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 18984 379 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);;