contig_metadata
10 rows where bioproject = "PRJEB2368", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3849103 | 3849103 | PRJEB2368_P_NODE_1384_length_742_cov_4.194326_g815_i1 | PRJEB2368 | 1384 | 742 | 4.194326 | 31.12189892 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 180 | 3.2699999999999998e-40 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g815 | i1 | 86.31 | 11.2830188679245 | 168 | 20 | 23 | 3 | 1 | 167 | 1138 | 1303 | Myxobolus arcticus from Japan 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 | 8372 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 7675173 | 7675173 | PRJEB2368_P_NODE_1647_length_681_cov_4.400621_g815_i2 | PRJEB2368 | 1647 | 681 | 4.400621 | 29.96822901 | Myxobolus xiantaoensis | 2571166 | Cnidaria | other_Eukaryota | 113 | 3.07e-20 | NTclustered | gi|1887098227|gb|MT872001.1| | 2571166 | g815 | i2 | 87.129 | 10.352422907489 | 101 | 12 | 15 | 1 | 80 | 180 | 829 | 730 | Myxobolus xiantaoensis isolate Xiantao large subunit ribosomal RNA gene, partial sequence | blastn | 7050 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus xiantaoensis | |
| 10225661 | 10225661 | PRJEB2368_P_NODE_1209_length_790_cov_8.243028_g992_i0 | PRJEB2368 | 1209 | 790 | 8.243028 | 65.1199212 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1254 | 0 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g992 | i0 | 100 | 53.5886075949367 | 679 | 0 | 99 | 0 | 1 | 679 | 1864 | 2542 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 42335 | 1254 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 10225673 | 10225673 | PRJEB2368_P_NODE_2509_length_541_cov_3.666667_g2225_i0 | PRJEB2368 | 2509 | 541 | 3.666667 | 19.83666847 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 440 | 9.709999999999995e-119 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g2225 | i0 | 99.184 | 53.1256931608133 | 245 | 1 | 91 | 1 | 181 | 425 | 189 | 432 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 28741 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 15325087 | 15325087 | PRJEB2368_P_NODE_753_length_1004_cov_4.901758_g588_i0 | PRJEB2368 | 753 | 1004 | 4.901758 | 49.21365032 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1203 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g588 | i0 | 99.696 | 35.1703187250996 | 657 | 2 | 93 | 0 | 174 | 830 | 907 | 1563 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 35311 | 1203 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 21699633 | 21699633 | PRJEB2368_P_NODE_6798_length_291_cov_1.531496_g6480_i0 | PRJEB2368 | 6798 | 291 | 1.531496 | 4.45665336 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g6480 | i0 | 100 | 0.202749140893471 | 30 | 0 | 10 | 0 | 240 | 269 | 8495842 | 8495871 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22974903 | 22974903 | PRJEB2368_P_NODE_8459_length_287_cov_1.616000_g8141_i0 | PRJEB2368 | 8459 | 287 | 1.616 | 4.63792 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2519002640|ref|XM_057452941.1| | 13093 | g8141 | i0 | 100 | 0.101045296167247 | 29 | 0 | 10 | 0 | 258 | 286 | 766 | 794 | PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130647178 (LOC130647178), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 23938554 | 23938554 | PRJEB2368_P_NODE_1039_length_850_cov_15.494465_g840_i0 | PRJEB2368 | 1039 | 850 | 15.494465 | 131.7029525 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 316 | 2.75e-81 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g840 | i0 | 96.825 | 21.9352941176471 | 189 | 6 | 22 | 0 | 1 | 189 | 3286 | 3098 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 18645 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 23938710 | 23938710 | PRJEB2368_P_NODE_5779_length_319_cov_1.524823_g5461_i0 | PRJEB2368 | 5779 | 319 | 1.524823 | 4.86418537 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 112 | 1.63e-26 | NR | YP_011052057.1 | 669202 | g5461 | i0 | 61.5 | 0.733542319749216 | 78 | 30 | 73.4 | 0 | 86 | 319 | 190 | 267 | YP_011052057.1 cytochrome c oxidase subunit I [Thelohanellus kitauei] | diamond | 234 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 32681800 | 32681800 | PRJEB2368_P_NODE_15520_length_154_cov_1.000000_g15201_i0 | PRJEB2368 | 15520 | 154 | 1 | 1.54 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00172 | NR | XP_022809421.1 | 50429 | g15201 | i0 | 56.3 | 3.11688311688312 | 32 | 14 | 62.3 | 0 | 100 | 5 | 349 | 380 | XP_022809421.1 uncharacterized protein LOC111346397 [Stylophora pistillata] | diamond | 480 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata |
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);;