contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 430098 | 430098 | PRJNA432257_S_NODE_72981_length_200_cov_3.055215_g72600_i0 | PRJNA432257 | 72981 | 200 | 3.055215 | 6.11043 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 60.2 | 1.04e-4 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g72600 | i0 | 97.143 | 0.175 | 35 | 1 | 18 | 0 | 147 | 181 | 1965460 | 1965494 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 35 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 430137 | 430137 | PRJNA432257_S_NODE_76261_length_196_cov_381.949686_g75880_i0 | PRJNA432257 | 76261 | 196 | 381.949686 | 748.62138456 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g75880 | i0 | 96.97 | 0.168367346938776 | 33 | 0 | 16 | 1 | 119 | 150 | 18463253 | 18463285 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1704741 | 1704741 | PRJNA432257_S_NODE_57302_length_219_cov_178.296703_g56921_i0 | PRJNA432257 | 57302 | 219 | 178.296703 | 390.46977957 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2918369558|emb|OZ237728.1| | 317547 | g56921 | i0 | 94.444 | 0.164383561643836 | 36 | 1 | 16 | 1 | 15 | 49 | 14145071 | 14145106 | Eunicella cavolini genome assembly, chromosome: 12 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 4257145 | 4257145 | PRJNA432257_S_NODE_78584_length_194_cov_11.063694_g78203_i0 | PRJNA432257 | 78584 | 194 | 11.063694 | 21.46356636 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g78203 | i0 | 100 | 0.149484536082474 | 29 | 0 | 15 | 0 | 4 | 32 | 13645460 | 13645432 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 4257286 | 4257286 | PRJNA432257_S_NODE_89404_length_184_cov_255.700680_g89023_i0 | PRJNA432257 | 89404 | 184 | 255.70068 | 470.4892512 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g89023 | i0 | 97.059 | 0.184782608695652 | 34 | 0 | 18 | 1 | 110 | 143 | 14354678 | 14354646 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 5532878 | 5532878 | PRJNA432257_S_NODE_124045_length_153_cov_2.344828_g123664_i0 | PRJNA432257 | 124045 | 153 | 2.344828 | 3.58758684 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g123664 | i0 | 100 | 0.183006535947712 | 28 | 0 | 18 | 0 | 100 | 127 | 13204206 | 13204233 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 5533182 | 5533182 | PRJNA432257_S_NODE_29685_length_280_cov_12.078189_g29304_i0 | PRJNA432257 | 29685 | 280 | 12.078189 | 33.8189292 | Bicaularia tongensis | 2035841 | Cnidaria | other_Eukaryota | 65.8 | 3.31e-6 | NTclustered | gi|1246716251|gb|MG001906.1| | 2035841 | g29304 | i0 | 76.86 | 2.90357142857143 | 121 | 24 | 43 | 4 | 127 | 247 | 1736 | 1852 | Bicaularia tongensis voucher XMUB000550 large subunit ribosomal RNA gene, partial sequence | blastn | 813 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Symplectoscyphidae | Bicaularia | Bicaularia tongensis | |
| 8082683 | 8082683 | PRJNA432257_S_NODE_23267_length_305_cov_217.063433_g22886_i0 | PRJNA432257 | 23267 | 305 | 217.063433 | 662.04347065 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 6.11e-4 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g22886 | i0 | 89.362 | 0.154098360655738 | 47 | 4 | 15 | 1 | 136 | 182 | 11992818 | 11992863 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 47 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 9357805 | 9357805 | PRJNA432257_S_NODE_44928_length_240_cov_23.330049_g44547_i0 | PRJNA432257 | 44928 | 240 | 23.330049 | 55.9921176 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2744854423|ref|XM_065794368.1| | 6087 | g44547 | i0 | 97.059 | 0.2625 | 34 | 0 | 14 | 1 | 128 | 160 | 159 | 126 | PREDICTED: Hydra vulgaris prostatic spermine-binding protein-like (LOC136078588), mRNA | blastn | 63 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 10634023 | 10634023 | PRJNA432257_S_NODE_76909_length_196_cov_2.339623_g76528_i0 | PRJNA432257 | 76909 | 196 | 2.339623 | 4.58566108 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2744826386|ref|XM_047283790.2| | 6087 | g76528 | i0 | 100 | 0.301020408163265 | 30 | 0 | 15 | 0 | 76 | 105 | 528 | 499 | PREDICTED: Hydra vulgaris hybrid signal transduction histidine kinase M (LOC105844315), transcript variant X1, mRNA | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 10634123 | 10634123 | PRJNA432257_S_NODE_85249_length_188_cov_2.814570_g84868_i0 | PRJNA432257 | 85249 | 188 | 2.81457 | 5.2913916 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 58.4 | 3.46e-4 | NTclustered | gi|2257860472|ref|XM_032385488.2| | 45351 | g84868 | i0 | 97.059 | 0.361702127659574 | 34 | 1 | 18 | 0 | 23 | 56 | 405 | 372 | PREDICTED: Nematostella vectensis trafficking kinesin-binding protein 2 (LOC5515718), transcript variant X4, mRNA | blastn | 68 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 11907951 | 11907951 | PRJNA432257_S_NODE_12450_length_379_cov_2.964912_g12071_i0 | PRJNA432257 | 12450 | 379 | 2.964912 | 11.23701648 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.036 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g12071 | i0 | 100 | 0.16622691292876 | 28 | 0 | 7 | 0 | 245 | 272 | 11332646 | 11332619 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 63 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11908426 | 11908426 | PRJNA432257_S_NODE_42070_length_246_cov_23.641148_g41689_i0 | PRJNA432257 | 42070 | 246 | 23.641148 | 58.15722408 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2784716440|ref|XM_067187060.1| | 159855 | g41689 | i0 | 94.444 | 0.48780487804878 | 36 | 1 | 14 | 1 | 109 | 143 | 2701 | 2736 | PREDICTED: Acropora muricata TNF receptor-associated factor 6-like (LOC136919199), mRNA | blastn | 120 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 11908766 | 11908766 | PRJNA432257_S_NODE_67330_length_206_cov_57.621302_g66949_i0 | PRJNA432257 | 67330 | 206 | 57.621302 | 118.69988212 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g66949 | i0 | 96.97 | 0.160194174757282 | 33 | 1 | 16 | 0 | 79 | 111 | 10304032 | 10304064 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13183872 | 13183872 | PRJNA432257_S_NODE_81611_length_191_cov_37.123377_g81230_i0 | PRJNA432257 | 81611 | 191 | 37.123377 | 70.90565007 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2917940712|emb|OZ237560.1| | 6108 | g81230 | i0 | 100 | 0.293193717277487 | 28 | 0 | 15 | 0 | 138 | 165 | 3510279 | 3510252 | Anemonia sulcata genome assembly, chromosome: 6 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22105781 | 22105781 | PRJNA432257_S_NODE_126558_length_151_cov_2.157895_g126177_i0 | PRJNA432257 | 126558 | 151 | 2.157895 | 3.25842145 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.012 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g126177 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 112 | 139 | 6416279 | 6416252 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23381688 | 23381688 | PRJNA432257_S_NODE_31879_length_273_cov_5.970339_g31498_i0 | PRJNA432257 | 31879 | 273 | 5.970339 | 16.29902547 | Craspedacusta sowerbii | 128124 | Cnidaria | other_Eukaryota | 462 | 9.77e-126 | NTclustered | gi|213495460|gb|FJ423621.1| | 128124 | g31498 | i0 | 97.101 | 97.2344322344322 | 276 | 5 | 100 | 2 | 1 | 273 | 1140 | 865 | Craspedacusta sowerbyi isolate Cs0Yyy10 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 26545 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Olindiidae | Craspedacusta | Craspedacusta sowerbii | |
| 23382020 | 23382020 | PRJNA432257_S_NODE_55499_length_222_cov_9.102703_g55118_i0 | PRJNA432257 | 55499 | 222 | 9.102703 | 20.20800066 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g55118 | i0 | 94.286 | 0.157657657657658 | 35 | 1 | 16 | 1 | 85 | 119 | 5948137 | 5948104 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 24040487 | 24040487 | PRJNA432257_S_NODE_34299_length_266_cov_3.842795_g33918_i0 | PRJNA432257 | 34299 | 266 | 3.842795 | 10.2218347 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g33918 | i0 | 100 | 1.00375939849624 | 28 | 0 | 11 | 0 | 92 | 119 | 13814907 | 13814934 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 267 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata |
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);;