contig_metadata
14 rows where bioproject = "PRJNA752278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12206600 | 12206600 | PRJNA752278_P_NODE_24370_length_331_cov_1.143411_g24167_i0 | PRJNA752278 | 24370 | 331 | 1.143411 | 3.78469041 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 3.49e-30 | NR | KAF4693773.1 | 32597 | g24167 | i0 | 75.6 | 4.41389728096677 | 82 | 18 | 72.5 | 1 | 92 | 331 | 51 | 132 | KAF4693773.1 Protein phosphatase PP2A regulatory subunit B [Perkinsus olseni] | diamond | 1461 | 124 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 14756186 | 14756186 | PRJNA752278_P_NODE_31612_length_304_cov_3.051948_g31409_i0 | PRJNA752278 | 31612 | 304 | 3.051948 | 9.27792192 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 9.430000000000001e-57 | NTclustered | gi|294933094|ref|XM_002780549.1| | 423536 | g31409 | i0 | 80.872 | 30.5625 | 298 | 55 | 98 | 2 | 4 | 300 | 253 | 549 | Perkinsus marinus ATCC 50983 40S ribosomal protein S5, putative, mRNA | blastn | 9291 | 233 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 14756927 | 14756927 | PRJNA752278_P_NODE_71992_length_256_cov_1.683060_g71789_i0 | PRJNA752278 | 71992 | 256 | 1.68306 | 4.3086336 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 5.07e-11 | NR | KAF4754290.1 | 32597 | g71789 | i0 | 49.4 | 4.74609375 | 81 | 41 | 94.9 | 0 | 5 | 247 | 960 | 1040 | KAF4754290.1 Dynein heavy chain 1, axonemal [Perkinsus olseni] | diamond | 1215 | 68.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 19854383 | 19854383 | PRJNA752278_P_NODE_336_length_1591_cov_4.151515_g256_i0 | PRJNA752278 | 336 | 1591 | 4.151515 | 66.05060365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 535 | 1.21e-184 | NR | KAF4669737.1 | 330153 | g256 | i0 | 60.5 | 12.1282212445003 | 410 | 160 | 76.9 | 1 | 1275 | 52 | 42 | 451 | KAF4669737.1 hypothetical protein FOL47_002387 [Perkinsus chesapeaki] | diamond | 19296 | 540 | 0.990740740740741 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27473570 | 27473570 | PRJNA752278_P_NODE_20403_length_353_cov_1.100000_g20200_i0 | PRJNA752278 | 20403 | 353 | 1.1 | 3.883 | root | 1 | Root_unresolved | Root_unresolved | 81.6 | 2.98e-15 | NR | KAF4744129.1 | 32597 | g20200 | i0 | 42.4 | 13.0198300283286 | 118 | 63 | 96 | 1 | 340 | 2 | 303 | 420 | KAF4744129.1 hypothetical protein FOZ62_021310, partial [Perkinsus olseni] | diamond | 4596 | 82.4 | 0.990291262135922 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27811144 | 27811144 | PRJNA752278_P_NODE_41424_length_285_cov_2.117925_g41221_i0 | PRJNA752278 | 41424 | 285 | 2.117925 | 6.03608625 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.0128 | NR | XP_002773434.1 | 423536 | g41221 | i0 | 33.3 | 1.68421052631579 | 69 | 46 | 72.6 | 0 | 277 | 71 | 625 | 693 | XP_002773434.1 hypothetical protein Pmar_PMAR027891 [Perkinsus marinus ATCC 50983] | diamond | 480 | 44.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27905421 | 27905421 | PRJNA752278_P_NODE_83485_length_249_cov_0.875000_g83282_i0 | PRJNA752278 | 83485 | 249 | 0.875 | 2.17875 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 8.74e-4 | NR | KAF4749868.1 | 32597 | g83282 | i0 | 32.5 | 1 | 83 | 53 | 98.8 | 2 | 3 | 248 | 12 | 92 | KAF4749868.1 hypothetical protein FOZ62_016364, partial [Perkinsus olseni] | diamond | 249 | 46.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28284366 | 28284366 | PRJNA752278_P_NODE_77366_length_251_cov_1.601124_g77163_i0 | PRJNA752278 | 77366 | 251 | 1.601124 | 4.01882124 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 2.72e-17 | NR | KAF4677473.1 | 330153 | g77163 | i0 | 68.5 | 1.36254980079681 | 54 | 17 | 64.5 | 0 | 2 | 163 | 127 | 180 | KAF4677473.1 hypothetical protein FOL47_001288 [Perkinsus chesapeaki] | diamond | 342 | 85.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29147326 | 29147326 | PRJNA752278_P_NODE_22509_length_341_cov_1.645522_g22306_i0 | PRJNA752278 | 22509 | 341 | 1.645522 | 5.61123002 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 3.72e-19 | NR | KAF4683873.1 | 32597 | g22306 | i0 | 56 | 1.97947214076246 | 75 | 33 | 66 | 0 | 106 | 330 | 10 | 84 | KAF4683873.1 hypothetical protein FOZ60_008534 [Perkinsus olseni] | diamond | 675 | 92 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29273061 | 29273061 | PRJNA752278_P_NODE_78949_length_251_cov_0.865169_g78746_i0 | PRJNA752278 | 78949 | 251 | 0.865169 | 2.17157419 | Perkinsida | 27998 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 1.37e-39 | NR | KAF4683798.1 | 32597 | g78746 | i0 | 84.3 | 15.8725099601594 | 83 | 13 | 99.2 | 0 | 249 | 1 | 40 | 122 | KAF4683798.1 ATP-dependent RNA helicase dbp2 [Perkinsus olseni] | diamond | 3984 | 144 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30694600 | 30694600 | PRJNA752278_P_NODE_103813_length_241_cov_1.470238_g103610_i0 | PRJNA752278 | 103813 | 241 | 1.470238 | 3.54327358 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 6.64e-4 | NR | KAF4748643.1 | 32597 | g103610 | i0 | 52.5 | 2.63900414937759 | 40 | 19 | 49.8 | 0 | 21 | 140 | 195 | 234 | KAF4748643.1 DUF1620 super, partial [Perkinsus olseni] | diamond | 636 | 47.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31674462 | 31674462 | PRJNA752278_P_NODE_66677_length_261_cov_2.143617_g66474_i0 | PRJNA752278 | 66677 | 261 | 2.143617 | 5.59484037 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 6.240000000000001e-21 | NR | KAF4703864.1 | 32597 | g66474 | i0 | 49.4 | 4.72413793103448 | 85 | 42 | 97.7 | 1 | 255 | 1 | 13 | 96 | KAF4703864.1 40S ribosomal protein S19 [Perkinsus olseni] | diamond | 1233 | 91.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32613584 | 32613584 | PRJNA752278_P_NODE_42920_length_284_cov_1.312796_g42717_i0 | PRJNA752278 | 42920 | 284 | 1.312796 | 3.72834064 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 5.19e-4 | NR | XP_002765694.1 | 423536 | g42717 | i0 | 35.6 | 0.919014084507042 | 87 | 49 | 88.7 | 3 | 258 | 7 | 45 | 127 | XP_002765694.1 hypothetical protein Pmar_PMAR013760 [Perkinsus marinus ATCC 50983] | diamond | 261 | 48.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32834004 | 32834004 | PRJNA752278_P_NODE_99880_length_243_cov_0.905882_g99677_i0 | PRJNA752278 | 99880 | 243 | 0.905882 | 2.20129326 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 4.45e-14 | NR | XP_002767542.1 | 423536 | g99677 | i0 | 81 | 3.11111111111111 | 42 | 8 | 51.9 | 0 | 37 | 162 | 929 | 970 | XP_002767542.1 succinate dehydrogenase, putative [Perkinsus marinus ATCC 50983] | diamond | 756 | 76.6 | 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);;