contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA758398" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 739812 | 739812 | PRJNA758398_S_NODE_4021_length_472_cov_1.683215_g3880_i0 | PRJNA758398 | 4021 | 472 | 1.683215 | 7.9447748 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 9.13e-59 | NTclustered | gi|302563026|dbj|AB546336.1| | 39717 | g3880 | i0 | 76.724 | 71.3728813559322 | 464 | 88 | 96 | 18 | 1 | 454 | 820 | 1273 | Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds | blastn | 33688 | 241 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 739836 | 739836 | PRJNA758398_S_NODE_42481_length_167_cov_0.864407_g42340_i0 | PRJNA758398 | 42481 | 167 | 0.864407 | 1.44355969 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 7.739999999999999e-60 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g42340 | i0 | 95.973 | 99.311377245509 | 149 | 6 | 89 | 0 | 1 | 149 | 3701 | 3849 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16585 | 243 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 3290844 | 3290844 | PRJNA758398_S_NODE_20483_length_225_cov_1.448864_g20342_i0 | PRJNA758398 | 20483 | 225 | 1.448864 | 3.259944 | Bodomorpha sp. Panama105 | 555789 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 2.869999999999999e-110 | NTclustered | gi|219524917|gb|EU709280.1| | 555789 | g20342 | i0 | 99.556 | 83.8266666666667 | 225 | 1 | 100 | 0 | 1 | 225 | 1369 | 1593 | Bodomorpha sp. Panama105 18S ribosomal RNA gene, partial sequence | blastn | 18861 | 411 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. Panama105 | |||
| 3291177 | 3291177 | PRJNA758398_S_NODE_47203_length_164_cov_2.234783_g47062_i0 | PRJNA758398 | 47203 | 164 | 2.234783 | 3.66504412 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 3.45e-73 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g47062 | i0 | 98.182 | 16.5548780487805 | 165 | 2 | 100 | 1 | 1 | 164 | 549 | 385 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 2715 | 287 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5843514 | 5843514 | PRJNA758398_S_NODE_55065_length_157_cov_3.907407_g54924_i0 | PRJNA758398 | 55065 | 157 | 3.907407 | 6.13462899 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.03e-45 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g54924 | i0 | 96.581 | 68.5095541401274 | 117 | 4 | 75 | 0 | 41 | 157 | 190 | 74 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 10756 | 195 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 7118538 | 7118538 | PRJNA758398_S_NODE_30226_length_193_cov_1.770833_g30085_i0 | PRJNA758398 | 30226 | 193 | 1.770833 | 3.41770769 | Massisteria marina | 127229 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.6699999999999997e-30 | NTclustered | gi|302026190|gb|GQ377684.1| | 127229 | g30085 | i0 | 81.977 | 2.30051813471503 | 172 | 30 | 89 | 1 | 19 | 190 | 188 | 18 | Massisteria marina HSP90 gene, partial cds | blastn | 444 | 145 | 1 | Eukaryota | Sar | Cercozoa | Massisteriidae | Massisteria | Massisteria marina | ||||
| 7118762 | 7118762 | PRJNA758398_S_NODE_50646_length_163_cov_0.894737_g50505_i0 | PRJNA758398 | 50646 | 163 | 0.894737 | 1.45842131 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 8.06e-10 | NTclustered | gi|27734338|gb|AY099124.1| | 1561963 | g50505 | i0 | 91.228 | 0.349693251533742 | 57 | 4 | 34 | 1 | 63 | 118 | 49 | 105 | Lotharella amoeboformis isolate pub4 polyubiquitin gene, partial cds | blastn | 57 | 76.8 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 10943622 | 10943622 | PRJNA758398_S_NODE_14629_length_258_cov_3.516746_g14488_i0 | PRJNA758398 | 14629 | 258 | 3.516746 | 9.07320468 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 7.539999999999998e-82 | NTclustered | gi|301014702|gb|GQ377715.1| | 323453 | g14488 | i0 | 89.919 | 58.0271317829457 | 248 | 21 | 95 | 4 | 2 | 247 | 285 | 40 | Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 14971 | 316 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 13493668 | 13493668 | PRJNA758398_S_NODE_4291_length_457_cov_20.553922_g4150_i0 | PRJNA758398 | 4291 | 457 | 20.553922 | 93.93142354 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 802 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g4150 | i0 | 98.886 | 86.9496717724289 | 449 | 5 | 98 | 0 | 1 | 449 | 783 | 335 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 39736 | 802 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14768586 | 14768586 | PRJNA758398_S_NODE_24132_length_211_cov_1.679012_g23991_i0 | PRJNA758398 | 24132 | 211 | 1.679012 | 3.54271532 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 3.459999999999999e-104 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g23991 | i0 | 100 | 42.781990521327 | 211 | 0 | 100 | 0 | 1 | 211 | 2899 | 2689 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 9027 | 390 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19866520 | 19866520 | PRJNA758398_S_NODE_216_length_1442_cov_14.035894_g181_i0 | PRJNA758398 | 216 | 1442 | 14.035894 | 202.39759148 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1616 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g181 | i0 | 99.328 | 68.8072122052705 | 893 | 6 | 62 | 0 | 518 | 1410 | 893 | 1 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 99220 | 1616 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19866915 | 19866915 | PRJNA758398_S_NODE_5776_length_395_cov_14.890173_g5635_i0 | PRJNA758398 | 5776 | 395 | 14.890173 | 58.81618335 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 1.14e-126 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g5635 | i0 | 99.225 | 38.3316455696203 | 258 | 2 | 65 | 0 | 1 | 258 | 258 | 1 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 15141 | 466 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21142547 | 21142547 | PRJNA758398_S_NODE_54577_length_161_cov_0.910714_g54436_i0 | PRJNA758398 | 54577 | 161 | 0.910714 | 1.46624954 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 7.72e-30 | NTclustered | gi|33304713|gb|AY251793.1| | 227086 | g54436 | i0 | 82.716 | 25.9689440993789 | 162 | 26 | 100 | 2 | 1 | 161 | 1283 | 1123 | Bigelowiella natans ubiquitin/actin fusion protein 2 mRNA, complete cds | blastn | 4181 | 143 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 22416833 | 22416833 | PRJNA758398_S_NODE_10718_length_296_cov_3.008097_g10577_i0 | PRJNA758398 | 10718 | 296 | 3.008097 | 8.90396712 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 6.78e-88 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g10577 | i0 | 88.256 | 66.2297297297297 | 281 | 33 | 95 | 0 | 3 | 283 | 59 | 339 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 19604 | 337 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 24966499 | 24966499 | PRJNA758398_S_NODE_50820_length_163_cov_0.894737_g50679_i0 | PRJNA758398 | 50820 | 163 | 0.894737 | 1.45842131 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|302563026|dbj|AB546336.1| | 39717 | g50679 | i0 | 100 | 0.521472392638037 | 29 | 0 | 18 | 0 | 131 | 159 | 1384 | 1412 | Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds | blastn | 85 | 54.7 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 24966530 | 24966530 | PRJNA758398_S_NODE_540_length_1110_cov_2.346843_g483_i0 | PRJNA758398 | 540 | 1110 | 2.346843 | 26.0499573 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 656 | 0 | NTclustered | gi|300676723|gb|GQ377712.1| | 323453 | g483 | i0 | 85.714 | 0.997297297297297 | 623 | 87 | 56 | 2 | 489 | 1110 | 832 | 211 | Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds | blastn | 1107 | 656 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 |
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);;