contig_metadata
13 rows where bioproject = "PRJNA630162", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9530533 | 9530533 | PRJNA630162_P_NODE_20048_length_413_cov_4.538462_g18534_i0 | PRJNA630162 | 20048 | 413 | 4.538462 | 18.74384806 | Salmoxcellia vastator | 2874172 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 6.55e-10 | NTclustered | gi|2258116978|gb|ON819178.1| | 2874172 | g18534 | i0 | 82.759 | 0.210653753026634 | 87 | 15 | 21 | 0 | 203 | 289 | 4584 | 4670 | Salmoxcellia vastator strain BC241120 internal transcribed spacer region, partial sequence | blastn | 87 | 78.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Xcellidae | Salmoxcellia | Salmoxcellia vastator | |||
| 15905647 | 15905647 | PRJNA630162_P_NODE_91793_length_190_cov_5.765957_g90270_i0 | PRJNA630162 | 91793 | 190 | 5.765957 | 10.9553183 | Tuberlatum coatsi | 2497440 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 5.629999999999999e-32 | NTclustered | gi|1538047935|gb|MK309360.1| | 2497440 | g90270 | i0 | 89.167 | 66.1473684210526 | 120 | 13 | 63 | 0 | 5 | 124 | 900 | 1019 | Tuberlatum coatsi strain TUcoa_LOHABE01 large subunit ribosomal RNA gene, partial sequence | blastn | 12568 | 150 | 1 | Eukaryota | Sar | Perkinsozoa | Parviluciferaceae | Tuberlatum | Tuberlatum coatsi | ||||
| 17180889 | 17180889 | PRJNA630162_P_NODE_98774_length_186_cov_2.131387_g97251_i0 | PRJNA630162 | 98774 | 186 | 2.131387 | 3.96437982 | Salmoxcellia vastator | 2874172 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 4.24e-33 | NTclustered | gi|2258116978|gb|ON819178.1| | 2874172 | g97251 | i0 | 86.014 | 5.94623655913978 | 143 | 20 | 77 | 0 | 7 | 149 | 5922 | 6064 | Salmoxcellia vastator strain BC241120 internal transcribed spacer region, partial sequence | blastn | 1106 | 154 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Xcellidae | Salmoxcellia | Salmoxcellia vastator | |||
| 19728680 | 19728680 | PRJNA630162_P_NODE_25656_length_360_cov_18.893891_g24136_i0 | PRJNA630162 | 25656 | 360 | 18.893891 | 68.0180076 | uncultured Perkinsea | 373149 | SAR_Eukaryotes | SAR_Eukaryotes | 658 | 0 | NTclustered | gi|918566068|gb|KP122533.1| | 373149 | g24136 | i0 | 99.721 | 100.213888888889 | 359 | 1 | 99 | 0 | 2 | 360 | 102 | 460 | Uncultured Perkinsea clone BIB6_B2 18S ribosomal RNA gene, partial sequence | blastn | 36077 | 658 | 1 | Eukaryota | Sar | Perkinsozoa | uncultured Perkinsea | ||||||
| 22828799 | 22828799 | PRJNA630162_P_NODE_28618_length_339_cov_5.534483_g27096_i0 | PRJNA630162 | 28618 | 339 | 5.534483 | 18.76189737 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 3.0299999999999996e-42 | NTclustered | gi|22417090|gb|AF509333.1| | 32597 | g27096 | i0 | 87.898 | 42.2625368731563 | 157 | 19 | 46 | 0 | 5 | 161 | 6938 | 7094 | Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 14327 | 185 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 23554644 | 23554644 | PRJNA630162_P_NODE_21459_length_397_cov_21.718391_g19941_i0 | PRJNA630162 | 21459 | 397 | 21.718391 | 86.22201227 | Salmoxcellia vastator | 2874172 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 1.27e-51 | NTclustered | gi|2258116978|gb|ON819178.1| | 2874172 | g19941 | i0 | 88.043 | 11.0831234256927 | 184 | 21 | 46 | 1 | 209 | 391 | 6077 | 5894 | Salmoxcellia vastator strain BC241120 internal transcribed spacer region, partial sequence | blastn | 4400 | 217 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Xcellidae | Salmoxcellia | Salmoxcellia vastator | |||
| 24828904 | 24828904 | PRJNA630162_P_NODE_77500_length_204_cov_2.935484_g75977_i0 | PRJNA630162 | 77500 | 204 | 2.935484 | 5.98838736 | Pararosarium dinoexitiosum | 2863858 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.87e-25 | NTclustered | gi|2074179780|gb|MZ668307.1| | 2863858 | g75977 | i0 | 82.667 | 79.3382352941177 | 150 | 20 | 72 | 6 | 31 | 176 | 969 | 1116 | Pararosarium dinoexitiosum strain PAdin_LOHABE01 large subunit ribosomal RNA gene, partial sequence | blastn | 16185 | 128 | 1 | Eukaryota | Sar | Perkinsozoa | Pararosarium | Pararosarium dinoexitiosum | |||||
| 27681269 | 27681269 | PRJNA630162_P_NODE_152284_length_164_cov_0.904348_g150761_i0 | PRJNA630162 | 152284 | 164 | 0.904348 | 1.48313072 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 2.68e-6 | NR | KAF4734972.1 | 32597 | g150761 | i0 | 44.2 | 1.90243902439024 | 52 | 29 | 95.1 | 0 | 7 | 162 | 238 | 289 | KAF4734972.1 hypothetical protein FOZ62_007319, partial [Perkinsus olseni] | diamond | 312 | 53.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28009559 | 28009559 | PRJNA630162_P_NODE_130245_length_169_cov_2.041667_g128722_i0 | PRJNA630162 | 130245 | 169 | 2.041667 | 3.45041723 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00158 | NR | KAF4676391.1 | 330153 | g128722 | i0 | 57.1 | 2.66272189349112 | 35 | 15 | 62.1 | 0 | 61 | 165 | 606 | 640 | KAF4676391.1 hypothetical protein FOL47_006305 [Perkinsus chesapeaki] | diamond | 450 | 45.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28059767 | 28059767 | PRJNA630162_P_NODE_155965_length_163_cov_0.912281_g154442_i0 | PRJNA630162 | 155965 | 163 | 0.912281 | 1.48701803 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.00665 | NR | XP_002772932.1 | 423536 | g154442 | i0 | 38 | 1.84049079754601 | 50 | 31 | 92 | 0 | 158 | 9 | 462 | 511 | XP_002772932.1 hypothetical protein Pmar_PMAR013275 [Perkinsus marinus ATCC 50983] | diamond | 300 | 43.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31262495 | 31262495 | PRJNA630162_P_NODE_113255_length_178_cov_1.387597_g111732_i0 | PRJNA630162 | 113255 | 178 | 1.387597 | 2.46992266 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 3.05e-5 | NR | KAF4701249.1 | 32597 | g111732 | i0 | 53.8 | 3.9438202247191 | 39 | 18 | 65.7 | 0 | 8 | 124 | 34 | 72 | KAF4701249.1 hypothetical protein FOZ63_016284, partial [Perkinsus olseni] | diamond | 702 | 49.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32546991 | 32546991 | PRJNA630162_P_NODE_112879_length_178_cov_1.589147_g111356_i0 | PRJNA630162 | 112879 | 178 | 1.589147 | 2.82868166 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00321 | NR | KAF4708041.1 | 32597 | g111356 | i0 | 46.9 | 1.65168539325843 | 49 | 25 | 80.9 | 1 | 173 | 30 | 924 | 972 | KAF4708041.1 hypothetical protein FOZ63_029828 [Perkinsus olseni] | diamond | 294 | 44.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32704191 | 32704191 | PRJNA630162_P_NODE_143280_length_166_cov_0.897436_g141757_i0 | PRJNA630162 | 143280 | 166 | 0.897436 | 1.48974376 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 3.35e-6 | NR | KAF4740879.1 | 32597 | g141757 | i0 | 40.4 | 1.86144578313253 | 52 | 31 | 94 | 0 | 157 | 2 | 107 | 158 | KAF4740879.1 hypothetical protein FOZ62_024698, partial [Perkinsus olseni] | diamond | 309 | 52.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni |
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);;