contig_metadata
16 rows where bioproject = "PRJNA603943", tax_clade = "Opisthokonta" and tax_phylum = "Echinodermata"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19703275 | 19703275 | PRJNA603943_P_NODE_21176_length_375_cov_1.152318_g20984_i0 | PRJNA603943 | 21176 | 375 | 1.152318 | 4.3211925 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 580 | 3.68e-161 | NTclustered | gi|116834194|gb|EF032038.1| | 307972 | g20984 | i0 | 98.777 | 1.01333333333333 | 327 | 2 | 87 | 1 | 1 | 327 | 190 | 514 | Apostichopus japonicus clone AH049 microsatellite sequence | blastn | 380 | 580 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 22254631 | 22254631 | PRJNA603943_P_NODE_52618_length_251_cov_0.865169_g52426_i0 | PRJNA603943 | 52618 | 251 | 0.865169 | 2.17157419 | Stichopus oshimae | 7693 | Echinodermata | other_Eukaryota | 67.6 | 8.12e-7 | NTclustered | gi|10196|emb|X01002.1| | 7693 | g52426 | i0 | 97.436 | 0.302788844621514 | 39 | 1 | 16 | 0 | 112 | 150 | 1 | 39 | Stichopus oshimae 5S rRNA sequence | blastn | 76 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Stichopus | Stichopus oshimae | |
| 26744714 | 26744714 | PRJNA603943_P_NODE_3021_length_834_cov_1.738502_g2862_i0 | PRJNA603943 | 3021 | 834 | 1.738502 | 14.49910668 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 135 | 4.2499999999999996e-32 | NR | XP_022081188.1 | 133434 | g2862 | i0 | 39.7 | 3.11870503597122 | 174 | 93 | 60.8 | 4 | 3 | 509 | 388 | 554 | XP_022081188.1 uncharacterized protein LOC110974122 [Acanthaster planci] | diamond | 2601 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 26890380 | 26890380 | PRJNA603943_P_NODE_58501_length_248_cov_0.880000_g58309_i0 | PRJNA603943 | 58501 | 248 | 0.88 | 2.1824 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 49.7 | 1.39e-4 | NR | PIK59500.1 | 307972 | g58309 | i0 | 74.2 | 0.375 | 31 | 8 | 37.5 | 0 | 181 | 89 | 323 | 353 | PIK59500.1 putative zinc finger CCCH-type containing 15 [Apostichopus japonicus] | diamond | 93 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27282961 | 27282961 | PRJNA603943_P_NODE_53283_length_251_cov_0.865169_g53091_i0 | PRJNA603943 | 53283 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 53.9 | 1e-6 | NR | XP_038059709.1 | 46514 | g53091 | i0 | 44.9 | 4.23107569721116 | 69 | 37 | 81.3 | 1 | 249 | 46 | 63 | 131 | XP_038059709.1 microsomal glutathione S-transferase 3-like [Patiria miniata] | diamond | 1062 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27396225 | 27396225 | PRJNA603943_P_NODE_50263_length_258_cov_1.654054_g50071_i0 | PRJNA603943 | 50263 | 258 | 1.654054 | 4.26745932 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 73.9 | 4.6e-13 | NR | PIK42423.1 | 307972 | g50071 | i0 | 100 | 0.372093023255814 | 32 | 0 | 37.2 | 0 | 163 | 258 | 1 | 32 | PIK42423.1 hypothetical protein BSL78_20719 [Apostichopus japonicus] | diamond | 96 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27648772 | 27648772 | PRJNA603943_P_NODE_69544_length_241_cov_0.916667_g69352_i0 | PRJNA603943 | 69544 | 241 | 0.916667 | 2.20916747 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 76.6 | 2.39e-14 | NR | PIK58224.1 | 307972 | g69352 | i0 | 100 | 0.485477178423237 | 39 | 0 | 48.5 | 0 | 107 | 223 | 273 | 311 | PIK58224.1 putative 5'-3' exoribonuclease 1-like [Apostichopus japonicus] | diamond | 117 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27964312 | 27964312 | PRJNA603943_P_NODE_57825_length_248_cov_0.880000_g57633_i0 | PRJNA603943 | 57825 | 248 | 0.88 | 2.1824 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 118 | 2.8e-30 | NR | KAJ8026355.1 | 206669 | g57633 | i0 | 89.6 | 0.810483870967742 | 67 | 7 | 81 | 0 | 2 | 202 | 237 | 303 | KAJ8026355.1 TWiK family of potassium channels protein 9 [Holothuria leucospilota] | diamond | 201 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28248341 | 28248341 | PRJNA603943_P_NODE_32146_length_321_cov_0.794355_g31954_i0 | PRJNA603943 | 32146 | 321 | 0.794355 | 2.54987955 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 90.1 | 2.12e-18 | NR | PIK46803.1 | 307972 | g31954 | i0 | 95.7 | 0.439252336448598 | 47 | 2 | 43.9 | 0 | 123 | 263 | 47 | 93 | PIK46803.1 putative cat eye syndrome critical region protein 2-like isoform X2 [Apostichopus japonicus] | diamond | 141 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 28753682 | 28753682 | PRJNA603943_P_NODE_2647_length_879_cov_1.488834_g2495_i0 | PRJNA603943 | 2647 | 879 | 1.488834 | 13.08685086 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 60.8 | 1.56e-6 | NR | XP_041457912.1 | 7654 | g2495 | i0 | 34.2 | 0.378839590443686 | 111 | 70 | 37.9 | 3 | 148 | 480 | 191 | 298 | XP_041457912.1 uncharacterized protein LOC121410105 [Lytechinus variegatus] | diamond | 333 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28753711 | 28753711 | PRJNA603943_P_NODE_63867_length_245_cov_0.895349_g63675_i0 | PRJNA603943 | 63867 | 245 | 0.895349 | 2.19360505 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 69.7 | 1.22e-11 | NR | KAJ8036972.1 | 206669 | g63675 | i0 | 81.8 | 0.538775510204082 | 44 | 8 | 53.9 | 0 | 3 | 134 | 406 | 449 | KAJ8036972.1 Kinesin-like protein KIF19 [Holothuria leucospilota] | diamond | 132 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31009462 | 31009462 | PRJNA603943_P_NODE_35034_length_309_cov_1.449153_g34842_i0 | PRJNA603943 | 35034 | 309 | 1.449153 | 4.47788277 | root | 1 | Root_unresolved | Root_unresolved | 91.7 | 5.12e-19 | NR | XP_038074569.1 | 46514 | g34842 | i0 | 48.4 | 7.6504854368932 | 95 | 34 | 92.2 | 2 | 24 | 308 | 424 | 503 | XP_038074569.1 dye-decolorizing peroxidase msp1-like [Patiria miniata] | diamond | 2364 | 92 | 0.996739130434783 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31547165 | 31547165 | PRJNA603943_P_NODE_69416_length_241_cov_0.916667_g69224_i0 | PRJNA603943 | 69416 | 241 | 0.916667 | 2.20916747 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 43.5 | 0.0182 | NR | KAJ8044767.1 | 206669 | g69224 | i0 | 77.3 | 0.547717842323652 | 22 | 5 | 27.4 | 0 | 130 | 195 | 193 | 214 | KAJ8044767.1 Protein STPG4 [Holothuria leucospilota] | diamond | 132 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32134910 | 32134910 | PRJNA603943_P_NODE_64758_length_244_cov_0.900585_g64566_i0 | PRJNA603943 | 64758 | 244 | 0.900585 | 2.1974274 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 55.8 | 9.01e-7 | NR | PIK43806.1 | 307972 | g64566 | i0 | 96.4 | 0.344262295081967 | 28 | 1 | 34.4 | 0 | 118 | 201 | 2 | 29 | PIK43806.1 putative trafficking kinesin-binding protein 1 [Apostichopus japonicus] | diamond | 84 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32577855 | 32577855 | PRJNA603943_P_NODE_70439_length_241_cov_0.916667_g70247_i0 | PRJNA603943 | 70439 | 241 | 0.916667 | 2.20916747 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 45.8 | 0.00286 | NR | PIK38398.1 | 307972 | g70247 | i0 | 86.4 | 0.560165975103734 | 22 | 3 | 27.4 | 0 | 95 | 160 | 125 | 146 | PIK38398.1 hypothetical protein BSL78_24766 [Apostichopus japonicus] | diamond | 135 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32797847 | 32797847 | PRJNA603943_P_NODE_56480_length_249_cov_0.875000_g56288_i0 | PRJNA603943 | 56480 | 249 | 0.875 | 2.17875 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 168 | 1.4e-48 | NR | PIK56379.1 | 307972 | g56288 | i0 | 100 | 1.96385542168675 | 81 | 0 | 97.6 | 0 | 5 | 247 | 1 | 81 | PIK56379.1 hypothetical protein BSL78_06753 [Apostichopus japonicus] | diamond | 489 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus |
Advanced export
JSON shape: default, array, newline-delimited
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);;