RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1073712" 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 · 15 ✖

bioproject 1

  • PRJNA1073712 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
4014026 4014026 PRJNA1073712_P_NODE_15644_length_243_cov_0.905882_g15561_i0 PRJNA1073712 15644 243 0.905882 2.20129326 Bryopsis sp. KO-2 3115439 Plants Plants 69.3 9.16e-12   NR GMH41502.1 3041901 g15561 i0 65.5 0.716049382716049 58 19 70.4 1 242 72 120 177 GMH41502.1 hypothetical protein BSKO_09412 [Bryopsis sp. KO-2023] diamond 174 69.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Bryopsidaceae Bryopsis Bryopsis sp. KO-2023
4844324 4844324 PRJNA1073712_P_NODE_8844_length_273_cov_1.445000_g8761_i0 PRJNA1073712 8844 273 1.445 3.94485 Chlorellaceae 35461 Plants Plants 121 1.04e-29   NR PSC69277.1 554055 g8761 i0 67.8 3.95604395604396 90 29 98.9 0 272 3 148 237 PSC69277.1 60S ribosomal L4-1 [Micractinium conductrix] diamond 1080 121 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium conductrix
15043871 15043871 PRJNA1073712_P_NODE_5992_length_312_cov_1.288703_g5909_i0 PRJNA1073712 5992 312 1.288703 4.02075336 Chlorophyta 3041 Plants Plants 181 2.1499999999999998e-52   NR KAG2436894.1 51695 g5909 i0 82.5 10.8846153846154 103 18 99 0 310 2 337 439 KAG2436894.1 hypothetical protein HXX76_006413 [Chlamydomonas incerta] diamond 3396 182 0.994505494505495 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas incerta
16764462 16764462 PRJNA1073712_P_NODE_11574_length_250_cov_1.615819_g11491_i0 PRJNA1073712 11574 250 1.615819 4.0395475 Trebouxia sp. C 2796353 Plants Plants 139 1.35e-38   NR KAL0031497.1 2905653 g11491 i0 79.5 0.996 83 17 99.6 0 1 249 79 161 KAL0031497.1 hypothetical protein WJX77_003436 [Trebouxia sp. C0004] diamond 249 139 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. C0004
27438418 27438418 PRJNA1073712_P_NODE_13083_length_248_cov_0.880000_g13000_i0 PRJNA1073712 13083 248 0.88 2.1824 Trebouxia 13786 Plants Plants 84 1.24e-16   NR KAL3140017.1 3373144 g13000 i0 48 4.54838709677419 75 39 90.7 0 226 2 904 978 KAL3140017.1 Acid phosphatase pho1 [Trebouxia sp. C0009 RCD-2024] diamond 1128 84 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. C0009 RCD-2024
27438419 27438419 PRJNA1073712_P_NODE_14883_length_244_cov_1.719298_g14800_i0 PRJNA1073712 14883 244 1.719298 4.19508712 Eukaryota 2759 Plants Plants 92.4 1.26e-19   NR AYF56515.1 270643 g14800 i0 63.9 2.79098360655738 72 26 88.5 0 222 7 597 668 AYF56515.1 heat shock protein 100 [Tetraselmis suecica] diamond 681 92.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorodendrophyceae Chlorodendrales Chlorodendraceae Tetraselmis Tetraselmis suecica
28646551 28646551 PRJNA1073712_P_NODE_9267_length_269_cov_1.280612_g9184_i0 PRJNA1073712 9267 269 1.280612 3.44484628 Coccomyxa viridis 1274662 Plants Plants 60.1 4.11e-8   NR CAK0763899.1 1274662 g9184 i0 39 0.858736059479554 77 45 85.9 2 261 31 445 519 CAK0763899.1 hypothetical protein CVIRNUC_003104 [Coccomyxa viridis] diamond 231 60.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa viridis
29080069 29080069 PRJNA1073712_P_NODE_11668_length_250_cov_0.870056_g11585_i0 PRJNA1073712 11668 250 0.870056 2.17514 Trebouxia 13786 Plants Plants 142 3.8399999999999995e-37   NR KAL0033728.1 2905653 g11585 i0 78.3 5.976 83 18 99.6 0 249 1 1469 1551 KAL0033728.1 hypothetical protein WJX77_002831 [Trebouxia sp. C0004] diamond 1494 143 0.993006993006993 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. C0004
29877974 29877974 PRJNA1073712_P_NODE_15031_length_244_cov_0.900585_g14948_i0 PRJNA1073712 15031 244 0.900585 2.1974274 Trebouxia sp. A1-2 2608996 Plants Plants 88.2 8.2e-19   NR KAA6423416.1 2608996 g14948 i0 60.3 0.836065573770492 68 25 83.6 1 41 244 16 81 KAA6423416.1 MAG: mitochondrial prohibitin complex 2 [Trebouxia sp. A1-2] diamond 204 88.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. A1-2
30004315 30004315 PRJNA1073712_P_NODE_9271_length_269_cov_1.260204_g9188_i0 PRJNA1073712 9271 269 1.260204 3.38994876 [Myrmecia] bisecta 41462 Plants Plants 108 2.6999999999999997e-25   NR KAK9812801.1 41462 g9188 i0 72.5 4.95167286245353 69 19 77 0 261 55 513 581 KAK9812801.1 hypothetical protein WJX72_004059 [[Myrmecia] bisecta] diamond 1332 108 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia [Myrmecia] bisecta
30098863 30098863 PRJNA1073712_P_NODE_8932_length_272_cov_1.547739_g8849_i0 PRJNA1073712 8932 272 1.547739 4.20985008 Coccomyxa sp. Obi 2315456 Plants Plants 115 1.14e-30   NR BDA42369.1 2315456 g8849 i0 60.4 1.00367647058824 91 35 99.3 1 3 272 44 134 BDA42369.1 40S ribosomal protein S19 [Coccomyxa sp. Obi] diamond 273 115 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa sp. Obi
30257334 30257334 PRJNA1073712_P_NODE_14912_length_244_cov_1.421053_g14829_i0 PRJNA1073712 14912 244 1.421053 3.46736932 [Myrmecia] bisecta 41462 Plants Plants 115 3.63e-28   NR KAK9808917.1 41462 g14829 i0 71.8 1.91803278688525 78 19 95.9 1 242 9 79 153 KAK9808917.1 hypothetical protein WJX72_006399 [[Myrmecia] bisecta] diamond 468 115 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia [Myrmecia] bisecta
30690738 30690738 PRJNA1073712_P_NODE_16153_length_242_cov_0.911243_g16070_i0 PRJNA1073712 16153 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 79 5.04e-15   NR CAD7697287.1 121088 g16070 i0 67.9 31.2272727272727 56 18 69.4 0 74 241 9 64 CAD7697287.1 unnamed protein product [Ostreobium quekettii] diamond 7557 79 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Ostreobiaceae Ostreobium Ostreobium quekettii
30825640 30825640 PRJNA1073712_P_NODE_8414_length_278_cov_1.200000_g8331_i0 PRJNA1073712 8414 278 1.2 3.336 Chlorella desiccata (nom. nud.) 1650286 Plants Plants 63.9 7.04e-10   NR KAG7668415.1 1650286 g8331 i0 46.4 2.71942446043165 84 40 85.3 2 278 42 81 164 KAG7668415.1 hypothetical protein KSW81_002300 [Chlorella desiccata (nom. nud.)] diamond 756 63.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Nannochloris Nannochloris sp. 'desiccata'
30857223 30857223 PRJNA1073712_P_NODE_11734_length_250_cov_0.870056_g11651_i0 PRJNA1073712 11734 250 0.870056 2.17514 Ostreobium quekettii 121088 Plants Plants 54.3 8.92e-7   NR CAD7701618.1 121088 g11651 i0 36.8 0.912 76 42 91.2 2 237 10 10 79 CAD7701618.1 unnamed protein product [Ostreobium quekettii] diamond 228 54.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Ostreobiaceae Ostreobium Ostreobium quekettii

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