contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA744060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1999746 | 1999746 | PRJNA744060_P_NODE_8362_length_552_cov_3.116910_g8037_i0 | PRJNA744060 | 8362 | 552 | 3.11691 | 17.2053432 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 54.7 | 0.015 | NTclustered | gi|1176110764|ref|XR_002298260.1| | 48498 | g8037 | i0 | 100 | 0.105072463768116 | 29 | 0 | 5 | 0 | 231 | 259 | 1890 | 1918 | PREDICTED: Orbicella faveolata uncharacterized LOC110063707 (LOC110063707), ncRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 2473895 | 2473895 | PRJNA744060_P_NODE_39862_length_263_cov_2.257895_g39533_i0 | PRJNA744060 | 39862 | 263 | 2.257895 | 5.93826385 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 250 | 7.93e-62 | NTclustered | gi|2782902330|ref|XM_067068799.1| | 252671 | g39533 | i0 | 87.111 | 78.212927756654 | 225 | 23 | 84 | 5 | 2 | 223 | 993 | 772 | PREDICTED: Clytia hemisphaerica ATP synthase subunit beta, mitochondrial-like (LOC136812302), mRNA | blastn | 20570 | 252 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 2473912 | 2473912 | PRJNA744060_P_NODE_54562_length_223_cov_3.240000_g54233_i0 | PRJNA744060 | 54562 | 223 | 3.24 | 7.2252 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g54233 | i0 | 100 | 1.11659192825112 | 30 | 0 | 13 | 0 | 113 | 142 | 455682 | 455653 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 249 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 3274933 | 3274933 | PRJNA744060_P_NODE_49943_length_244_cov_0.912281_g49614_i0 | PRJNA744060 | 49943 | 244 | 0.912281 | 2.22596564 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g49614 | i0 | 100 | 0.122950819672131 | 30 | 0 | 12 | 0 | 27 | 56 | 10490640 | 10490669 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7101909 | 7101909 | PRJNA744060_P_NODE_27086_length_313_cov_1.566667_g26757_i0 | PRJNA744060 | 27086 | 313 | 1.566667 | 4.90366771 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 161 | 4.66e-35 | NTclustered | gi|1778061234|ref|XM_031712101.1| | 6105 | g26757 | i0 | 79.012 | 6.11821086261981 | 243 | 45 | 77 | 6 | 74 | 313 | 693 | 454 | PREDICTED: Actinia tenebrosa ras-related protein Rab-1A (LOC116302738), mRNA | blastn | 1915 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 8376894 | 8376894 | PRJNA744060_P_NODE_49347_length_244_cov_5.005848_g49018_i0 | PRJNA744060 | 49347 | 244 | 5.005848 | 12.21426912 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 158 | 4.53e-34 | NTclustered | gi|1778056593|ref|XM_031709719.1| | 6105 | g49018 | i0 | 82.418 | 66.4262295081967 | 182 | 30 | 74 | 2 | 2 | 182 | 635 | 815 | PREDICTED: Actinia tenebrosa 60S ribosomal protein L8-like (LOC116300781), mRNA | blastn | 16208 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 10127165 | 10127165 | PRJNA744060_P_NODE_24688_length_327_cov_1.720472_g24359_i0 | PRJNA744060 | 24688 | 327 | 1.720472 | 5.62594344 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|1524880682|ref|XM_027192197.1| | 46731 | g24359 | i0 | 96.774 | 0.18960244648318 | 31 | 1 | 9 | 0 | 141 | 171 | 342 | 372 | PREDICTED: Pocillopora damicornis probable phospholipid-transporting ATPase IIA (LOC113675607), mRNA | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 14752265 | 14752265 | PRJNA744060_P_NODE_35312_length_278_cov_1.424390_g34983_i0 | PRJNA744060 | 35312 | 278 | 1.42439 | 3.9598042 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2782905469|ref|XM_067069540.1| | 252671 | g34983 | i0 | 84.746 | 0.37410071942446 | 59 | 6 | 37 | 3 | 180 | 237 | 4783 | 4727 | PREDICTED: Clytia hemisphaerica fibrillin-1-like (LOC136813030), mRNA | blastn | 104 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 16026074 | 16026074 | PRJNA744060_P_NODE_42033_length_257_cov_2.510870_g41704_i0 | PRJNA744060 | 42033 | 257 | 2.51087 | 6.4529359 | Gonothyraea inornata | 314519 | Cnidaria | other_Eukaryota | 268 | 2.1299999999999998e-67 | NTclustered | gi|62825457|gb|AY789865.1| | 314519 | g41704 | i0 | 87.234 | 91.852140077821 | 235 | 30 | 91 | 0 | 21 | 255 | 398 | 164 | Laomedea inornata voucher 564WA calmodulin gene, partial cds | blastn | 23606 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Campanulariidae | Gonothyraea | Gonothyraea inornata | |
| 24950044 | 24950044 | PRJNA744060_P_NODE_47020_length_248_cov_1.268571_g46691_i0 | PRJNA744060 | 47020 | 248 | 1.268571 | 3.14605608 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 128 | 3.62e-25 | NTclustered | gi|2518997595|ref|XM_057450250.1| | 13093 | g46691 | i0 | 78.947 | 2.23387096774194 | 190 | 38 | 76 | 2 | 58 | 246 | 614 | 426 | PREDICTED: Hydractinia symbiolongicarpus cell division cycle 5-related protein-like (LOC130644589), mRNA | blastn | 554 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus |
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);;