contig_metadata
11 rows where bioproject = "PRJNA800090", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5902668 | 5902668 | PRJNA800090_P_NODE_46985_length_527_cov_2.327511_g44809_i0 | PRJNA800090 | 46985 | 527 | 2.327511 | 12.26598297 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 115 | 6.5e-21 | NTclustered | gi|2037951426|ref|XM_041620741.1| | 7654 | g44809 | i0 | 79.63 | 1.48007590132827 | 162 | 31 | 31 | 2 | 353 | 513 | 2685 | 2525 | PREDICTED: Lytechinus variegatus nascent polypeptide-associated complex subunit alpha, muscle-specific form-like (LOC121424886), transcript variant X2, mRNA | blastn | 780 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 11004209 | 11004209 | PRJNA800090_P_NODE_99549_length_327_cov_1.131783_g97364_i0 | PRJNA800090 | 99549 | 327 | 1.131783 | 3.70093041 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 146 | 6.729999999999999e-40 | NR | XP_022093919.1 | 133434 | g97364 | i0 | 71.4 | 6.25688073394495 | 91 | 26 | 83.5 | 0 | 326 | 54 | 293 | 383 | XP_022093919.1 obg-like ATPase 1 isoform X4 [Acanthaster planci] | diamond | 2046 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 16522770 | 16522770 | PRJNA800090_P_NODE_101713_length_323_cov_1.047244_g99528_i0 | PRJNA800090 | 101713 | 323 | 1.047244 | 3.38259812 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 140 | 1.62e-37 | NR | XP_038059235.1 | 46514 | g99528 | i0 | 62.4 | 2.02476780185758 | 109 | 36 | 99.4 | 2 | 321 | 1 | 148 | 253 | XP_038059235.1 nucleoredoxin-like [Patiria miniata] | diamond | 654 | 141 | 0.99290780141844 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 17375244 | 17375244 | PRJNA800090_P_NODE_124974_length_285_cov_1.263889_g122789_i0 | PRJNA800090 | 124974 | 285 | 1.263889 | 3.60208365 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 151 | 4.93e-44 | NR | XP_033640423.1 | 7604 | g122789 | i0 | 77.9 | 53 | 95 | 21 | 100 | 0 | 285 | 1 | 22 | 116 | XP_033640423.1 60S ribosomal protein L19-like [Asterias rubens] | diamond | 15105 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27843662 | 27843662 | PRJNA800090_P_NODE_70264_length_407_cov_1.251479_g68079_i0 | PRJNA800090 | 70264 | 407 | 1.251479 | 5.09351953 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 67 | 7.83e-10 | NR | XP_041473160.1 | 7654 | g68079 | i0 | 52.3 | 1.79115479115479 | 65 | 30 | 47.2 | 1 | 83 | 274 | 290 | 354 | XP_041473160.1 transient receptor potential cation channel subfamily A member 1-like [Lytechinus variegatus] | diamond | 729 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28822316 | 28822316 | PRJNA800090_P_NODE_51348_length_498_cov_1.321678_g49166_i0 | PRJNA800090 | 51348 | 498 | 1.321678 | 6.58195644 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 152 | 1.06e-41 | NR | KAJ8036290.1 | 206669 | g49166 | i0 | 57.5 | 3.7710843373494 | 120 | 51 | 72.3 | 0 | 134 | 493 | 100 | 219 | KAJ8036290.1 Alternative oxidase, mitochondrial [Holothuria leucospilota] | diamond | 1878 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29391059 | 29391059 | PRJNA800090_P_NODE_184589_length_231_cov_0.901235_g182404_i0 | PRJNA800090 | 184589 | 231 | 0.901235 | 2.08185285 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 78.2 | 1.09e-14 | NR | XP_071483682.1 | 105358 | g182404 | i0 | 46.1 | 2.88311688311688 | 76 | 41 | 98.7 | 0 | 231 | 4 | 646 | 721 | XP_071483682.1 vacuolar protein sorting-associated protein 11 homolog [Diadema antillarum] | diamond | 666 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31105527 | 31105527 | PRJNA800090_P_NODE_119455_length_293_cov_0.919643_g117270_i0 | PRJNA800090 | 119455 | 293 | 0.919643 | 2.69455399 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 100 | 7.639999999999999e-24 | NR | XP_041473889.1 | 7654 | g117270 | i0 | 48.4 | 1.91467576791809 | 93 | 45 | 94.2 | 2 | 4 | 279 | 104 | 194 | XP_041473889.1 outer membrane lipoprotein Blc-like [Lytechinus variegatus] | diamond | 561 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31231893 | 31231893 | PRJNA800090_P_NODE_115475_length_299_cov_1.230435_g113290_i0 | PRJNA800090 | 115475 | 299 | 1.230435 | 3.67900065 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 61.6 | 4.35e-10 | NR | KAJ8020693.1 | 206669 | g113290 | i0 | 48.4 | 4.5752508361204 | 64 | 33 | 64.2 | 0 | 265 | 74 | 14 | 77 | KAJ8020693.1 Reactive oxygen species modulator 1 [Holothuria leucospilota] | diamond | 1368 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31950584 | 31950584 | PRJNA800090_P_NODE_184717_length_231_cov_0.901235_g182532_i0 | PRJNA800090 | 184717 | 231 | 0.901235 | 2.08185285 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 54.7 | 1.81e-6 | NR | XP_071501689.1 | 105358 | g182532 | i0 | 40.5 | 0.961038961038961 | 74 | 37 | 92.2 | 2 | 230 | 18 | 114 | 183 | XP_071501689.1 serum paraoxonase/arylesterase 2-like [Diadema antillarum] | diamond | 222 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31991147 | 31991147 | PRJNA800090_P_NODE_80698_length_372_cov_1.848185_g78513_i0 | PRJNA800090 | 80698 | 372 | 1.848185 | 6.8752482 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 91.3 | 1.78e-18 | NR | XP_038060559.1 | 46514 | g78513 | i0 | 39.8 | 3.96774193548387 | 123 | 66 | 99.2 | 4 | 1 | 369 | 1339 | 1453 | XP_038060559.1 uncharacterized protein LOC119731463 isoform X1 [Patiria miniata] | diamond | 1476 | 91.7 | 0.995637949836423 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;