contig_metadata
13 rows where bioproject = "PRJNA437204", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 432268 | 432268 | PRJNA437204_P_NODE_25501_length_377_cov_1.269737_g25202_i0 | PRJNA437204 | 25501 | 377 | 1.269737 | 4.78690849 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 1.83e-17 | NR | KAF4680237.1 | 32597 | g25202 | i0 | 40.6 | 6.31034482758621 | 106 | 62 | 84.4 | 1 | 373 | 56 | 62 | 166 | KAF4680237.1 hypothetical protein FOZ60_013851 [Perkinsus olseni] | diamond | 2379 | 87.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 2983636 | 2983636 | PRJNA437204_P_NODE_59863_length_281_cov_1.480769_g59564_i0 | PRJNA437204 | 59863 | 281 | 1.480769 | 4.16096089 | root | 1 | Root_unresolved | Root_unresolved | 154 | 5.22e-41 | NR | KAF4669701.1 | 32597 | g59564 | i0 | 77.4 | 11.914590747331 | 93 | 20 | 99.3 | 1 | 279 | 1 | 870 | 961 | KAF4669701.1 hypothetical protein FOZ61_003295 [Perkinsus olseni] | diamond | 3348 | 154 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 4259184 | 4259184 | PRJNA437204_P_NODE_18984_length_420_cov_1.109510_g18685_i0 | PRJNA437204 | 18984 | 420 | 1.10951 | 4.659942 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.4e-55 | NR | KAF4719607.1 | 32597 | g18685 | i0 | 69.2 | 19.5071428571429 | 130 | 40 | 92.9 | 0 | 3 | 392 | 213 | 342 | KAF4719607.1 hypothetical protein FOZ62_009256, partial [Perkinsus olseni] | diamond | 8193 | 189 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 9361253 | 9361253 | PRJNA437204_P_NODE_73668_length_259_cov_1.704301_g73369_i0 | PRJNA437204 | 73668 | 259 | 1.704301 | 4.41413959 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 6.33e-28 | NTclustered | gi|294929719|ref|XM_002779297.1| | 423536 | g73369 | i0 | 79.104 | 3.0965250965251 | 201 | 40 | 77 | 2 | 53 | 252 | 1382 | 1183 | Perkinsus marinus ATCC 50983 translation elongation factor EF-1, subunit alpha,, putative, mRNA | blastn | 802 | 137 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 22109376 | 22109376 | PRJNA437204_P_NODE_5058_length_702_cov_6.344992_g4775_i0 | PRJNA437204 | 5058 | 702 | 6.344992 | 44.54184384 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 8.45e-76 | NR | XP_002778466.1 | 423536 | g4775 | i0 | 61.6 | 0.811965811965812 | 190 | 67 | 78.6 | 3 | 42 | 593 | 1 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 570 | 237 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27408583 | 27408583 | PRJNA437204_P_NODE_3023_length_856_cov_7.467433_g2777_i0 | PRJNA437204 | 3023 | 856 | 7.467433 | 63.92122648 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 3.19e-44 | NR | KAF4703844.1 | 32597 | g2777 | i0 | 37.7 | 7.51752336448598 | 268 | 157 | 91.5 | 4 | 843 | 61 | 178 | 442 | KAF4703844.1 40S ribosomal protein S3-1, partial [Perkinsus olseni] | diamond | 6435 | 167 | 0.994011976047904 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28197561 | 28197561 | PRJNA437204_P_NODE_15866_length_449_cov_1.861702_g15567_i0 | PRJNA437204 | 15866 | 449 | 1.861702 | 8.35904198 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 0.00215 | NR | KAF4654098.1 | 330153 | g15567 | i0 | 33.6 | 1.1358574610245 | 107 | 59 | 70.8 | 3 | 441 | 124 | 226 | 321 | KAF4654098.1 Protein phosphatase PP2A regulatory subunit B [Perkinsus chesapeaki] | diamond | 510 | 49.3 | 0.991886409736308 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28433975 | 28433975 | PRJNA437204_P_NODE_62806_length_276_cov_1.517241_g62507_i0 | PRJNA437204 | 62806 | 276 | 1.517241 | 4.18758516 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 5.45e-7 | NR | KAF4659815.1 | 330153 | g62507 | i0 | 39.2 | 3.64130434782609 | 79 | 46 | 85.9 | 1 | 239 | 3 | 4 | 80 | KAF4659815.1 histone H2B [Perkinsus chesapeaki] | diamond | 1005 | 54.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30612843 | 30612843 | PRJNA437204_P_NODE_11073_length_516_cov_2.952596_g10775_i0 | PRJNA437204 | 11073 | 516 | 2.952596 | 15.23539536 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 4.27e-16 | NR | XP_002784356.1 | 423536 | g10775 | i0 | 31.8 | 1.56395348837209 | 129 | 88 | 75 | 0 | 69 | 455 | 19 | 147 | XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983] | diamond | 807 | 81.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30850514 | 30850514 | PRJNA437204_P_NODE_26294_length_373_cov_1.263333_g25995_i0 | PRJNA437204 | 26294 | 373 | 1.263333 | 4.71223209 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 9.62e-15 | NR | KAF4705896.1 | 32597 | g25995 | i0 | 50 | 6.98123324396783 | 86 | 40 | 69.2 | 1 | 266 | 9 | 12 | 94 | KAF4705896.1 H/ACA snoRNP pseudouridylase subunit, partial [Perkinsus olseni] | diamond | 2604 | 80.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31008558 | 31008558 | PRJNA437204_P_NODE_104434_length_246_cov_0.890173_g104135_i0 | PRJNA437204 | 104434 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 3.24e-23 | NR | KAF4712232.1 | 32597 | g104135 | i0 | 63.3 | 8.64634146341463 | 79 | 29 | 96.3 | 0 | 3 | 239 | 64 | 142 | KAF4712232.1 oligosaccharyl transferase stt3 subunit, partial [Perkinsus olseni] | diamond | 2127 | 100 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31719397 | 31719397 | PRJNA437204_P_NODE_128597_length_241_cov_0.916667_g128298_i0 | PRJNA437204 | 128597 | 241 | 0.916667 | 2.20916747 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 3.19e-4 | NR | KAF4689687.1 | 32597 | g128298 | i0 | 36 | 1.41908713692946 | 75 | 33 | 74.7 | 2 | 36 | 215 | 344 | 418 | KAF4689687.1 Chromosomal serine/threonine-protein kinase jil-1 [Perkinsus olseni] | diamond | 342 | 48.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31909210 | 31909210 | PRJNA437204_P_NODE_4337_length_747_cov_3.111276_g4066_i0 | PRJNA437204 | 4337 | 747 | 3.111276 | 23.24123172 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 1.65e-44 | NR | KAF4675741.1 | 330153 | g4066 | i0 | 41.4 | 6.53413654618474 | 232 | 134 | 93.2 | 2 | 738 | 43 | 748 | 977 | KAF4675741.1 40S ribosomal protein S3-1 [Perkinsus chesapeaki] | diamond | 4881 | 171 | 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);;