contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA741997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 721695 | 721695 | PRJNA741997_P_NODE_81341_length_246_cov_0.890173_g80221_i0 | PRJNA741997 | 81341 | 246 | 0.890173 | 2.18982558 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 63.9 | 1.03e-5 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g80221 | i0 | 93.182 | 1.11788617886179 | 44 | 1 | 17 | 2 | 98 | 140 | 12461030 | 12461072 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 275 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1198085 | 1198085 | PRJNA741997_P_NODE_22541_length_475_cov_2.723881_g21423_i0 | PRJNA741997 | 22541 | 475 | 2.723881 | 12.93843475 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 436 | 1.09e-117 | NTclustered | gi|2519003460|ref|XM_057453373.1| | 13093 | g21423 | i0 | 86.683 | 84.6968421052632 | 398 | 48 | 83 | 4 | 80 | 475 | 1442 | 1048 | PREDICTED: Hydractinia symbiolongicarpus tubulin alpha-1 chain-like (LOC130647500), mRNA | blastn | 40231 | 438 | 0.995433789954338 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 1997659 | 1997659 | PRJNA741997_P_NODE_71582_length_251_cov_0.865169_g70462_i0 | PRJNA741997 | 71582 | 251 | 0.865169 | 2.17157419 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 100 | 8.01e-17 | NTclustered | gi|1524899782|ref|XM_027202351.1| | 46731 | g70462 | i0 | 89.024 | 1.27091633466135 | 82 | 8 | 33 | 1 | 168 | 249 | 2388 | 2308 | PREDICTED: Pocillopora damicornis probable 2-oxoglutarate dehydrogenase E1 component DHKTD1, mitochondrial (LOC113684930), mRNA | blastn | 319 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 4550093 | 4550093 | PRJNA741997_P_NODE_65924_length_264_cov_1.612565_g64804_i0 | PRJNA741997 | 65924 | 264 | 1.612565 | 4.2571716 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 189 | 1.7599999999999999e-43 | NTclustered | gi|1270064191|ref|XM_022938999.1| | 50429 | g64804 | i0 | 81.385 | 17.2348484848485 | 231 | 43 | 88 | 0 | 28 | 258 | 200 | 430 | PREDICTED: Stylophora pistillata 40S ribosomal protein S14 (LOC111333429), mRNA | blastn | 4550 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 7100414 | 7100414 | PRJNA741997_P_NODE_82886_length_245_cov_0.895349_g81766_i0 | PRJNA741997 | 82886 | 245 | 0.895349 | 2.19360505 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 62.1 | 3.67e-5 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g81766 | i0 | 94.872 | 0.159183673469388 | 39 | 2 | 16 | 0 | 104 | 142 | 41047937 | 41047975 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 39 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 13952064 | 13952064 | PRJNA741997_P_NODE_25491_length_441_cov_1.173913_g24371_i0 | PRJNA741997 | 25491 | 441 | 1.173913 | 5.17695633 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|1524855689|ref|XM_027203370.1| | 46731 | g24371 | i0 | 90.909 | 0.299319727891156 | 44 | 1 | 9 | 2 | 171 | 211 | 623 | 666 | PREDICTED: Pocillopora damicornis nuclear localization sequence-binding protein-like (LOC113685800), transcript variant X2, mRNA | blastn | 132 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 16501132 | 16501132 | PRJNA741997_P_NODE_50173_length_305_cov_0.995690_g49053_i0 | PRJNA741997 | 50173 | 305 | 0.99569 | 3.0368545 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.3 | 7.85e-8 | NTclustered | gi|2113718509|ref|XR_006393933.1| | 45264 | g49053 | i0 | 85.294 | 2.67540983606557 | 68 | 10 | 22 | 0 | 238 | 305 | 1823 | 1890 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122955186), rRNA | blastn | 816 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 17299459 | 17299459 | PRJNA741997_P_NODE_24254_length_455_cov_1.589005_g23134_i0 | PRJNA741997 | 24254 | 455 | 1.589005 | 7.22997275 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 246 | 1.89e-60 | NTclustered | gi|1603780777|ref|XM_028537764.1| | 151771 | g23134 | i0 | 77.574 | 35.3318681318681 | 437 | 78 | 94 | 16 | 27 | 453 | 572 | 998 | PREDICTED: Dendronephthya gigantea calmodulin-like (LOC114517914), mRNA | blastn | 16076 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 17299718 | 17299718 | PRJNA741997_P_NODE_64894_length_266_cov_2.393782_g63774_i0 | PRJNA741997 | 64894 | 266 | 2.393782 | 6.36746012 | Salacia desmoides | 662031 | Cnidaria | other_Eukaryota | 121 | 6.57e-23 | NTclustered | gi|256674477|gb|FJ550381.1| | 662031 | g63774 | i0 | 83.333 | 21.1578947368421 | 132 | 20 | 50 | 2 | 1 | 132 | 1537 | 1666 | Salacia desmoides 28S ribosomal RNA gene, partial sequence | blastn | 5628 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Salacia | Salacia desmoides | |
| 19049841 | 19049841 | PRJNA741997_P_NODE_16375_length_584_cov_1.491194_g15269_i0 | PRJNA741997 | 16375 | 584 | 1.491194 | 8.70857296 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g15269 | i0 | 100 | 0.102739726027397 | 30 | 0 | 5 | 0 | 232 | 261 | 11591048 | 11591077 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19848625 | 19848625 | PRJNA741997_P_NODE_69116_length_257_cov_1.179348_g67996_i0 | PRJNA741997 | 69116 | 257 | 1.179348 | 3.03092436 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 58.4 | 5.02e-4 | NTclustered | gi|1778016754|ref|XM_031692803.1| | 6105 | g67996 | i0 | 97.059 | 0.132295719844358 | 34 | 1 | 13 | 0 | 11 | 44 | 1338 | 1305 | PREDICTED: Actinia tenebrosa leucine-rich repeat and IQ domain-containing protein 1-like (LOC116286326), mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa |
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);;