contig_metadata
6 rows where bioproject = "PRJNA1111448" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1493060 | 1493060 | PRJNA1111448_S_NODE_87822_length_286_cov_1.028169_g86999_i0 | PRJNA1111448 | 87822 | 286 | 1.0281690000000001 | 2.94056334 | Samytha sexcirrata | 1131446 | Annelida | Annelida | 108 | 5.56e-19 | NTclustered | gi|371456066|gb|JN936485.1| | 1131446 | g86999 | i0 | 93.243 | 24.1433566433566 | 74 | 3 | 25 | 2 | 215 | 286 | 619 | 692 | Samytha sexcirrata 28S ribosomal RNA gene, partial sequence | blastn | 6905 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Ampharetidae | Samytha | Samytha sexcirrata | |
| 4044102 | 4044102 | PRJNA1111448_S_NODE_106484_length_264_cov_3.769634_g105661_i0 | PRJNA1111448 | 106484 | 264 | 3.769634 | 9.95183376 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g105661 | i0 | 100 | 0.234848484848485 | 29 | 0 | 11 | 0 | 183 | 211 | 287055 | 287083 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 62 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7871362 | 7871362 | PRJNA1111448_S_NODE_9787_length_590_cov_3.125725_g9007_i0 | PRJNA1111448 | 9787 | 590 | 3.125725 | 18.4417775 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 3.49e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g9007 | i0 | 100 | 1.13220338983051 | 32 | 0 | 6 | 0 | 474 | 505 | 1760047 | 1760016 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 668 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9144933 | 9144933 | PRJNA1111448_S_NODE_102808_length_268_cov_3.087179_g101985_i0 | PRJNA1111448 | 102808 | 268 | 3.087179 | 8.27363972 | Hirudo verbana | 311461 | Annelida | Annelida | 113 | 1.11e-20 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g101985 | i0 | 85.345 | 0.57089552238806 | 116 | 10 | 43 | 2 | 150 | 265 | 8927781 | 8927889 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 153 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16325549 | 16325549 | PRJNA1111448_S_NODE_86533_length_287_cov_2.280374_g85710_i0 | PRJNA1111448 | 86533 | 287 | 2.280374 | 6.54467338 | Mesonerilla | 36117 | Annelida | Annelida | 122 | 1.99e-23 | NTclustered | gi|67541538|gb|AY859538.2| | 319732 | g85710 | i0 | 79.459 | 64.9477351916376 | 185 | 28 | 61 | 8 | 105 | 280 | 744 | 927 | Mesonerilla sp. KW-2005 18S ribosomal RNA gene, partial sequence | blastn | 18640 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Nerillidae | Mesonerilla | Mesonerilla sp. KW-2005 | ||
| 29467443 | 29467443 | PRJNA1111448_S_NODE_139690_length_241_cov_0.857143_g138867_i0 | PRJNA1111448 | 139690 | 241 | 0.857143 | 2.06571463 | Helobdella robusta | 6412 | Annelida | Annelida | 55.8 | 5.24e-7 | NR | XP_009021643.1 | 6412 | g138867 | i0 | 39.7 | 2.00414937759336 | 78 | 47 | 97.1 | 0 | 234 | 1 | 22 | 99 | XP_009021643.1 hypothetical protein HELRODRAFT_176046 [Helobdella robusta] | diamond | 483 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;