RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB75017", tax_clade = "Sar" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 5 ✖

tax_clade 1

bioproject 1

  • PRJEB75017 · 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
6513488 6513488 PRJEB75017_P_NODE_2886_length_517_cov_1.864865_g2757_i0 PRJEB75017 2886 517 1.864865 9.64135205 Brizalina sp. 1 RS-2013 1368626 SAR_Eukaryotes SAR_Eukaryotes 207 1.02e-48   NTclustered gi|529159331|gb|KF170435.1| 1368626 g2757 i0 86.387 24.2514506769826 191 22 37 4 328 516 111 299 Brizalina sp. 1 RS-2013 beta-tubulin type 1 isoform 1 gene, partial cds blastn 12538 207 1 Eukaryota Sar   Foraminifera   Rotaliida Bolivinitidae Brizalina Brizalina sp. 1 RS-2013
26748851 26748851 PRJEB75017_P_NODE_18341_length_242_cov_0.923077_g18212_i0 PRJEB75017 18341 242 0.923077 2.23384634 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 98.2 1.13e-21   NR ETO05095.1 46433 g18212 i0 57.7 0.966942148760331 78 33 96.7 0 9 242 389 466 ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] diamond 234 98.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29433858 29433858 PRJEB75017_P_NODE_3670_length_457_cov_0.945312_g3541_i0 PRJEB75017 3670 457 0.945312 4.32007584 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 50.4 5.69e-4   NR ETO15786.1 46433 g3541 i0 28.7 0.617067833698031 94 63 59.7 4 436 164 9 101 ETO15786.1 hypothetical protein RFI_21577 [Reticulomyxa filosa] diamond 282 50.4 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30855585 30855585 PRJEB75017_P_NODE_11294_length_276_cov_1.679803_g11165_i0 PRJEB75017 11294 276 1.679803 4.63625628 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 51.2 5.24e-5   NR ETO01891.1 46433 g11165 i0 39.1 0.945652173913043 87 47 92.4 4 260 6 190 272 ETO01891.1 histon H1 [Reticulomyxa filosa] diamond 261 51.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31645847 31645847 PRJEB75017_P_NODE_14017_length_253_cov_0.866667_g13888_i0 PRJEB75017 14017 253 0.866667 2.19266751 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 58.2 7.45e-8   NR ETN98481.1 46433 g13888 i0 43 0.936758893280632 79 40 93.7 3 3 239 35 108 ETN98481.1 hypothetical protein RFI_39015, partial [Reticulomyxa filosa] diamond 237 58.2 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);;