contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA559720" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1130417 | 1130417 | PRJNA559720_P_NODE_2241_length_682_cov_3.397373_g2125_i0 | PRJNA559720 | 2241 | 682 | 3.397373 | 23.17008386 | Cystodiscus | 1141733 | Cnidaria | other_Eukaryota | 276 | 3.71e-69 | NTclustered | gi|331704035|gb|HQ822225.1| | 1026749 | g2125 | i0 | 94.886 | 23.8123167155425 | 176 | 9 | 26 | 0 | 440 | 615 | 330 | 505 | Cystodiscus cf. immersus Brazil 1 isolate CTBRIFJ3 18S small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16240 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Cystodiscus | Cystodiscus cf. immersus Brazil 1 | |
| 1819270 | 1819270 | PRJNA559720_P_NODE_6582_length_398_cov_7.323077_g6443_i0 | PRJNA559720 | 6582 | 398 | 7.323077 | 29.14584646 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 339 | 2.61e-88 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g6443 | i0 | 82.5 | 3.69597989949749 | 400 | 57 | 100 | 10 | 1 | 398 | 6595 | 6207 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 1471 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 3094414 | 3094414 | PRJNA559720_P_NODE_10723_length_294_cov_1.638009_g10584_i0 | PRJNA559720 | 10723 | 294 | 1.638009 | 4.81574646 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 145 | 4.3699999999999995e-30 | NTclustered | gi|1524898366|ref|XM_027201588.1| | 46731 | g10584 | i0 | 79.439 | 5.80272108843537 | 214 | 37 | 72 | 6 | 23 | 233 | 1667 | 1458 | PREDICTED: Pocillopora damicornis general transcription and DNA repair factor IIH helicase subunit XPB-like (LOC113684249), mRNA | blastn | 1706 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 12022646 | 12022646 | PRJNA559720_P_NODE_2070_length_704_cov_9.534073_g1958_i0 | PRJNA559720 | 2070 | 704 | 9.534073 | 67.11987392 | Aurantiactinomyxon sp. AUM-3 | 2184215 | Cnidaria | other_Eukaryota | 1301 | 0 | NTclustered | gi|1387575735|gb|KY784583.1| | 2184215 | g1958 | i0 | 100 | 101.546875 | 704 | 0 | 100 | 0 | 1 | 704 | 598 | 1301 | Aurantiactinomyxon sp. AUM-3 18S ribosomal RNA gene, complete sequence. | blastn | 71489 | 1301 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Aurantiactinomyxon | Aurantiactinomyxon sp. AUM-3 | |||
| 15846294 | 15846294 | PRJNA559720_P_NODE_12553_length_265_cov_1.385417_g12414_i0 | PRJNA559720 | 12553 | 265 | 1.385417 | 3.67135505 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 176 | 1.38e-39 | NTclustered | gi|2729076316|ref|XM_065200451.1| | 499914 | g12414 | i0 | 79.592 | 3.45283018867925 | 245 | 50 | 92 | 0 | 3 | 247 | 1334 | 1090 | PREDICTED: Rhopilema esculentum obg-like ATPase 1 (LOC135684793), mRNA | blastn | 915 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 17121254 | 17121254 | PRJNA559720_P_NODE_3574_length_547_cov_21.413502_g3446_i0 | PRJNA559720 | 3574 | 547 | 21.413502 | 117.13185594 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 180 | 2.3699999999999998e-40 | NTclustered | gi|2751569456|ref|XM_059086926.2| | 203993 | g3446 | i0 | 74.61 | 3.87934186471664 | 449 | 95 | 80 | 15 | 70 | 508 | 644 | 205 | PREDICTED: Pocillopora verrucosa calmodulin (LOC131771151), transcript variant X1, mRNA | blastn | 2122 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 20256928 | 20256928 | PRJNA559720_P_NODE_3056_length_590_cov_12.056093_g2934_i0 | PRJNA559720 | 3056 | 590 | 12.056093 | 71.1309487 | Aurantiactinomyxon | 66476 | Cnidaria | other_Eukaryota | 985 | 0 | NTclustered | gi|1387575734|gb|KY784582.1| | 2184214 | g2934 | i0 | 96.154 | 92.9898305084746 | 598 | 12 | 99 | 1 | 1 | 587 | 598 | 1 | Aurantiactinomyxon sp. AUM-1 18S ribosomal RNA gene, complete sequence. | blastn | 54864 | 990 | 0.994949494949495 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Aurantiactinomyxon | Aurantiactinomyxon sp. AUM-1 |
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);;