contig_metadata
11 rows where bioproject = "PRJNA724011" and tax_phylum = "Xenacoelomorpha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1193832 | 1193832 | PRJNA724011_P_NODE_33401_length_473_cov_1.020000_g32382_i0 | PRJNA724011 | 33401 | 473 | 1.02 | 4.8246 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|2701334661|ref|XM_063871370.1| | 84072 | g32382 | i0 | 100 | 0.841437632135307 | 31 | 0 | 7 | 0 | 34 | 64 | 1183 | 1213 | PREDICTED: Symsagittifera roscoffensis ribosome-binding protein 1-like (LOC134854990), mRNA | blastn | 398 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 12189848 | 12189848 | PRJNA724011_P_NODE_28450_length_522_cov_3.403118_g27433_i0 | PRJNA724011 | 28450 | 522 | 3.403118 | 17.76427596 | Sagittiferidae | 170511 | Xenacoelomorpha | other_Eukaryota | 208 | 1.56e-65 | NR | XP_063720622.1 | 84072 | g27433 | i0 | 65.8 | 4.41954022988506 | 155 | 52 | 88.5 | 1 | 490 | 29 | 18 | 172 | XP_063720622.1 superoxide dismutase [Cu-Zn]-like [Symsagittifera roscoffensis] | diamond | 2307 | 209 | 0.995215311004785 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 23663515 | 23663515 | PRJNA724011_P_NODE_19959_length_657_cov_1.982877_g18949_i0 | PRJNA724011 | 19959 | 657 | 1.982877 | 13.02750189 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 161 | 1.15e-43 | NR | XP_063724635.1 | 84072 | g18949 | i0 | 57.8 | 1.98630136986301 | 147 | 59 | 65.8 | 1 | 180 | 611 | 2 | 148 | XP_063724635.1 dynein assembly factor with WD repeat domains 1-like [Symsagittifera roscoffensis] | diamond | 1305 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26640589 | 26640589 | PRJNA724011_P_NODE_32341_length_482_cov_2.007335_g31322_i0 | PRJNA724011 | 32341 | 482 | 2.007335 | 9.6753547 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 71.6 | 3.31e-11 | NR | XP_063723580.1 | 84072 | g31322 | i0 | 38.5 | 0.597510373443983 | 96 | 50 | 54.8 | 3 | 9 | 272 | 304 | 398 | XP_063723580.1 paladin-like [Symsagittifera roscoffensis] | diamond | 288 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26925647 | 26925647 | PRJNA724011_P_NODE_99362_length_247_cov_1.764368_g98339_i0 | PRJNA724011 | 99362 | 247 | 1.764368 | 4.35798896 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 74.3 | 2.9e-13 | NR | XP_063713335.1 | 84072 | g98339 | i0 | 48.1 | 0.983805668016194 | 81 | 29 | 98.4 | 2 | 245 | 3 | 164 | 231 | XP_063713335.1 splicing factor 3B subunit 3-like [Symsagittifera roscoffensis] | diamond | 243 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28536650 | 28536650 | PRJNA724011_P_NODE_101267_length_246_cov_1.179191_g100244_i0 | PRJNA724011 | 101267 | 246 | 1.179191 | 2.90080986 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 57.4 | 2.43e-7 | NR | XP_063725174.1 | 84072 | g100244 | i0 | 48.3 | 0.707317073170732 | 58 | 28 | 70.7 | 1 | 71 | 244 | 285 | 340 | XP_063725174.1 uncharacterized protein LOC134853149 [Symsagittifera roscoffensis] | diamond | 174 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29862517 | 29862517 | PRJNA724011_P_NODE_106751_length_243_cov_0.905882_g105728_i0 | PRJNA724011 | 106751 | 243 | 0.905882 | 2.20129326 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 47 | 0.0012 | NR | XP_063714243.1 | 84072 | g105728 | i0 | 78.3 | 0.283950617283951 | 23 | 5 | 28.4 | 0 | 78 | 10 | 145 | 167 | XP_063714243.1 uncharacterized protein LOC134842028 [Symsagittifera roscoffensis] | diamond | 69 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30315825 | 30315825 | PRJNA724011_P_NODE_42992_length_402_cov_1.835866_g41969_i0 | PRJNA724011 | 42992 | 402 | 1.835866 | 7.38018132 | Opisthokonta | 33154 | Xenacoelomorpha | other_Eukaryota | 56.6 | 3.24e-6 | NR | XP_063712779.1 | 84072 | g41969 | i0 | 31.5 | 5.82089552238806 | 130 | 88 | 96.3 | 1 | 394 | 8 | 1025 | 1154 | XP_063712779.1 dynein axonemal heavy chain 2-like isoform X1 [Symsagittifera roscoffensis] | diamond | 2340 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30368519 | 30368519 | PRJNA724011_P_NODE_22772_length_602_cov_2.431002_g21758_i0 | PRJNA724011 | 22772 | 602 | 2.431002 | 14.63463204 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 112 | 1.23e-24 | NR | XP_063717246.1 | 84072 | g21758 | i0 | 49.6 | 2.29734219269103 | 135 | 66 | 66.3 | 2 | 37 | 435 | 676 | 810 | XP_063717246.1 pre-rRNA 2'-O-ribose RNA methyltransferase FTSJ3-like [Symsagittifera roscoffensis] | diamond | 1383 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31853742 | 31853742 | PRJNA724011_P_NODE_81777_length_273_cov_3.080000_g80754_i0 | PRJNA724011 | 81777 | 273 | 3.08 | 8.4084 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 48.5 | 4.68e-4 | NR | XP_063717070.1 | 84072 | g80754 | i0 | 39.3 | 1.34065934065934 | 61 | 36 | 65.9 | 1 | 185 | 6 | 6 | 66 | XP_063717070.1 histone acetyltransferase type B catalytic subunit-like [Symsagittifera roscoffensis] | diamond | 366 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32801794 | 32801794 | PRJNA724011_P_NODE_8100_length_1112_cov_3.038499_g7394_i0 | PRJNA724011 | 8100 | 1112 | 3.038499 | 33.78810888 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 117 | 1.98e-25 | NR | XP_063723580.1 | 84072 | g7394 | i0 | 27.7 | 0.866007194244604 | 321 | 197 | 83.9 | 9 | 1050 | 118 | 116 | 411 | XP_063723580.1 paladin-like [Symsagittifera roscoffensis] | diamond | 963 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis |
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);;