contig_metadata
21 rows where bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4313715 | 4313715 | PRJNA515078_P_NODE_1784_length_727_cov_2.963768_g1606_i0 | PRJNA515078 | 1784 | 727 | 2.963768 | 21.54659336 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 123 | 1.14e-29 | NR | XP_009029644.1 | 6412 | g1606 | i0 | 65.2 | 6.06189821182944 | 92 | 31 | 38 | 1 | 3 | 278 | 215 | 305 | XP_009029644.1 hypothetical protein HELRODRAFT_186151 [Helobdella robusta] | diamond | 4407 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 8139802 | 8139802 | PRJNA515078_P_NODE_10087_length_285_cov_1.185484_g9854_i0 | PRJNA515078 | 10087 | 285 | 1.185484 | 3.3786294 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g9854 | i0 | 94.444 | 0.224561403508772 | 36 | 1 | 12 | 1 | 210 | 244 | 520155 | 520190 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8139819 | 8139819 | PRJNA515078_P_NODE_12467_length_252_cov_1.269767_g12234_i0 | PRJNA515078 | 12467 | 252 | 1.269767 | 3.19981284 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.91e-4 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g12234 | i0 | 100 | 0.575396825396825 | 31 | 0 | 12 | 0 | 131 | 161 | 20955849 | 20955819 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 145 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9414982 | 9414982 | PRJNA515078_P_NODE_24108_length_177_cov_1.114286_g23875_i0 | PRJNA515078 | 24108 | 177 | 1.114286 | 1.97228622 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 3.21e-4 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g23875 | i0 | 100 | 1.44067796610169 | 31 | 0 | 18 | 0 | 20 | 50 | 797032 | 797002 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 255 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14515793 | 14515793 | PRJNA515078_P_NODE_26152_length_170_cov_1.172932_g25919_i0 | PRJNA515078 | 26152 | 170 | 1.172932 | 1.9939844 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g25919 | i0 | 100 | 0.170588235294118 | 29 | 0 | 17 | 0 | 104 | 132 | 4048964 | 4048992 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16413655 | 16413655 | PRJNA515078_P_NODE_30173_length_159_cov_1.278689_g29940_i0 | PRJNA515078 | 30173 | 159 | 1.278689 | 2.03311551 | Opisthokonta | 33154 | Annelida | Annelida | 52.8 | 0.013 | NTclustered | gi|675859291|ref|XM_009016958.1| | 6412 | g29940 | i0 | 100 | 0.528301886792453 | 28 | 0 | 18 | 0 | 132 | 159 | 1089 | 1116 | Helobdella robusta hypothetical protein partial mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 22163747 | 22163747 | PRJNA515078_P_NODE_7338_length_344_cov_1.306189_g7105_i0 | PRJNA515078 | 7338 | 344 | 1.306189 | 4.49329016 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g7105 | i0 | 100 | 0.927325581395349 | 29 | 0 | 8 | 0 | 222 | 250 | 12192786 | 12192814 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 319 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 27393420 | 27393420 | PRJNA515078_P_NODE_9183_length_301_cov_1.420455_g8950_i0 | PRJNA515078 | 9183 | 301 | 1.420455 | 4.27556955 | Capitella teleta | 283909 | Annelida | Annelida | 145 | 7.14e-38 | NR | ELT93316.1 | 283909 | g8950 | i0 | 71.3 | 0.93687707641196 | 94 | 26 | 93.7 | 1 | 300 | 19 | 16 | 108 | ELT93316.1 hypothetical protein CAPTEDRAFT_125179 [Capitella teleta] | diamond | 282 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28087757 | 28087757 | PRJNA515078_P_NODE_30525_length_158_cov_1.611570_g30292_i0 | PRJNA515078 | 30525 | 158 | 1.61157 | 2.5462806 | Ridgeia piscesae | 27915 | Annelida | Annelida | 70.9 | 7.53e-13 | NR | KAK2171970.1 | 27915 | g30292 | i0 | 72.1 | 0.816455696202532 | 43 | 12 | 81.6 | 0 | 158 | 30 | 143 | 185 | KAK2171970.1 hypothetical protein NP493_1009g01009 [Ridgeia piscesae] | diamond | 129 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28387374 | 28387374 | PRJNA515078_P_NODE_13486_length_241_cov_1.147059_g13253_i0 | PRJNA515078 | 13486 | 241 | 1.147059 | 2.76441219 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 2.35e-10 | NR | XP_009023537.1 | 6412 | g13253 | i0 | 50.9 | 3.59751037344398 | 57 | 28 | 71 | 0 | 239 | 69 | 44 | 100 | XP_009023537.1 hypothetical protein HELRODRAFT_84675, partial [Helobdella robusta] | diamond | 867 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28593185 | 28593185 | PRJNA515078_P_NODE_7987_length_326_cov_1.065744_g7754_i0 | PRJNA515078 | 7987 | 326 | 1.065744 | 3.47432544 | Helobdella robusta | 6412 | Annelida | Annelida | 70.9 | 5.04e-12 | NR | XP_009021849.1 | 6412 | g7754 | i0 | 38.1 | 6.66257668711656 | 105 | 47 | 96.6 | 1 | 3 | 317 | 103 | 189 | XP_009021849.1 hypothetical protein HELRODRAFT_83625 [Helobdella robusta] | diamond | 2172 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28829382 | 28829382 | PRJNA515078_P_NODE_8788_length_308_cov_1.782288_g8555_i0 | PRJNA515078 | 8788 | 308 | 1.782288 | 5.48944704 | Metazoa | 33208 | Annelida | Annelida | 92 | 1.19e-19 | NR | CAH1796383.1 | 6347 | g8555 | i0 | 48.2 | 2.47402597402597 | 85 | 43 | 81.8 | 1 | 253 | 2 | 169 | 253 | CAH1796383.1 unnamed protein product [Owenia fusiformis] | diamond | 762 | 92.4 | 0.995670995670996 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29808169 | 29808169 | PRJNA515078_P_NODE_21091_length_189_cov_1.250000_g20858_i0 | PRJNA515078 | 21091 | 189 | 1.25 | 2.3625 | Metazoa | 33208 | Annelida | Annelida | 82 | 2.54e-16 | NR | KAK2162310.1 | 53620 | g20858 | i0 | 68.5 | 1.79365079365079 | 54 | 17 | 85.7 | 0 | 164 | 3 | 309 | 362 | KAK2162310.1 hypothetical protein LSH36_100g00026 [Paralvinella palmiformis] | diamond | 339 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30361982 | 30361982 | PRJNA515078_P_NODE_20432_length_192_cov_1.258065_g20199_i0 | PRJNA515078 | 20432 | 192 | 1.258065 | 2.4154848 | Capitella teleta | 283909 | Annelida | Annelida | 69.3 | 7.63e-12 | NR | ELU09893.1 | 283909 | g20199 | i0 | 49.2 | 1.9375 | 63 | 32 | 98.4 | 0 | 191 | 3 | 133 | 195 | ELU09893.1 hypothetical protein CAPTEDRAFT_178707 [Capitella teleta] | diamond | 372 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30456701 | 30456701 | PRJNA515078_P_NODE_31293_length_157_cov_0.975000_g31060_i0 | PRJNA515078 | 31293 | 157 | 0.975 | 1.53075 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 56.6 | 1.47e-7 | NR | KAK2153638.1 | 53620 | g31060 | i0 | 60.5 | 0.821656050955414 | 43 | 17 | 82.2 | 0 | 157 | 29 | 261 | 303 | KAK2153638.1 hypothetical protein LSH36_291g09021 [Paralvinella palmiformis] | diamond | 129 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30597956 | 30597956 | PRJNA515078_P_NODE_6793_length_358_cov_3.031153_g6560_i0 | PRJNA515078 | 6793 | 358 | 3.031153 | 10.85152774 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.3 | 7.61e-14 | NR | ELU12778.1 | 283909 | g6560 | i0 | 42.7 | 6.16759776536313 | 103 | 59 | 86.3 | 0 | 357 | 49 | 128 | 230 | ELU12778.1 hypothetical protein CAPTEDRAFT_170468 [Capitella teleta] | diamond | 2208 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30661275 | 30661275 | PRJNA515078_P_NODE_19613_length_196_cov_1.440252_g19380_i0 | PRJNA515078 | 19613 | 196 | 1.440252 | 2.82289392 | Polychaeta | 6341 | Annelida | Annelida | 41.2 | 0.0298 | NR | CAH1781705.1 | 6347 | g19380 | i0 | 31.3 | 2.73979591836735 | 67 | 44 | 99.5 | 1 | 196 | 2 | 37 | 103 | CAH1781705.1 unnamed protein product [Owenia fusiformis] | diamond | 537 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31467845 | 31467845 | PRJNA515078_P_NODE_30696_length_158_cov_1.289256_g30463_i0 | PRJNA515078 | 30696 | 158 | 1.289256 | 2.03702448 | Helobdella robusta | 6412 | Annelida | Annelida | 61.2 | 2.41e-9 | NR | XP_009018535.1 | 6412 | g30463 | i0 | 62.7 | 4.87974683544304 | 51 | 17 | 96.8 | 1 | 1 | 153 | 64 | 112 | XP_009018535.1 hypothetical protein HELRODRAFT_185645 [Helobdella robusta] | diamond | 771 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31546480 | 31546480 | PRJNA515078_P_NODE_14676_length_229_cov_1.817708_g14443_i0 | PRJNA515078 | 14676 | 229 | 1.817708 | 4.16255132 | root | 1 | Root_unresolved | Root_unresolved | 119 | 1.2e-30 | NR | CAH1794795.1 | 6347 | g14443 | i0 | 71.1 | 18.9170305676856 | 76 | 22 | 99.6 | 0 | 228 | 1 | 195 | 270 | CAH1794795.1 unnamed protein product [Owenia fusiformis] | diamond | 4332 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31767639 | 31767639 | PRJNA515078_P_NODE_17317_length_209_cov_3.906977_g17084_i0 | PRJNA515078 | 17317 | 209 | 3.906977 | 8.16558193 | Metazoa | 33208 | Annelida | Annelida | 45.8 | 2.35e-4 | NR | KAK2141783.1 | 53620 | g17084 | i0 | 41.1 | 4.62200956937799 | 56 | 29 | 80.4 | 1 | 6 | 173 | 25 | 76 | KAK2141783.1 hypothetical protein LSH36_1041g00012 [Paralvinella palmiformis] | diamond | 966 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32858228 | 32858228 | PRJNA515078_P_NODE_11520_length_263_cov_1.969027_g11287_i0 | PRJNA515078 | 11520 | 263 | 1.969027 | 5.17854101 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 65.5 | 4.64e-10 | NR | CAD5124401.1 | 2664684 | g11287 | i0 | 45.3 | 2.3041825095057 | 64 | 33 | 71.9 | 2 | 6 | 194 | 489 | 551 | CAD5124401.1 DgyrCDS12686 [Dimorphilus gyrociliatus] | diamond | 606 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus |
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);;