contig_metadata
8 rows where bioproject = "PRJNA340009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2942966 | 2942966 | PRJNA340009_P_NODE_52363_length_180_cov_1.305344_g52056_i0 | PRJNA340009 | 52363 | 180 | 1.305344 | 2.3496192 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 2.54e-5 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g52056 | i0 | 94.872 | 3.59444444444444 | 39 | 2 | 22 | 0 | 88 | 126 | 11677923 | 11677961 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 647 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6769685 | 6769685 | PRJNA340009_P_NODE_3106_length_579_cov_7.969811_g2810_i0 | PRJNA340009 | 3106 | 579 | 7.969811 | 46.14520569 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.016 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g2810 | i0 | 100 | 0.0500863557858377 | 29 | 0 | 5 | 0 | 508 | 536 | 3369208 | 3369180 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9320241 | 9320241 | PRJNA340009_P_NODE_42928_length_195_cov_2.184932_g42621_i0 | PRJNA340009 | 42928 | 195 | 2.184932 | 4.2606174 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 250 | 5.57e-62 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g42621 | i0 | 92.571 | 2.76410256410256 | 175 | 11 | 89 | 2 | 22 | 195 | 3542 | 3369 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 539 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 13145955 | 13145955 | PRJNA340009_P_NODE_54331_length_177_cov_1.515625_g54024_i0 | PRJNA340009 | 54331 | 177 | 1.515625 | 2.68265625 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g54024 | i0 | 100 | 0.169491525423729 | 30 | 0 | 17 | 0 | 44 | 73 | 9692575 | 9692546 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14421350 | 14421350 | PRJNA340009_P_NODE_77752_length_160_cov_3.225225_g77445_i0 | PRJNA340009 | 77752 | 160 | 3.225225 | 5.16036 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.013 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g77445 | i0 | 100 | 0.175 | 28 | 0 | 18 | 0 | 43 | 70 | 8523329 | 8523356 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17647586 | 17647586 | PRJNA340009_P_NODE_30314_length_226_cov_1.728814_g30007_i0 | PRJNA340009 | 30314 | 226 | 1.728814 | 3.90711964 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g30007 | i0 | 94.286 | 0.29646017699115 | 35 | 1 | 15 | 1 | 57 | 90 | 3409722 | 3409688 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 67 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22068632 | 22068632 | PRJNA340009_P_NODE_39578_length_202_cov_1.941176_g39271_i0 | PRJNA340009 | 39578 | 202 | 1.941176 | 3.92117552 | Levensteiniella cf. riftense | 3061307 | Annelida | Annelida | 78.7 | 2.9e-10 | NTclustered | gi|2172388294|gb|OM105857.1| | 3061307 | g39271 | i0 | 100 | 3.96534653465347 | 42 | 0 | 21 | 0 | 155 | 196 | 1921 | 1962 | Levensteiniella cf. riftense voucher SIO:BIC:A13202 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 801 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Polynoidae | Levensteiniella | Levensteiniella cf. riftense | |
| 31640518 | 31640518 | PRJNA340009_P_NODE_25976_length_241_cov_93.255208_g25669_i0 | PRJNA340009 | 25976 | 241 | 93.255208 | 224.74505128 | Metazoa | 33208 | Annelida | Annelida | 79.7 | 3.34e-15 | NR | XP_009017197.1 | 6412 | g25669 | i0 | 60.9 | 19.4066390041494 | 64 | 23 | 77.2 | 1 | 22 | 207 | 430 | 493 | XP_009017197.1 hypothetical protein HELRODRAFT_172284 [Helobdella robusta] | diamond | 4677 | 80.1 | 0.995006242197254 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;