contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA832865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2098498 | 2098498 | PRJNA832865_S_NODE_35982_length_457_cov_2.111979_g30898_i0 | PRJNA832865 | 35982 | 457 | 2.111979 | 9.65174403 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g30898 | 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 | |
| 4652270 | 4652270 | PRJNA832865_S_NODE_90724_length_256_cov_1.262295_g85638_i0 | PRJNA832865 | 90724 | 256 | 1.262295 | 3.2314752 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.87e-5 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g85638 | 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 | |
| 5926017 | 5926017 | PRJNA832865_S_NODE_30165_length_532_cov_2.721133_g25114_i0 | PRJNA832865 | 30165 | 532 | 2.721133 | 14.47642756 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|675877575|ref|XM_009026100.1| | 6412 | g25114 | i0 | 96.97 | 0.182330827067669 | 33 | 1 | 6 | 0 | 87 | 119 | 1176 | 1144 | Helobdella robusta hypothetical protein mRNA | blastn | 97 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 5926450 | 5926450 | PRJNA832865_S_NODE_52005_length_350_cov_1.350181_g46919_i0 | PRJNA832865 | 52005 | 350 | 1.350181 | 4.7256335 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g46919 | i0 | 100 | 0.0857142857142857 | 30 | 0 | 9 | 0 | 313 | 342 | 4685508 | 4685479 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13575577 | 13575577 | PRJNA832865_S_NODE_101951_length_246_cov_1.219653_g96865_i0 | PRJNA832865 | 101951 | 246 | 1.219653 | 3.00034638 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.78e-4 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g96865 | 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 | |
| 13577441 | 13577441 | PRJNA832865_S_NODE_90811_length_256_cov_1.202186_g85725_i0 | PRJNA832865 | 90811 | 256 | 1.202186 | 3.07759616 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g85725 | i0 | 100 | 0.21875 | 28 | 0 | 11 | 0 | 177 | 204 | 843353 | 843326 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18674850 | 18674850 | PRJNA832865_S_NODE_66875_length_302_cov_1.973799_g61789_i0 | PRJNA832865 | 66875 | 302 | 1.973799 | 5.96087298 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g61789 | 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 | |
| 19949211 | 19949211 | PRJNA832865_S_NODE_23336_length_675_cov_3.091362_g18446_i0 | PRJNA832865 | 23336 | 675 | 3.091362 | 20.8666935 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 1.12e-4 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g18446 | i0 | 88.462 | 0.231111111111111 | 52 | 4 | 7 | 2 | 468 | 517 | 17095809 | 17095758 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 156 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21225065 | 21225065 | PRJNA832865_S_NODE_36217_length_455_cov_1.068063_g31133_i0 | PRJNA832865 | 36217 | 455 | 1.068063 | 4.85968665 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.012 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g31133 | 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 | |
| 22500382 | 22500382 | PRJNA832865_S_NODE_71278_length_292_cov_1.570776_g66192_i0 | PRJNA832865 | 71278 | 292 | 1.570776 | 4.58666592 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g66192 | 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 | |
| 25049820 | 25049820 | PRJNA832865_S_NODE_64920_length_307_cov_2.136752_g59834_i0 | PRJNA832865 | 64920 | 307 | 2.136752 | 6.55982864 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g59834 | 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 |
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);;