RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 5 ✖

bioproject 1

  • PRJNA1093380 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
199118 199118 PRJNA1093380_P_NODE_16801_length_241_cov_1.613095_g16695_i0 PRJNA1093380 16801 241 1.613095 3.88755895 Bryopsis sp. KO-2 3115439 Plants Plants 67.8 5.6e-11   NR GMH40341.1 3041901 g16695 i0 41 9.59751037344398 78 46 97.1 0 240 7 484 561 GMH40341.1 hypothetical protein BSKO_08245 [Bryopsis sp. KO-2023] diamond 2313 68.2 0.994134897360704 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Bryopsidaceae Bryopsis Bryopsis sp. KO-2023
28985613 28985613 PRJNA1093380_P_NODE_5548_length_288_cov_1.255814_g5442_i0 PRJNA1093380 5548 288 1.255814 3.61674432 Coccomyxa 41891 Plants Plants 132 4.02e-35   NR XP_005647123.1 574566 g5442 i0 66.3 6.98958333333333 95 32 99 0 286 2 100 194 XP_005647123.1 hypothetical protein COCSUDRAFT_66290 [Coccomyxa subellipsoidea C-169] diamond 2013 133 0.992481203007519 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
31078807 31078807 PRJNA1093380_P_NODE_11335_length_254_cov_1.348066_g11229_i0 PRJNA1093380 11335 254 1.348066 3.42408764 Scenedesmus sp. NREL 46B-D3 2650976 Plants Plants 105 1.99e-24   NR KAF6261355.1 2650976 g11229 i0 57.1 1.98425196850394 84 36 99.2 0 253 2 296 379 KAF6261355.1 putative cation transporter/universal stress family protein [Scenedesmus sp. NREL 46B-D3] diamond 504 105 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Scenedesmus Scenedesmus sp. NREL 46B-D3
31173116 31173116 PRJNA1093380_P_NODE_15095_length_245_cov_0.895349_g14989_i0 PRJNA1093380 15095 245 0.895349 2.19360505 Chlorella ohadii 2649997 Plants Plants 47.4 9.07e-4   NR KAI7845374.1 2649997 g14989 i0 41.2 0.624489795918367 51 30 62.4 0 34 186 781 831 KAI7845374.1 hypothetical protein COHA_001081 [Chlorella ohadii] diamond 153 47.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella ohadii
31458223 31458223 PRJNA1093380_P_NODE_6896_length_280_cov_1.183575_g6790_i0 PRJNA1093380 6896 280 1.183575 3.31401 Edaphochlamys debaryana 47281 Plants Plants 98.6 1.3700000000000002e-21   NR KAG2498751.1 47281 g6790 i0 60.2 3.34285714285714 83 33 88.9 0 8 256 562 644 KAG2498751.1 hypothetical protein HYH03_003490 [Edaphochlamys debaryana] diamond 936 98.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales   Edaphochlamys Edaphochlamys debaryana

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