RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA841653" and tax_phylum = "Discosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Discosea · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA841653 · 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
23783026 23783026 PRJNA841653_P_NODE_46139_length_250_cov_0.870056_g45465_i0 PRJNA841653 46139 250 0.870056 2.17514 Acanthamoeba castellanii str. Neff 1257118 Discosea other_Eukaryota 105 1.26e-24   NR XP_004333651.1 1257118 g45465 i0 57.3 2.94 82 32 96 2 10 249 230 310 XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff] diamond 735 105 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Acanthamoeba Acanthamoeba castellanii
26841870 26841870 PRJNA841653_P_NODE_17821_length_387_cov_1.391720_g17149_i0 PRJNA841653 17821 387 1.39172 5.3859564 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 48.1 0.0022   NR AFD36246.1 5755 g17149 i0 38.7 5.03875968992248 75 40 55.8 2 285 70 375 446 AFD36246.1 protein kinase C17 [Acanthamoeba castellanii] diamond 1950 48.1 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Acanthamoeba Acanthamoeba castellanii
28570522 28570522 PRJNA841653_P_NODE_51507_length_247_cov_0.885057_g50833_i0 PRJNA841653 51507 247 0.885057 2.18609079 Acanthamoeba castellanii str. Neff 1257118 Discosea other_Eukaryota 103 7.91e-24   NR XP_004334790.1 1257118 g50833 i0 56.6 0.923076923076923 76 33 92.3 0 19 246 144 219 XP_004334790.1 tryptophan-tRNA ligase [Acanthamoeba castellanii str. Neff] diamond 228 103 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Acanthamoeba Acanthamoeba castellanii
30907930 30907930 PRJNA841653_P_NODE_51234_length_247_cov_0.885057_g50560_i0 PRJNA841653 51234 247 0.885057 2.18609079 Acanthamoeba castellanii str. Neff 1257118 Discosea other_Eukaryota 140 4.87e-40   NR XP_004334642.1 1257118 g50560 i0 82.1 0.947368421052632 78 14 94.7 0 239 6 55 132 XP_004334642.1 Ras family GTPase [Acanthamoeba castellanii str. Neff] diamond 234 140 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Acanthamoeba Acanthamoeba castellanii
31508572 31508572 PRJNA841653_P_NODE_45436_length_250_cov_0.870056_g44762_i0 PRJNA841653 45436 250 0.870056 2.17514 Acanthamoeba castellanii str. Neff 1257118 Discosea other_Eukaryota 67.8 5.88e-11   NR XP_004339235.1 1257118 g44762 i0 60 0.72 60 24 72 0 203 24 169 228 XP_004339235.1 Signal transducer and activator of transcription STAT family protein [Acanthamoeba castellanii str. Neff] diamond 180 67.8 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Acanthamoeba Acanthamoeba castellanii

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