contig_metadata
7 rows where bioproject = "PRJEB6584", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25661230 | 25661230 | PRJEB6584o_S_NODE_64442_length_160_cov_4.296000_g64334_i0 | PRJEB6584 | 64442 | 160 | 4.296 | 6.8736 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|1944916053|ref|XM_038214868.1| | 46514 | g64334 | i0 | 100 | 0.18125 | 29 | 0 | 18 | 0 | 32 | 60 | 912 | 884 | PREDICTED: Patiria miniata nucleoplasmin-like protein ANO39 (LOC119739794), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 25795722 | 25795722 | PRJEB6584e_S_NODE_891_length_268_cov_3.901288_g876_i0 | PRJEB6584 | 891 | 268 | 3.901288 | 10.45545184 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 176 | 1.4e-39 | NTclustered | gi|1752383407|ref|XM_030994820.1| | 7668 | g876 | i0 | 84.066 | 48.839552238806 | 182 | 29 | 68 | 0 | 66 | 247 | 1498 | 1317 | PREDICTED: Strongylocentrotus purpuratus tubulin alpha-1 chain-like (LOC115928089), mRNA | blastn | 13089 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26160745 | 26160745 | PRJEB6584o_S_NODE_7997_length_303_cov_5.220149_g7889_i0 | PRJEB6584 | 7997 | 303 | 5.220149 | 15.81705147 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 185 | 2.6699999999999994e-42 | NTclustered | gi|2037967640|ref|XM_041629424.1| | 7654 | g7889 | i0 | 88.312 | 44.6963696369637 | 154 | 18 | 51 | 0 | 149 | 302 | 1440 | 1287 | PREDICTED: Lytechinus variegatus tubulin alpha-3 chain-like (LOC121431736), mRNA | blastn | 13543 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 33008497 | 33008497 | PRJEB6584h_S_NODE_5099_length_245_cov_2.823810_g5037_i0 | PRJEB6584 | 5099 | 245 | 2.82381 | 6.9183345 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 120 | 1.2699999999999998e-32 | NR | XP_030845498.1 | 7668 | g5037 | i0 | 81.7 | 7.82448979591837 | 71 | 13 | 86.9 | 0 | 3 | 215 | 78 | 148 | XP_030845498.1 60S ribosomal protein L27a [Strongylocentrotus purpuratus] | diamond | 1917 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 33014490 | 33014490 | PRJEB6584h_S_NODE_39772_length_167_cov_1.560606_g39710_i0 | PRJEB6584 | 39772 | 167 | 1.560606 | 2.60621202 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 70.9 | 4.81e-14 | NR | XP_033640987.1 | 7604 | g39710 | i0 | 72.7 | 1.97604790419162 | 55 | 15 | 98.8 | 0 | 2 | 166 | 39 | 93 | XP_033640987.1 ATPase inhibitor A, mitochondrial-like [Asterias rubens] | diamond | 330 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 33093951 | 33093951 | PRJEB6584o_S_NODE_58158_length_163_cov_2.351562_g58050_i0 | PRJEB6584 | 58158 | 163 | 2.351562 | 3.83304606 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 80.1 | 3.52e-17 | NR | XP_054756763.1 | 7653 | g58050 | i0 | 71.2 | 4.89570552147239 | 52 | 15 | 95.7 | 0 | 162 | 7 | 112 | 163 | XP_054756763.1 large ribosomal subunit protein uL11-like [Lytechinus pictus] | diamond | 798 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 33167760 | 33167760 | PRJEB6584a_S_NODE_2632_length_229_cov_533.778351_g2612_i0 | PRJEB6584 | 2632 | 229 | 533.778351 | 1222.35242379 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 44.3 | 0.00857 | NR | PIK62516.1 | 307972 | g2612 | i0 | 47.5 | 1.89956331877729 | 40 | 18 | 48.5 | 1 | 109 | 219 | 30 | 69 | PIK62516.1 hypothetical protein BSL78_00522 [Apostichopus japonicus] | diamond | 435 | 44.3 | 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);;