contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2712058 | 2712058 | PRJNA1022139_P_NODE_3023_length_720_cov_3.020093_g2925_i0 | PRJNA1022139 | 3023 | 720 | 3.020093 | 21.7446696 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 247 | 1.19e-79 | NR | XP_002778466.1 | 423536 | g2925 | i0 | 66.3 | 0.791666666666667 | 190 | 63 | 78.8 | 1 | 17 | 583 | 1 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 570 | 247 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 14190160 | 14190160 | PRJNA1022139_P_NODE_11092_length_402_cov_1.285714_g10987_i0 | PRJNA1022139 | 11092 | 402 | 1.285714 | 5.16857028 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 194 | 1.41e-54 | NR | XP_002766029.1 | 423536 | g10987 | i0 | 69.9 | 10.9179104477612 | 133 | 38 | 99.3 | 1 | 400 | 2 | 486 | 616 | XP_002766029.1 ribonucleoside-diphosphate reductase large chain, putative [Perkinsus marinus ATCC 50983] | diamond | 4389 | 194 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 24387925 | 24387925 | PRJNA1022139_P_NODE_8480_length_453_cov_2.623684_g8375_i0 | PRJNA1022139 | 8480 | 453 | 2.623684 | 11.88528852 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 212 | 3.809999999999999e-67 | NR | XP_002778466.1 | 423536 | g8375 | i0 | 68.2 | 1 | 151 | 47 | 99.3 | 1 | 3 | 452 | 14 | 164 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 453 | 212 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27540575 | 27540575 | PRJNA1022139_P_NODE_25904_length_281_cov_2.451923_g25799_i0 | PRJNA1022139 | 25904 | 281 | 2.451923 | 6.88990363 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 2.81e-27 | NR | KAF4730534.1 | 32597 | g25799 | i0 | 69.8 | 0.918149466192171 | 86 | 24 | 91.8 | 1 | 258 | 1 | 1 | 84 | KAF4730534.1 DnaJ (Hsp40), sub A, member 4 [Perkinsus olseni] | diamond | 258 | 113 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27887692 | 27887692 | PRJNA1022139_P_NODE_19025_length_319_cov_4.191057_g18920_i0 | PRJNA1022139 | 19025 | 319 | 4.191057 | 13.36947183 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0363 | NR | KAF4665648.1 | 32597 | g18920 | i0 | 37.5 | 0.601880877742947 | 64 | 35 | 60.2 | 1 | 3 | 194 | 2 | 60 | KAF4665648.1 hypothetical protein FOZ61_010655 [Perkinsus olseni] | diamond | 192 | 41.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27951037 | 27951037 | PRJNA1022139_P_NODE_36125_length_249_cov_0.875000_g36020_i0 | PRJNA1022139 | 36125 | 249 | 0.875 | 2.17875 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 7.39e-15 | NR | KAF4749625.1 | 32597 | g36020 | i0 | 38.3 | 7.63855421686747 | 81 | 50 | 97.6 | 0 | 247 | 5 | 15 | 95 | KAF4749625.1 hypothetical protein FOZ62_015881, partial [Perkinsus olseni] | diamond | 1902 | 75.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28361345 | 28361345 | PRJNA1022139_P_NODE_4246_length_619_cov_5.241758_g4142_i0 | PRJNA1022139 | 4246 | 619 | 5.241758 | 32.44648202 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 5.1599999999999996e-89 | NR | XP_002778466.1 | 423536 | g4142 | i0 | 70 | 0.920840064620355 | 190 | 56 | 91.6 | 1 | 612 | 46 | 1 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 570 | 270 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28645731 | 28645731 | PRJNA1022139_P_NODE_33327_length_254_cov_1.607735_g33222_i0 | PRJNA1022139 | 33327 | 254 | 1.607735 | 4.0836469 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 8.03e-6 | NR | XP_002782567.1 | 423536 | g33222 | i0 | 54.3 | 1.08661417322835 | 46 | 20 | 53.1 | 1 | 140 | 6 | 56 | 101 | XP_002782567.1 Basic endochitinase 1 precursor, putative, partial [Perkinsus marinus ATCC 50983] | diamond | 276 | 53.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28740381 | 28740381 | PRJNA1022139_P_NODE_8247_length_459_cov_1.792746_g8142_i0 | PRJNA1022139 | 8247 | 459 | 1.792746 | 8.22870414 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.11e-4 | NR | KAF4664580.1 | 330153 | g8142 | i0 | 53.2 | 0.61437908496732 | 47 | 22 | 30.7 | 0 | 149 | 9 | 335 | 381 | KAF4664580.1 hypothetical protein FOL47_005067 [Perkinsus chesapeaki] | diamond | 282 | 52.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28827000 | 28827000 | PRJNA1022139_P_NODE_3548_length_669_cov_0.984899_g3447_i0 | PRJNA1022139 | 3548 | 669 | 0.984899 | 6.58897431 | Pelagophyceae | 35675 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 1.49e-15 | NR | XP_002767931.1 | 423536 | g3447 | i0 | 34.5 | 1.2780269058296 | 174 | 93 | 68.6 | 3 | 499 | 41 | 164 | 337 | XP_002767931.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 855 | 86.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29269030 | 29269030 | PRJNA1022139_P_NODE_30429_length_265_cov_1.604167_g30324_i0 | PRJNA1022139 | 30429 | 265 | 1.604167 | 4.25104255 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 1.31e-7 | NR | KAF4654070.1 | 330153 | g30324 | i0 | 57.7 | 2.95471698113208 | 52 | 22 | 58.9 | 0 | 170 | 15 | 164 | 215 | KAF4654070.1 hypothetical protein FOL47_010155 [Perkinsus chesapeaki] | diamond | 783 | 58.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29498081 | 29498081 | PRJNA1022139_P_NODE_5610_length_548_cov_2.090526_g5506_i0 | PRJNA1022139 | 5610 | 548 | 2.090526 | 11.45608248 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 1.96e-8 | NR | KAF4671708.1 | 330153 | g5506 | i0 | 30 | 1.94343065693431 | 180 | 104 | 97.4 | 5 | 547 | 14 | 25 | 184 | KAF4671708.1 hypothetical protein FOL47_001315 [Perkinsus chesapeaki] | diamond | 1065 | 64.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29805864 | 29805864 | PRJNA1022139_P_NODE_19591_length_315_cov_3.471074_g19486_i0 | PRJNA1022139 | 19591 | 315 | 3.471074 | 10.9338831 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.00511 | NR | KAF4697269.1 | 32597 | g19486 | i0 | 41.4 | 1.46666666666667 | 70 | 31 | 63.8 | 2 | 304 | 104 | 9 | 71 | KAF4697269.1 hypothetical protein FOZ60_009892 [Perkinsus olseni] | diamond | 462 | 44.3 | 0.99097065462754 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30343618 | 30343618 | PRJNA1022139_P_NODE_31692_length_260_cov_1.647059_g31587_i0 | PRJNA1022139 | 31692 | 260 | 1.647059 | 4.2823534 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 8.72e-28 | NR | KAF4689043.1 | 32597 | g31587 | i0 | 65.4 | 3.83076923076923 | 81 | 28 | 93.5 | 0 | 18 | 260 | 1 | 81 | KAF4689043.1 hypothetical protein FOZ60_002144 [Perkinsus olseni] | diamond | 996 | 115 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30445875 | 30445875 | PRJNA1022139_P_NODE_37533_length_247_cov_2.011494_g37428_i0 | PRJNA1022139 | 37533 | 247 | 2.011494 | 4.96839018 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 1.28e-11 | NR | KAF4687757.1 | 32597 | g37428 | i0 | 43.7 | 1.66396761133603 | 71 | 40 | 86.2 | 0 | 32 | 244 | 1 | 71 | KAF4687757.1 hypothetical protein FOZ60_003512 [Perkinsus olseni] | diamond | 411 | 69.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30698392 | 30698392 | PRJNA1022139_P_NODE_24054_length_288_cov_1.432558_g23949_i0 | PRJNA1022139 | 24054 | 288 | 1.432558 | 4.12576704 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 2.55e-15 | NR | KAF4687771.1 | 32597 | g23949 | i0 | 46.2 | 4.84375 | 93 | 49 | 95.8 | 1 | 8 | 283 | 101 | 193 | KAF4687771.1 hypothetical protein FOZ62_004224 [Perkinsus olseni] | diamond | 1395 | 80.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31046281 | 31046281 | PRJNA1022139_P_NODE_11955_length_389_cov_0.863924_g11850_i0 | PRJNA1022139 | 11955 | 389 | 0.863924 | 3.36066436 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 1.62e-42 | NR | KAF4675435.1 | 330153 | g11850 | i0 | 59.8 | 9.72493573264781 | 127 | 50 | 97.2 | 1 | 10 | 387 | 1730 | 1856 | KAF4675435.1 hypothetical protein FOL47_007743 [Perkinsus chesapeaki] | diamond | 3783 | 160 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31488910 | 31488910 | PRJNA1022139_P_NODE_6376_length_518_cov_1.979775_g6271_i0 | PRJNA1022139 | 6376 | 518 | 1.979775 | 10.2552345 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.25e-24 | NR | XP_002780228.1 | 423536 | g6271 | i0 | 35.4 | 0.915057915057915 | 158 | 95 | 90.9 | 3 | 1 | 471 | 356 | 507 | XP_002780228.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 474 | 108 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31892008 | 31892008 | PRJNA1022139_P_NODE_28617_length_272_cov_1.241206_g28512_i0 | PRJNA1022139 | 28617 | 272 | 1.241206 | 3.37608032 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 1.2e-9 | NR | KAF4728239.1 | 32597 | g28512 | i0 | 65.1 | 0.948529411764706 | 43 | 15 | 47.4 | 0 | 265 | 137 | 93 | 135 | KAF4728239.1 hypothetical protein FOZ63_033213 [Perkinsus olseni] | diamond | 258 | 61.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32374621 | 32374621 | PRJNA1022139_P_NODE_3559_length_668_cov_1.821849_g3457_i0 | PRJNA1022139 | 3559 | 668 | 1.821849 | 12.16995132 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 3.69e-7 | NR | XP_002771916.1 | 423536 | g3457 | i0 | 40 | 0.359281437125749 | 80 | 48 | 35.9 | 0 | 656 | 417 | 206 | 285 | XP_002771916.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 240 | 61.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);;