contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 739846 | 739846 | PRJNA758398_S_NODE_43501_length_166_cov_2.162393_g43360_i0 | PRJNA758398 | 43501 | 166 | 2.162393 | 3.58957238 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 69.4 | 1.38e-7 | NTclustered | gi|2782861585|ref|XM_067059026.1| | 252671 | g43360 | i0 | 78.641 | 0.620481927710843 | 103 | 22 | 62 | 0 | 10 | 112 | 927 | 1029 | PREDICTED: Clytia hemisphaerica ATP-binding cassette sub-family D member 3-like (LOC136802309), mRNA | blastn | 103 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 2479829 | 2479829 | PRJNA758398_S_NODE_53082_length_161_cov_1.491071_g52941_i0 | PRJNA758398 | 53082 | 161 | 1.491071 | 2.40062431 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1524897621|ref|XM_027201191.1| | 46731 | g52941 | i0 | 100 | 0.869565217391304 | 28 | 0 | 17 | 0 | 90 | 117 | 2174 | 2147 | PREDICTED: Pocillopora damicornis uncharacterized LOC113683904 (LOC113683904), mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 3291130 | 3291130 | PRJNA758398_S_NODE_4243_length_460_cov_2.158151_g4102_i0 | PRJNA758398 | 4243 | 460 | 2.158151 | 9.9274946 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 361 | 6.53e-95 | NTclustered | gi|2782899435|ref|XM_067068137.1| | 252671 | g4102 | i0 | 82.836 | 147.134782608696 | 402 | 69 | 87 | 0 | 36 | 437 | 766 | 365 | PREDICTED: Clytia hemisphaerica polyubiquitin-B (LOC136811514), mRNA | blastn | 67682 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 5843438 | 5843438 | PRJNA758398_S_NODE_45925_length_165_cov_0.879310_g45784_i0 | PRJNA758398 | 45925 | 165 | 0.87931 | 1.4508615 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|1176077388|ref|XM_020753065.1| | 48498 | g45784 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 73 | 100 | 833 | 860 | PREDICTED: Orbicella faveolata uncharacterized LOC110047321 (LOC110047321), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 7118542 | 7118542 | PRJNA758398_S_NODE_30426_length_193_cov_1.062500_g30285_i0 | PRJNA758398 | 30426 | 193 | 1.0625 | 2.050625 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 62.1 | 2.76e-5 | NTclustered | gi|1778070703|ref|XM_031717089.1| | 6105 | g30285 | i0 | 100 | 0.50259067357513 | 33 | 0 | 17 | 0 | 23 | 55 | 304 | 336 | PREDICTED: Actinia tenebrosa radial spoke head 1 homolog (LOC116306949), mRNA | blastn | 97 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 8857442 | 8857442 | PRJNA758398_S_NODE_21987_length_219_cov_1.200000_g21846_i0 | PRJNA758398 | 21987 | 219 | 1.2 | 2.628 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2812148277|ref|XM_068886669.1| | 246305 | g21846 | i0 | 100 | 1.17351598173516 | 29 | 0 | 13 | 0 | 89 | 117 | 648 | 676 | PREDICTED: Montipora capricornis cilia- and flagella-associated protein 251-like (LOC138040935), mRNA | blastn | 257 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 10943943 | 10943943 | PRJNA758398_S_NODE_36609_length_178_cov_1.186047_g36468_i0 | PRJNA758398 | 36609 | 178 | 1.186047 | 2.11116366 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 126 | 8.75e-25 | NTclustered | gi|2744802553|ref|XM_002157969.5| | 6087 | g36468 | i0 | 81.29 | 9.07865168539326 | 155 | 29 | 87 | 0 | 19 | 173 | 293 | 447 | PREDICTED: Hydra vulgaris ruvB-like 1 (LOC100202153), mRNA | blastn | 1616 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 12219369 | 12219369 | PRJNA758398_S_NODE_28590_length_198_cov_1.026846_g28449_i0 | PRJNA758398 | 28590 | 198 | 1.026846 | 2.03315508 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 134 | 5.9600000000000006e-27 | NTclustered | gi|1619619909|ref|XM_021038214.2| | 2652724 | g28449 | i0 | 79.397 | 6.19191919191919 | 199 | 33 | 98 | 8 | 1 | 195 | 432 | 238 | PREDICTED: Exaiptasia diaphana guanine nucleotide-binding protein subunit beta-like protein (LOC110232977), mRNA | blastn | 1226 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 13493479 | 13493479 | PRJNA758398_S_NODE_28191_length_199_cov_1.020000_g28050_i0 | PRJNA758398 | 28191 | 199 | 1.02 | 2.0298 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 134 | 6e-27 | NTclustered | gi|2782834302|ref|XM_067080188.1| | 252671 | g28050 | i0 | 90.909 | 6.82412060301507 | 99 | 9 | 50 | 0 | 100 | 198 | 935 | 1033 | PREDICTED: Clytia hemisphaerica nucleolar protein 56-like (LOC136824027), transcript variant X2, mRNA | blastn | 1358 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 13958332 | 13958332 | PRJNA758398_S_NODE_15851_length_250_cov_1.243781_g15710_i0 | PRJNA758398 | 15851 | 250 | 1.243781 | 3.1094525 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g15710 | i0 | 100 | 1.54 | 30 | 0 | 12 | 0 | 182 | 211 | 6730937 | 6730908 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 385 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14768778 | 14768778 | PRJNA758398_S_NODE_39352_length_172_cov_1.333333_g39211_i0 | PRJNA758398 | 39352 | 172 | 1.333333 | 2.29333276 | Henneguya sp. n. LFR-2019 | 2665658 | Cnidaria | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|1773394596|gb|MN653130.1| | 2665658 | g39211 | i0 | 100 | 0.325581395348837 | 28 | 0 | 16 | 0 | 145 | 172 | 163 | 136 | Henneguya sp. n. LFR-2019 isolate H2B small subunit ribosomal RNA gene, partial sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya sp. n. LFR-2019 | |
| 19866529 | 19866529 | PRJNA758398_S_NODE_22216_length_218_cov_1.207101_g22075_i0 | PRJNA758398 | 22216 | 218 | 1.207101 | 2.63148018 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 135 | 1.86e-27 | NTclustered | gi|1524891796|ref|XM_027198100.1| | 46731 | g22075 | i0 | 80 | 2.54128440366972 | 185 | 35 | 84 | 2 | 6 | 189 | 368 | 551 | PREDICTED: Pocillopora damicornis phosphoenolpyruvate phosphomutase-like (LOC113681042), mRNA | blastn | 554 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 23692969 | 23692969 | PRJNA758398_S_NODE_6379_length_377_cov_2.310976_g6238_i0 | PRJNA758398 | 6379 | 377 | 2.310976 | 8.71237952 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 63.9 | 1.66e-5 | NTclustered | gi|2729101427|ref|XM_065213730.1| | 499914 | g6238 | i0 | 87.5 | 0.816976127320955 | 56 | 6 | 15 | 1 | 66 | 120 | 1451 | 1506 | PREDICTED: Rhopilema esculentum phospholipid-transporting ATPase ABCA1-like (LOC135694856), mRNA | blastn | 308 | 63.9 | 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);;