contig_metadata
12 rows where bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26635307 | 26635307 | PRJNA556992_P_NODE_518321_length_265_cov_4.822917_g516132_i0 | PRJNA556992 | 518321 | 265 | 4.822917 | 12.78073005 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 52 | 2.61e-5 | NR | PIK59741.1 | 307972 | g516132 | i0 | 38.2 | 4.3811320754717 | 76 | 46 | 84.9 | 1 | 258 | 34 | 330 | 405 | PIK59741.1 putative actin-related protein 6 [Apostichopus japonicus] | diamond | 1161 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27219065 | 27219065 | PRJNA556992_P_NODE_455502_length_271_cov_2.116162_g453313_i0 | PRJNA556992 | 455502 | 271 | 2.116162 | 5.73479902 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 84.7 | 8.78e-17 | NR | KAJ8024825.1 | 206669 | g453313 | i0 | 64.4 | 5.22509225092251 | 59 | 21 | 65.3 | 0 | 179 | 3 | 716 | 774 | KAJ8024825.1 Vacuolar protein sorting-associated protein 41-like [Holothuria leucospilota] | diamond | 1416 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27899541 | 27899541 | PRJNA556992_P_NODE_335905_length_284_cov_1.312796_g333716_i0 | PRJNA556992 | 335905 | 284 | 1.312796 | 3.72834064 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 92.8 | 1.61e-19 | NR | XP_033097872.1 | 1529436 | g333716 | i0 | 46.2 | 4.91197183098592 | 93 | 47 | 98.2 | 1 | 284 | 6 | 479 | 568 | XP_033097872.1 LOW QUALITY PROTEIN: dynein heavy chain 8, axonemal-like [Anneissia japonica] | diamond | 1395 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27977269 | 27977269 | PRJNA556992_P_NODE_973925_length_233_cov_3.250000_g971735_i0 | PRJNA556992 | 973925 | 233 | 3.25 | 7.5725 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 54.3 | 2.77e-6 | NR | XP_022079723.1 | 133434 | g971735 | i0 | 72.4 | 1.1587982832618 | 29 | 7 | 36.1 | 1 | 2 | 85 | 419 | 447 | XP_022079723.1 LOW QUALITY PROTEIN: SWI/SNF-related matrix-associated actin-dependent regulator of chromatin subfamily A-like protein 1 [Acanthaster planci] | diamond | 270 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28215117 | 28215117 | PRJNA556992_P_NODE_199486_length_327_cov_3.578740_g197298_i0 | PRJNA556992 | 199486 | 327 | 3.57874 | 11.7024798 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 58.5 | 2.75e-7 | NR | XP_033100089.1 | 1529436 | g197298 | i0 | 41.1 | 3.3394495412844 | 73 | 43 | 67 | 0 | 78 | 296 | 412 | 484 | XP_033100089.1 heparan-alpha-glucosaminide N-acetyltransferase-like isoform X2 [Anneissia japonica] | diamond | 1092 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28278524 | 28278524 | PRJNA556992_P_NODE_522586_length_265_cov_2.390625_g520397_i0 | PRJNA556992 | 522586 | 265 | 2.390625 | 6.33515625 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 92.4 | 1.5700000000000001e-19 | NR | XP_033106562.1 | 1529436 | g520397 | i0 | 54.3 | 8.2188679245283 | 81 | 34 | 89.4 | 2 | 29 | 265 | 324 | 403 | XP_033106562.1 copine-8-like isoform X2 [Anneissia japonica] | diamond | 2178 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29019477 | 29019477 | PRJNA556992_P_NODE_1080048_length_217_cov_6.423611_g1077857_i0 | PRJNA556992 | 1080048 | 217 | 6.423611 | 13.93923587 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 48.9 | 1.74e-4 | NR | KAJ8023561.1 | 206669 | g1077857 | i0 | 44.2 | 1.28571428571429 | 52 | 23 | 70.5 | 2 | 182 | 30 | 344 | 390 | KAJ8023561.1 Reticulon-4 receptor-like 1 [Holothuria leucospilota] | diamond | 279 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29177267 | 29177267 | PRJNA556992_P_NODE_294549_length_290_cov_1.000000_g292360_i0 | PRJNA556992 | 294549 | 290 | 1 | 2.9 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 46.2 | 0.00363 | NR | XP_041460609.1 | 7654 | g292360 | i0 | 37 | 3.22758620689655 | 81 | 51 | 83.8 | 0 | 290 | 48 | 9 | 89 | XP_041460609.1 protein FAM50A-like [Lytechinus variegatus] | diamond | 936 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30426283 | 30426283 | PRJNA556992_P_NODE_1040873_length_226_cov_3.640523_g1038683_i0 | PRJNA556992 | 1040873 | 226 | 3.640523 | 8.22758198 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 62 | 4.92e-9 | NR | KAJ8047577.1 | 206669 | g1038683 | i0 | 55.6 | 5.8141592920354 | 54 | 23 | 70.4 | 1 | 67 | 225 | 660 | 713 | KAJ8047577.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota] | diamond | 1314 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30440544 | 30440544 | PRJNA556992_P_NODE_146053_length_361_cov_2.496528_g143865_i0 | PRJNA556992 | 146053 | 361 | 2.496528 | 9.01246608 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 59.7 | 1.75e-7 | NR | XP_071477442.1 | 105358 | g143865 | i0 | 42.7 | 4.50415512465374 | 75 | 41 | 61.5 | 2 | 1 | 222 | 763 | 836 | XP_071477442.1 antigen WC1.1-like [Diadema antillarum] | diamond | 1626 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31975255 | 31975255 | PRJNA556992_P_NODE_735158_length_249_cov_2.414773_g732969_i0 | PRJNA556992 | 735158 | 249 | 2.414773 | 6.01278477 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 48.1 | 5.04e-4 | NR | XP_022083184.1 | 133434 | g732969 | i0 | 57.5 | 0.927710843373494 | 40 | 17 | 48.2 | 0 | 247 | 128 | 260 | 299 | XP_022083184.1 inversin-A-like isoform X2 [Acanthaster planci] | diamond | 231 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32747987 | 32747987 | PRJNA556992_P_NODE_547920_length_263_cov_2.063158_g545731_i0 | PRJNA556992 | 547920 | 263 | 2.063158 | 5.42610554 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 50.4 | 9.46e-5 | NR | XP_033647332.1 | 7604 | g545731 | i0 | 39.6 | 11.212927756654 | 53 | 31 | 60.5 | 1 | 98 | 256 | 1715 | 1766 | XP_033647332.1 A disintegrin and metalloproteinase with thrombospondin motifs 9-like [Asterias rubens] | diamond | 2949 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens |
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);;