contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA741997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 721334 | 721334 | PRJNA741997_P_NODE_20981_length_498_cov_1.075294_g19864_i0 | PRJNA741997 | 20981 | 498 | 1.075294 | 5.35496412 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 2.91e-4 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g19864 | i0 | 100 | 0.566265060240964 | 32 | 0 | 6 | 0 | 105 | 136 | 23367032 | 23367001 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 282 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 721479 | 721479 | PRJNA741997_P_NODE_44401_length_325_cov_10.563492_g43281_i0 | PRJNA741997 | 44401 | 325 | 10.563492 | 34.331349 | Pectinaria gouldii | 260746 | Annelida | Annelida | 71.3 | 8.43e-8 | NTclustered | gi|121483560|gb|EF174157.1| | 260746 | g43281 | i0 | 85.714 | 9.86461538461539 | 70 | 6 | 21 | 3 | 259 | 325 | 305 | 373 | Pectinaria gouldii clone BM-P-1-2 hypothetical protein mRNA, complete cds | blastn | 3206 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Pectinariidae | Pectinaria | Pectinaria gouldii | |
| 3272731 | 3272731 | PRJNA741997_P_NODE_30003_length_400_cov_1.278287_g28883_i0 | PRJNA741997 | 30003 | 400 | 1.278287 | 5.113148 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g28883 | i0 | 96.97 | 0.0825 | 33 | 1 | 8 | 0 | 184 | 216 | 21062086 | 21062054 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4549815 | 4549815 | PRJNA741997_P_NODE_15864_length_597_cov_1.175573_g14760_i0 | PRJNA741997 | 15864 | 597 | 1.175573 | 7.01817081 | Pristina sp. CEE | 3386361 | Annelida | Annelida | 889 | 0 | NTclustered | gi|2889117355|gb|PP138076.1| | 3386361 | g14760 | i0 | 99.793 | 78.1474036850921 | 484 | 1 | 81 | 0 | 42 | 525 | 1 | 484 | Pristina sp. CEE voucher CE2232 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 46654 | 889 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina sp. CEE | |
| 4549927 | 4549927 | PRJNA741997_P_NODE_33584_length_375_cov_4.721854_g32464_i0 | PRJNA741997 | 33584 | 375 | 4.721854 | 17.7069525 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 73.1 | 2.74e-8 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g32464 | i0 | 84.416 | 0.413333333333333 | 77 | 9 | 20 | 3 | 131 | 206 | 15266569 | 15266643 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 155 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4550124 | 4550124 | PRJNA741997_P_NODE_70924_length_252_cov_1.603352_g69804_i0 | PRJNA741997 | 70924 | 252 | 1.603352 | 4.04044704 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g69804 | i0 | 100 | 0.119047619047619 | 30 | 0 | 12 | 0 | 198 | 227 | 874053 | 874082 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12200885 | 12200885 | PRJNA741997_P_NODE_45930_length_320_cov_1.246964_g44810_i0 | PRJNA741997 | 45930 | 320 | 1.246964 | 3.9902848 | Urechis unicinctus | 6432 | Annelida | Annelida | 204 | 7.829999999999998e-48 | NTclustered | gi|1953566331|gb|MN662255.1| | 6432 | g44810 | i0 | 78.594 | 79.534375 | 313 | 63 | 97 | 4 | 10 | 320 | 387 | 697 | Urechis unicinctus beta-tubulin mRNA, partial cds | blastn | 25451 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Xenopneusta | Urechidae | Urechis | Urechis unicinctus | |
| 13475503 | 13475503 | PRJNA741997_P_NODE_75891_length_249_cov_0.875000_g74771_i0 | PRJNA741997 | 75891 | 249 | 0.875 | 2.17875 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.35e-4 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g74771 | i0 | 97.222 | 5.16465863453815 | 36 | 0 | 14 | 1 | 184 | 219 | 2971871 | 2971905 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 1286 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17299714 | 17299714 | PRJNA741997_P_NODE_64674_length_267_cov_1.438144_g63554_i0 | PRJNA741997 | 64674 | 267 | 1.438144 | 3.83984448 | Helobdella robusta | 6412 | Annelida | Annelida | 58.4 | 5.25e-4 | NTclustered | gi|675868499|ref|XM_009021562.1| | 6412 | g63554 | i0 | 97.059 | 5.36704119850187 | 34 | 1 | 13 | 0 | 115 | 148 | 803 | 770 | Helobdella robusta hypothetical protein partial mRNA | blastn | 1433 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 19848547 | 19848547 | PRJNA741997_P_NODE_57236_length_284_cov_1.284360_g56116_i0 | PRJNA741997 | 57236 | 284 | 1.28436 | 3.6475824 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g56116 | i0 | 100 | 0.200704225352113 | 29 | 0 | 10 | 0 | 58 | 86 | 5900023 | 5900051 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19848569 | 19848569 | PRJNA741997_P_NODE_60516_length_277_cov_0.843137_g59396_i0 | PRJNA741997 | 60516 | 277 | 0.843137 | 2.33548949 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.52e-4 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g59396 | i0 | 100 | 0.220216606498195 | 32 | 0 | 12 | 0 | 218 | 249 | 26143205 | 26143236 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 61 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22398884 | 22398884 | PRJNA741997_P_NODE_36778_length_358_cov_1.368421_g35658_i0 | PRJNA741997 | 36778 | 358 | 1.368421 | 4.89894718 | Hirudo verbana | 311461 | Annelida | Annelida | 78.7 | 5.59e-10 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g35658 | i0 | 94.118 | 0.430167597765363 | 51 | 3 | 14 | 0 | 248 | 298 | 1184428 | 1184378 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 154 | 78.7 | 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);;