contig_metadata
20 rows where bioproject = "PRJEB7799", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25527530 | 25527530 | PRJEB7799j_S_NODE_73_length_371_cov_649.467262_g70_i0 | PRJEB7799 | 73 | 371 | 649.467262 | 2409.52354202 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 122 | 2.6499999999999996e-23 | NTclustered | gi|1005425980|ref|XR_001560994.1| | 70779 | g70 | i0 | 96 | 19.0134770889488 | 75 | 3 | 20 | 0 | 1 | 75 | 82 | 8 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA | blastn | 7054 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 25616843 | 25616843 | PRJEB7799h_S_NODE_1913_length_181_cov_1.732877_g1910_i0 | PRJEB7799 | 1913 | 181 | 1.732877 | 3.13650737 | Plumulariidae | 308572 | Cnidaria | other_Eukaryota | 91.6 | 3.26e-14 | NTclustered | gi|256674467|gb|FJ550371.1| | 308574 | g1910 | i0 | 100 | 28.0994475138122 | 49 | 0 | 27 | 0 | 76 | 124 | 1364 | 1412 | Plumularia setacea 28S ribosomal RNA gene, partial sequence | blastn | 5086 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Plumulariidae | Plumularia | Plumularia setacea | |
| 25616958 | 25616958 | PRJEB7799j_S_NODE_105_length_339_cov_667.746711_g100_i0 | PRJEB7799 | 105 | 339 | 667.746711 | 2263.66135029 | root | 1 | Root_unresolved | Root_unresolved | 119 | 3.11e-22 | NTclustered | gi|1005425977|ref|XR_001560985.1| | 70779 | g100 | i0 | 97.143 | 20.7846607669617 | 70 | 2 | 21 | 0 | 270 | 339 | 12 | 81 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA | blastn | 7046 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 25617424 | 25617424 | PRJEB7799p_S_NODE_3489_length_265_cov_5435.682609_g3466_i0 | PRJEB7799 | 3489 | 265 | 5435.682609 | 14404.55891385 | root | 1 | Root_unresolved | Root_unresolved | 119 | 2.35e-22 | NTclustered | gi|1005425975|ref|XR_001560982.1| | 70779 | g3466 | i0 | 97.143 | 26.6792452830189 | 70 | 2 | 26 | 0 | 196 | 265 | 34 | 103 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X2, ncRNA | blastn | 7070 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 25662128 | 25662128 | PRJEB7799a_S_NODE_3210_length_258_cov_2531.645740_g3175_i0 | PRJEB7799 | 3210 | 258 | 2531.64574 | 6531.6460092 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 121 | 6.35e-23 | NTclustered | gi|1005425980|ref|XR_001560994.1| | 70779 | g3175 | i0 | 95.946 | 29.2596899224806 | 74 | 3 | 29 | 0 | 1 | 74 | 82 | 9 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA | blastn | 7549 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 25664245 | 25664245 | PRJEB7799m_S_NODE_194_length_322_cov_2.885017_g189_i0 | PRJEB7799 | 194 | 322 | 2.885017 | 9.28975474 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 52.8 | 0.03 | NTclustered | gi|2114135399|ref|XM_029355121.2| | 45264 | g189 | i0 | 100 | 0.260869565217391 | 28 | 0 | 9 | 0 | 228 | 255 | 605 | 578 | PREDICTED: Acropora millepora uncharacterized LOC114974984 (LOC114974984), mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 25753568 | 25753568 | PRJEB7799o_S_NODE_682_length_247_cov_346.683962_g674_i0 | PRJEB7799 | 682 | 247 | 346.683962 | 856.30938614 | root | 1 | Root_unresolved | Root_unresolved | 119 | 2.17e-22 | NTclustered | gi|1005425977|ref|XR_001560985.1| | 70779 | g674 | i0 | 95.89 | 29.17004048583 | 73 | 3 | 30 | 0 | 1 | 73 | 81 | 9 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA | blastn | 7205 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 25800948 | 25800948 | PRJEB7799p_S_NODE_1507_length_350_cov_3021.898413_g1484_i0 | PRJEB7799 | 1507 | 350 | 3021.898413 | 10576.6444455 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 119 | 3.21e-22 | NTclustered | gi|1005425980|ref|XR_001560994.1| | 70779 | g1484 | i0 | 95.946 | 20.0628571428571 | 74 | 1 | 21 | 2 | 279 | 350 | 9 | 82 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA | blastn | 7022 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 25801030 | 25801030 | PRJEB7799p_S_NODE_1843_length_328_cov_1175.795222_g1820_i0 | PRJEB7799 | 1843 | 328 | 1175.795222 | 3856.60832816 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 121 | 8.339999999999999e-23 | NTclustered | gi|1005425977|ref|XR_001560985.1| | 70779 | g1820 | i0 | 97.183 | 21.4146341463415 | 71 | 2 | 22 | 0 | 258 | 328 | 11 | 81 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA | blastn | 7024 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 25935473 | 25935473 | PRJEB7799g_S_NODE_1596_length_221_cov_9.747312_g1380_i0 | PRJEB7799 | 1596 | 221 | 9.747312 | 21.54155952 | Symplectoscyphus tricuspidatus | 308614 | Cnidaria | other_Eukaryota | 143 | 1.13e-29 | NTclustered | gi|1006165264|gb|KT190774.1| | 308614 | g1380 | i0 | 80.402 | 71.2217194570136 | 199 | 29 | 89 | 6 | 1 | 196 | 2298 | 2489 | Symplectoscyphus tricuspidatus voucher MBM240558 clone STNB12P212-1, P213-1 28S ribosomal RNA gene, partial sequence | blastn | 15740 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Symplectoscyphus | Symplectoscyphus tricuspidatus | |
| 25936879 | 25936879 | PRJEB7799n_S_NODE_9612_length_165_cov_5.384615_g9575_i0 | PRJEB7799 | 9612 | 165 | 5.384615 | 8.88461475 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 122 | 1.0399999999999997e-23 | NTclustered | gi|2751537337|ref|XM_059111680.2| | 203993 | g9575 | i0 | 85.714 | 23.6787878787879 | 119 | 14 | 70 | 2 | 50 | 165 | 1404 | 1286 | PREDICTED: Pocillopora verrucosa tubulin beta chain (LOC131794157), mRNA | blastn | 3907 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 25937559 | 25937559 | PRJEB7799p_S_NODE_4756_length_237_cov_1184.628713_g4733_i0 | PRJEB7799 | 4756 | 237 | 1184.628713 | 2807.57004981 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 121 | 5.75e-23 | NTclustered | gi|1005425977|ref|XR_001560985.1| | 70779 | g4733 | i0 | 97.183 | 29.6371308016878 | 71 | 2 | 30 | 0 | 167 | 237 | 11 | 81 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA | blastn | 7024 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 26073021 | 26073021 | PRJEB7799p_S_NODE_11629_length_186_cov_2.940397_g11606_i0 | PRJEB7799 | 11629 | 186 | 2.940397 | 5.46913842 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 75 | 3.39e-9 | NTclustered | gi|1176065152|ref|XM_020747121.1| | 48498 | g11606 | i0 | 79.439 | 0.575268817204301 | 107 | 20 | 57 | 2 | 72 | 177 | 525 | 420 | PREDICTED: Orbicella faveolata 60S ribosomal protein L23a-like (LOC110041789), mRNA | blastn | 107 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 26208974 | 26208974 | PRJEB7799n_S_NODE_3062_length_254_cov_2.945205_g3025_i0 | PRJEB7799 | 3062 | 254 | 2.945205 | 7.4808207 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 139 | 1.72e-28 | NTclustered | gi|2257888155|ref|XM_001640516.3| | 45351 | g3025 | i0 | 83.007 | 1.37795275590551 | 153 | 26 | 60 | 0 | 1 | 153 | 433 | 585 | PREDICTED: Nematostella vectensis ubiquitin-40S ribosomal protein S27a (LOC5520747), mRNA | blastn | 350 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 26209771 | 26209771 | PRJEB7799p_S_NODE_4350_length_244_cov_545.913876_g4327_i0 | PRJEB7799 | 4350 | 244 | 545.913876 | 1332.02985744 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 124 | 4.599999999999999e-24 | NTclustered | gi|1005425977|ref|XR_001560985.1| | 70779 | g4327 | i0 | 97.26 | 29.0737704918033 | 73 | 2 | 30 | 0 | 1 | 73 | 81 | 9 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA | blastn | 7094 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 26342893 | 26342893 | PRJEB7799c_S_NODE_1631_length_278_cov_14859.637860_g1608_i0 | PRJEB7799 | 1631 | 278 | 14859.63786 | 41309.7932508 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 121 | 6.92e-23 | NTclustered | gi|1005425981|ref|XR_001560995.1| | 70779 | g1608 | i0 | 96 | 27.1007194244604 | 75 | 1 | 26 | 2 | 1 | 73 | 91 | 17 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X8, ncRNA | blastn | 7534 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 26343481 | 26343481 | PRJEB7799g_S_NODE_1447_length_226_cov_449.481675_g1231_i0 | PRJEB7799 | 1447 | 226 | 449.481675 | 1015.8285855 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 124 | 4.2e-24 | NTclustered | gi|1005425980|ref|XR_001560994.1| | 70779 | g1231 | i0 | 94.937 | 31.5088495575221 | 79 | 4 | 35 | 0 | 10 | 88 | 82 | 4 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA | blastn | 7121 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 26345564 | 26345564 | PRJEB7799p_S_NODE_3551_length_264_cov_2.152838_g3528_i0 | PRJEB7799 | 3551 | 264 | 2.152838 | 5.68349232 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 63.9 | 1.11e-5 | NTclustered | gi|2782870700|ref|XM_067060981.1| | 252671 | g3528 | i0 | 97.368 | 0.143939393939394 | 38 | 0 | 14 | 1 | 221 | 258 | 412 | 376 | PREDICTED: Clytia hemisphaerica large ribosomal subunit protein eL34-like (LOC136804275), transcript variant X1, mRNA | blastn | 38 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 26481510 | 26481510 | PRJEB7799p_S_NODE_1680_length_338_cov_791.716172_g1657_i0 | PRJEB7799 | 1680 | 338 | 791.716172 | 2676.00066136 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 121 | 8.619999999999999e-23 | NTclustered | gi|1005425977|ref|XR_001560985.1| | 70779 | g1657 | i0 | 97.183 | 20.8195266272189 | 71 | 2 | 21 | 0 | 1 | 71 | 81 | 11 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA | blastn | 7037 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 33101343 | 33101343 | PRJEB7799n_S_NODE_4198_length_224_cov_2.412698_g4161_i0 | PRJEB7799 | 4198 | 224 | 2.412698 | 5.40444352 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 62 | 4.66e-9 | NR | RMX38827.1 | 46731 | g4161 | i0 | 57.1 | 1.6875 | 63 | 25 | 81.7 | 1 | 214 | 32 | 561 | 623 | RMX38827.1 hypothetical protein pdam_00013964 [Pocillopora damicornis] | diamond | 378 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis |
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);;