contig_metadata
13 rows where bioproject = "PRJNA293022", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4200372 | 4200372 | PRJNA293022_P_NODE_28484_length_263_cov_6.700935_g27747_i0 | PRJNA293022 | 28484 | 263 | 6.700935 | 17.62345905 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g27747 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 45 | 72 | 1214835 | 1214808 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6750967 | 6750967 | PRJNA293022_P_NODE_45246_length_207_cov_2.892405_g44509_i0 | PRJNA293022 | 45246 | 207 | 2.892405 | 5.98727835 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 3.89e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g44509 | i0 | 74.834 | 1.58937198067633 | 151 | 27 | 72 | 9 | 7 | 155 | 10364315 | 10364174 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 329 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13127158 | 13127158 | PRJNA293022_P_NODE_55391_length_187_cov_1.608696_g54654_i0 | PRJNA293022 | 55391 | 187 | 1.608696 | 3.00826152 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 9.57e-5 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g54654 | i0 | 76.636 | 14.6631016042781 | 107 | 25 | 57 | 0 | 1 | 107 | 9061088 | 9060982 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 2742 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14402245 | 14402245 | PRJNA293022_P_NODE_48112_length_201_cov_1.368421_g47375_i0 | PRJNA293022 | 48112 | 201 | 1.368421 | 2.75052621 | Branchipolynoe segonzaci | 907760 | Annelida | Annelida | 52.8 | 0.017 | NTclustered | gi|2738922717|gb|OP648300.1| | 907760 | g47375 | i0 | 100 | 0.139303482587065 | 28 | 0 | 14 | 0 | 141 | 168 | 15731 | 15704 | Branchipolynoe segonzaci voucher SIO:BIC:A4659 mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Polynoidae | Branchipolynoe | Branchipolynoe segonzaci | |
| 14402360 | 14402360 | PRJNA293022_P_NODE_70952_length_167_cov_0.881356_g70215_i0 | PRJNA293022 | 70952 | 167 | 0.881356 | 1.47186452 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|675882807|ref|XM_009028658.1| | 6412 | g70215 | i0 | 96.97 | 0.70059880239521 | 33 | 1 | 20 | 0 | 22 | 54 | 2155 | 2187 | Helobdella robusta hypothetical protein partial mRNA | blastn | 117 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 15676115 | 15676115 | PRJNA293022_P_NODE_60053_length_179_cov_2.246154_g59316_i0 | PRJNA293022 | 60053 | 179 | 2.246154 | 4.02061566 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 9.06e-5 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g59316 | i0 | 94.872 | 0.418994413407821 | 39 | 0 | 21 | 2 | 143 | 179 | 19674576 | 19674538 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 75 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15676249 | 15676249 | PRJNA293022_P_NODE_82893_length_153_cov_2.932692_g82156_i0 | PRJNA293022 | 82893 | 153 | 2.932692 | 4.48701876 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 7.49e-5 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g82156 | i0 | 94.737 | 15.4444444444444 | 38 | 2 | 25 | 0 | 26 | 63 | 6827399 | 6827362 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 2363 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18224974 | 18224974 | PRJNA293022_P_NODE_44495_length_209_cov_1.887500_g43758_i0 | PRJNA293022 | 44495 | 209 | 1.8875 | 3.944875 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 159 | 1.05e-34 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g43758 | i0 | 84 | 1.67942583732057 | 175 | 18 | 82 | 9 | 38 | 208 | 3542 | 3374 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 351 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 19499382 | 19499382 | PRJNA293022_P_NODE_76136_length_164_cov_0.904348_g75399_i0 | PRJNA293022 | 76136 | 164 | 0.904348 | 1.48313072 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 2.94e-4 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g75399 | i0 | 100 | 4.90853658536585 | 31 | 0 | 19 | 0 | 55 | 85 | 10947949 | 10947979 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 805 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19499424 | 19499424 | PRJNA293022_P_NODE_9436_length_466_cov_3.199041_g8704_i0 | PRJNA293022 | 9436 | 466 | 3.199041 | 14.90753106 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.013 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g8704 | i0 | 100 | 0.242489270386266 | 29 | 0 | 6 | 0 | 275 | 303 | 13067074 | 13067102 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 113 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23325212 | 23325212 | PRJNA293022_P_NODE_12219_length_408_cov_5.994429_g11482_i0 | PRJNA293022 | 12219 | 408 | 5.994429 | 24.45727032 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 2.34e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g11482 | i0 | 100 | 1.92647058823529 | 32 | 0 | 8 | 0 | 89 | 120 | 1760016 | 1760047 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 786 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 27091850 | 27091850 | PRJNA293022_P_NODE_39422_length_222_cov_2.387283_g38685_i0 | PRJNA293022 | 39422 | 222 | 2.387283 | 5.29976826 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.3 | 2.84e-14 | NR | CAH1772408.1 | 6347 | g38685 | i0 | 58.6 | 24.8513513513514 | 70 | 29 | 94.6 | 0 | 220 | 11 | 107 | 176 | CAH1772408.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 5517 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29190134 | 29190134 | PRJNA293022_P_NODE_65089_length_172_cov_1.227642_g64352_i0 | PRJNA293022 | 65089 | 172 | 1.227642 | 2.11154424 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 73.9 | 1.44e-13 | NR | KAK2164532.1 | 53620 | g64352 | i0 | 55.4 | 1.95348837209302 | 56 | 25 | 97.7 | 0 | 169 | 2 | 201 | 256 | KAK2164532.1 hypothetical protein LSH36_62g02042 [Paralvinella palmiformis] | diamond | 336 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis |
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);;