contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 776861 | 776861 | PRJNA792582_P_NODE_32721_length_302_cov_0.855895_g31907_i0 | PRJNA792582 | 32721 | 302 | 0.855895 | 2.5848029 | Actinia equina | 6106 | Cnidaria | other_Eukaryota | 379 | 1.14e-100 | NTclustered | gi|76262440|gb|DQ159069.1| | 6106 | g31907 | i0 | 89.369 | 7.94701986754967 | 301 | 32 | 99 | 0 | 1 | 301 | 467 | 167 | Actinia equina blue chromoprotein aeCP597 mRNA, complete cds | blastn | 2400 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia equina | |
| 777071 | 777071 | PRJNA792582_P_NODE_51281_length_249_cov_3.107955_g50467_i0 | PRJNA792582 | 51281 | 249 | 3.107955 | 7.73880795 | Actinia equina | 6106 | Cnidaria | other_Eukaryota | 285 | 2.0399999999999997e-72 | NTclustered | gi|76262440|gb|DQ159069.1| | 6106 | g50467 | i0 | 87.449 | 3.8714859437751 | 247 | 31 | 99 | 0 | 1 | 247 | 396 | 642 | Actinia equina blue chromoprotein aeCP597 mRNA, complete cds | blastn | 964 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia equina | |
| 3328001 | 3328001 | PRJNA792582_P_NODE_23443_length_356_cov_1.356890_g22629_i0 | PRJNA792582 | 23443 | 356 | 1.35689 | 4.8305284 | Actinia equina | 6106 | Cnidaria | other_Eukaryota | 392 | 1.7499999999999995e-104 | NTclustered | gi|76262440|gb|DQ159069.1| | 6106 | g22629 | i0 | 86.686 | 5.78932584269663 | 353 | 47 | 99 | 0 | 3 | 355 | 600 | 248 | Actinia equina blue chromoprotein aeCP597 mRNA, complete cds | blastn | 2061 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia equina | |
| 7155154 | 7155154 | PRJNA792582_P_NODE_12586_length_481_cov_2.622549_g11774_i0 | PRJNA792582 | 12586 | 481 | 2.622549 | 12.61446069 | Myxobolus wulii | 649408 | Cnidaria | other_Eukaryota | 137 | 1.26e-27 | NTclustered | gi|2692952329|ref|NC_086768.1| | 649408 | g11774 | i0 | 75.658 | 0.632016632016632 | 304 | 59 | 61 | 13 | 184 | 475 | 6171 | 6471 | Myxobolus wulii isolate C1 complete mitochondrial genome | blastn | 304 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus wulii | |
| 11419253 | 11419253 | PRJNA792582_P_NODE_27329_length_330_cov_2.836576_g26515_i0 | PRJNA792582 | 27329 | 330 | 2.836576 | 9.3607008 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 176 | 1.77e-39 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g26515 | i0 | 90.84 | 34.6939393939394 | 131 | 12 | 40 | 0 | 1 | 131 | 6426 | 6556 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 11449 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 13530422 | 13530422 | PRJNA792582_P_NODE_15831_length_433_cov_1.636111_g15017_i0 | PRJNA792582 | 15831 | 433 | 1.636111 | 7.08436063 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 789 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g15017 | i0 | 99.538 | 35.8221709006928 | 433 | 2 | 100 | 0 | 1 | 433 | 1210 | 778 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 15511 | 789 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 14805621 | 14805621 | PRJNA792582_P_NODE_44892_length_264_cov_2.272251_g44078_i0 | PRJNA792582 | 44892 | 264 | 2.272251 | 5.99874264 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|1603815660|ref|XM_028556383.1| | 151771 | g44078 | i0 | 100 | 0.106060606060606 | 28 | 0 | 11 | 0 | 38 | 65 | 2866 | 2839 | PREDICTED: Dendronephthya gigantea uncharacterized LOC114535004 (LOC114535004), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 17355258 | 17355258 | PRJNA792582_P_NODE_38014_length_283_cov_1.357143_g37200_i0 | PRJNA792582 | 38014 | 283 | 1.357143 | 3.84071469 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2784710515|ref|XR_010871289.1| | 159855 | g37200 | i0 | 92.105 | 0.134275618374558 | 38 | 3 | 13 | 0 | 1 | 38 | 569 | 532 | PREDICTED: Acropora muricata uncharacterized lncRNA (LOC136917055), ncRNA | blastn | 38 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 21179248 | 21179248 | PRJNA792582_P_NODE_1277_length_1355_cov_3.477379_g919_i0 | PRJNA792582 | 1277 | 1355 | 3.477379 | 47.11848545 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 91.6 | 2.94e-13 | NTclustered | gi|2692952344|ref|NC_086769.1| | 669202 | g919 | i0 | 76.316 | 0.140221402214022 | 190 | 34 | 14 | 8 | 591 | 773 | 547 | 732 | Thelohanellus kitauei isolate A1 complete mitochondrial genome | blastn | 190 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 25003267 | 25003267 | PRJNA792582_P_NODE_1840_length_1156_cov_4.669437_g1393_i0 | PRJNA792582 | 1840 | 1156 | 4.669437 | 53.97869172 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 58.4 | 0.003 | NTclustered | gi|1519156033|gb|MK087050.1| | 59785 | g1393 | i0 | 100 | 0.130622837370242 | 31 | 0 | 3 | 0 | 144 | 174 | 13174 | 13204 | Myxobolus squamalis mitochondrion, complete genome | blastn | 151 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis |
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);;