RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA692200" 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

  • PRJNA692200 · 4 ✖

analysis 1

  • diamond · 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
24898790 24898790 PRJNA692200_S_NODE_100_length_666_cov_538.118314_g81_i0 PRJNA692200 100 666 538.118314 3583.86797124 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 127 2.1e-33   NR ADK26622.1 323453 g81 i0 85.9 0.288288288288288 64 9 28.8 0 2 193 67 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 192 127 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
28061623 28061623 PRJNA692200_S_NODE_10925_length_215_cov_2.415663_g10868_i0 PRJNA692200 10925 215 2.415663 5.19367545 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 48.9 8.51e-5   NR MES1913617.1 1215613 g10868 i0 53.3 0.627906976744186 45 20 62.8 1 213 79 130 173 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 135 48.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32022199 32022199 PRJNA692200_S_NODE_578_length_491_cov_9.092760_g542_i0 PRJNA692200 578 491 9.09276 44.6454516 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 72.4 2.12e-11   NR BAJ14650.1 39717 g542 i0 62.9 4.61303462321792 62 21 37.9 1 489 304 382 441 BAJ14650.1 elongation factor 1alpha, partial [Paulinella chromatophora] diamond 2265 72.4 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
32769097 32769097 PRJNA692200_S_NODE_12100_length_205_cov_8.230769_g12043_i0 PRJNA692200 12100 205 8.230769 16.87307645 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 79 3.98e-15   NR MES1909388.1 1215613 g12043 i0 59.1 1.93170731707317 66 26 96.6 1 1 198 257 321 MES1909388.1 hypothetical protein [Cercozoa sp. M6MM] diamond 396 79 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);;