RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 5 ✖

analysis 1

  • diamond · 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
29587755 29587755 PRJNA630162_P_NODE_102850_length_184_cov_1.355556_g101327_i0 PRJNA630162 102850 184 1.355556 2.49422304 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.5 2.83e-12   NR ETO26066.1 46433 g101327 i0 52.6 4.67934782608696 57 26 92.9 1 178 8 426 481 ETO26066.1 SET domain containing protein [Reticulomyxa filosa] diamond 861 70.9 0.994358251057828 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29764742 29764742 PRJNA630162_P_NODE_72971_length_210_cov_2.720497_g71448_i0 PRJNA630162 72971 210 2.720497 5.7130437 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 48.5 2.1e-4   NR ETO27253.1 46433 g71448 i0 71.4 0.914285714285714 28 8 40 0 6 89 170 197 ETO27253.1 hypothetical protein RFI_09882, partial [Reticulomyxa filosa] diamond 192 48.5 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30112169 30112169 PRJNA630162_P_NODE_131212_length_169_cov_1.325000_g129689_i0 PRJNA630162 131212 169 1.325 2.23925 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 55.5 4.21e-7   NR ETO09817.1 46433 g129689 i0 92.9 1.47337278106509 28 2 49.7 0 85 2 3 30 ETO09817.1 Ras GTPase [Reticulomyxa filosa] diamond 249 55.5 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31439405 31439405 PRJNA630162_P_NODE_118756_length_175_cov_1.555556_g117233_i0 PRJNA630162 118756 175 1.555556 2.722223 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00119   NR ETO04668.1 46433 g117233 i0 35.7 1.85142857142857 56 34 96 1 3 170 28 81 ETO04668.1 hypothetical protein RFI_32728, partial [Reticulomyxa filosa] diamond 324 45.8 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
32874456 32874456 PRJNA630162_P_NODE_70060_length_212_cov_3.239264_g68537_i0 PRJNA630162 70060 212 3.239264 6.86723968 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 55.8 2.52e-7   NR ETO28446.1 46433 g68537 i0 81.3 4.07547169811321 32 6 45.3 0 208 113 120 151 ETO28446.1 hybrid cluster protein [Reticulomyxa filosa] diamond 864 55.8 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

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