contig_metadata
11 rows where bioproject = "PRJEB7799", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21398591 | 21398591 | PRJEB7799_P_NODE_1237_length_239_cov_198378.042857_g1230_i0 | PRJEB7799 | 1237 | 239 | 198378.042857 | 474123.52242823 | root | 1 | Root_unresolved | Root_unresolved | 65.8 | 2.76e-6 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g1230 | i0 | 100 | 15.7531380753138 | 35 | 0 | 15 | 0 | 205 | 239 | 42 | 8 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3765 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 25616650 | 25616650 | PRJEB7799c_S_NODE_2929_length_227_cov_1396.062500_g2906_i0 | PRJEB7799 | 2929 | 227 | 1396.0625 | 3169.061875 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g2906 | i0 | 100 | 15.0660792951542 | 30 | 0 | 13 | 0 | 188 | 217 | 35 | 6 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3420 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 25753782 | 25753782 | PRJEB7799q_S_NODE_2610_length_186_cov_11.900662_g2600_i0 | PRJEB7799 | 2610 | 186 | 11.900662 | 22.13523132 | root | 1 | Root_unresolved | Root_unresolved | 60.2 | 9.5e-5 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g2600 | i0 | 97.143 | 19.0591397849462 | 35 | 1 | 19 | 0 | 2 | 36 | 8 | 42 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3545 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 25799344 | 25799344 | PRJEB7799g_S_NODE_8275_length_169_cov_1.888060_g8059_i0 | PRJEB7799 | 8275 | 169 | 1.88806 | 3.1908214 | Platynereis dumerilii | 6359 | Annelida | Annelida | 82.4 | 1.8e-11 | NTclustered | gi|83307676|emb|CT033650.1| | 6359 | g8059 | i0 | 78.74 | 6.40828402366864 | 127 | 23 | 74 | 3 | 1 | 125 | 653 | 777 | Platynereis dumerilii EST IB0AAA16CH07EM1 | blastn | 1083 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 25889144 | 25889144 | PRJEB7799n_S_NODE_2051_length_297_cov_19.954198_g2014_i0 | PRJEB7799 | 2051 | 297 | 19.954198 | 59.26396806 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 5.93e-4 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g2014 | i0 | 100 | 11.2861952861953 | 31 | 0 | 10 | 0 | 261 | 291 | 42 | 12 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3352 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 25937657 | 25937657 | PRJEB7799p_S_NODE_6796_length_212_cov_167.632768_g6773_i0 | PRJEB7799 | 6796 | 212 | 167.632768 | 355.38146816 | Platynereis dumerilii | 6359 | Annelida | Annelida | 63.9 | 8.61e-6 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g6773 | i0 | 91.489 | 17.622641509434 | 47 | 2 | 21 | 2 | 10 | 54 | 6 | 52 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3736 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 26025137 | 26025137 | PRJEB7799h_S_NODE_748_length_213_cov_1143.247191_g745_i0 | PRJEB7799 | 748 | 213 | 1143.247191 | 2435.11651683 | root | 1 | Root_unresolved | Root_unresolved | 60.2 | 1.12e-4 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g745 | i0 | 100 | 17.1267605633803 | 32 | 0 | 15 | 0 | 163 | 194 | 37 | 6 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3648 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 26481257 | 26481257 | PRJEB7799o_S_NODE_2152_length_186_cov_1.284768_g2144_i0 | PRJEB7799 | 2152 | 186 | 1.284768 | 2.38966848 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.016 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g2144 | i0 | 100 | 0.150537634408602 | 28 | 0 | 15 | 0 | 31 | 58 | 14428653 | 14428680 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 26481870 | 26481870 | PRJEB7799p_S_NODE_4864_length_236_cov_2.184080_g4841_i0 | PRJEB7799 | 4864 | 236 | 2.18408 | 5.1544288 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 1.47e-30 | NR | AAC15915.1 | 34590 | g4841 | i0 | 85.5 | 199.093220338983 | 69 | 10 | 87.7 | 0 | 235 | 29 | 53 | 121 | AAC15915.1 histone H2B [Chaetopterus variopedatus] | diamond | 46986 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Chaetopteridae | Chaetopterus | Chaetopterus variopedatus | ||
| 26568872 | 26568872 | PRJEB7799c_S_NODE_1024_length_323_cov_1076.861111_g1001_i0 | PRJEB7799 | 1024 | 323 | 1076.861111 | 3478.26138853 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 6.52e-4 | NTclustered | gi|440586614|emb|HE971740.1| | 6359 | g1001 | i0 | 100 | 10.9628482972136 | 31 | 0 | 10 | 0 | 11 | 41 | 6 | 36 | Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene) | blastn | 3541 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 33145272 | 33145272 | PRJEB7799p_S_NODE_17455_length_171_cov_2.602941_g17432_i0 | PRJEB7799 | 17455 | 171 | 2.602941 | 4.45102911 | Opisthokonta | 33154 | Annelida | Annelida | 43.9 | 0.00397 | NR | ABW23172.1 | 6344 | g17432 | i0 | 54.1 | 4.54385964912281 | 37 | 16 | 64.9 | 1 | 166 | 56 | 142 | 177 | ABW23172.1 ribosomal protein rpl18 [Arenicola marina] | diamond | 777 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina |
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);;