contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4958800 | 4958800 | PRJNA561212_P_NODE_17604_length_271_cov_1.136364_g17393_i0 | PRJNA561212 | 17604 | 271 | 1.136364 | 3.07954644 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|675890529|ref|XM_009032519.1| | 6412 | g17393 | i0 | 100 | 0.738007380073801 | 29 | 0 | 11 | 0 | 22 | 50 | 355 | 327 | Helobdella robusta hypothetical protein partial mRNA | blastn | 200 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 5649230 | 5649230 | PRJNA561212_P_NODE_22605_length_248_cov_1.285714_g22394_i0 | PRJNA561212 | 22605 | 248 | 1.285714 | 3.18857072 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|675870651|ref|XM_009022638.1| | 6412 | g22394 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 77 | 104 | 1143 | 1116 | Helobdella robusta hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 6923510 | 6923510 | PRJNA561212_P_NODE_2686_length_670_cov_7.465662_g2481_i0 | PRJNA561212 | 2686 | 670 | 7.465662 | 50.0199354 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.019 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g2481 | i0 | 100 | 0.0432835820895522 | 29 | 0 | 4 | 0 | 338 | 366 | 17840604 | 17840576 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6923596 | 6923596 | PRJNA561212_P_NODE_7526_length_400_cov_1.321101_g7315_i0 | PRJNA561212 | 7526 | 400 | 1.321101 | 5.284404 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.77e-5 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g7315 | i0 | 89.796 | 2.1875 | 49 | 5 | 12 | 0 | 30 | 78 | 7359848 | 7359800 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 875 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9473988 | 9473988 | PRJNA561212_P_NODE_22948_length_248_cov_0.891429_g22737_i0 | PRJNA561212 | 22948 | 248 | 0.891429 | 2.21074392 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g22737 | i0 | 94.286 | 0.366935483870968 | 35 | 2 | 14 | 0 | 27 | 61 | 12709396 | 12709430 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 91 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10749872 | 10749872 | PRJNA561212_P_NODE_729_length_1215_cov_2.049037_g611_i0 | PRJNA561212 | 729 | 1215 | 2.049037 | 24.89579955 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.034 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g611 | i0 | 100 | 0.0238683127572016 | 29 | 0 | 2 | 0 | 624 | 652 | 1874493 | 1874465 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12024397 | 12024397 | PRJNA561212_P_NODE_15390_length_287_cov_1.294393_g15179_i0 | PRJNA561212 | 15390 | 287 | 1.294393 | 3.71490791 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 4.41e-5 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g15179 | i0 | 92.857 | 1.03135888501742 | 42 | 3 | 15 | 0 | 7 | 48 | 15632692 | 15632651 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 296 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13299628 | 13299628 | PRJNA561212_P_NODE_6451_length_434_cov_0.819945_g6240_i0 | PRJNA561212 | 6451 | 434 | 0.819945 | 3.5585613 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.012 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g6240 | i0 | 100 | 0.0668202764976959 | 29 | 0 | 7 | 0 | 318 | 346 | 1545397 | 1545369 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15848201 | 15848201 | PRJNA561212_P_NODE_16393_length_280_cov_0.850242_g16182_i0 | PRJNA561212 | 16393 | 280 | 0.850242 | 2.3806776 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 5.55e-4 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g16182 | i0 | 97.059 | 0.221428571428571 | 34 | 1 | 12 | 0 | 136 | 169 | 11866456 | 11866489 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18397184 | 18397184 | PRJNA561212_P_NODE_13795_length_301_cov_1.267544_g13584_i0 | PRJNA561212 | 13795 | 301 | 1.267544 | 3.81530744 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g13584 | i0 | 100 | 0.0996677740863787 | 30 | 0 | 10 | 0 | 235 | 264 | 2320929 | 2320900 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20947573 | 20947573 | PRJNA561212_P_NODE_23377_length_247_cov_0.896552_g23166_i0 | PRJNA561212 | 23377 | 247 | 0.896552 | 2.21448344 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.8e-4 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g23166 | i0 | 97.059 | 0.137651821862348 | 34 | 1 | 14 | 0 | 214 | 247 | 11877213 | 11877246 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21532726 | 21532726 | PRJNA561212_P_NODE_517_length_1396_cov_3.064248_g418_i0 | PRJNA561212 | 517 | 1396 | 3.064248 | 42.77690208 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.2 | 8.55e-4 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g418 | i0 | 92.683 | 0.101002865329513 | 41 | 3 | 3 | 0 | 1314 | 1354 | 16353082 | 16353042 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 141 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25357035 | 25357035 | PRJNA561212_P_NODE_25780_length_242_cov_0.923077_g25569_i0 | PRJNA561212 | 25780 | 242 | 0.923077 | 2.23384634 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g25569 | i0 | 100 | 0.231404958677686 | 28 | 0 | 12 | 0 | 43 | 70 | 3456972 | 3456999 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 56 | 52.8 | 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);;