contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA315399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 381344 | 381344 | PRJNA315399_P_NODE_124221_length_193_cov_4.621795_g123773_i0 | PRJNA315399 | 124221 | 193 | 4.621795 | 8.92006435 | Halistemma rubrum | 316183 | Cnidaria | other_Eukaryota | 67.6 | 5.94e-7 | NTclustered | gi|2554488361|ref|NC_080957.1| | 316183 | g123773 | i0 | 97.436 | 0.202072538860104 | 39 | 1 | 20 | 0 | 119 | 157 | 3477 | 3439 | Halistemma rubrum voucher YPM:IZ:35040 mitochondrion, complete genome | blastn | 39 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Siphonophorae | Agalmatidae | Halistemma | Halistemma rubrum | |
| 1656296 | 1656296 | PRJNA315399_P_NODE_152242_length_188_cov_10.642384_g151794_i0 | PRJNA315399 | 152242 | 188 | 10.642384 | 20.00768192 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 63.9 | 7.44e-6 | NTclustered | gi|2744854439|ref|XM_065794377.1| | 6087 | g151794 | i0 | 85.246 | 0.324468085106383 | 61 | 9 | 32 | 0 | 19 | 79 | 310 | 250 | PREDICTED: Hydra vulgaris protein GVQW3-like (LOC136078596), mRNA | blastn | 61 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 5486719 | 5486719 | PRJNA315399_P_NODE_41845_length_249_cov_4.415094_g41398_i0 | PRJNA315399 | 41845 | 249 | 4.415094 | 10.99358406 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g41398 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 14 | 41 | 13475461 | 13475488 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 6760254 | 6760254 | PRJNA315399_P_NODE_327666_length_176_cov_2.266187_g327218_i0 | PRJNA315399 | 327666 | 176 | 2.266187 | 3.98848912 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2729065362|ref|XM_065216043.1| | 499914 | g327218 | i0 | 96.97 | 0.5625 | 33 | 0 | 19 | 1 | 14 | 46 | 3766 | 3797 | PREDICTED: Rhopilema esculentum myb-related protein A-like (LOC135696598), transcript variant X1, mRNA | blastn | 99 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 6760993 | 6760993 | PRJNA315399_P_NODE_447326_length_156_cov_6.781513_g446878_i0 | PRJNA315399 | 447326 | 156 | 6.781513 | 10.57916028 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1270073437|ref|XM_022943959.1| | 50429 | g446878 | i0 | 100 | 0.358974358974359 | 28 | 0 | 18 | 0 | 48 | 75 | 1304 | 1331 | PREDICTED: Stylophora pistillata protein dimmed-like (LOC111337621), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 13135397 | 13135397 | PRJNA315399_P_NODE_186791_length_186_cov_1.744966_g186343_i0 | PRJNA315399 | 186791 | 186 | 1.744966 | 3.24563676 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g186343 | i0 | 100 | 0.155913978494624 | 29 | 0 | 16 | 0 | 54 | 82 | 11599879 | 11599907 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13137793 | 13137793 | PRJNA315399_P_NODE_93331_length_204_cov_5.161677_g92883_i0 | PRJNA315399 | 93331 | 204 | 5.161677 | 10.52982108 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g92883 | i0 | 100 | 0.137254901960784 | 28 | 0 | 14 | 0 | 173 | 200 | 7948999 | 7948972 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14412616 | 14412616 | PRJNA315399_P_NODE_508992_length_150_cov_4.663717_g508544_i0 | PRJNA315399 | 508992 | 150 | 4.663717 | 6.9955755 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 108 | 2.57e-19 | NTclustered | gi|2113716488|ref|XM_044314392.1| | 45264 | g508544 | i0 | 95.522 | 19.92 | 67 | 3 | 45 | 0 | 10 | 76 | 803 | 737 | PREDICTED: Acropora millepora uncharacterized LOC122954378 (LOC122954378), mRNA | blastn | 2988 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 15094646 | 15094646 | PRJNA315399_S_NODE_34012_length_239_cov_4.846535_g33811_i0 | PRJNA315399 | 34012 | 239 | 4.846535 | 11.58321865 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g33811 | i0 | 92.105 | 0.317991631799163 | 38 | 1 | 15 | 2 | 197 | 233 | 1539567 | 1539531 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 76 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 17644394 | 17644394 | PRJNA315399_S_NODE_196354_length_150_cov_4.938053_g196153_i0 | PRJNA315399 | 196354 | 150 | 4.938053 | 7.4070795 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 52.8 | 0.012 | NTclustered | gi|1524893355|ref|XM_027198927.1| | 46731 | g196153 | i0 | 100 | 2.61333333333333 | 28 | 0 | 19 | 0 | 32 | 59 | 2916 | 2889 | PREDICTED: Pocillopora damicornis uncharacterized LOC113681808 (LOC113681808), mRNA | blastn | 392 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 17644721 | 17644721 | PRJNA315399_S_NODE_83974_length_187_cov_2.053333_g83773_i0 | PRJNA315399 | 83974 | 187 | 2.053333 | 3.83973271 | Coronatae | 86058 | Cnidaria | other_Eukaryota | 110 | 9.36e-20 | NTclustered | gi|15208481|gb|AY026368.1| | 86043 | g83773 | i0 | 86.275 | 53.668449197861 | 102 | 12 | 54 | 2 | 21 | 121 | 1252 | 1352 | Atolla vanhoeffeni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 10036 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Coronatae | Atollidae | Atolla | Atolla vanhoeffeni | |
| 20782824 | 20782824 | PRJNA315399_P_NODE_129037_length_192_cov_4.019355_g128589_i0 | PRJNA315399 | 129037 | 192 | 4.019355 | 7.7171616 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g128589 | i0 | 100 | 0.145833333333333 | 28 | 0 | 15 | 0 | 46 | 73 | 70170254 | 70170227 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 20783134 | 20783134 | PRJNA315399_P_NODE_177637_length_186_cov_6.040268_g177189_i0 | PRJNA315399 | 177637 | 186 | 6.040268 | 11.23489848 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 82.4 | 2.03e-11 | NTclustered | gi|2784680719|ref|XM_067170670.1| | 159855 | g177189 | i0 | 89.706 | 5.01075268817204 | 68 | 2 | 37 | 2 | 112 | 179 | 623 | 685 | PREDICTED: Acropora muricata uncharacterized protein (LOC136898106), mRNA | blastn | 932 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 20785953 | 20785953 | PRJNA315399_S_NODE_14297_length_311_cov_4.354015_g14096_i0 | PRJNA315399 | 14297 | 311 | 4.354015 | 13.54098665 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|1603825303|ref|XM_028561341.1| | 151771 | g14096 | i0 | 100 | 0.0932475884244373 | 29 | 0 | 9 | 0 | 30 | 58 | 381 | 353 | PREDICTED: Dendronephthya gigantea uncharacterized LOC114541416 (LOC114541416), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 23333430 | 23333430 | PRJNA315399_P_NODE_143739_length_189_cov_11.506579_g143291_i0 | PRJNA315399 | 143739 | 189 | 11.506579 | 21.74743431 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 69.4 | 1.61e-7 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g143291 | i0 | 97.5 | 3.17460317460317 | 40 | 1 | 21 | 0 | 7 | 46 | 19294690 | 19294651 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 600 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23333547 | 23333547 | PRJNA315399_P_NODE_159899_length_188_cov_2.543046_g159451_i0 | PRJNA315399 | 159899 | 188 | 2.543046 | 4.78092648 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2744803861|ref|XM_047287536.2| | 6087 | g159451 | i0 | 100 | 0.148936170212766 | 28 | 0 | 15 | 0 | 128 | 155 | 2431 | 2404 | PREDICTED: Hydra vulgaris uncharacterized LOC124817450 (LOC124817450), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 23333880 | 23333880 | PRJNA315399_P_NODE_210059_length_184_cov_4.537415_g209611_i0 | PRJNA315399 | 210059 | 184 | 4.537415 | 8.3488436 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g209611 | i0 | 100 | 0.152173913043478 | 28 | 0 | 15 | 0 | 16 | 43 | 25817823 | 25817796 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 24017654 | 24017654 | PRJNA315399_P_NODE_277199_length_180_cov_2.979021_g276751_i0 | PRJNA315399 | 277199 | 180 | 2.979021 | 5.3622378 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 102 | 1.49e-17 | NTclustered | gi|2744880551|ref|XR_010641096.1| | 6087 | g276751 | i0 | 91.892 | 1.58888888888889 | 74 | 5 | 41 | 1 | 13 | 86 | 752 | 824 | PREDICTED: Hydra vulgaris uncharacterized LOC136085120 (LOC136085120), ncRNA | blastn | 286 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 24610143 | 24610143 | PRJNA315399_P_NODE_7740_length_369_cov_4.352410_g7342_i0 | PRJNA315399 | 7740 | 369 | 4.35241 | 16.0603929 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.035 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g7342 | i0 | 94.286 | 0.0948509485094851 | 35 | 1 | 9 | 1 | 21 | 55 | 14742363 | 14742330 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 35 | 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);;