RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA896758" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA896758 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
16175631 16175631 PRJNA896758_P_NODE_3513_length_613_cov_2.694444_g3132_i0 PRJNA896758 3513 613 2.694444 16.51694172 Chlorophyta 3041 Plants Plants 248 8.85e-74   NR PRW32846.1 3076 g3132 i0 74.9 28.1500815660685 179 45 87.6 0 613 77 2 180 PRW32846.1 60S ribosomal L19-2 isoform A [Chlorella sorokiniana] diamond 17256 248 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
26707214 26707214 PRJNA896758_P_NODE_8461_length_390_cov_1.353312_g8071_i0 PRJNA896758 8461 390 1.353312 5.2779168 Cymbomonas tetramitiformis 36881 Plants Plants 80.1 1.62e-14   NR KAK3288761.1 36881 g8071 i0 51 0.784615384615385 102 47 77.7 3 347 45 125 224 KAK3288761.1 hypothetical protein CYMTET_3778 [Cymbomonas tetramitiformis] diamond 306 80.1 1 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Cymbomonas Cymbomonas tetramitiformis
27348078 27348078 PRJNA896758_P_NODE_21863_length_250_cov_0.870056_g21473_i0 PRJNA896758 21863 250 0.870056 2.17514 Coccomyxa 41891 Plants Plants 57 4.01e-7   NR CAL8470626.1 1965095 g21473 i0 44.6 4.104 65 36 78 0 201 7 1735 1799 CAL8470626.1 g10168 [Coccomyxa elongata] diamond 1026 57 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa elongata
27498175 27498175 PRJNA896758_P_NODE_12803_length_321_cov_1.862903_g12413_i0 PRJNA896758 12803 321 1.862903 5.97991863 Chlorella desiccata (nom. nud.) 1650286 Plants Plants 45.8 0.00297   NR KAG7671249.1 1650286 g12413 i0 49.2 0.570093457943925 61 23 49.5 2 320 162 81 141 KAG7671249.1 hypothetical protein KSW81_003387 [Chlorella desiccata (nom. nud.)] diamond 183 45.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Nannochloris Nannochloris sp. 'desiccata'
27529636 27529636 PRJNA896758_P_NODE_9643_length_367_cov_1.897959_g9253_i0 PRJNA896758 9643 367 1.897959 6.96550953 Volvox carteri f. nagariensis 3068 Plants Plants 51.6 9.71e-5   NR XP_002957370.1 3068 g9253 i0 41.3 1.25068119891008 63 37 51.5 0 84 272 40 102 XP_002957370.1 chitinase, lysozyme [Volvox carteri f. nagariensis] diamond 459 51.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox carteri
27568845 27568845 PRJNA896758_P_NODE_18344_length_271_cov_1.742424_g17954_i0 PRJNA896758 18344 271 1.742424 4.72196904 Opisthokonta 33154 Plants Plants 151 2.98e-40   NR XP_002507787.1 296587 g17954 i0 78.9 10.9594095940959 90 19 99.6 0 2 271 1333 1422 XP_002507787.1 isocitrate dehydrogenase/citrate hydrolyase [Micromonas commoda] diamond 2970 152 0.993421052631579 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
27845218 27845218 PRJNA896758_P_NODE_17564_length_277_cov_0.906863_g17174_i0 PRJNA896758 17564 277 0.906863 2.51201051 Volvox carteri f. nagariensis 3068 Plants Plants 45.1 0.00633   NR XP_002948120.1 3068 g17174 i0 43.1 0.703971119133574 65 31 70.4 1 75 269 130 188 XP_002948120.1 uncharacterized protein VOLCADRAFT_88419 [Volvox carteri f. nagariensis] diamond 195 45.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox carteri
28318955 28318955 PRJNA896758_P_NODE_25126_length_244_cov_0.900585_g24736_i0 PRJNA896758 25126 244 0.900585 2.1974274 [Myrmecia] bisecta 41462 Plants Plants 45.1 0.00569   NR KAK9803630.1 41462 g24736 i0 36.8 0.700819672131147 57 36 70.1 0 173 3 509 565 KAK9803630.1 hypothetical protein WJX72_007017 [[Myrmecia] bisecta] diamond 171 45.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia [Myrmecia] bisecta
28540258 28540258 PRJNA896758_P_NODE_14487_length_301_cov_1.877193_g14097_i0 PRJNA896758 14487 301 1.877193 5.65035093 Monoraphidium minutum 39955 Plants Plants 42.4 0.0296   NR KAI8470570.1 39955 g14097 i0 66.7 0.32890365448505 33 10 32.9 1 74 172 53 84 KAI8470570.1 MAG: hypothetical protein J3K34DRAFT_468978 [Monoraphidium minutum] diamond 99 42.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium minutum
29266044 29266044 PRJNA896758_P_NODE_23749_length_246_cov_1.780347_g23359_i0 PRJNA896758 23749 246 1.780347 4.37965362 [Myrmecia] bisecta 41462 Plants Plants 45.4 0.00447   NR KAK9816436.1 41462 g23359 i0 32.1 0.98780487804878 81 50 98.8 1 1 243 243 318 KAK9816436.1 hypothetical protein WJX72_000212 [[Myrmecia] bisecta] diamond 243 45.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia [Myrmecia] bisecta
29707830 29707830 PRJNA896758_P_NODE_26470_length_241_cov_0.916667_g26080_i0 PRJNA896758 26470 241 0.916667 2.20916747 Volvox africanus 51714 Plants Plants 52.8 8.05e-6   NR GLI69515.1 51714 g26080 i0 33.8 2.73858921161826 74 48 92.1 1 228 7 154 226 GLI69515.1 hypothetical protein VaNZ11_014151 [Volvox africanus] diamond 660 52.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox africanus
30498065 30498065 PRJNA896758_P_NODE_16013_length_287_cov_1.359813_g15623_i0 PRJNA896758 16013 287 1.359813 3.90266331 Cymbomonas tetramitiformis 36881 Plants Plants 92.8 1.6e-19   NR KAK3236683.1 36881 g15623 i0 51.1 1.8397212543554 90 38 88.9 3 16 270 496 584 KAK3236683.1 hypothetical protein CYMTET_53189 [Cymbomonas tetramitiformis] diamond 528 92.8 1 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Cymbomonas Cymbomonas tetramitiformis
30505784 30505784 PRJNA896758_P_NODE_23933_length_246_cov_0.890173_g23543_i0 PRJNA896758 23933 246 0.890173 2.18982558 Eukaryota 2759 Plants Plants 61.6 4.13e-9   NR KAF5838424.1 3046 g23543 i0 46.2 2.3780487804878 65 35 79.3 0 52 246 1 65 KAF5838424.1 ribosomal protein L10-domain-containing protein [Dunaliella salina] diamond 585 61.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella salina
30687502 30687502 PRJNA896758_P_NODE_24753_length_244_cov_1.637427_g24363_i0 PRJNA896758 24753 244 1.637427 3.99532188 Chlorella desiccata (nom. nud.) 1650286 Plants Plants 70.9 4.61e-12   NR KAL4531732.1 1650286 g24363 i0 39 3 82 48 98.4 1 243 4 164 245 KAL4531732.1 hypothetical protein Ndes2437A_g09046 [Chlorella desiccata (nom. nud.)] diamond 732 70.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Nannochloris Nannochloris sp. 'desiccata'
31066948 31066948 PRJNA896758_P_NODE_20535_length_255_cov_1.692308_g20145_i0 PRJNA896758 20535 255 1.692308 4.3153854 Chloropicon primus 1764295 Plants Plants 75.1 1.74e-13   NR QDZ21294.1 1764295 g20145 i0 51.7 1.02352941176471 87 35 98.8 2 3 254 503 585 QDZ21294.1 kinesin [Chloropicon primus] diamond 261 75.1 1 Eukaryota   Viridiplantae Chlorophyta Chloropicophyceae Chloropicales Chloropicaceae Chloropicon Chloropicon primus
31161192 31161192 PRJNA896758_P_NODE_26115_length_242_cov_0.911243_g25725_i0 PRJNA896758 26115 242 0.911243 2.20520806 Monoraphidium neglectum 145388 Plants Plants 75.5 1.08e-13   NR XP_013902452.1 145388 g25725 i0 62.5 1.38842975206612 56 21 69.4 0 238 71 139 194 XP_013902452.1 leucyl aminopeptidase [Monoraphidium neglectum] diamond 336 75.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium neglectum
31604386 31604386 PRJNA896758_P_NODE_25396_length_243_cov_0.905882_g25006_i0 PRJNA896758 25396 243 0.905882 2.20129326 Cymbomonas tetramitiformis 36881 Plants Plants 75.5 7.75e-14   NR KAK3270138.1 36881 g25006 i0 58.8 3.33333333333333 68 28 84 0 38 241 207 274 KAK3270138.1 hypothetical protein CYMTET_21452 [Cymbomonas tetramitiformis] diamond 810 75.5 1 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Cymbomonas Cymbomonas tetramitiformis
31793866 31793866 PRJNA896758_P_NODE_25997_length_242_cov_0.911243_g25607_i0 PRJNA896758 25997 242 0.911243 2.20520806 Bathycoccus prasinos 41875 Plants Plants 49.7 2.81e-5   NR XP_007509562.1 41875 g25607 i0 43.9 0.706611570247934 57 28 65.7 1 74 232 66 122 XP_007509562.1 predicted protein [Bathycoccus prasinos] diamond 171 49.7 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Bathycoccus Bathycoccus prasinos
32466487 32466487 PRJNA896758_P_NODE_20659_length_254_cov_1.696133_g20269_i0 PRJNA896758 20659 254 1.696133 4.30817782 Chlorophyta 3041 Plants Plants 63.2 2.64e-9   NR XP_003062842.1 564608 g20269 i0 48.6 1.62992125984252 70 34 82.7 1 42 251 155 222 XP_003062842.1 cation diffusion facilitator family [Micromonas pusilla CCMP1545] diamond 414 63.2 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
32624042 32624042 PRJNA896758_P_NODE_26620_length_241_cov_0.916667_g26230_i0 PRJNA896758 26620 241 0.916667 2.20916747 Viridiplantae 33090 Plants Plants 103 1.4599999999999995e-23   NR XP_003081904.2 70448 g26230 i0 71.4 4.65560165975104 63 16 75.9 1 241 59 433 495 XP_003081904.2 Glycosyl transferase, family 35 [Ostreococcus tauri] diamond 1122 104 0.990384615384615 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri

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