contig_metadata
7 rows where bioproject = "PRJEB39643", tax_clade = "Metamonada" and tax_phylum = "Parabasalia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26938353 | 26938353 | PRJEB39643_P_NODE_77122_length_272_cov_1.547739_g76929_i0 | PRJEB39643 | 77122 | 272 | 1.547739 | 4.20985008 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 47 | 3.09e-4 | NR | XP_068366990.1 | 1144522 | g76929 | i0 | 47.7 | 0.485294117647059 | 44 | 23 | 48.5 | 0 | 117 | 248 | 58 | 101 | XP_068366990.1 uncharacterized protein TRFO_15861 [Tritrichomonas foetus] | diamond | 132 | 47 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 27507547 | 27507547 | PRJEB39643_P_NODE_142983_length_243_cov_2.423529_g142790_i0 | PRJEB39643 | 142983 | 243 | 2.423529 | 5.88917547 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 49.7 | 1.37e-4 | NR | XP_068345929.1 | 1144522 | g142790 | i0 | 40 | 5.38271604938272 | 70 | 42 | 86.4 | 0 | 10 | 219 | 190 | 259 | XP_068345929.1 uncharacterized protein TRFO_40913 [Tritrichomonas foetus] | diamond | 1308 | 49.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 27507601 | 27507601 | PRJEB39643_P_NODE_76923_length_272_cov_1.547739_g76730_i0 | PRJEB39643 | 76923 | 272 | 1.547739 | 4.20985008 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 105 | 5.13e-24 | NR | XP_001310194.1 | 412133 | g76730 | i0 | 66.7 | 1.93014705882353 | 90 | 27 | 96 | 1 | 10 | 270 | 388 | 477 | XP_001310194.1 copine family [Trichomonas vaginalis G3] | diamond | 525 | 105 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 28486227 | 28486227 | PRJEB39643_P_NODE_64347_length_278_cov_3.004878_g64154_i0 | PRJEB39643 | 64347 | 278 | 3.004878 | 8.35356084 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 50.8 | 7.74e-5 | NR | XP_068349703.1 | 1144522 | g64154 | i0 | 30.9 | 2.25539568345324 | 81 | 54 | 85.3 | 1 | 12 | 248 | 203 | 283 | XP_068349703.1 uncharacterized protein TRFO_37275 [Tritrichomonas foetus] | diamond | 627 | 50.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30570291 | 30570291 | PRJEB39643_P_NODE_893_length_1687_cov_2.837670_g851_i0 | PRJEB39643 | 893 | 1687 | 2.83767 | 47.8714929 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 56.2 | 4.41e-4 | NR | XP_068349620.1 | 1144522 | g851 | i0 | 50 | 0.0782454060462359 | 44 | 22 | 7.8 | 0 | 1327 | 1196 | 85 | 128 | XP_068349620.1 uncharacterized protein TRFO_37341 [Tritrichomonas foetus] | diamond | 132 | 56.2 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 32404617 | 32404617 | PRJEB39643_P_NODE_151739_length_238_cov_3.030303_g151546_i0 | PRJEB39643 | 151739 | 238 | 3.030303 | 7.21212114 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 48.5 | 3.19e-4 | NR | XP_068367489.1 | 1144522 | g151546 | i0 | 40 | 1.38655462184874 | 55 | 31 | 69.3 | 1 | 8 | 172 | 244 | 296 | XP_068367489.1 CK1 family protein kinase [Tritrichomonas foetus] | diamond | 330 | 48.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 32720232 | 32720232 | PRJEB39643_P_NODE_131860_length_247_cov_3.298851_g131667_i0 | PRJEB39643 | 131860 | 247 | 3.298851 | 8.14816197 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 123 | 1.6100000000000002e-33 | NR | XP_001322019.1 | 412133 | g131667 | i0 | 64.6 | 4.95546558704453 | 82 | 29 | 99.6 | 0 | 247 | 2 | 6 | 87 | XP_001322019.1 peptidyl-prolyl cis-trans isomerase protein [Trichomonas vaginalis G3] | diamond | 1224 | 123 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis |
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);;