contig_metadata
11 rows where bioproject = "PRJNA400391", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1081063 | 1081063 | PRJNA400391_S_NODE_201_length_602_cov_12.125220_g153_i0 | PRJNA400391 | 201 | 602 | 12.12522 | 72.9938244 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 110 | 3.49e-19 | NTclustered | gi|167507730|gb|EU262833.1| | 46758 | g153 | i0 | 95.652 | 18.330564784053198 | 69 | 2 | 11 | 1 | 1 | 68 | 242 | 310 | Lobophyllia hemprichii 28S large subunit ribosomal RNA gene, partial sequence | blastn | 11035 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Lobophylliidae | Lobophyllia | Lobophyllia hemprichii | |
| 1081109 | 1081109 | PRJNA400391_S_NODE_5241_length_172_cov_14.131387_g5180_i0 | PRJNA400391 | 5241 | 172 | 14.131387 | 24.30598564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 6.66e-6 | NTclustered | gi|2160785901|gb|OL741695.1| | 68568 | g5180 | i0 | 95.122 | 23.343023255814 | 41 | 1 | 24 | 1 | 1 | 41 | 5785 | 5824 | Funiculina quadrangularis voucher NMS.Z.2019.25.17 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 4015 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Funiculinidae | Funiculina | Funiculina quadrangularis | |
| 3631871 | 3631871 | PRJNA400391_S_NODE_4323_length_193_cov_2.746835_g4262_i0 | PRJNA400391 | 4323 | 193 | 2.746835 | 5.30139155 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.6 | 3.53e-14 | NTclustered | gi|2689317146|gb|PP410670.1| | 44190 | g4262 | i0 | 94.828 | 32.0621761658031 | 58 | 3 | 30 | 0 | 17 | 74 | 3605 | 3548 | Acanthogorgia sp. voucher USNM:1659375 large subunit ribosomal RNA gene, partial sequence | blastn | 6188 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Acanthogorgiidae | Acanthogorgia | Acanthogorgia sp. | |
| 4241112 | 4241112 | PRJNA400391_S_NODE_1984_length_281_cov_4.117886_g1923_i0 | PRJNA400391 | 1984 | 281 | 4.117886 | 11.57125966 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 1.55e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g1923 | i0 | 100 | 2.37010676156584 | 32 | 0 | 11 | 0 | 187 | 218 | 6365 | 6334 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 9342226 | 9342226 | PRJNA400391_S_NODE_2948_length_234_cov_16.452261_g2887_i0 | PRJNA400391 | 2948 | 234 | 16.452261 | 38.49829074 | Anthohebella parasitica | 308667 | Cnidaria | other_Eukaryota | 102 | 2.05e-17 | NTclustered | gi|166407129|gb|EU272545.1| | 308667 | g2887 | i0 | 92.958 | 23.5683760683761 | 71 | 3 | 30 | 2 | 165 | 234 | 1888 | 1819 | Anthohebella parasitica voucher MHNG INVE29762 28S large subunit ribosomal RNA gene, partial sequence | blastn | 5515 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Hebellidae | Anthohebella | Anthohebella parasitica | |
| 10009115 | 10009115 | PRJNA400391_S_NODE_3468_length_216_cov_2.591160_g3407_i0 | PRJNA400391 | 3468 | 216 | 2.59116 | 5.5969056 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.4 | 1.89e-7 | NTclustered | gi|2113715647|ref|XR_006393646.1| | 45264 | g3407 | i0 | 95.349 | 3.18518518518519 | 43 | 2 | 20 | 0 | 152 | 194 | 3244 | 3286 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954209), rRNA | blastn | 688 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 10009152 | 10009152 | PRJNA400391_S_NODE_6468_length_153_cov_1.610169_g6407_i0 | PRJNA400391 | 6468 | 153 | 1.610169 | 2.46355857 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 54.7 | 0.003 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g6407 | i0 | 100 | 1.51633986928105 | 29 | 0 | 19 | 0 | 108 | 136 | 4680 | 4652 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 232 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 13834545 | 13834545 | PRJNA400391_S_NODE_4491_length_189_cov_1.506494_g4430_i0 | PRJNA400391 | 4491 | 189 | 1.506494 | 2.84727366 | Scleralcyonacea | 3028851 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2160785902|gb|OL741696.1| | 2598113 | g4430 | i0 | 100 | 0.296296296296296 | 28 | 0 | 15 | 0 | 1 | 28 | 4886 | 4859 | Kophobelemnon sp. NMS.Z.2019.25.4 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Kophobelemnidae | Kophobelemnon | Kophobelemnon sp. 1 RH-2019 | |
| 15716745 | 15716745 | PRJNA400391_S_NODE_2293_length_264_cov_7.934498_g2232_i0 | PRJNA400391 | 2293 | 264 | 7.934498 | 20.94707472 | Polypodium hydriforme | 43186 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2663986578|emb|OY756919.1| | 43186 | g2232 | i0 | 100 | 0.109848484848485 | 29 | 0 | 11 | 0 | 107 | 135 | 6126 | 6154 | Polypodium hydriforme genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Polypodiozoa | Polypodiidea | Polypodiidae | Polypodium | Polypodium hydriforme | |
| 18932517 | 18932517 | PRJNA400391_S_NODE_2715_length_243_cov_8.312500_g2654_i0 | PRJNA400391 | 2715 | 243 | 8.3125 | 20.199375 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 80.5 | 1e-10 | NTclustered | gi|2689317321|gb|PP410756.1| | 86543 | g2654 | i0 | 97.826 | 30.9917695473251 | 46 | 1 | 19 | 0 | 3 | 48 | 3565 | 3520 | Briareum asbestinum voucher USNM:1606846 large subunit ribosomal RNA gene, partial sequence | blastn | 7531 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Briareidae | Briareum | Briareum asbestinum | |
| 25307152 | 25307152 | PRJNA400391_S_NODE_1260_length_331_cov_25.956081_g1199_i0 | PRJNA400391 | 1260 | 331 | 25.956081 | 85.91462811 | Rhizostomeae | 37535 | Cnidaria | other_Eukaryota | 111 | 5.07e-20 | NTclustered | gi|2729058829|ref|XR_010517322.1| | 499914 | g1199 | i0 | 89.888 | 26.7703927492447 | 89 | 5 | 27 | 1 | 4 | 92 | 3608 | 3524 | PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA | blastn | 8861 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum |
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);;