contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA515078" and tax_phylum = "Perkinsozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 486849 | 486849 | PRJNA515078_P_NODE_28721_length_163_cov_0.928571_g28488_i0 | PRJNA515078 | 28721 | 163 | 0.928571 | 1.51357073 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 1.8e-16 | NR | KAF4677828.1 | 330153 | g28488 | i0 | 73.5 | 5.41104294478528 | 49 | 13 | 90.2 | 0 | 160 | 14 | 842 | 890 | KAF4677828.1 H(+)-transporting V0 sector ATPase subunit a [Perkinsus chesapeaki] | diamond | 882 | 82 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 10690717 | 10690717 | PRJNA515078_P_NODE_4889_length_431_cov_2.017766_g4656_i0 | PRJNA515078 | 4889 | 431 | 2.017766 | 8.69657146 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 7.01e-50 | NR | KAF4677256.1 | 330153 | g4656 | i0 | 69.6 | 0.80046403712297 | 115 | 29 | 80 | 1 | 430 | 86 | 362 | 470 | KAF4677256.1 Cytosolic seryl-tRNA synthetase [Perkinsus chesapeaki] | diamond | 345 | 176 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 26649234 | 26649234 | PRJNA515078_P_NODE_28241_length_164_cov_1.228346_g28008_i0 | PRJNA515078 | 28241 | 164 | 1.228346 | 2.01448744 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 1.9e-20 | NR | KAF4754071.1 | 32597 | g28008 | i0 | 74.1 | 63.219512195122 | 54 | 14 | 98.8 | 0 | 2 | 163 | 5 | 58 | KAF4754071.1 Ras- protein Rab-2A, partial [Perkinsus olseni] | diamond | 10368 | 88.2 | 0.99092970521542 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26728561 | 26728561 | PRJNA515078_P_NODE_2121_length_668_cov_10.026941_g1923_i0 | PRJNA515078 | 2121 | 668 | 10.026941 | 66.97996588 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.39e-76 | NR | XP_002778466.1 | 423536 | g1923 | i0 | 63.4 | 0.835329341317365 | 186 | 67 | 83.1 | 1 | 27 | 581 | 6 | 191 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 558 | 239 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27976909 | 27976909 | PRJNA515078_P_NODE_29625_length_160_cov_1.902439_g29392_i0 | PRJNA515078 | 29625 | 160 | 1.902439 | 3.0439024 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 6.72e-9 | NR | KAF4650015.1 | 330153 | g29392 | i0 | 54.3 | 4.81875 | 46 | 20 | 84.4 | 1 | 26 | 160 | 25 | 70 | KAF4650015.1 DNA-directed RNA polymerase core subunit rpc10 [Perkinsus chesapeaki] | diamond | 771 | 56.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30139977 | 30139977 | PRJNA515078_P_NODE_1772_length_730_cov_1.975469_g1594_i0 | PRJNA515078 | 1772 | 730 | 1.975469 | 14.4209237 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 1.19e-80 | NR | XP_002778466.1 | 423536 | g1594 | i0 | 64.1 | 0.789041095890411 | 192 | 63 | 78.5 | 2 | 37 | 609 | 6 | 192 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 576 | 250 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30155482 | 30155482 | PRJNA515078_P_NODE_28832_length_162_cov_1.864000_g28599_i0 | PRJNA515078 | 28832 | 162 | 1.864 | 3.01968 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 2.34e-5 | NR | KAF4659790.1 | 330153 | g28599 | i0 | 51 | 2.72222222222222 | 49 | 23 | 90.7 | 1 | 2 | 148 | 2012 | 2059 | KAF4659790.1 chromosome X 22 [Perkinsus chesapeaki] | diamond | 441 | 50.8 | 0.992125984251969 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30250784 | 30250784 | PRJNA515078_P_NODE_24812_length_174_cov_1.708029_g24579_i0 | PRJNA515078 | 24812 | 174 | 1.708029 | 2.97197046 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 2.59e-14 | NR | KAF4751618.1 | 32597 | g24579 | i0 | 61.8 | 4.74137931034483 | 55 | 20 | 93.1 | 1 | 174 | 13 | 41 | 95 | KAF4751618.1 E2-like enzyme [Perkinsus olseni] | diamond | 825 | 75.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31483298 | 31483298 | PRJNA515078_P_NODE_4616_length_447_cov_1.580488_g4384_i0 | PRJNA515078 | 4616 | 447 | 1.580488 | 7.06478136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.1e-66 | NR | KAF4661621.1 | 32597 | g4384 | i0 | 78.1 | 21.7852348993289 | 146 | 32 | 98 | 0 | 445 | 8 | 1960 | 2105 | KAF4661621.1 hypothetical protein FOZ61_003069 [Perkinsus olseni] | diamond | 9738 | 230 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31483299 | 31483299 | PRJNA515078_P_NODE_716_length_1123_cov_5.098527_g619_i0 | PRJNA515078 | 716 | 1123 | 5.098527 | 57.25645821 | root | 1 | Root_unresolved | Root_unresolved | 311 | 3.01e-98 | NR | KAF4671711.1 | 330153 | g619 | i0 | 57.6 | 4.34372217275156 | 271 | 115 | 72.4 | 0 | 985 | 173 | 209 | 479 | KAF4671711.1 hypothetical protein FOL47_001318 [Perkinsus chesapeaki] | diamond | 4878 | 313 | 0.993610223642173 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31594407 | 31594407 | PRJNA515078_P_NODE_3256_length_538_cov_2.157685_g3028_i0 | PRJNA515078 | 3256 | 538 | 2.157685 | 11.6083453 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 0.00103 | NR | KAF4695550.1 | 32597 | g3028 | i0 | 31.7 | 1.47211895910781 | 120 | 76 | 65.2 | 2 | 370 | 20 | 727 | 843 | KAF4695550.1 hypothetical protein FOZ60_004046, partial [Perkinsus olseni] | diamond | 792 | 50.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31657251 | 31657251 | PRJNA515078_P_NODE_28657_length_163_cov_1.238095_g28424_i0 | PRJNA515078 | 28657 | 163 | 1.238095 | 2.01809485 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0169 | NR | XP_002774997.1 | 423536 | g28424 | i0 | 35.2 | 0.993865030674847 | 54 | 32 | 93.9 | 1 | 156 | 4 | 53 | 106 | XP_002774997.1 tubulin-specific chaperone B, putative [Perkinsus marinus ATCC 50983] | diamond | 162 | 42.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32322156 | 32322156 | PRJNA515078_P_NODE_7159_length_348_cov_2.257235_g6926_i0 | PRJNA515078 | 7159 | 348 | 2.257235 | 7.8551778 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 7.46e-5 | NR | XP_002765612.1 | 423536 | g6926 | i0 | 55.1 | 0.75 | 49 | 21 | 42.2 | 1 | 326 | 180 | 1 | 48 | XP_002765612.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 261 | 51.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus |
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);;