contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 622971 | 622971 | PRJNA657343_P_NODE_26941_length_186_cov_1.788321_g26917_i0 | PRJNA657343 | 26941 | 186 | 1.788321 | 3.32627706 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 141 | 3.299999999999999e-29 | NTclustered | gi|2519006363|ref|XM_057454946.1| | 13093 | g26917 | i0 | 84.507 | 14.1182795698925 | 142 | 22 | 76 | 0 | 21 | 162 | 645 | 504 | PREDICTED: Hydractinia symbiolongicarpus aconitate hydratase, mitochondrial-like (LOC130648841), mRNA | blastn | 2626 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 3173903 | 3173903 | PRJNA657343_P_NODE_31743_length_175_cov_1.650794_g31719_i0 | PRJNA657343 | 31743 | 175 | 1.650794 | 2.8888895 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 309 | 7.920000000000001e-80 | NTclustered | gi|2744812730|ref|XM_012705529.3| | 6087 | g31719 | i0 | 99.412 | 3.88571428571429 | 170 | 1 | 97 | 0 | 5 | 174 | 967 | 798 | PREDICTED: Hydra vulgaris cilia- and flagella-associated protein 53 (LOC100211623), transcript variant X2, mRNA | blastn | 680 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 3712126 | 3712126 | PRJNA657343_P_NODE_14003_length_237_cov_1.095745_g13979_i0 | PRJNA657343 | 14003 | 237 | 1.095745 | 2.59691565 | Acropora | 6127 | Cnidaria | other_Eukaryota | 189 | 1.5499999999999996e-43 | NTclustered | gi|2113716488|ref|XM_044314392.1| | 45264 | g13979 | i0 | 96.491 | 16.0506329113924 | 114 | 4 | 78 | 0 | 121 | 234 | 507 | 620 | PREDICTED: Acropora millepora uncharacterized LOC122954378 (LOC122954378), mRNA | blastn | 3804 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 3712137 | 3712137 | PRJNA657343_P_NODE_31163_length_176_cov_2.456693_g31139_i0 | PRJNA657343 | 31163 | 176 | 2.456693 | 4.32377968 | Hydra | 6083 | Cnidaria | other_Eukaryota | 315 | 1.7199999999999996e-81 | NTclustered | gi|827883650|dbj|LC053786.1| | 6087 | g31139 | i0 | 100 | 96.5454545454545 | 170 | 0 | 97 | 0 | 6 | 175 | 1426 | 1257 | Hydra vulgaris mitochondrial chromosome 1 DNA, partial sequence, strain: D7 | blastn | 16992 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 4450783 | 4450783 | PRJNA657343_P_NODE_20284_length_206_cov_3.528662_g20260_i0 | PRJNA657343 | 20284 | 206 | 3.528662 | 7.26904372 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 372 | 1.2199999999999997e-98 | NTclustered | gi|2744778924|ref|XM_065824308.1| | 6087 | g20260 | i0 | 100 | 38.8252427184466 | 201 | 0 | 98 | 0 | 4 | 204 | 89 | 289 | PREDICTED: Hydra vulgaris histone H3 (LOC124810124), mRNA | blastn | 7998 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 7001629 | 7001629 | PRJNA657343_P_NODE_29706_length_179_cov_4.553846_g29682_i0 | PRJNA657343 | 29706 | 179 | 4.553846 | 8.15138434 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 303 | 3.79e-78 | NTclustered | gi|2744798379|ref|XM_002167002.4| | 6087 | g29682 | i0 | 98.266 | 1.78212290502793 | 173 | 3 | 97 | 0 | 4 | 176 | 606 | 778 | PREDICTED: Hydra vulgaris uncharacterized LOC100201561 (LOC100201561), transcript variant X1, mRNA | blastn | 319 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 8813367 | 8813367 | PRJNA657343_P_NODE_16927_length_220_cov_6.257310_g16903_i0 | PRJNA657343 | 16927 | 220 | 6.25731 | 13.766082 | Hydra | 6083 | Cnidaria | other_Eukaryota | 398 | 2.1699999999999996e-106 | NTclustered | gi|291360673|gb|GU591887.1| | 6087 | g16903 | i0 | 100 | 96.6727272727273 | 215 | 0 | 98 | 0 | 2 | 216 | 290 | 504 | Hydra vulgaris strain Ind-Pune 28S ribosomal RNA gene, partial sequence | blastn | 21268 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 13377264 | 13377264 | PRJNA657343_P_NODE_43431_length_163_cov_0.912281_g43407_i0 | PRJNA657343 | 43431 | 163 | 0.912281 | 1.48701803 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 298 | 1.58e-76 | NTclustered | gi|2744779219|ref|XM_047274257.2| | 6087 | g43407 | i0 | 100 | 75.6993865030675 | 161 | 0 | 99 | 0 | 1 | 161 | 168 | 328 | PREDICTED: Hydra vulgaris late histone H2A.2.2 (LOC124810056), mRNA | blastn | 12339 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 15925720 | 15925720 | PRJNA657343_P_NODE_12673_length_246_cov_0.807107_g12649_i0 | PRJNA657343 | 12673 | 246 | 0.807107 | 1.98548322 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 255 | 1.58e-63 | NTclustered | gi|2782896212|ref|XM_067067428.1| | 252671 | g12649 | i0 | 85.714 | 95.3333333333333 | 245 | 31 | 99 | 3 | 1 | 243 | 880 | 638 | PREDICTED: Clytia hemisphaerica actin, non-muscle 6.2-like (LOC136810843), mRNA | blastn | 23452 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 15926049 | 15926049 | PRJNA657343_P_NODE_37953_length_167_cov_0.881356_g37929_i0 | PRJNA657343 | 37953 | 167 | 0.881356 | 1.47186452 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 268 | 1.28e-67 | NTclustered | gi|2744799211|ref|XM_012701686.3| | 6087 | g37929 | i0 | 98.065 | 2.62275449101796 | 155 | 2 | 92 | 1 | 1 | 154 | 226 | 72 | PREDICTED: Hydra vulgaris uncharacterized LOC101237647 (LOC101237647), transcript variant X1, mRNA | blastn | 438 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 16463201 | 16463201 | PRJNA657343_P_NODE_37893_length_167_cov_0.881356_g37869_i0 | PRJNA657343 | 37893 | 167 | 0.881356 | 1.47186452 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g37869 | i0 | 100 | 0.688622754491018 | 29 | 0 | 17 | 0 | 134 | 162 | 2550810 | 2550782 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 115 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 18475099 | 18475099 | PRJNA657343_P_NODE_14215_length_235_cov_3.790323_g14191_i0 | PRJNA657343 | 14215 | 235 | 3.790323 | 8.90725905 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 183 | 7.16e-42 | NTclustered | gi|2744794010|ref|XM_012698561.3| | 6087 | g14191 | i0 | 81.696 | 11.7702127659574 | 224 | 37 | 94 | 4 | 3 | 224 | 351 | 572 | PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA | blastn | 2766 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 18475381 | 18475381 | PRJNA657343_P_NODE_36975_length_168_cov_0.857143_g36951_i0 | PRJNA657343 | 36975 | 168 | 0.857143 | 1.44000024 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 121 | 3.8099999999999996e-23 | NTclustered | gi|2782956737|ref|XM_067080196.1| | 252671 | g36951 | i0 | 81.818 | 2.98809523809524 | 143 | 26 | 85 | 0 | 1 | 143 | 484 | 626 | PREDICTED: Clytia hemisphaerica 26S proteasome non-ATPase regulatory subunit 7-like (LOC136824042), mRNA | blastn | 502 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 18475409 | 18475409 | PRJNA657343_P_NODE_39815_length_165_cov_1.793103_g39791_i0 | PRJNA657343 | 39815 | 165 | 1.793103 | 2.95861995 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 279 | 5.81e-71 | NTclustered | gi|2744822708|ref|XR_010650594.1| | 6087 | g39791 | i0 | 98.125 | 43.9030303030303 | 160 | 3 | 97 | 0 | 4 | 163 | 62 | 221 | PREDICTED: Hydra vulgaris uncharacterized LOC136097041 (LOC136097041), transcript variant X1, ncRNA | blastn | 7244 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 21562406 | 21562406 | PRJNA657343_P_NODE_41617_length_164_cov_0.904348_g41593_i0 | PRJNA657343 | 41617 | 164 | 0.904348 | 1.48313072 | Hydra | 6083 | Cnidaria | other_Eukaryota | 289 | 9.59e-74 | NTclustered | gi|310687948|dbj|AB565150.1| | 6087 | g41593 | i0 | 100 | 95.8109756097561 | 156 | 0 | 95 | 0 | 3 | 158 | 717 | 872 | Hydra vulgaris mitochondrial COII gene for cytochrome oxidase subunit II, partial cds, strain: B4 | blastn | 15713 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 23575744 | 23575744 | PRJNA657343_P_NODE_33339_length_172_cov_1.382114_g33315_i0 | PRJNA657343 | 33339 | 172 | 1.382114 | 2.37723608 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|1778025922|ref|XM_031694245.1| | 6105 | g33315 | i0 | 100 | 0.325581395348837 | 28 | 0 | 16 | 0 | 52 | 79 | 941 | 914 | PREDICTED: Actinia tenebrosa high mobility group nucleosome-binding domain-containing protein 5-like (LOC116287561), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 24849094 | 24849094 | PRJNA657343_P_NODE_1220_length_570_cov_5.616123_g1198_i0 | PRJNA657343 | 1220 | 570 | 5.616123 | 32.0119011 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 743 | 0 | NTclustered | gi|2744780760|ref|XM_047274306.2| | 6087 | g1198 | i0 | 99.753 | 29.8578947368421 | 405 | 1 | 71 | 0 | 30 | 434 | 1 | 405 | PREDICTED: Hydra vulgaris histone H2B, gonadal-like (LOC124810088), mRNA | blastn | 17019 | 743 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 24849410 | 24849410 | PRJNA657343_P_NODE_34100_length_170_cov_2.677686_g34076_i0 | PRJNA657343 | 34100 | 170 | 2.677686 | 4.5520662 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 267 | 4.659999999999999e-67 | NTclustered | gi|2744781297|ref|XR_007021210.2| | 6087 | g34076 | i0 | 95.238 | 92.2058823529412 | 168 | 8 | 99 | 0 | 2 | 169 | 169 | 2 | PREDICTED: Hydra vulgaris large subunit ribosomal RNA (LOC124810676), rRNA | blastn | 15675 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;