contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA966993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1265654 | 1265654 | PRJNA966993_P_NODE_81961_length_251_cov_1.606742_g81509_i0 | PRJNA966993 | 81961 | 251 | 1.606742 | 4.03292242 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 60.2 | 1.36e-4 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g81509 | i0 | 100 | 20.1035856573705 | 32 | 0 | 13 | 0 | 64 | 95 | 18906651 | 18906682 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 5046 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 3817699 | 3817699 | PRJNA966993_P_NODE_94303_length_244_cov_0.900585_g93851_i0 | PRJNA966993 | 94303 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g93851 | i0 | 100 | 0.229508196721311 | 28 | 0 | 11 | 0 | 44 | 71 | 2804853 | 2804826 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 4770476 | 4770476 | PRJNA966993_P_NODE_38464_length_346_cov_2.820513_g38012_i0 | PRJNA966993 | 38464 | 346 | 2.820513 | 9.75897498 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 230 | 1.4099999999999995e-55 | NTclustered | gi|2744830644|ref|XM_002162514.5| | 6087 | g38012 | i0 | 82.331 | 6.28323699421965 | 266 | 45 | 77 | 2 | 31 | 295 | 398 | 134 | PREDICTED: Hydra vulgaris ADP-ribosylation factor-like protein 8B-A (LOC100213960), transcript variant X1, mRNA | blastn | 2174 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 4770615 | 4770615 | PRJNA966993_P_NODE_53784_length_296_cov_0.789238_g53332_i0 | PRJNA966993 | 53784 | 296 | 0.789238 | 2.33614448 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 243 | 1.52e-59 | NTclustered | gi|2518998737|ref|XM_057450856.1| | 13093 | g53332 | i0 | 86.977 | 111.790540540541 | 215 | 28 | 74 | 0 | 39 | 253 | 975 | 761 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA | blastn | 33090 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 5093877 | 5093877 | PRJNA966993_P_NODE_32464_length_374_cov_1.531561_g32012_i0 | PRJNA966993 | 32464 | 374 | 1.531561 | 5.72803814 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g32012 | i0 | 96.97 | 2.09625668449198 | 33 | 1 | 9 | 0 | 223 | 255 | 1049658 | 1049690 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 784 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 5093935 | 5093935 | PRJNA966993_P_NODE_52444_length_299_cov_1.964602_g51992_i0 | PRJNA966993 | 52444 | 299 | 1.964602 | 5.87415998 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2784716170|ref|XM_067186921.1| | 159855 | g51992 | i0 | 100 | 0.280936454849498 | 28 | 0 | 9 | 0 | 114 | 141 | 4304 | 4277 | PREDICTED: Acropora muricata uncharacterized protein (LOC136919097), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 9870117 | 9870117 | PRJNA966993_P_NODE_16948_length_508_cov_1.825287_g16506_i0 | PRJNA966993 | 16948 | 508 | 1.825287 | 9.27245796 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g16506 | i0 | 100 | 0.0610236220472441 | 31 | 0 | 6 | 0 | 235 | 265 | 18104322 | 18104292 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 16568046 | 16568046 | PRJNA966993_P_NODE_25473_length_418_cov_1.176812_g25026_i0 | PRJNA966993 | 25473 | 418 | 1.176812 | 4.91907416 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.04 | NTclustered | gi|2917940756|emb|OZ237571.1| | 6108 | g25026 | i0 | 100 | 1.4066985645933 | 28 | 0 | 7 | 0 | 391 | 418 | 11085647 | 11085620 | Anemonia sulcata genome assembly, chromosome: 17 | blastn | 588 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 18794247 | 18794247 | PRJNA966993_P_NODE_78695_length_256_cov_2.120219_g78243_i0 | PRJNA966993 | 78695 | 256 | 2.120219 | 5.42776064 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 62.1 | 3.87e-5 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g78243 | i0 | 100 | 2.35546875 | 33 | 0 | 13 | 0 | 75 | 107 | 10714036 | 10714004 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 603 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 21344031 | 21344031 | PRJNA966993_P_NODE_14277_length_555_cov_5.070539_g13843_i0 | PRJNA966993 | 14277 | 555 | 5.070539 | 28.14149145 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 351 | 4.81e-92 | NTclustered | gi|2782931191|ref|XM_067074155.1| | 252671 | g13843 | i0 | 79.837 | 24.9333333333333 | 491 | 92 | 88 | 5 | 18 | 505 | 651 | 165 | PREDICTED: Clytia hemisphaerica ADP-ribosylation factor 2 (LOC136817831), mRNA | blastn | 13838 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 21344079 | 21344079 | PRJNA966993_P_NODE_20877_length_459_cov_2.512953_g20432_i0 | PRJNA966993 | 20877 | 459 | 2.512953 | 11.53445427 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 52.8 | 0.045 | NTclustered | gi|2784689907|ref|XM_067175574.1| | 159855 | g20432 | i0 | 100 | 0.0610021786492375 | 28 | 0 | 6 | 0 | 46 | 73 | 1867 | 1840 | PREDICTED: Acropora muricata uncharacterized protein (LOC136909384), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 21344655 | 21344655 | PRJNA966993_P_NODE_89477_length_247_cov_0.885057_g89025_i0 | PRJNA966993 | 89477 | 247 | 0.885057 | 2.18609079 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2782827904|ref|XM_067063322.1| | 252671 | g89025 | i0 | 100 | 0.117408906882591 | 29 | 0 | 12 | 0 | 81 | 109 | 984 | 1012 | PREDICTED: Clytia hemisphaerica deformed epidermal autoregulatory factor 1 homolog (LOC136806731), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 25492194 | 25492194 | PRJNA966993_P_NODE_90400_length_246_cov_1.722543_g89948_i0 | PRJNA966993 | 90400 | 246 | 1.722543 | 4.23745578 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.022 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g89948 | i0 | 100 | 1.13821138211382 | 28 | 0 | 11 | 0 | 70 | 97 | 1665971 | 1665998 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 280 | 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);;