contig_metadata
11 rows where bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6076765 | 6076765 | PRJNA986481_P_NODE_3325_length_830_cov_4.165173_g2959_i0 | PRJNA986481 | 3325 | 830 | 4.165173 | 34.5709359 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 1.07e-30 | NR | TEB19254.1 | 2494336 | g2959 | i0 | 34.7 | 0.907228915662651 | 251 | 142 | 84.2 | 8 | 810 | 112 | 17 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 753 | 125 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 13727499 | 13727499 | PRJNA986481_P_NODE_5691_length_669_cov_9.924194_g4979_i1 | PRJNA986481 | 5691 | 669 | 9.924194 | 66.39285786 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 275 | 1.05e-90 | NR | XP_002778466.1 | 423536 | g4979 | i1 | 70 | 0.852017937219731 | 190 | 56 | 84.8 | 1 | 606 | 40 | 1 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 570 | 275 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 23925953 | 23925953 | PRJNA986481_P_NODE_26079_length_321_cov_2.727941_g25554_i0 | PRJNA986481 | 26079 | 321 | 2.727941 | 8.75669061 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 8.31e-8 | NTclustered | gi|294947933|ref|XM_002785487.1| | 423536 | g25554 | i0 | 77.876 | 0.35202492211838 | 113 | 25 | 35 | 0 | 209 | 321 | 161 | 49 | Perkinsus marinus ATCC 50983 40S ribosomal protein S29-B, putative, mRNA | blastn | 113 | 71.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 25199436 | 25199436 | PRJNA986481_P_NODE_15040_length_423_cov_1.647059_g14515_i0 | PRJNA986481 | 15040 | 423 | 1.647059 | 6.96705957 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.41e-69 | NR | XP_002774056.1 | 423536 | g14515 | i0 | 75 | 0.99290780141844 | 140 | 35 | 99.3 | 0 | 4 | 423 | 158 | 297 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 420 | 222 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 25200068 | 25200068 | PRJNA986481_P_NODE_5420_length_683_cov_4.952681_g4979_i0 | PRJNA986481 | 5420 | 683 | 4.952681 | 33.82681123 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 1.73e-90 | NR | XP_002778466.1 | 423536 | g4979 | i0 | 70.5 | 0.834553440702782 | 190 | 55 | 83 | 1 | 620 | 54 | 1 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 570 | 274 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27506518 | 27506518 | PRJNA986481_P_NODE_16683_length_402_cov_1.348442_g16158_i0 | PRJNA986481 | 16683 | 402 | 1.348442 | 5.42073684 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 2.889999999999999e-38 | NR | KAF4657204.1 | 32597 | g16158 | i0 | 56.2 | 6.40298507462687 | 121 | 49 | 88.1 | 2 | 21 | 374 | 207 | 326 | KAF4657204.1 hypothetical protein FOZ61_006415 [Perkinsus olseni] | diamond | 2574 | 148 | 0.993243243243243 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28921064 | 28921064 | PRJNA986481_P_NODE_35968_length_272_cov_1.686099_g35443_i0 | PRJNA986481 | 35968 | 272 | 1.686099 | 4.58618928 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 7.29e-18 | NR | TEB19866.1 | 2494336 | g35443 | i0 | 95.3 | 0.474264705882353 | 43 | 2 | 47.4 | 0 | 252 | 124 | 521 | 563 | TEB19866.1 Aldehyde/histidinol dehydrogenase [Perkinsus sp. BL_2016] | diamond | 129 | 87.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 29047659 | 29047659 | PRJNA986481_P_NODE_8828_length_548_cov_2.328657_g8315_i0 | PRJNA986481 | 8828 | 548 | 2.328657 | 12.76104036 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.78e-66 | NR | XP_002778466.1 | 423536 | g8315 | i0 | 65.6 | 0.85948905109489 | 157 | 49 | 85.4 | 2 | 548 | 81 | 38 | 190 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 471 | 211 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30974362 | 30974362 | PRJNA986481_P_NODE_13954_length_439_cov_1.374359_g13430_i0 | PRJNA986481 | 13954 | 439 | 1.374359 | 6.03343601 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 3.36e-34 | NR | XP_002783965.1 | 423536 | g13430 | i0 | 48.5 | 8.56947608200456 | 130 | 66 | 88.8 | 1 | 390 | 1 | 80 | 208 | XP_002783965.1 Rab11, putative [Perkinsus marinus ATCC 50983] | diamond | 3762 | 129 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31422768 | 31422768 | PRJNA986481_P_NODE_23356_length_339_cov_2.641379_g22831_i0 | PRJNA986481 | 23356 | 339 | 2.641379 | 8.95427481 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 5.95e-24 | NR | KAF4656785.1 | 32597 | g22831 | i0 | 43.4 | 4.66371681415929 | 106 | 60 | 93.8 | 0 | 339 | 22 | 56 | 161 | KAF4656785.1 5', 3'-nucleotidase, cytosolic [Perkinsus olseni] | diamond | 1581 | 106 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31796177 | 31796177 | PRJNA986481_P_NODE_2857_length_881_cov_6.813702_g2508_i0 | PRJNA986481 | 2857 | 881 | 6.813702 | 60.02871462 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 1.2399999999999997e-42 | NR | TEB19254.1 | 2494336 | g2508 | i0 | 44.9 | 0.735527809307605 | 216 | 108 | 70.8 | 3 | 29 | 652 | 51 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 648 | 157 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 |
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);;