contig_metadata
14 rows where bioproject = "PRJNA854078", tax_kingdom = "Metazoa" and tax_phylum = "Brachiopoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7219894 | 7219894 | PRJNA854078_P_NODE_5526_length_402_cov_10.346505_g5314_i0 | PRJNA854078 | 5526 | 402 | 10.346505 | 41.5929501 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 230 | 1.73e-74 | NR | XP_013395382.2 | 7574 | g5314 | i0 | 93.5 | 61.4477611940299 | 123 | 8 | 91.8 | 0 | 2 | 370 | 89 | 211 | XP_013395382.2 ubiquitin-60S ribosomal protein L40 [Lingula anatina] | diamond | 24702 | 232 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 25067806 | 25067806 | PRJNA854078_P_NODE_3620_length_499_cov_2.492958_g3408_i0 | PRJNA854078 | 3620 | 499 | 2.492958 | 12.43986042 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 309 | 8.49e-100 | NR | XP_013399710.1 | 7574 | g3408 | i0 | 92.2 | 150.673346693387 | 166 | 13 | 99.8 | 0 | 499 | 2 | 273 | 438 | XP_013399710.1 V-type proton ATPase catalytic subunit A [Lingula anatina] | diamond | 75186 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27623933 | 27623933 | PRJNA854078_P_NODE_5184_length_416_cov_1.591837_g4972_i0 | PRJNA854078 | 5184 | 416 | 1.591837 | 6.62204192 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 144 | 7.78e-39 | NR | XP_013399318.1 | 7574 | g4972 | i0 | 52.3 | 2.73317307692308 | 128 | 59 | 92.3 | 1 | 416 | 33 | 215 | 340 | XP_013399318.1 ribonuclease H1 [Lingula anatina] | diamond | 1137 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27907617 | 27907617 | PRJNA854078_P_NODE_7045_length_355_cov_1.854610_g6833_i0 | PRJNA854078 | 7045 | 355 | 1.85461 | 6.5838655 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 76.3 | 2.31e-13 | NR | XP_013393255.1 | 7574 | g6833 | i0 | 38.2 | 1.8 | 110 | 67 | 93 | 1 | 330 | 1 | 3 | 111 | XP_013393255.1 lysosome membrane protein 2 [Lingula anatina] | diamond | 639 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 28349897 | 28349897 | PRJNA854078_P_NODE_5226_length_414_cov_2.395894_g5014_i0 | PRJNA854078 | 5226 | 414 | 2.395894 | 9.91900116 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 73.9 | 8.09e-13 | NR | XP_013384316.1 | 7574 | g5014 | i0 | 33.3 | 1 | 138 | 88 | 97.1 | 2 | 414 | 13 | 16 | 153 | XP_013384316.1 surfeit locus protein 2 [Lingula anatina] | diamond | 414 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29391971 | 29391971 | PRJNA854078_P_NODE_16589_length_241_cov_0.916667_g16377_i0 | PRJNA854078 | 16589 | 241 | 0.916667 | 2.20916747 | Novocrania anomala | 317945 | Brachiopoda | other_Eukaryota | 43.9 | 0.0145 | NR | QUP08111.1 | 317945 | g16377 | i0 | 48.6 | 2.73858921161826 | 37 | 19 | 46.1 | 0 | 2 | 112 | 146 | 182 | QUP08111.1 fibroblast growth factor receptor 1, partial [Novocrania anomala] | diamond | 660 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Craniata | Craniida | Craniidae | Novocrania | Novocrania anomala | |
| 29612540 | 29612540 | PRJNA854078_P_NODE_670_length_1171_cov_1.834244_g541_i0 | PRJNA854078 | 670 | 1171 | 1.834244 | 21.47899724 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 136 | 6.599999999999998e-32 | NR | XP_013414821.1 | 7574 | g541 | i0 | 30.9 | 0.763450042698548 | 298 | 168 | 74.3 | 9 | 872 | 3 | 126 | 393 | XP_013414821.1 uncharacterized protein LOC106176828 isoform X1 [Lingula anatina] | diamond | 894 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 30600241 | 30600241 | PRJNA854078_P_NODE_1973_length_683_cov_2.536066_g1772_i0 | PRJNA854078 | 1973 | 683 | 2.536066 | 17.32133078 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 224 | 8.27e-64 | NR | XP_013383194.1 | 7574 | g1772 | i0 | 49.8 | 4.9194729136164 | 227 | 110 | 98.8 | 3 | 7 | 681 | 703 | 927 | XP_013383194.1 AP-1 complex subunit beta-1 isoform X1 [Lingula anatina] | diamond | 3360 | 225 | 0.995555555555556 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31105746 | 31105746 | PRJNA854078_P_NODE_1675_length_737_cov_2.233434_g1481_i0 | PRJNA854078 | 1675 | 737 | 2.233434 | 16.46040858 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 314 | 1.7899999999999995e-101 | NR | XP_013419828.1 | 7574 | g1481 | i0 | 62.7 | 4.90094979647218 | 244 | 89 | 98.9 | 2 | 6 | 734 | 36 | 278 | XP_013419828.1 alanine aminotransferase 1 [Lingula anatina] | diamond | 3612 | 314 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31327112 | 31327112 | PRJNA854078_P_NODE_2655_length_585_cov_3.322266_g2447_i0 | PRJNA854078 | 2655 | 585 | 3.322266 | 19.4352561 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 87.4 | 2.6e-16 | NR | XP_013414821.1 | 7574 | g2447 | i0 | 39 | 1.28717948717949 | 118 | 63 | 59 | 4 | 230 | 574 | 126 | 237 | XP_013414821.1 uncharacterized protein LOC106176828 isoform X1 [Lingula anatina] | diamond | 753 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31477317 | 31477317 | PRJNA854078_P_NODE_5236_length_414_cov_0.903226_g5024_i0 | PRJNA854078 | 5236 | 414 | 0.903226 | 3.73935564 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 212 | 2.97e-65 | NR | XP_013416642.1 | 7574 | g5024 | i0 | 73.7 | 2.95652173913043 | 137 | 36 | 99.3 | 0 | 3 | 413 | 54 | 190 | XP_013416642.1 uroporphyrinogen decarboxylase [Lingula anatina] | diamond | 1224 | 212 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 32276423 | 32276423 | PRJNA854078_P_NODE_10898_length_285_cov_1.952830_g10686_i0 | PRJNA854078 | 10898 | 285 | 1.95283 | 5.5655655 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 101 | 4.4599999999999996e-23 | NR | XP_013382053.1 | 7574 | g10686 | i0 | 51.1 | 12.8842105263158 | 94 | 45 | 98.9 | 1 | 3 | 284 | 204 | 296 | XP_013382053.1 mitogen-activated protein kinase 14 [Lingula anatina] | diamond | 3672 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 32339706 | 32339706 | PRJNA854078_P_NODE_8279_length_327_cov_1.515748_g8067_i0 | PRJNA854078 | 8279 | 327 | 1.515748 | 4.95649596 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 54.7 | 6.46e-6 | NR | XP_013418896.1 | 7574 | g8067 | i0 | 38.6 | 1.86238532110092 | 101 | 42 | 83.5 | 5 | 286 | 14 | 97 | 187 | XP_013418896.1 phospholipase D2 [Lingula anatina] | diamond | 609 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 32615831 | 32615831 | PRJNA854078_P_NODE_6420_length_372_cov_1.411371_g6208_i0 | PRJNA854078 | 6420 | 372 | 1.411371 | 5.25030012 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 62 | 1.32e-9 | NR | XP_013408695.1 | 7574 | g6208 | i0 | 38.3 | 2.60483870967742 | 81 | 46 | 65.3 | 1 | 370 | 128 | 30 | 106 | XP_013408695.1 SH3 domain-binding glutamic acid-rich-like protein 3 isoform X2 [Lingula anatina] | diamond | 969 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina |
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);;