contig_metadata
17 rows where bioproject = "PRJNA914897", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 894736 | 894736 | PRJNA914897_P_NODE_19081_length_391_cov_0.940252_g18659_i0 | PRJNA914897 | 19081 | 391 | 0.940252 | 3.67638532 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.23e-4 | NTclustered | gi|294939297|ref|XM_002782354.1| | 423536 | g18659 | i0 | 90.909 | 0.112531969309463 | 44 | 4 | 11 | 0 | 259 | 302 | 165 | 122 | Perkinsus marinus ATCC 50983 centrin, putative, mRNA | blastn | 44 | 60.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26651746 | 26651746 | PRJNA914897_P_NODE_27401_length_307_cov_1.611111_g26977_i0 | PRJNA914897 | 27401 | 307 | 1.611111 | 4.94611077 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 2.4e-16 | NR | KAF4662111.1 | 330153 | g26977 | i0 | 68.3 | 5.24755700325733 | 60 | 19 | 58.6 | 0 | 44 | 223 | 311 | 370 | KAF4662111.1 Protein transport protein Sec61 subunit alpha [Perkinsus chesapeaki] | diamond | 1611 | 84 | 0.995238095238095 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27537512 | 27537512 | PRJNA914897_P_NODE_12143_length_527_cov_1.759912_g11723_i0 | PRJNA914897 | 12143 | 527 | 1.759912 | 9.27473624 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 5.83e-14 | NR | KAF4749396.1 | 32597 | g11723 | i0 | 33.7 | 6.91081593927894 | 172 | 89 | 89.9 | 7 | 53 | 526 | 40 | 200 | KAF4749396.1 hypothetical protein FOZ63_030813 [Perkinsus olseni] | diamond | 3642 | 79.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29329824 | 29329824 | PRJNA914897_P_NODE_9489_length_618_cov_1.400000_g9074_i0 | PRJNA914897 | 9489 | 618 | 1.4 | 8.652 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 2.95e-50 | NR | XP_002785732.1 | 423536 | g9074 | i0 | 68.9 | 0.577669902912621 | 119 | 37 | 57.8 | 0 | 79 | 435 | 351 | 469 | XP_002785732.1 Urocanate hydratase, putative [Perkinsus marinus ATCC 50983] | diamond | 357 | 183 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29368811 | 29368811 | PRJNA914897_P_NODE_30149_length_287_cov_1.799065_g29725_i0 | PRJNA914897 | 30149 | 287 | 1.799065 | 5.16331655 | Perkinsida | 27998 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 2.61e-29 | NR | KAF4654695.1 | 32597 | g29725 | i0 | 56.8 | 11.8745644599303 | 95 | 41 | 99.3 | 0 | 1 | 285 | 432 | 526 | KAF4654695.1 hypothetical protein FOZ61_008090 [Perkinsus olseni] | diamond | 3408 | 121 | 0.991735537190083 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29558055 | 29558055 | PRJNA914897_P_NODE_21330_length_363_cov_1.058621_g20906_i0 | PRJNA914897 | 21330 | 363 | 1.058621 | 3.84279423 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 2.5199999999999998e-34 | NR | KAF4670479.1 | 32597 | g20906 | i0 | 61.3 | 6.50413223140496 | 111 | 42 | 91.7 | 1 | 363 | 31 | 767 | 876 | KAF4670479.1 H(+)-transporting V0 sector ATPase subunit a [Perkinsus olseni] | diamond | 2361 | 136 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30150678 | 30150678 | PRJNA914897_P_NODE_12732_length_512_cov_1.111617_g12312_i0 | PRJNA914897 | 12732 | 512 | 1.111617 | 5.69147904 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 5.869999999999999e-48 | NR | KAF4706882.1 | 32597 | g12312 | i0 | 64.9 | 4.0078125 | 114 | 40 | 66.8 | 0 | 147 | 488 | 83 | 196 | KAF4706882.1 snoRNA-binding rRNA-processing protein imp4, partial [Perkinsus olseni] | diamond | 2052 | 169 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30372477 | 30372477 | PRJNA914897_P_NODE_18412_length_401_cov_1.371951_g17990_i0 | PRJNA914897 | 18412 | 401 | 1.371951 | 5.50152351 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00848 | NR | XP_002784034.1 | 423536 | g17990 | i0 | 28 | 4.21197007481297 | 132 | 90 | 98.8 | 1 | 401 | 6 | 66 | 192 | XP_002784034.1 myosin heavy chain, embryonic smooth muscle isoform, putative [Perkinsus marinus ATCC 50983] | diamond | 1689 | 46.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30435552 | 30435552 | PRJNA914897_P_NODE_14593_length_468_cov_0.974684_g14171_i0 | PRJNA914897 | 14593 | 468 | 0.974684 | 4.56152112 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 197 | 2.88e-61 | NR | XP_002778466.1 | 423536 | g14171 | i0 | 69.1 | 0.891025641025641 | 139 | 42 | 88.5 | 1 | 4 | 417 | 52 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 417 | 197 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30593158 | 30593158 | PRJNA914897_P_NODE_12413_length_519_cov_6.650224_g11993_i0 | PRJNA914897 | 12413 | 519 | 6.650224 | 34.51466256 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 4.4e-16 | NR | XP_002784356.1 | 423536 | g11993 | i0 | 31.8 | 1.55491329479769 | 129 | 88 | 74.6 | 0 | 72 | 458 | 19 | 147 | XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983] | diamond | 807 | 81.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30782821 | 30782821 | PRJNA914897_P_NODE_33594_length_268_cov_1.010256_g33170_i0 | PRJNA914897 | 33594 | 268 | 1.010256 | 2.70748608 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00537 | NR | KAF4666776.1 | 330153 | g33170 | i0 | 62.5 | 0.358208955223881 | 32 | 12 | 35.8 | 0 | 21 | 116 | 219 | 250 | KAF4666776.1 galactokinase [Perkinsus chesapeaki] | diamond | 96 | 45.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30821793 | 30821793 | PRJNA914897_P_NODE_18554_length_399_cov_1.177914_g18132_i0 | PRJNA914897 | 18554 | 399 | 1.177914 | 4.69987686 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 6.2e-6 | NR | KAF4725103.1 | 32597 | g18132 | i0 | 34.4 | 4.06015037593985 | 90 | 59 | 67.7 | 0 | 126 | 395 | 35 | 124 | KAF4725103.1 hypothetical protein FOZ62_006516, partial [Perkinsus olseni] | diamond | 1620 | 55.8 | 0.99462365591397806 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31517379 | 31517379 | PRJNA914897_P_NODE_2956_length_1149_cov_2.684944_g2710_i0 | PRJNA914897 | 2956 | 1149 | 2.684944 | 30.85000656 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 216 | 4.73e-62 | NR | KAF4713159.1 | 32597 | g2710 | i0 | 50 | 3.2402088772846 | 210 | 94 | 52.5 | 3 | 620 | 18 | 228 | 435 | KAF4713159.1 phosphatidate cytidylyltransferase [Perkinsus olseni] | diamond | 3723 | 216 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32015959 | 32015959 | PRJNA914897_P_NODE_22018_length_355_cov_4.833333_g21594_i0 | PRJNA914897 | 22018 | 355 | 4.833333 | 17.15833215 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.95e-5 | NR | KAF4656929.1 | 32597 | g21594 | i0 | 34.7 | 1.57183098591549 | 95 | 56 | 76.1 | 3 | 307 | 38 | 117 | 210 | KAF4656929.1 hypothetical protein FOZ61_006606, partial [Perkinsus olseni] | diamond | 558 | 52.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32403131 | 32403131 | PRJNA914897_P_NODE_37879_length_249_cov_0.875000_g37455_i0 | PRJNA914897 | 37879 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.4e-4 | NR | KAF4656041.1 | 32597 | g37455 | i0 | 41.4 | 5.73493975903614 | 58 | 28 | 63.9 | 2 | 74 | 232 | 15 | 71 | KAF4656041.1 hypothetical protein FOZ61_007220, partial [Perkinsus olseni] | diamond | 1428 | 49.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32616963 | 32616963 | PRJNA914897_P_NODE_38100_length_248_cov_3.097143_g37676_i0 | PRJNA914897 | 38100 | 248 | 3.097143 | 7.68091464 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 8.13e-11 | NR | XP_002774272.1 | 423536 | g37676 | i0 | 47.5 | 2.26209677419355 | 61 | 32 | 73.8 | 0 | 56 | 238 | 16 | 76 | XP_002774272.1 ubiquitin, putative [Perkinsus marinus ATCC 50983] | diamond | 561 | 62.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32837260 | 32837260 | PRJNA914897_P_NODE_31880_length_278_cov_0.970732_g31456_i0 | PRJNA914897 | 31880 | 278 | 0.970732 | 2.69863496 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00653 | NR | KAF4659055.1 | 330153 | g31456 | i0 | 65.4 | 0.280575539568345 | 26 | 9 | 28.1 | 0 | 275 | 198 | 68 | 93 | KAF4659055.1 hypothetical protein FOL47_007732 [Perkinsus chesapeaki] | diamond | 78 | 45.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki |
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);;