contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1161852 | 1161852 | PRJNA662254_P_NODE_17861_length_387_cov_3.993631_g17210_i0 | PRJNA662254 | 17861 | 387 | 3.993631 | 15.45535197 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 180 | 1.6199999999999996e-40 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g17210 | i0 | 90.977 | 31.8733850129199 | 133 | 12 | 34 | 0 | 219 | 351 | 6556 | 6424 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 12335 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 4456309 | 4456309 | PRJNA662254_P_NODE_59724_length_244_cov_0.900585_g59073_i0 | PRJNA662254 | 59724 | 244 | 0.900585 | 2.1974274 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2113840228|ref|XM_029337221.2| | 45264 | g59073 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 132 | 159 | 2064 | 2091 | PREDICTED: Acropora millepora histone-lysine N-methyltransferase SMYD3-like (LOC114959269), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 5731727 | 5731727 | PRJNA662254_P_NODE_31765_length_295_cov_1.090090_g31114_i0 | PRJNA662254 | 31765 | 295 | 1.09009 | 3.2157655 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 217 | 9.17e-52 | NTclustered | gi|2744794010|ref|XM_012698561.3| | 6087 | g31114 | i0 | 82.47 | 9.2 | 251 | 40 | 84 | 4 | 47 | 295 | 496 | 248 | PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA | blastn | 2714 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 8281389 | 8281389 | PRJNA662254_P_NODE_11507_length_486_cov_8.145278_g10856_i0 | PRJNA662254 | 11507 | 486 | 8.145278 | 39.58605108 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 809 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g10856 | i0 | 99.774 | 40.738683127572 | 442 | 0 | 91 | 1 | 44 | 485 | 1 | 441 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19799 | 809 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 8281610 | 8281610 | PRJNA662254_P_NODE_6367_length_677_cov_9.221854_g5754_i0 | PRJNA662254 | 6367 | 677 | 9.221854 | 62.43195158 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1251 | 0 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g5754 | i0 | 100 | 60.5036927621861 | 677 | 0 | 100 | 0 | 1 | 677 | 1870 | 2546 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 40961 | 1251 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 10090566 | 10090566 | PRJNA662254_P_NODE_6188_length_691_cov_1.092233_g5579_i0 | PRJNA662254 | 6188 | 691 | 1.092233 | 7.54733003 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 154 | 1.84e-32 | NTclustered | gi|8101942|gb|AF262347.1| | 51768 | g5579 | i0 | 95.789 | 14.7684515195369 | 95 | 4 | 14 | 0 | 150 | 244 | 769 | 675 | Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 10205 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Alcyoniidae | Alcyonium | Alcyonium digitatum | |
| 10832540 | 10832540 | PRJNA662254_P_NODE_62189_length_242_cov_2.100592_g61538_i0 | PRJNA662254 | 62189 | 242 | 2.100592 | 5.08343264 | Sphaerospora angulata | 1232752 | Cnidaria | other_Eukaryota | 165 | 2.68e-36 | NTclustered | gi|444437440|gb|JX286637.1| | 1232752 | g61538 | i0 | 87.857 | 5.3595041322314 | 140 | 17 | 58 | 0 | 84 | 223 | 1 | 140 | Sphaerospora angulata isolate 4K2/01032011 elongation factor 2 (EF2) gene, partial cds | blastn | 1297 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaerosporidae | Sphaerospora | Sphaerospora angulata | |
| 12107633 | 12107633 | PRJNA662254_P_NODE_34450_length_284_cov_4.573460_g33799_i0 | PRJNA662254 | 34450 | 284 | 4.57346 | 12.9886264 | Myxobolus sp. 'branchicola' | 1446104 | Cnidaria | other_Eukaryota | 215 | 3.16e-51 | NTclustered | gi|573041015|gb|JN616264.1| | 1446104 | g33799 | i0 | 88.636 | 58.556338028169 | 176 | 20 | 62 | 0 | 1 | 176 | 3759 | 3584 | Myxobolus sp. 'branchicola' voucher CQ-20090225 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16630 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus sp. 'branchicola' | |
| 13915918 | 13915918 | PRJNA662254_P_NODE_4251_length_851_cov_3.141388_g3713_i0 | PRJNA662254 | 4251 | 851 | 3.141388 | 26.73321188 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 396 | 3.44e-105 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g3713 | i0 | 97.414 | 27.2820211515864 | 232 | 6 | 27 | 0 | 1 | 232 | 3329 | 3098 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 23217 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 14657191 | 14657191 | PRJNA662254_P_NODE_2532_length_1119_cov_7.329828_g2131_i0 | PRJNA662254 | 2532 | 1119 | 7.329828 | 82.02077532 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 2056 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g2131 | i0 | 99.821 | 37.2359249329759 | 1119 | 2 | 100 | 0 | 1 | 1119 | 1749 | 631 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 41667 | 2056 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 15931128 | 15931128 | PRJNA662254_P_NODE_3153_length_994_cov_14.989142_g2697_i0 | PRJNA662254 | 3153 | 994 | 14.989142 | 148.99207148 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.028 | NTclustered | gi|2744889029|ref|XM_065810454.1| | 6087 | g2697 | i0 | 100 | 0.0583501006036217 | 29 | 0 | 3 | 0 | 218 | 246 | 2248 | 2276 | PREDICTED: Hydra vulgaris kinesin-like protein KIF28P (LOC100208423), transcript variant X3, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 21563878 | 21563878 | PRJNA662254_P_NODE_17657_length_390_cov_0.968454_g17006_i0 | PRJNA662254 | 17657 | 390 | 0.968454 | 3.7769706 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.037 | NTclustered | gi|2114213470|ref|XM_044322636.1| | 45264 | g17006 | i0 | 100 | 0.78974358974359 | 28 | 0 | 7 | 0 | 363 | 390 | 319 | 292 | PREDICTED: Acropora millepora clumping factor A-like (LOC114976410), mRNA | blastn | 308 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora |
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);;