contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA980587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2231121 | 2231121 | PRJNA980587_P_NODE_53202_length_314_cov_1.904564_g52409_i0 | PRJNA980587 | 53202 | 314 | 1.904564 | 5.98033096 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 248 | 3.49e-61 | NTclustered | gi|1619630004|ref|XM_021042007.2| | 2652724 | g52409 | i0 | 83.032 | 43.2675159235669 | 277 | 44 | 88 | 3 | 27 | 301 | 345 | 70 | PREDICTED: Exaiptasia diaphana dynein light chain 2, cytoplasmic (LOC110236476), mRNA | blastn | 13586 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 2545260 | 2545260 | PRJNA980587_P_NODE_86902_length_246_cov_0.890173_g86109_i0 | PRJNA980587 | 86902 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 4.78e-4 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g86109 | i0 | 97.143 | 0.414634146341463 | 35 | 0 | 14 | 1 | 15 | 49 | 4125404 | 4125371 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 102 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 3506880 | 3506880 | PRJNA980587_P_NODE_92563_length_242_cov_1.414201_g91770_i0 | PRJNA980587 | 92563 | 242 | 1.414201 | 3.42236642 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 193 | 1.23e-44 | NTclustered | gi|1603780777|ref|XM_028537764.1| | 151771 | g91770 | i0 | 81.25 | 12.8719008264463 | 240 | 43 | 99 | 2 | 3 | 241 | 972 | 734 | PREDICTED: Dendronephthya gigantea calmodulin-like (LOC114517914), mRNA | blastn | 3115 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 3821498 | 3821498 | PRJNA980587_P_NODE_56703_length_303_cov_2.152174_g55910_i0 | PRJNA980587 | 56703 | 303 | 2.152174 | 6.52108722 | Acropora | 6127 | Cnidaria | other_Eukaryota | 459 | 1.4199999999999996e-124 | NTclustered | gi|2114305033|ref|XR_006396780.1| | 45264 | g55910 | i0 | 93.851 | 19.3003300330033 | 309 | 12 | 100 | 7 | 1 | 303 | 1738 | 1431 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122961987), rRNA | blastn | 5848 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 3821524 | 3821524 | PRJNA980587_P_NODE_65063_length_281_cov_1.302885_g64270_i0 | PRJNA980587 | 65063 | 281 | 1.302885 | 3.66110685 | Montipora | 46703 | Cnidaria | other_Eukaryota | 139 | 1.9299999999999999e-28 | NTclustered | gi|2812116856|ref|XM_068871240.1| | 246305 | g64270 | i0 | 91.346 | 4.44839857651246 | 104 | 5 | 37 | 1 | 178 | 281 | 4693 | 4792 | PREDICTED: Montipora capricornis zinc finger protein 420-like (LOC138024132), transcript variant X2, mRNA | blastn | 1250 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 3821579 | 3821579 | PRJNA980587_P_NODE_90683_length_243_cov_2.676471_g89890_i0 | PRJNA980587 | 90683 | 243 | 2.676471 | 6.50382453 | Acroporidae | 6126 | Cnidaria | other_Eukaryota | 444 | 3.09e-120 | NTclustered | gi|2164965894|gb|MW246498.1| | 6130 | g89890 | i0 | 99.588 | 100 | 243 | 1 | 100 | 0 | 1 | 243 | 11238 | 10996 | Acropora cervicornis voucher 13917 clone HG0061 mitochondrion, complete genome | blastn | 24300 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 7334125 | 7334125 | PRJNA980587_P_NODE_95166_length_241_cov_0.916667_g94373_i0 | PRJNA980587 | 95166 | 241 | 0.916667 | 2.20916747 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 390 | 4.05e-104 | NTclustered | gi|2784726531|ref|XR_010872733.1| | 159855 | g94373 | i0 | 97.797 | 24.9045643153527 | 227 | 4 | 94 | 1 | 1 | 226 | 235 | 461 | PREDICTED: Acropora muricata uncharacterized lncRNA (LOC136923684), ncRNA | blastn | 6002 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 7647574 | 7647574 | PRJNA980587_P_NODE_50566_length_323_cov_1.760000_g49773_i0 | PRJNA980587 | 50566 | 323 | 1.76 | 5.6848 | Acropora | 6127 | Cnidaria | other_Eukaryota | 508 | 1.5e-139 | NTclustered | gi|2113715647|ref|XR_006393646.1| | 45264 | g49773 | i0 | 97.03 | 52.2941176470588 | 303 | 7 | 94 | 2 | 21 | 323 | 2496 | 2796 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954209), rRNA | blastn | 16891 | 512 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 7647683 | 7647683 | PRJNA980587_P_NODE_95666_length_240_cov_3.197605_g94873_i0 | PRJNA980587 | 95666 | 240 | 3.197605 | 7.674252 | Acropora | 6127 | Cnidaria | other_Eukaryota | 230 | 9.29e-56 | NTclustered | gi|2113715650|ref|XR_006393648.1| | 45264 | g94873 | i0 | 84.4 | 16.875 | 250 | 21 | 99 | 10 | 1 | 237 | 3256 | 3012 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954211), rRNA | blastn | 4050 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 11159511 | 11159511 | PRJNA980587_P_NODE_76849_length_254_cov_1.519337_g76056_i0 | PRJNA980587 | 76849 | 254 | 1.519337 | 3.85911598 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 398 | 2.5699999999999995e-106 | NTclustered | gi|2784690524|ref|XR_010869713.1| | 159855 | g76056 | i0 | 94.922 | 8.92125984251969 | 256 | 10 | 100 | 2 | 1 | 254 | 4799 | 4545 | PREDICTED: Acropora muricata neurogenic locus notch homolog protein 3-like (LOC136909588), transcript variant X2, misc_RNA | blastn | 2266 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 20082679 | 20082679 | PRJNA980587_P_NODE_79556_length_250_cov_2.401130_g78763_i0 | PRJNA980587 | 79556 | 250 | 2.40113 | 6.002825 | Adelopora cf. fragilis AL-2008 | 520276 | Cnidaria | other_Eukaryota | 60.2 | 1.35e-4 | NTclustered | gi|188474707|gb|EU645420.1| | 520276 | g78763 | i0 | 97.143 | 1.652 | 35 | 1 | 14 | 0 | 25 | 59 | 264 | 230 | Adelopora cf. fragilis AL-2008 voucher USNM:1027762 calmodulin (CaM) gene, partial cds | blastn | 413 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Stylasteridae | Adelopora | Adelopora cf. fragilis AL-2008 | |
| 22633340 | 22633340 | PRJNA980587_P_NODE_87438_length_245_cov_2.645349_g86645_i0 | PRJNA980587 | 87438 | 245 | 2.645349 | 6.48110505 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 440 | 4.0399999999999986e-119 | NTclustered | gi|1253553523|emb|LT631041.1| | 159855 | g86645 | i0 | 99.18 | 57.7142857142857 | 244 | 2 | 99 | 0 | 2 | 245 | 845 | 602 | Acropora muricata partial 18S rRNA gene, specimen voucher DJ232 | blastn | 14140 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 23908315 | 23908315 | PRJNA980587_P_NODE_55559_length_307_cov_1.179487_g54766_i0 | PRJNA980587 | 55559 | 307 | 1.179487 | 3.62102509 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 279 | 1.21e-70 | NTclustered | gi|2782844603|ref|XM_067056021.1| | 252671 | g54766 | i0 | 88.136 | 75.1172638436482 | 236 | 26 | 77 | 2 | 73 | 307 | 1403 | 1169 | PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA | blastn | 23061 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 23908476 | 23908476 | PRJNA980587_P_NODE_68919_length_272_cov_1.417085_g68126_i0 | PRJNA980587 | 68919 | 272 | 1.417085 | 3.8544712 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 390 | 4.66e-104 | NTclustered | gi|2113715643|ref|XR_006393644.1| | 45264 | g68126 | i0 | 92.254 | 16.0073529411765 | 284 | 8 | 100 | 10 | 1 | 272 | 1842 | 1561 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954207), rRNA | blastn | 4354 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora |
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);;