RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1020641 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
19286257 19286257 PRJNA1020641_P_NODE_5736_length_250_cov_0.870056_g5693_i0 PRJNA1020641 5736 250 0.870056 2.17514 Trifolium subterraneum 3900 Plants Plants 95.5 1.13e-20   NR GAU52014.1 3900 g5693 i0 65.1 1.992 83 25 99.6 2 249 1 139 217 GAU52014.1 hypothetical protein TSUD_418260, partial [Trifolium subterraneum] diamond 498 95.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium subterraneum
27382654 27382654 PRJNA1020641_P_NODE_6563_length_246_cov_0.890173_g6520_i0 PRJNA1020641 6563 246 0.890173 2.18982558 Vigna mungo 3915 Plants Plants 62 7.97e-10   NR WVZ16020.1 3915 g6520 i0 45.1 2.69512195121951 71 34 82.9 3 204 1 5 73 WVZ16020.1 hypothetical protein V8G54_013586 [Vigna mungo] diamond 663 62 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna mungo
28582522 28582522 PRJNA1020641_P_NODE_6187_length_248_cov_0.880000_g6144_i0 PRJNA1020641 6187 248 0.88 2.1824 Mangifera indica 29780 Plants Plants 67 1.97e-11   NR XP_044466254.1 29780 g6144 i0 60 6.06048387096774 50 20 60.5 0 154 5 8 57 XP_044466254.1 ras-related protein Rab11D-like isoform X3 [Mangifera indica] diamond 1503 67 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Anacardiaceae Mangifera Mangifera indica
31836325 31836325 PRJNA1020641_P_NODE_7357_length_241_cov_0.916667_g7314_i0 PRJNA1020641 7357 241 0.916667 2.20916747 Salvia divinorum 28513 Plants Plants 42.4 0.046   NR KAL1568354.1 28513 g7314 i0 44.7 0.473029045643154 38 20 46.1 1 215 105 104 141 KAL1568354.1 putative carboxylesterase 18 [Salvia divinorum] diamond 114 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia divinorum
31955169 31955169 PRJNA1020641_P_NODE_3377_length_333_cov_0.888462_g3334_i0 PRJNA1020641 3377 333 0.888462 2.95857846 Eukaryota 2759 Plants Plants 88.6 2.44e-18   NR KAJ6801984.1 29817 g3334 i0 60 14 65 26 58.6 0 197 3 238 302 KAJ6801984.1 geranylgeranyl transferase type-2 subunit beta 1-like isoform X2 [Iris pallida] diamond 4662 89 0.995505617977528 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Iridaceae Iris Iris pallida
32847574 32847574 PRJNA1020641_P_NODE_4980_length_267_cov_1.824742_g4937_i0 PRJNA1020641 4980 267 1.824742 4.87206114 Dorcoceras hygrometricum 472368 Plants Plants 43.5 0.0236   NR KZV31801.1 472368 g4937 i0 34.2 0.853932584269663 76 41 75.3 2 267 67 6 81 KZV31801.1 dystroglycan-like [Dorcoceras hygrometricum] diamond 228 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Gesneriaceae Dorcoceras Dorcoceras hygrometricum

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