contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1782934 | 1782934 | PRJNA534016_P_NODE_3942_length_414_cov_1.677419_g3852_i0 | PRJNA534016 | 3942 | 414 | 1.677419 | 6.94451466 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.04 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g3852 | i0 | 100 | 0.0676328502415459 | 28 | 0 | 7 | 0 | 100 | 127 | 14231448 | 14231475 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4334346 | 4334346 | PRJNA534016_P_NODE_1044_length_807_cov_2.852861_g967_i0 | PRJNA534016 | 1044 | 807 | 2.852861 | 23.02258827 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.006 | NTclustered | gi|675890235|ref|XM_009032372.1| | 6412 | g967 | i0 | 96.97 | 0.332094175960347 | 33 | 1 | 4 | 0 | 251 | 283 | 472 | 504 | Helobdella robusta hypothetical protein partial mRNA | blastn | 268 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 8160392 | 8160392 | PRJNA534016_P_NODE_8547_length_291_cov_1.261468_g8457_i0 | PRJNA534016 | 8547 | 291 | 1.261468 | 3.67087188 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.027 | NTclustered | gi|675890753|ref|XM_009032631.1| | 6412 | g8457 | i0 | 100 | 0.0962199312714777 | 28 | 0 | 10 | 0 | 228 | 255 | 601 | 574 | Helobdella robusta hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 14536394 | 14536394 | PRJNA534016_P_NODE_5512_length_355_cov_1.092199_g5422_i0 | PRJNA534016 | 5512 | 355 | 1.092199 | 3.87730645 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 4.31e-6 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g5422 | i0 | 80.435 | 8.76338028169014 | 92 | 12 | 26 | 3 | 165 | 256 | 13007069 | 13006984 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 3111 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 23459730 | 23459730 | PRJNA534016_P_NODE_17379_length_243_cov_0.905882_g17289_i0 | PRJNA534016 | 17379 | 243 | 0.905882 | 2.20129326 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.71e-4 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g17289 | i0 | 97.143 | 2.07818930041152 | 35 | 0 | 14 | 1 | 1 | 34 | 13569384 | 13569350 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 505 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24733369 | 24733369 | PRJNA534016_P_NODE_13000_length_255_cov_2.247253_g12910_i0 | PRJNA534016 | 13000 | 255 | 2.247253 | 5.73049515 | Hirudo verbana | 311461 | Annelida | Annelida | 185 | 2.19e-42 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g12910 | i0 | 92.913 | 1.01176470588235 | 127 | 9 | 100 | 0 | 129 | 255 | 3830460 | 3830334 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 258 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24733462 | 24733462 | PRJNA534016_P_NODE_18940_length_231_cov_2.607595_g18850_i0 | PRJNA534016 | 18940 | 231 | 2.607595 | 6.02354445 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.44e-4 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g18850 | i0 | 92.5 | 2.35064935064935 | 40 | 3 | 17 | 0 | 36 | 75 | 14222459 | 14222420 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 543 | 58.4 | 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);;