RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA675331", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA675331 · 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
16471314 16471314 PRJNA675331_P_NODE_2673_length_568_cov_2.135354_g2505_i0 PRJNA675331 2673 568 2.135354 12.12881072 Fabomonas 1291204 SAR_Eukaryotes SAR_Eukaryotes 147 2.5e-30   NTclustered gi|220983376|dbj|AB453012.1| 552662 g2505 i0 87.5 21.4066901408451 128 15 23 1 441 568 1667 1541 Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence blastn 12159 148 0.993243243243243 Eukaryota Sar   Cercozoa         Cercozoa sp. YPF501
23600551 23600551 PRJNA675331_P_NODE_16259_length_263_cov_1.215789_g16087_i0 PRJNA675331 16259 263 1.215789 3.19752507 Aulacantha scolymantha 238793 SAR_Eukaryotes SAR_Eukaryotes 167 8.22e-37   NTclustered gi|528530870|emb|HG316279.1| 238793 g16087 i0 85.625 12.3992395437262 160 21 60 2 99 257 140 298 Aulacantha scolymantha partial mRNA for Rps14, isolate Asco01, clone UN06628 blastn 3261 167 1 Eukaryota Sar   Cercozoa Thecofilosea Phaeocystida Aulacanthidae Aulacantha Aulacantha scolymantha
28471639 28471639 PRJNA675331_P_NODE_17826_length_252_cov_1.290503_g17654_i0 PRJNA675331 17826 252 1.290503 3.25206756 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 69.3 7.02e-12   NR MES1913935.1 1215613 g17654 i0 70.2 0.678571428571429 57 16 67.9 1 34 204 158 213 MES1913935.1 hypothetical protein [Cercozoa sp. M6MM] diamond 171 69.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30998261 30998261 PRJNA675331_P_NODE_20474_length_247_cov_0.885057_g20302_i0 PRJNA675331 20474 247 0.885057 2.18609079 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 115 5.58e-29   NR MES1911029.1 1215613 g20302 i0 69.1 2.96356275303644 81 25 98.4 0 3 245 22 102 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 732 115 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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