contig_metadata
9 rows where bioproject = "PRJEB8827", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25617858 | 25617858 | PRJEB8827h_S_NODE_929_length_299_cov_1862.946970_g910_i0 | PRJEB8827 | 929 | 299 | 1862.94697 | 5570.2114403 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.008 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g910 | i0 | 100 | 11.1003344481605 | 29 | 0 | 10 | 0 | 252 | 280 | 34 | 6 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3319 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 25938510 | 25938510 | PRJEB8827f_S_NODE_6836_length_194_cov_3.698113_g6816_i0 | PRJEB8827 | 6836 | 194 | 3.698113 | 7.17433922 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 3.6e-4 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g6816 | i0 | 100 | 0.15979381443299 | 31 | 0 | 16 | 0 | 164 | 194 | 10515784 | 10515754 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26433844 | 26433844 | PRJEB8827b_S_NODE_2343_length_233_cov_12.156566_g2291_i0 | PRJEB8827 | 2343 | 233 | 12.156566 | 28.32479878 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.021 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g2291 | i0 | 100 | 13.5793991416309 | 28 | 0 | 12 | 0 | 206 | 233 | 36 | 9 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3164 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 26482160 | 26482160 | PRJEB8827c_S_NODE_416_length_215_cov_141.022222_g403_i0 | PRJEB8827 | 416 | 215 | 141.022222 | 303.1977773 | Platynereis dumerilii | 6359 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g403 | i0 | 100 | 0.786046511627907 | 29 | 0 | 13 | 0 | 187 | 215 | 42 | 14 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 169 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 26569881 | 26569881 | PRJEB8827e_S_NODE_6600_length_205_cov_380.888235_g6572_i0 | PRJEB8827 | 6600 | 205 | 380.888235 | 780.82088175 | root | 1 | Root_unresolved | Root_unresolved | 62.1 | 2.97e-5 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g6572 | i0 | 100 | 17.4536585365854 | 33 | 0 | 16 | 0 | 169 | 201 | 42 | 10 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3578 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 32914171 | 32914171 | PRJEB8827h_S_NODE_601_length_347_cov_2.108974_g582_i0 | PRJEB8827 | 601 | 347 | 2.108974 | 7.31813978 | Eurythoe complanata | 167815 | Annelida | Annelida | 84 | 3.46e-17 | NR | ABW23216.1 | 167815 | g582 | i0 | 64.3 | 6.25936599423631 | 56 | 20 | 48.4 | 0 | 347 | 180 | 153 | 208 | ABW23216.1 ribosomal protein rpl10 [Eurythoe complanata] | diamond | 2172 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Eurythoe | Eurythoe complanata | |
| 33008780 | 33008780 | PRJEB8827f_S_NODE_9747_length_182_cov_1.251701_g9727_i0 | PRJEB8827 | 9747 | 182 | 1.251701 | 2.27809582 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 1.29e-26 | NR | KAK2181487.1 | 27915 | g9727 | i0 | 83.6 | 7.07142857142857 | 55 | 9 | 90.7 | 0 | 3 | 167 | 284 | 338 | KAK2181487.1 hypothetical protein NP493_396g02012 [Ridgeia piscesae] | diamond | 1287 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33033508 | 33033508 | PRJEB8827b_S_NODE_3124_length_221_cov_1627.225806_g3072_i0 | PRJEB8827 | 3124 | 221 | 1627.225806 | 3596.16903126 | Capitella teleta | 283909 | Annelida | Annelida | 69.7 | 8.57e-12 | NR | ELU14708.1 | 283909 | g3072 | i0 | 54.2 | 1.45248868778281 | 59 | 27 | 80.1 | 0 | 180 | 4 | 81 | 139 | ELU14708.1 hypothetical protein CAPTEDRAFT_122874 [Capitella teleta] | diamond | 321 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 33111067 | 33111067 | PRJEB8827f_S_NODE_2054_length_290_cov_4.184314_g2034_i0 | PRJEB8827 | 2054 | 290 | 4.184314 | 12.1345106 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 2.18e-34 | NR | ELU06845.1 | 283909 | g2034 | i0 | 71.3 | 4.48965517241379 | 87 | 23 | 90 | 1 | 290 | 30 | 308 | 392 | ELU06845.1 hypothetical protein CAPTEDRAFT_183346 [Capitella teleta] | diamond | 1302 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta |
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);;