contig_metadata
20 rows where bioproject = "PRJEB75230", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136034 | 136034 | PRJEB75230_P_NODE_130361_length_249_cov_0.875000_g130179_i0 | PRJEB75230 | 130361 | 249 | 0.875 | 2.17875 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2919403878|ref|XM_071632303.1| | 105358 | g130179 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 32 | 59 | 2616 | 2643 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139720973), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 995943 | 995943 | PRJEB75230_P_NODE_176081_length_242_cov_0.911243_g175899_i0 | PRJEB75230 | 176081 | 242 | 0.911243 | 2.20520806 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 85.5 | 3.31e-17 | NR | XP_033637674.1 | 7604 | g175899 | i0 | 53.2 | 3.80578512396694 | 77 | 34 | 94.2 | 2 | 1 | 228 | 647 | 722 | XP_033637674.1 multidrug resistance-associated protein 5-like [Asterias rubens] | diamond | 921 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 1412421 | 1412421 | PRJEB75230_P_NODE_8162_length_506_cov_0.928406_g7980_i0 | PRJEB75230 | 8162 | 506 | 0.928406 | 4.69773436 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.049 | NTclustered | gi|2707398240|ref|XM_064104547.1| | 7653 | g7980 | i0 | 100 | 0.0553359683794466 | 28 | 0 | 6 | 0 | 226 | 253 | 1272 | 1299 | PREDICTED: Lytechinus pictus CD151 antigen-like (LOC129268882), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 5240020 | 5240020 | PRJEB75230_P_NODE_5605_length_586_cov_11.370370_g5424_i0 | PRJEB75230 | 5605 | 586 | 11.37037 | 66.6303682 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 164 | 6.62e-48 | NR | XP_033123568.1 | 1529436 | g5424 | i0 | 63 | 1.30546075085324 | 127 | 47 | 65 | 0 | 444 | 64 | 55 | 181 | XP_033123568.1 60S ribosomal protein L23a-like [Anneissia japonica] | diamond | 765 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 16713177 | 16713177 | PRJEB75230_P_NODE_161974_length_244_cov_0.900585_g161792_i0 | PRJEB75230 | 161974 | 244 | 0.900585 | 2.1974274 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2707401160|ref|XM_064113199.1| | 7653 | g161792 | i0 | 94.595 | 1.13934426229508 | 37 | 1 | 15 | 1 | 73 | 108 | 4424 | 4460 | PREDICTED: Lytechinus pictus endosomal/lysosomal proton channel TMEM175-like (LOC129281552), mRNA | blastn | 278 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 19262858 | 19262858 | PRJEB75230_P_NODE_4856_length_624_cov_13.243194_g4675_i0 | PRJEB75230 | 4856 | 624 | 13.243194 | 82.63753056 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 142 | 1.78e-38 | NR | XP_022088490.1 | 133434 | g4675 | i0 | 47.1 | 11.0528846153846 | 189 | 88 | 85.1 | 2 | 571 | 41 | 15 | 203 | XP_022088490.1 40S ribosomal protein S7-like isoform X1 [Acanthaster planci] | diamond | 6897 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 26907655 | 26907655 | PRJEB75230_P_NODE_87382_length_273_cov_1.715000_g87200_i0 | PRJEB75230 | 87382 | 273 | 1.715 | 4.68195 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 50.4 | 1.05e-4 | NR | XP_033632631.1 | 7604 | g87200 | i0 | 31.8 | 0.967032967032967 | 88 | 48 | 94.5 | 4 | 266 | 9 | 658 | 735 | XP_033632631.1 attractin-like protein 1 isoform X3 [Asterias rubens] | diamond | 264 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27002372 | 27002372 | PRJEB75230_P_NODE_7662_length_518_cov_1.496629_g7480_i0 | PRJEB75230 | 7662 | 518 | 1.496629 | 7.75253822 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 79.3 | 5.95e-14 | NR | XP_033102840.1 | 1529436 | g7480 | i0 | 33.3 | 0.955598455598456 | 165 | 103 | 93.2 | 5 | 5 | 487 | 99 | 260 | XP_033102840.1 uncharacterized protein ZK1073.1-like isoform X2 [Anneissia japonica] | diamond | 495 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27216360 | 27216360 | PRJEB75230_P_NODE_49322_length_313_cov_1.283333_g49140_i0 | PRJEB75230 | 49322 | 313 | 1.283333 | 4.01683229 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 110 | 1.03e-25 | NR | XP_038068058.1 | 46514 | g49140 | i0 | 55 | 27.9872204472843 | 100 | 45 | 95.8 | 0 | 13 | 312 | 2 | 101 | XP_038068058.1 vacuolar protein sorting-associated protein 35-like [Patiria miniata] | diamond | 8760 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27248212 | 27248212 | PRJEB75230_P_NODE_3123_length_765_cov_2.119942_g2959_i0 | PRJEB75230 | 3123 | 765 | 2.119942 | 16.2175563 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 236 | 2.2799999999999999e-69 | NR | XP_022090401.1 | 133434 | g2959 | i0 | 49.2 | 8.90588235294118 | 238 | 112 | 90.2 | 4 | 740 | 51 | 417 | 653 | XP_022090401.1 methylenetetrahydrofolate reductase-like isoform X2 [Acanthaster planci] | diamond | 6813 | 236 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27501119 | 27501119 | PRJEB75230_P_NODE_132743_length_249_cov_0.875000_g132561_i0 | PRJEB75230 | 132743 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 7.4e-8 | NR | KAJ8045666.1 | 206669 | g132561 | i0 | 50 | 3.21686746987952 | 62 | 30 | 74.7 | 1 | 242 | 57 | 230 | 290 | KAJ8045666.1 Kelch domain-containing protein 3 [Holothuria leucospilota] | diamond | 801 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27824109 | 27824109 | PRJEB75230_P_NODE_71104_length_288_cov_1.065116_g70922_i0 | PRJEB75230 | 71104 | 288 | 1.065116 | 3.06753408 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 45.1 | 0.00996 | NR | KAJ8034571.1 | 206669 | g70922 | i0 | 40.6 | 1.4375 | 69 | 33 | 66.7 | 3 | 94 | 285 | 27 | 92 | KAJ8034571.1 hypothetical protein HOLleu_21466 [Holothuria leucospilota] | diamond | 414 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27981866 | 27981866 | PRJEB75230_P_NODE_172005_length_242_cov_1.804734_g171823_i0 | PRJEB75230 | 172005 | 242 | 1.804734 | 4.36745628 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 43.5 | 0.0192 | NR | XP_041479805.1 | 7654 | g171823 | i0 | 45.5 | 2.05785123966942 | 33 | 18 | 40.9 | 0 | 39 | 137 | 225 | 257 | XP_041479805.1 zinc finger protein 135-like [Lytechinus variegatus] | diamond | 498 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28013552 | 28013552 | PRJEB75230_P_NODE_11185_length_453_cov_2.157895_g11003_i0 | PRJEB75230 | 11185 | 453 | 2.157895 | 9.77526435 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 71.2 | 3.35e-11 | NR | XP_041457443.1 | 7654 | g11003 | i0 | 32.8 | 0.788079470198676 | 119 | 72 | 77.5 | 3 | 96 | 446 | 16 | 128 | XP_041457443.1 carboxypeptidase B-like [Lytechinus variegatus] | diamond | 357 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28076406 | 28076406 | PRJEB75230_P_NODE_113225_length_254_cov_1.276243_g113043_i0 | PRJEB75230 | 113225 | 254 | 1.276243 | 3.24165722 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 45.1 | 0.00654 | NR | XP_022088949.1 | 133434 | g113043 | i0 | 32.4 | 2.62204724409449 | 74 | 49 | 86.2 | 1 | 1 | 219 | 445 | 518 | XP_022088949.1 gamma-aminobutyric acid type B receptor subunit 2-like [Acanthaster planci] | diamond | 666 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30445114 | 30445114 | PRJEB75230_P_NODE_15073_length_414_cov_1.287390_g14891_i0 | PRJEB75230 | 15073 | 414 | 1.28739 | 5.3297946 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 67.4 | 5.66e-10 | NR | XP_033638180.1 | 7604 | g14891 | i0 | 40.7 | 0.623188405797101 | 86 | 50 | 61.6 | 1 | 261 | 7 | 13 | 98 | XP_033638180.1 thymus-specific serine protease-like [Asterias rubens] | diamond | 258 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30855659 | 30855659 | PRJEB75230_P_NODE_47734_length_315_cov_1.582645_g47552_i0 | PRJEB75230 | 47734 | 315 | 1.582645 | 4.98533175 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 55.8 | 2.12e-6 | NR | XP_001185285.2 | 7668 | g47552 | i0 | 38.5 | 0.914285714285714 | 96 | 52 | 84.8 | 2 | 296 | 30 | 352 | 447 | XP_001185285.2 EIN3-binding F-box protein 1 [Strongylocentrotus purpuratus] | diamond | 288 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31488135 | 31488135 | PRJEB75230_P_NODE_104296_length_260_cov_1.540107_g104114_i0 | PRJEB75230 | 104296 | 260 | 1.540107 | 4.0042782 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 42.7 | 0.0476 | NR | XP_030827930.1 | 7668 | g104114 | i0 | 40.3 | 1.43076923076923 | 62 | 33 | 69.2 | 2 | 21 | 200 | 225 | 284 | XP_030827930.1 macrophage mannose receptor 1 isoform X1 [Strongylocentrotus purpuratus] | diamond | 372 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32279020 | 32279020 | PRJEB75230_P_NODE_48299_length_315_cov_0.847107_g48117_i0 | PRJEB75230 | 48299 | 315 | 0.847107 | 2.66838705 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 46.2 | 0.00519 | NR | XP_033647912.1 | 7604 | g48117 | i0 | 30.8 | 0.990476190476191 | 104 | 58 | 99 | 1 | 314 | 3 | 309 | 398 | XP_033647912.1 pre-rRNA-processing protein TSR1 homolog isoform X2 [Asterias rubens] | diamond | 312 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32808182 | 32808182 | PRJEB75230_P_NODE_111400_length_255_cov_1.269231_g111218_i0 | PRJEB75230 | 111400 | 255 | 1.269231 | 3.23653905 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 4.78e-6 | NR | XP_054748116.2 | 7653 | g111218 | i0 | 44.3 | 3.78823529411765 | 79 | 40 | 92.9 | 1 | 14 | 250 | 165 | 239 | XP_054748116.2 amine oxidase [flavin-containing] B-like [Lytechinus pictus] | diamond | 966 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus |
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);;