contig_metadata
17 rows where bioproject = "PRJNA867519", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848044 | 848044 | PRJNA867519_P_NODE_16481_length_292_cov_1.397260_g16327_i0 | PRJNA867519 | 16481 | 292 | 1.39726 | 4.0799992 | root | 1 | Root_unresolved | Root_unresolved | 148 | 8.83e-41 | NR | KAF4698987.1 | 32597 | g16327 | i0 | 75.3 | 34.8698630136986 | 93 | 23 | 95.5 | 0 | 284 | 6 | 112 | 204 | KAF4698987.1 formate dehydrogenase (NAD+) [Perkinsus olseni] | diamond | 10182 | 149 | 0.993288590604027 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 848182 | 848182 | PRJNA867519_P_NODE_4101_length_522_cov_1.028953_g3949_i0 | PRJNA867519 | 4101 | 522 | 1.028953 | 5.37113466 | Bigyra | 2683628 | SAR_Eukaryotes | SAR_Eukaryotes | 251 | 5.0800000000000007e-79 | NR | XP_002784281.1 | 423536 | g3949 | i0 | 67.6 | 6.95977011494253 | 173 | 56 | 99.4 | 0 | 3 | 521 | 8 | 180 | XP_002784281.1 protein transport protein Sec61 subunit alpha, putative [Perkinsus marinus ATCC 50983] | diamond | 3633 | 253 | 0.992094861660079 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 3788878 | 3788878 | PRJNA867519_P_NODE_1423_length_807_cov_4.859673_g1285_i0 | PRJNA867519 | 1423 | 807 | 4.859673 | 39.21756111 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 358 | 4.23e-121 | NR | XP_002774056.1 | 423536 | g1285 | i0 | 75.7 | 0.840148698884758 | 226 | 55 | 84 | 0 | 804 | 127 | 90 | 315 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 678 | 358 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 8500986 | 8500986 | PRJNA867519_P_NODE_22967_length_262_cov_1.724868_g22813_i0 | PRJNA867519 | 22967 | 262 | 1.724868 | 4.51915416 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 6.6e-8 | NTclustered | gi|294941004|ref|XM_002782919.1| | 423536 | g22813 | i0 | 92 | 0.190839694656489 | 50 | 4 | 19 | 0 | 57 | 106 | 1250 | 1201 | Perkinsus marinus ATCC 50983 hypothetical protein, mRNA | blastn | 50 | 71.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 8501132 | 8501132 | PRJNA867519_P_NODE_947_length_948_cov_2.187429_g825_i0 | PRJNA867519 | 947 | 948 | 2.187429 | 20.73682692 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 478 | 1.3099999999999996e-167 | NR | XP_002774056.1 | 423536 | g825 | i0 | 72.9 | 0.981012658227848 | 310 | 83 | 97.8 | 1 | 948 | 22 | 6 | 315 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 930 | 478 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 17426289 | 17426289 | PRJNA867519_P_NODE_21494_length_269_cov_1.408163_g21340_i0 | PRJNA867519 | 21494 | 269 | 1.408163 | 3.78795847 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.2500000000000001e-22 | NR | KAF4651186.1 | 32597 | g21340 | i0 | 55.1 | 10.9516728624535 | 89 | 35 | 99.3 | 2 | 269 | 3 | 148 | 231 | KAF4651186.1 hypothetical protein FOZ61_010677 [Perkinsus olseni] | diamond | 2946 | 102 | 0.990196078431373 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27718959 | 27718959 | PRJNA867519_P_NODE_1224_length_860_cov_7.087675_g1089_i0 | PRJNA867519 | 1224 | 860 | 7.087675 | 60.954005 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 7.5e-30 | NR | TEB19254.1 | 2494336 | g1089 | i0 | 33.3 | 0.931395348837209 | 267 | 156 | 86.9 | 7 | 817 | 71 | 1 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 801 | 124 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 28191901 | 28191901 | PRJNA867519_P_NODE_20926_length_272_cov_0.824121_g20772_i0 | PRJNA867519 | 20926 | 272 | 0.824121 | 2.24160912 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0498 | NR | KAF4739663.1 | 32597 | g20772 | i0 | 32.1 | 1.16911764705882 | 53 | 36 | 58.5 | 0 | 269 | 111 | 54 | 106 | KAF4739663.1 hypothetical protein FOZ62_004327, partial [Perkinsus olseni] | diamond | 318 | 42 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28579280 | 28579280 | PRJNA867519_P_NODE_5747_length_452_cov_1.490765_g5593_i0 | PRJNA867519 | 5747 | 452 | 1.490765 | 6.7382578 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 4.6e-63 | NR | KAF4659385.1 | 330153 | g5593 | i0 | 69.3 | 4.95132743362832 | 150 | 46 | 99.6 | 0 | 450 | 1 | 233 | 382 | KAF4659385.1 hypothetical protein FOL47_007601 [Perkinsus chesapeaki] | diamond | 2238 | 219 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29242257 | 29242257 | PRJNA867519_P_NODE_5229_length_471_cov_2.459799_g5075_i0 | PRJNA867519 | 5229 | 471 | 2.459799 | 11.58565329 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.07e-50 | NR | KAF4653627.1 | 32597 | g5075 | i0 | 64.3 | 20.7324840764331 | 140 | 48 | 89.2 | 2 | 456 | 37 | 1 | 138 | KAF4653627.1 60S ribosomal protein L26 [Perkinsus olseni] | diamond | 9765 | 170 | 0.994117647058824 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29747103 | 29747103 | PRJNA867519_P_NODE_3270_length_574_cov_1.802395_g3119_i0 | PRJNA867519 | 3270 | 574 | 1.802395 | 10.3457473 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 8.33e-50 | NR | KAF4750125.1 | 32597 | g3119 | i0 | 46.8 | 7.8397212543554 | 190 | 101 | 99.3 | 0 | 570 | 1 | 17 | 206 | KAF4750125.1 hypothetical protein FOZ62_004160 [Perkinsus olseni] | diamond | 4500 | 172 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30403122 | 30403122 | PRJNA867519_P_NODE_18173_length_284_cov_1.094787_g18019_i0 | PRJNA867519 | 18173 | 284 | 1.094787 | 3.10919508 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00347 | NR | KAF4669884.1 | 330153 | g18019 | i0 | 36.7 | 0.517605633802817 | 49 | 31 | 51.8 | 0 | 53 | 199 | 57 | 105 | KAF4669884.1 hypothetical protein FOL47_002315 [Perkinsus chesapeaki] | diamond | 147 | 46.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31011069 | 31011069 | PRJNA867519_P_NODE_25714_length_251_cov_0.865169_g25560_i0 | PRJNA867519 | 25714 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00587 | NR | KAF4667143.1 | 32597 | g25560 | i0 | 52.5 | 4.64940239043825 | 40 | 18 | 46.6 | 1 | 6 | 122 | 189 | 228 | KAF4667143.1 hypothetical protein FOZ61_008604 [Perkinsus olseni] | diamond | 1167 | 45.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31287338 | 31287338 | PRJNA867519_P_NODE_495_length_1214_cov_3.260298_g399_i0 | PRJNA867519 | 495 | 1214 | 3.260298 | 39.58001772 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 7.989999999999998e-47 | NR | TEB19254.1 | 2494336 | g399 | i0 | 42.8 | 0.652388797364086 | 264 | 139 | 63 | 5 | 30 | 794 | 3 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 792 | 171 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 31991391 | 31991391 | PRJNA867519_P_NODE_8618_length_380_cov_1.612378_g8464_i0 | PRJNA867519 | 8618 | 380 | 1.612378 | 6.1270364 | Bigyra | 2683628 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 4.9e-16 | NR | XP_002767777.1 | 423536 | g8464 | i0 | 50.7 | 1.12105263157895 | 73 | 36 | 57.6 | 0 | 56 | 274 | 1 | 73 | XP_002767777.1 Metal homeostasis factor ATX1, putative [Perkinsus marinus ATCC 50983] | diamond | 426 | 78.2 | 0.994884910485933 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32086400 | 32086400 | PRJNA867519_P_NODE_31218_length_244_cov_0.900585_g31064_i0 | PRJNA867519 | 31218 | 244 | 0.900585 | 2.1974274 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.55e-36 | NR | KAF4717776.1 | 32597 | g31064 | i0 | 77.5 | 4.91803278688525 | 80 | 18 | 98.4 | 0 | 242 | 3 | 10 | 89 | KAF4717776.1 3-ketoacyl-CoA thiolase, peroxisomal, partial [Perkinsus olseni] | diamond | 1200 | 130 | 0.992307692307692 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32749946 | 32749946 | PRJNA867519_P_NODE_4800_length_488_cov_1.402410_g4647_i0 | PRJNA867519 | 4800 | 488 | 1.40241 | 6.8437608 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 3.66e-44 | NR | KAF4659554.1 | 330153 | g4647 | i0 | 63.7 | 12.9159836065574 | 124 | 45 | 76.2 | 0 | 476 | 105 | 427 | 550 | KAF4659554.1 60S ribosomal protein L9 [Perkinsus chesapeaki] | diamond | 6303 | 163 | 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);;