contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA798511" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 791157 | 791157 | PRJNA798511_P_NODE_85301_length_256_cov_1.262295_g81035_i0 | PRJNA798511 | 85301 | 256 | 1.262295 | 3.2314752 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.87e-5 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g81035 | i0 | 91.304 | 0.921875 | 46 | 2 | 36 | 2 | 184 | 229 | 14363340 | 14363297 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 236 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2066666 | 2066666 | PRJNA798511_P_NODE_65042_length_302_cov_1.973799_g60776_i0 | PRJNA798511 | 65042 | 302 | 1.973799 | 5.96087298 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g60776 | i0 | 100 | 0.28476821192053 | 29 | 0 | 10 | 0 | 188 | 216 | 843326 | 843354 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 86 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4619299 | 4619299 | PRJNA798511_P_NODE_68804_length_292_cov_1.566210_g64538_i0 | PRJNA798511 | 68804 | 292 | 1.56621 | 4.5733332 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g64538 | i0 | 87.755 | 0.167808219178082 | 49 | 4 | 16 | 2 | 74 | 120 | 6101102 | 6101150 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 49 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5893911 | 5893911 | PRJNA798511_P_NODE_36445_length_455_cov_1.068063_g32186_i0 | PRJNA798511 | 36445 | 455 | 1.068063 | 4.85968665 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.012 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g32186 | i0 | 94.286 | 0.138461538461538 | 35 | 2 | 8 | 0 | 300 | 334 | 4784586 | 4784620 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 63 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5894751 | 5894751 | PRJNA798511_P_NODE_91845_length_248_cov_1.765714_g87579_i0 | PRJNA798511 | 91845 | 248 | 1.765714 | 4.37897072 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g87579 | i0 | 100 | 5.66532258064516 | 29 | 0 | 12 | 0 | 99 | 127 | 8645408 | 8645436 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 1405 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7169566 | 7169566 | PRJNA798511_P_NODE_95046_length_246_cov_1.219653_g90780_i0 | PRJNA798511 | 95046 | 246 | 1.219653 | 3.00034638 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.78e-4 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g90780 | i0 | 97.059 | 0.252032520325203 | 34 | 1 | 14 | 0 | 195 | 228 | 1199910 | 1199943 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12269702 | 12269702 | PRJNA798511_P_NODE_32450_length_502_cov_1.934732_g28198_i0 | PRJNA798511 | 32450 | 502 | 1.934732 | 9.71235464 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|675877575|ref|XM_009026100.1| | 6412 | g28198 | i0 | 96.97 | 0.472111553784861 | 33 | 1 | 7 | 0 | 57 | 89 | 1176 | 1144 | Helobdella robusta hypothetical protein mRNA | blastn | 237 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 14819058 | 14819058 | PRJNA798511_P_NODE_53972_length_339_cov_1.364662_g49706_i0 | PRJNA798511 | 53972 | 339 | 1.364662 | 4.62620418 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g49706 | i0 | 100 | 0.0884955752212389 | 30 | 0 | 9 | 0 | 9 | 38 | 4685479 | 4685508 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16093699 | 16093699 | PRJNA798511_P_NODE_83853_length_259_cov_1.150538_g79587_i0 | PRJNA798511 | 83853 | 259 | 1.150538 | 2.97989342 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g79587 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 70 | 97 | 8279198 | 8279171 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19917311 | 19917311 | PRJNA798511_P_NODE_42356_length_403_cov_0.827273_g38092_i0 | PRJNA798511 | 42356 | 403 | 0.827273 | 3.33391019 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.039 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g38092 | i0 | 100 | 0.0694789081885856 | 28 | 0 | 7 | 0 | 16 | 43 | 13644653 | 13644680 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23743560 | 23743560 | PRJNA798511_P_NODE_63299_length_307_cov_2.136752_g59033_i0 | PRJNA798511 | 63299 | 307 | 2.136752 | 6.55982864 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g59033 | i0 | 100 | 0.0944625407166124 | 29 | 0 | 9 | 0 | 119 | 147 | 10345452 | 10345480 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25016829 | 25016829 | PRJNA798511_P_NODE_36200_length_457_cov_2.104167_g31941_i0 | PRJNA798511 | 36200 | 457 | 2.104167 | 9.61604319 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g31941 | i0 | 100 | 0.636761487964989 | 31 | 0 | 7 | 0 | 311 | 341 | 3728493 | 3728463 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 291 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25016900 | 25016900 | PRJNA798511_P_NODE_39760_length_423_cov_1.494286_g35497_i0 | PRJNA798511 | 39760 | 423 | 1.494286 | 6.32082978 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.88e-5 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g35497 | i0 | 97.297 | 1.34042553191489 | 37 | 1 | 9 | 0 | 22 | 58 | 10232720 | 10232684 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 567 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana |
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);;