RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA753704" and tax_phylum = "Tubulinea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Tubulinea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA753704 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
10130635 10130635 PRJNA753704_P_NODE_11308_length_352_cov_1.677419_g10947_i0 PRJNA753704 11308 352 1.677419 5.90451488 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 176 3.56e-49   NR YP_003540848.1 5778 g10947 i0 93.7 1.61931818181818 95 6 81 0 68 352 385 479 YP_003540848.1 NADH dehydrogenase subunit 5 [Vermamoeba vermiformis] diamond 570 176 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
16033737 16033737 PRJNA753704_P_NODE_26773_length_245_cov_1.813953_g26412_i0 PRJNA753704 26773 245 1.813953 4.44418485 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 137 7.29e-39   NR YP_003540833.1 5778 g26412 i0 77.2 1.93469387755102 79 18 96.7 0 237 1 47 125 YP_003540833.1 NADH dehydrogenase subunit 9 [Vermamoeba vermiformis] diamond 474 137 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
18582915 18582915 PRJNA753704_P_NODE_21255_length_264_cov_3.204188_g20894_i0 PRJNA753704 21255 264 3.204188 8.45905632 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 174 4.44e-51   NR YP_003540834.1 5778 g20894 i0 96.6 0.988636363636364 87 3 98.9 0 263 3 56 142 YP_003540834.1 NADH dehydrogenase subunit 7 [Vermamoeba vermiformis] diamond 261 174 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
26926355 26926355 PRJNA753704_P_NODE_27202_length_244_cov_2.701754_g26841_i0 PRJNA753704 27202 244 2.701754 6.59227976 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 146 2.63e-39   NR YP_003540812.1 5778 g26841 i0 96.3 0.983606557377049 80 3 98.4 0 3 242 65 144 YP_003540812.1 ATP synthase F1 subunit alpha [Vermamoeba vermiformis] diamond 240 146 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
30906157 30906157 PRJNA753704_P_NODE_27174_length_244_cov_3.777778_g26813_i0 PRJNA753704 27174 244 3.777778 9.21777832 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 78.6 2.23e-16   NR YP_003540821.1 5778 g26813 i0 86 1.05737704918033 43 6 52.9 0 244 116 96 138 YP_003540821.1 ribosomal protein L16 [Vermamoeba vermiformis] diamond 258 78.6 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
32487548 32487548 PRJNA753704_P_NODE_27759_length_243_cov_1.541176_g27398_i0 PRJNA753704 27759 243 1.541176 3.74505768 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 119 5.459999999999999e-31   NR YP_003540842.1 5778 g27398 i0 96.9 0.790123456790123 64 2 79 0 192 1 117 180 YP_003540842.1 cytochrome c oxidase subunit 3 [Vermamoeba vermiformis] diamond 192 119 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis

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