contig_metadata
16 rows where bioproject = "PRJNA946307", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 927853 | 927853 | PRJNA946307_P_NODE_73981_length_198_cov_3.080537_g73107_i0 | PRJNA946307 | 73981 | 198 | 3.080537 | 6.09946326 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 85.9 | 1e-17 | NR | RMX42961.1 | 46731 | g73107 | i0 | 44.8 | 3.77272727272727 | 105 | 13 | 90.9 | 1 | 6 | 185 | 207 | 311 | RMX42961.1 hypothetical protein pdam_00001854 [Pocillopora damicornis] | diamond | 747 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 3812360 | 3812360 | PRJNA946307_P_NODE_172363_length_154_cov_2.123810_g171489_i0 | PRJNA946307 | 172363 | 154 | 2.12381 | 3.2706674 | Hydra | 6083 | Cnidaria | other_Eukaryota | 285 | 1.14e-72 | NTclustered | gi|1032656005|gb|JN594043.2| | 6087 | g171489 | i0 | 100 | 95.3506493506493 | 154 | 0 | 100 | 0 | 1 | 154 | 56 | 209 | Hydra vulgaris 28S ribosomal RNA gene, partial sequence | blastn | 14684 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 7304044 | 7304044 | PRJNA946307_P_NODE_127846_length_171_cov_11.336066_g126972_i0 | PRJNA946307 | 127846 | 171 | 11.336066 | 19.38467286 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 97.1 | 6.52e-16 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g126972 | i0 | 95.161 | 0.91812865497076 | 62 | 2 | 36 | 1 | 77 | 137 | 10841882 | 10841821 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 157 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7305049 | 7305049 | PRJNA946307_P_NODE_27246_length_247_cov_3.560606_g26372_i0 | PRJNA946307 | 27246 | 247 | 3.560606 | 8.79469682 | Sphaerospora sparis | 1279230 | Cnidaria | other_Eukaryota | 130 | 1e-25 | NTclustered | gi|444437469|gb|JX286634.1| | 1279230 | g26372 | i0 | 90 | 36.9068825910931 | 100 | 10 | 40 | 0 | 42 | 141 | 2840 | 2741 | Sphaerospora sparis isolate 166/05 28S ribosomal RNA gene, partial sequence | blastn | 9116 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaerosporidae | Sphaerospora | Sphaerospora sparis | |
| 8579560 | 8579560 | PRJNA946307_P_NODE_168227_length_157_cov_4.546296_g167353_i0 | PRJNA946307 | 168227 | 157 | 4.546296 | 7.13768472 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 60.2 | 7.74e-5 | NTclustered | gi|2113715645|ref|XR_006393645.1| | 45264 | g167353 | i0 | 88.235 | 3.3375796178344 | 51 | 5 | 32 | 1 | 96 | 145 | 1472 | 1522 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954208), rRNA | blastn | 524 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 10189563 | 10189563 | PRJNA946307_P_NODE_70328_length_199_cov_3.113333_g69454_i0 | PRJNA946307 | 70328 | 199 | 3.113333 | 6.19553267 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|1524875281|ref|XM_027189328.1| | 46731 | g69454 | i0 | 100 | 0.281407035175879 | 28 | 0 | 14 | 0 | 156 | 183 | 632 | 659 | PREDICTED: Pocillopora damicornis keratin-associated protein 5-4-like (LOC113672978), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 11129665 | 11129665 | PRJNA946307_P_NODE_128509_length_171_cov_2.491803_g127635_i0 | PRJNA946307 | 128509 | 171 | 2.491803 | 4.26098313 | Virgularia mirabilis | 1399339 | Cnidaria | other_Eukaryota | 67.6 | 5.11e-7 | NTclustered | gi|2160785914|gb|OL741708.1| | 1399339 | g127635 | i0 | 85.294 | 0.39766081871345 | 68 | 6 | 37 | 4 | 106 | 169 | 4388 | 4455 | Virgularia mirabilis voucher NMS.Z.2019.25.15 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 | 68 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Virgulariidae | Virgularia | Virgularia mirabilis | |
| 14954284 | 14954284 | PRJNA946307_P_NODE_150772_length_164_cov_6.704348_g149898_i0 | PRJNA946307 | 150772 | 164 | 6.704348 | 10.99513072 | Nemalecium lighti | 1769417 | Cnidaria | other_Eukaryota | 195 | 2.15e-45 | NTclustered | gi|984932204|gb|KT757146.1| | 1769417 | g149898 | i0 | 90 | 110.792682926829 | 150 | 15 | 91 | 0 | 13 | 162 | 2771 | 2920 | Nemalecium lighti voucher LEM m3x S17 large subunit 28S ribosomal RNA gene, partial sequence | blastn | 18170 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Haleciidae | Nemalecium | Nemalecium lighti | |
| 20387194 | 20387194 | PRJNA946307_P_NODE_78096_length_195_cov_4.369863_g77222_i0 | PRJNA946307 | 78096 | 195 | 4.369863 | 8.52123285 | Hydra | 6083 | Cnidaria | other_Eukaryota | 324 | 3.2299999999999998e-84 | NTclustered | gi|1032656003|gb|JN594041.2| | 6088 | g77222 | i0 | 98.895 | 92.8820512820513 | 181 | 2 | 93 | 0 | 15 | 195 | 1639 | 1819 | Hydra oligactis 28S ribosomal RNA gene, partial sequence | blastn | 18112 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra oligactis | |
| 22938542 | 22938542 | PRJNA946307_P_NODE_65598_length_200_cov_1.788079_g64724_i0 | PRJNA946307 | 65598 | 200 | 1.788079 | 3.576158 | Unicapsula | 244779 | Cnidaria | other_Eukaryota | 73.1 | 1.33e-8 | NTclustered | gi|2236662747|dbj|LC705027.1| | 493404 | g64724 | i0 | 75.148 | 28.995 | 169 | 34 | 83 | 7 | 25 | 189 | 4238 | 4074 | Unicapsula pflugfelderi MPM<JPN>:21854 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA | blastn | 5799 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Multivalvulida | Trilosporidae | Unicapsula | Unicapsula pflugfelderi | |
| 24212610 | 24212610 | PRJNA946307_P_NODE_86779_length_190_cov_1.716312_g85905_i0 | PRJNA946307 | 86779 | 190 | 1.716312 | 3.2609928 | Hydra | 6083 | Cnidaria | other_Eukaryota | 313 | 6.78e-81 | NTclustered | gi|1032656003|gb|JN594041.2| | 6088 | g85905 | i0 | 98.864 | 27.7947368421053 | 176 | 1 | 92 | 1 | 15 | 189 | 2074 | 2249 | Hydra oligactis 28S ribosomal RNA gene, partial sequence | blastn | 5281 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra oligactis | |
| 29646088 | 29646088 | PRJNA946307_P_NODE_7190_length_525_cov_3.518908_g6399_i0 | PRJNA946307 | 7190 | 525 | 3.518908 | 18.474267 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 115 | 3.33e-27 | NR | CAB4029133.1 | 317549 | g6399 | i0 | 38.7 | 3.10857142857143 | 181 | 92 | 99.4 | 5 | 523 | 2 | 37 | 205 | CAB4029133.1 Retrovirus-related Pol poly from transposon TNT 1-94 [Paramuricea clavata] | diamond | 1632 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30878511 | 30878511 | PRJNA946307_P_NODE_7254_length_521_cov_8.506356_g6461_i0 | PRJNA946307 | 7254 | 521 | 8.506356 | 44.31811476 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 154 | 8.9e-40 | NR | CAB4007695.1 | 317549 | g6461 | i0 | 42.5 | 1.07101727447217 | 186 | 82 | 92.7 | 1 | 502 | 20 | 1145 | 1330 | CAB4007695.1 Retrovirus-related Pol poly from transposon TNT 1-94 [Paramuricea clavata] | diamond | 558 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31732081 | 31732081 | PRJNA946307_P_NODE_65837_length_199_cov_7.180000_g64963_i0 | PRJNA946307 | 65837 | 199 | 7.18 | 14.2882 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 60.1 | 8.6e-9 | NR | XP_066924241.1 | 252671 | g64963 | i0 | 59.6 | 1.28140703517588 | 52 | 14 | 78.4 | 1 | 39 | 194 | 160 | 204 | XP_066924241.1 AMMECR1-like protein [Clytia hemisphaerica] | diamond | 255 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 32048498 | 32048498 | PRJNA946307_P_NODE_131438_length_170_cov_1.669421_g130564_i0 | PRJNA946307 | 131438 | 170 | 1.669421 | 2.8380157 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 56.6 | 6.12e-9 | NR | EDO26015.1 | 45351 | g130564 | i0 | 54.2 | 5.22352941176471 | 48 | 21 | 84.7 | 1 | 154 | 11 | 18 | 64 | EDO26015.1 predicted protein, partial [Nematostella vectensis] | diamond | 888 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32555133 | 32555133 | PRJNA946307_P_NODE_57679_length_210_cov_2.677019_g56805_i0 | PRJNA946307 | 57679 | 210 | 2.677019 | 5.6217399 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 60.1 | 1.74e-8 | NR | XP_020611151.1 | 48498 | g56805 | i0 | 83.9 | 0.442857142857143 | 31 | 5 | 44.3 | 0 | 98 | 6 | 34 | 64 | XP_020611151.1 LOW QUALITY PROTEIN: protein MAK16 homolog [Orbicella faveolata] | diamond | 93 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata |
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);;