RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA773778" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA773778 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
31127194 31127194 PRJNA773778_S_NODE_12295_length_397_cov_4.975309_g12145_i0 PRJNA773778 12295 397 4.975309 19.75197673 Cymbomonas tetramitiformis 36881 Plants Plants 60.5 3.97e-8   NR KAK3236989.1 36881 g12145 i0 35.4 0.619647355163728 82 53 62 0 3 248 116 197 KAK3236989.1 hypothetical protein CYMTET_52902 [Cymbomonas tetramitiformis] diamond 246 60.5 1 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Cymbomonas Cymbomonas tetramitiformis
31412218 31412218 PRJNA773778_S_NODE_9596_length_437_cov_3.859890_g9446_i0 PRJNA773778 9596 437 3.85989 16.8677193 Sanguina aurantia 2578422 Plants Plants 67.4 7.83e-10   NR MEW5310664.1 2578422 g9446 i0 56.3 0.638443935926774 48 21 33 0 435 292 1106 1153 MEW5310664.1 hypothetical protein [Sanguina aurantia] diamond 279 67.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Sanguina Sanguina aurantia
31760057 31760057 PRJNA773778_S_NODE_27757_length_291_cov_8.788991_g27607_i0 PRJNA773778 27757 291 8.788991 25.57596381 Micromonas pusilla CCMP1545 564608 Plants Plants 45.8 0.00504   NR XP_003063541.1 564608 g27607 i0 51.4 0.360824742268041 35 17 36.1 0 286 182 333 367 XP_003063541.1 uncharacterized protein MICPUCDRAFT_48890 [Micromonas pusilla CCMP1545] diamond 105 45.8 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
32780873 32780873 PRJNA773778_S_NODE_21520_length_320_cov_5.959514_g21370_i0 PRJNA773778 21520 320 5.959514 19.0704448 Viridiplantae 33090 Plants Plants 75.9 1.19e-14   NR QDZ24001.1 1764295 g21370 i0 60.3 1.790625 63 25 59.1 0 320 132 92 154 QDZ24001.1 N-acetyltransferase [Chloropicon primus] diamond 573 76.6 0.990861618798956 Eukaryota   Viridiplantae Chlorophyta Chloropicophyceae Chloropicales Chloropicaceae Chloropicon Chloropicon primus

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