contig_metadata
12 rows where bioproject = "PRJNA685060", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942103 | 1942103 | PRJNA685060_P_NODE_12142_length_267_cov_1.237113_g12052_i0 | PRJNA685060 | 12142 | 267 | 1.237113 | 3.30309171 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|675879857|ref|XM_009027202.1| | 6412 | g12052 | i0 | 96.97 | 0.123595505617978 | 33 | 0 | 12 | 1 | 134 | 165 | 2089 | 2057 | Helobdella robusta hypothetical protein partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 2451367 | 2451367 | PRJNA685060_P_NODE_8982_length_316_cov_15.209877_g8892_i0 | PRJNA685060 | 8982 | 316 | 15.209877 | 48.06321132 | Haemadipsidae | 27387 | Annelida | Annelida | 209 | 1.6600000000000001e-49 | NTclustered | gi|316927165|gb|HQ203119.1| | 933824 | g8892 | i0 | 79.624 | 101.20253164557 | 319 | 44 | 100 | 12 | 1 | 316 | 1053 | 1353 | Domanibdella palmyrae isolate APY 28S ribosomal RNA gene, partial sequence | blastn | 31980 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Haemadipsidae | Domanibdella | Domanibdella palmyrae | |
| 10870248 | 10870248 | PRJNA685060_P_NODE_9909_length_300_cov_1.356828_g9819_i0 | PRJNA685060 | 9909 | 300 | 1.356828 | 4.070484 | Metazoa | 33208 | Annelida | Annelida | 174 | 2.9399999999999995e-48 | NR | XP_009022593.1 | 6412 | g9819 | i0 | 94 | 98 | 100 | 6 | 100 | 0 | 1 | 300 | 240 | 339 | XP_009022593.1 hypothetical protein HELRODRAFT_94925, partial [Helobdella robusta] | diamond | 29400 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 17244149 | 17244149 | PRJNA685060_P_NODE_4554_length_455_cov_1.198953_g4464_i0 | PRJNA685060 | 4554 | 455 | 1.198953 | 5.45523615 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 191 | 8.96e-44 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g4464 | i0 | 80.469 | 7.07692307692308 | 256 | 44 | 55 | 6 | 184 | 434 | 22861768 | 22862022 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 3220 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27271848 | 27271848 | PRJNA685060_P_NODE_8463_length_327_cov_0.925197_g8373_i0 | PRJNA685060 | 8463 | 327 | 0.925197 | 3.02539419 | Owenia fusiformis | 6347 | Annelida | Annelida | 89.7 | 3.24e-18 | NR | CAH1780744.1 | 6347 | g8373 | i0 | 42.3 | 2.01834862385321 | 111 | 56 | 98.2 | 2 | 321 | 1 | 188 | 294 | CAH1780744.1 unnamed protein product [Owenia fusiformis] | diamond | 660 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27555935 | 27555935 | PRJNA685060_P_NODE_9204_length_312_cov_3.510460_g9114_i0 | PRJNA685060 | 9204 | 312 | 3.51046 | 10.9526352 | Owenia fusiformis | 6347 | Annelida | Annelida | 95.1 | 1.8e-20 | NR | CAH1790732.1 | 6347 | g9114 | i0 | 47.5 | 0.971153846153846 | 101 | 50 | 97.1 | 1 | 9 | 311 | 12 | 109 | CAH1790732.1 unnamed protein product [Owenia fusiformis] | diamond | 303 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28629871 | 28629871 | PRJNA685060_P_NODE_2707_length_599_cov_1.878327_g2617_i0 | PRJNA685060 | 2707 | 599 | 1.878327 | 11.25117873 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 61.6 | 3.31e-7 | NR | KAK2140645.1 | 53620 | g2617 | i0 | 50 | 0.746243739565943 | 52 | 25 | 25.5 | 1 | 593 | 441 | 489 | 540 | KAK2140645.1 hypothetical protein LSH36_1285g00055 [Paralvinella palmiformis] | diamond | 447 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28945638 | 28945638 | PRJNA685060_P_NODE_11608_length_274_cov_1.532338_g11518_i0 | PRJNA685060 | 11608 | 274 | 1.532338 | 4.19860612 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 44.3 | 0.0148 | NR | KAK2156904.1 | 53620 | g11518 | i0 | 34.2 | 1.45620437956204 | 73 | 47 | 79.9 | 1 | 47 | 265 | 253 | 324 | KAK2156904.1 hypothetical protein LSH36_202g04001 [Paralvinella palmiformis] | diamond | 399 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29682865 | 29682865 | PRJNA685060_P_NODE_2990_length_573_cov_1.356000_g2900_i0 | PRJNA685060 | 2990 | 573 | 1.356 | 7.76988 | Metazoa | 33208 | Annelida | Annelida | 111 | 1.2e-24 | NR | CAH1785081.1 | 6347 | g2900 | i0 | 71.9 | 10.2670157068063 | 128 | 36 | 67 | 0 | 2 | 385 | 467 | 594 | CAH1785081.1 unnamed protein product [Owenia fusiformis] | diamond | 5883 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31167724 | 31167724 | PRJNA685060_P_NODE_13075_length_254_cov_1.558011_g12985_i0 | PRJNA685060 | 13075 | 254 | 1.558011 | 3.95734794 | Metazoa | 33208 | Annelida | Annelida | 76.6 | 2.73e-14 | NR | CAH1780361.1 | 6347 | g12985 | i0 | 56.9 | 1.41732283464567 | 58 | 25 | 68.5 | 0 | 248 | 75 | 263 | 320 | CAH1780361.1 unnamed protein product [Owenia fusiformis] | diamond | 360 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31314545 | 31314545 | PRJNA685060_P_NODE_4495_length_458_cov_0.935065_g4405_i0 | PRJNA685060 | 4495 | 458 | 0.935065 | 4.2825977 | Capitella teleta | 283909 | Annelida | Annelida | 73.2 | 9.34e-12 | NR | ELT89300.1 | 283909 | g4405 | i0 | 32 | 9.75982532751092 | 153 | 100 | 98.9 | 3 | 1 | 453 | 578 | 728 | ELT89300.1 hypothetical protein CAPTEDRAFT_225765 [Capitella teleta] | diamond | 4470 | 73.9 | 0.990527740189445 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32674195 | 32674195 | PRJNA685060_P_NODE_7880_length_339_cov_1.601504_g7790_i0 | PRJNA685060 | 7880 | 339 | 1.601504 | 5.42909856 | Ridgeia piscesae | 27915 | Annelida | Annelida | 62.4 | 2.66e-9 | NR | KAK2138633.1 | 27915 | g7790 | i0 | 45.7 | 0.831858407079646 | 94 | 44 | 80.5 | 2 | 301 | 29 | 71 | 160 | KAK2138633.1 hypothetical protein NP493_7395g00002 [Ridgeia piscesae] | diamond | 282 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;