RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA573544" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA573544 · 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
28784676 28784676 PRJNA573544_P_NODE_1247_length_454_cov_0.905512_g1229_i0 PRJNA573544 1247 454 0.905512 4.11102448 Chlamydomonas reinhardtii 3055 Plants Plants 135 1.58e-36   NR XP_042922091.1 3055 g1229 i0 48.9 0.918502202643172 139 67 89.2 1 50 454 2 140 XP_042922091.1 uncharacterized protein CHLRE_08g373359v5 [Chlamydomonas reinhardtii] diamond 417 135 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
29353299 29353299 PRJNA573544_P_NODE_6949_length_246_cov_1.797688_g6931_i0 PRJNA573544 6949 246 1.797688 4.42231248 Chlamydomonas schloesseri 2026947 Plants Plants 103 8.55e-27   NR KAG2448676.1 2026947 g6931 i0 93 0.865853658536585 71 5 86.6 0 246 34 32 102 KAG2448676.1 hypothetical protein HYH02_006033 [Chlamydomonas schloesseri] diamond 213 103 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas schloesseri
29795035 29795035 PRJNA573544_P_NODE_3651_length_298_cov_1.386667_g3633_i0 PRJNA573544 3651 298 1.386667 4.13226766 Astrephomene gubernaculifera 47775 Plants Plants 88.6 4.06e-18   NR GFR46647.1 47775 g3633 i0 47.9 0.946308724832215 94 47 93.6 2 18 296 338 430 GFR46647.1 hypothetical protein Agub_g8258 [Astrephomene gubernaculifera] diamond 282 88.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Astrephomenaceae Astrephomene Astrephomene gubernaculifera
30647973 30647973 PRJNA573544_P_NODE_5453_length_253_cov_0.866667_g5435_i0 PRJNA573544 5453 253 0.866667 2.19266751 Auxenochlorella protothecoides 3075 Plants Plants 66.6 8.92e-11   NR XP_011396120.1 3075 g5435 i0 34.1 3.88932806324111 82 53 97.2 1 3 248 53 133 XP_011396120.1 Mitochondrial outer membrane protein porin 1 [Auxenochlorella protothecoides] diamond 984 66.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
31817835 31817835 PRJNA573544_P_NODE_2677_length_337_cov_1.477273_g2659_i0 PRJNA573544 2677 337 1.477273 4.97841001 Chlamydomonas schloesseri 2026947 Plants Plants 139 1.24e-40   NR KAG2436013.1 2026947 g2659 i0 90.7 0.667655786350148 75 6 65.9 1 65 286 1 75 KAG2436013.1 hypothetical protein HYH02_011725 [Chlamydomonas schloesseri] diamond 225 139 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas schloesseri
32797420 32797420 PRJNA573544_P_NODE_4180_length_282_cov_1.425837_g4162_i0 PRJNA573544 4180 282 1.425837 4.02086034 Tetrabaena socialis 47790 Plants Plants 54.7 3.29e-6   NR PNH07308.1 47790 g4162 i0 65.9 0.436170212765957 41 14 43.6 0 2 124 2 42 PNH07308.1 Iron-sulfur cluster assembly 2, mitochondrial [Tetrabaena socialis] diamond 123 54.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Tetrabaenaceae Tetrabaena Tetrabaena socialis

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