contig_metadata
7 rows where bioproject = "PRJNA630162" and tax_phylum = "Bryozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2426611 | 2426611 | PRJNA630162_P_NODE_26342_length_355_cov_8.859477_g24821_i0 | PRJNA630162 | 26342 | 355 | 8.859477 | 31.45114335 | Bryozoa | 10205 | Bryozoa | other_Eukaryota | 122 | 2.52e-23 | NTclustered | gi|1919295466|gb|MW173738.1| | 2780303 | g24821 | i0 | 88.35 | 25.5549295774648 | 103 | 10 | 29 | 2 | 254 | 355 | 2725 | 2624 | Dimetopia cornuta voucher BLEED1354 large subunit ribosomal RNA gene, partial sequence | blastn | 9072 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Dimetopia | Dimetopia cornuta | |
| 5705735 | 5705735 | PRJNA630162_P_NODE_25705_length_360_cov_2.864952_g24185_i0 | PRJNA630162 | 25705 | 360 | 2.864952 | 10.3138272 | Stylopoma viride | 2865421 | Bryozoa | other_Eukaryota | 62.1 | 5.67e-5 | NTclustered | gi|2075442493|gb|MZ677775.1| | 2865421 | g24185 | i0 | 97.222 | 4.25833333333333 | 36 | 1 | 10 | 0 | 243 | 278 | 3655 | 3620 | Stylopoma viride voucher BLEED1541 large subunit ribosomal RNA gene, partial sequence | blastn | 1533 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Schizoporellidae | Stylopoma | Stylopoma viride | |
| 6980493 | 6980493 | PRJNA630162_P_NODE_17186_length_451_cov_3.291045_g15682_i0 | PRJNA630162 | 17186 | 451 | 3.291045 | 14.84261295 | Membranipora membranacea | 95170 | Bryozoa | other_Eukaryota | 322 | 3.02e-83 | NTclustered | gi|2320635325|gb|ON868447.1| | 95170 | g15682 | i0 | 82.011 | 72.5011086474501 | 378 | 68 | 84 | 0 | 5 | 382 | 92 | 469 | Membranipora membranacea calmodulin-like protein 1 mRNA, complete cds | blastn | 32698 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Membraniporidae | Membranipora | Membranipora membranacea | |
| 8254931 | 8254931 | PRJNA630162_P_NODE_151887_length_164_cov_0.904348_g150364_i0 | PRJNA630162 | 151887 | 164 | 0.904348 | 1.48313072 | Hirosella fruticosa | 3279206 | Bryozoa | other_Eukaryota | 281 | 1.6000000000000001e-71 | NTclustered | gi|478434494|gb|KC462026.1| | 3279206 | g150364 | i0 | 98.734 | 20.5731707317073 | 158 | 2 | 96 | 0 | 6 | 163 | 104 | 261 | Plumatella fruticosa isolate EW19 28S ribosomal RNA gene, partial sequence | blastn | 3374 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Phylactolaemata | Plumatellida | Hirosellidae | Hirosella | Hirosella fruticosa | |
| 8255262 | 8255262 | PRJNA630162_P_NODE_27007_length_350_cov_32.990033_g25485_i0 | PRJNA630162 | 27007 | 350 | 32.990033 | 115.4651155 | Paludicella articulata | 569425 | Bryozoa | other_Eukaryota | 60.2 | 1.98e-4 | NTclustered | gi|2587622415|gb|OR625502.1| | 569425 | g25485 | i0 | 84.127 | 5.19714285714286 | 63 | 9 | 18 | 1 | 286 | 347 | 4035 | 3973 | Paludicella articulata strain VIBE2 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1819 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Ctenostomatida | Paludicellidae | Paludicella | Paludicella articulata | |
| 14630643 | 14630643 | PRJNA630162_P_NODE_143192_length_166_cov_1.179487_g141669_i0 | PRJNA630162 | 143192 | 166 | 1.179487 | 1.95794842 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 101 | 2.3699999999999998e-23 | NR | KAF6025715.1 | 10212 | g141669 | i0 | 86.8 | 19.1566265060241 | 53 | 7 | 95.8 | 0 | 7 | 165 | 436 | 488 | KAF6025715.1 MYO1H [Bugula neritina] | diamond | 3180 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 16453896 | 16453896 | PRJNA630162_P_NODE_11533_length_562_cov_9.580897_g10082_i0 | PRJNA630162 | 11533 | 562 | 9.580897 | 53.84464114 | Thalamoporella | 97293 | Bryozoa | other_Eukaryota | 65.8 | 7.11e-6 | NTclustered | gi|2075442530|gb|MZ677793.1| | 2865220 | g10082 | i0 | 91.667 | 0.311387900355872 | 48 | 2 | 8 | 2 | 192 | 237 | 3661 | 3708 | Thalamoporella sp. BLEED1037 large subunit ribosomal RNA gene, partial sequence | blastn | 175 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Thalamoporellidae | Thalamoporella | Thalamoporella sp. BLEED1037 |
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);;