RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1016321 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
2710037 2710037 PRJNA1016321_P_NODE_39843_length_281_cov_1.197115_g39612_i0 PRJNA1016321 39843 281 1.197115 3.36389315 Micractinium tetrahymenae 2728915 Plants Plants 181 2.7699999999999997e-56   NR KAL4444291.1 2728915 g39612 i0 93.5 0.99288256227758 93 6 99.3 0 1 279 81 173 KAL4444291.1 hypothetical protein ABPG75_012028 [Micractinium tetrahymenae] diamond 279 181 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium tetrahymenae
27121591 27121591 PRJNA1016321_P_NODE_53522_length_244_cov_0.900585_g53291_i0 PRJNA1016321 53522 244 0.900585 2.1974274 Micractinium 126838 Plants Plants 106 3.6e-27   NR KAL4438718.1 554058 g53291 i0 85.2 1.48770491803279 61 8 73.8 1 234 55 87 147 KAL4438718.1 hypothetical protein ABPG77_006322 [Micractinium sp. CCAP 211/92] diamond 363 106 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92
27666900 27666900 PRJNA1016321_P_NODE_53644_length_244_cov_0.900585_g53413_i0 PRJNA1016321 53644 244 0.900585 2.1974274 Micractinium tetrahymenae 2728915 Plants Plants 53.9 4.44e-6   NR KAL4457275.1 2728915 g53413 i0 74.3 0.430327868852459 35 7 43 1 22 126 987 1019 KAL4457275.1 hypothetical protein ABPG75_012140 [Micractinium tetrahymenae] diamond 105 53.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium tetrahymenae
28677204 28677204 PRJNA1016321_P_NODE_49087_length_249_cov_2.335227_g48856_i0 PRJNA1016321 49087 249 2.335227 5.81471523 Micractinium sp. CCAP 211/92 554058 Plants Plants 68.2 4.55e-11   NR KAL4419243.1 554058 g48856 i0 94.9 0.469879518072289 39 2 47 0 249 133 716 754 KAL4419243.1 hypothetical protein ABPG77_001181 [Micractinium sp. CCAP 211/92] diamond 117 68.2 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92
29087725 29087725 PRJNA1016321_P_NODE_57368_length_230_cov_2.452229_g57137_i0 PRJNA1016321 57368 230 2.452229 5.6401267 Micractinium sp. CCAP 211/92 554058 Plants Plants 57.8 1.65e-8   NR KAL4427330.1 554058 g57137 i0 68.4 1.55217391304348 38 12 49.6 0 114 1 13 50 KAL4427330.1 hypothetical protein ABPG77_003239 [Micractinium sp. CCAP 211/92] diamond 357 57.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92
29497991 29497991 PRJNA1016321_P_NODE_36810_length_294_cov_1.045249_g36579_i0 PRJNA1016321 36810 294 1.045249 3.07303206 Micractinium sp. CCAP 211/92 554058 Plants Plants 63.5 2.56e-9   NR KAL4450700.1 554058 g36579 i0 90.9 0.336734693877551 33 3 33.7 0 195 293 72 104 KAL4450700.1 hypothetical protein ABPG77_001056 [Micractinium sp. CCAP 211/92] diamond 99 63.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92
30003423 30003423 PRJNA1016321_P_NODE_51331_length_247_cov_0.885057_g51100_i0 PRJNA1016321 51331 247 0.885057 2.18609079 Micractinium sp. CCAP 211/92 554058 Plants Plants 47 0.00106   NR KAL4451430.1 554058 g51100 i0 89.3 0.340080971659919 28 3 34 0 243 160 219 246 KAL4451430.1 hypothetical protein ABPG77_009502 [Micractinium sp. CCAP 211/92] diamond 84 47 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92
30034974 30034974 PRJNA1016321_P_NODE_34111_length_308_cov_1.063830_g33880_i0 PRJNA1016321 34111 308 1.06383 3.2765964 Micractinium sp. CCAP 211/92 554058 Plants Plants 62.4 1.06e-9   NR KAL4438997.1 554058 g33880 i0 58.8 0.662337662337662 68 24 64.3 2 91 288 8 73 KAL4438997.1 hypothetical protein ABPG77_006934 [Micractinium sp. CCAP 211/92] diamond 204 62.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92
31710008 31710008 PRJNA1016321_P_NODE_27457_length_351_cov_1.107914_g27226_i0 PRJNA1016321 27457 351 1.107914 3.88877814 Micractinium sp. CCAP 211/92 554058 Plants Plants 94 1.24e-21   NR KAL4425101.1 554058 g27226 i0 84 0.427350427350427 50 8 42.7 0 320 171 107 156 KAL4425101.1 hypothetical protein ABPG77_010415 [Micractinium sp. CCAP 211/92] diamond 150 94 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92
31741479 31741479 PRJNA1016321_P_NODE_40097_length_280_cov_1.115942_g39866_i0 PRJNA1016321 40097 280 1.115942 3.1246376 Micractinium tetrahymenae 2728915 Plants Plants 167 1.03e-47   NR KAL4443353.1 2728915 g39866 i0 93.1 0.932142857142857 87 6 93.2 0 1 261 360 446 KAL4443353.1 hypothetical protein ABPG75_011090 [Micractinium tetrahymenae] diamond 261 167 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium tetrahymenae
32026352 32026352 PRJNA1016321_P_NODE_12918_length_551_cov_2.257322_g12695_i0 PRJNA1016321 12918 551 2.257322 12.43784422 Micractinium sp. CCAP 211/92 554058 Plants Plants 234 4.46e-74   NR KAL4424901.1 554058 g12695 i0 88.3 0.696914700544465 128 15 69.7 0 1 384 172 299 KAL4424901.1 hypothetical protein ABPG77_002124 [Micractinium sp. CCAP 211/92] diamond 384 234 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Micractinium Micractinium sp. CCAP 211/92

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