contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8318105 | 8318105 | PRJNA683669_P_NODE_20127_length_287_cov_2.126168_g19895_i0 | PRJNA683669 | 20127 | 287 | 2.126168 | 6.10210216 | Acromegalomma interruptum | 2023653 | Annelida | Annelida | 276 | 1.45e-69 | NTclustered | gi|1227250258|gb|MF145113.1| | 2023653 | g19895 | i0 | 87.19 | 80.9268292682927 | 242 | 31 | 84 | 0 | 46 | 287 | 483 | 242 | Acromegalomma interruptum isolate Rcvrn_Contig127_ORF20 putative phototransduction mRNA, partial cds | blastn | 23226 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Sabellidae | Acromegalomma | Acromegalomma interruptum | |
| 17242935 | 17242935 | PRJNA683669_P_NODE_2994_length_758_cov_3.077372_g2789_i0 | PRJNA683669 | 2994 | 758 | 3.077372 | 23.32647976 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.006 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g2789 | i0 | 92.308 | 0.0514511873350923 | 39 | 3 | 5 | 0 | 88 | 126 | 25695889 | 25695851 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 39 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17242974 | 17242974 | PRJNA683669_P_NODE_4194_length_637_cov_2.294326_g3970_i0 | PRJNA683669 | 4194 | 637 | 2.294326 | 14.61485662 | Mesenchytraeus cf. pedatus SL-2017 | 2052678 | Annelida | Annelida | 305 | 4.4e-78 | NTclustered | gi|1275874787|gb|KU728824.2| | 2052678 | g3970 | i0 | 80.235 | 52.4960753532182 | 425 | 69 | 65 | 12 | 222 | 637 | 959 | 541 | Mesenchytraeus cf. pedatus SL-2017 glyceraldehyde-3-phosphate dehydrogenase mRNA, complete cds | blastn | 33440 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Mesenchytraeus | Mesenchytraeus cf. pedatus SL-2017 | |
| 22342334 | 22342334 | PRJNA683669_P_NODE_34378_length_229_cov_2.397436_g34146_i0 | PRJNA683669 | 34378 | 229 | 2.397436 | 5.49012844 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.39e-4 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g34146 | i0 | 100 | 0.135371179039301 | 31 | 0 | 14 | 0 | 35 | 65 | 203454 | 203484 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24891138 | 24891138 | PRJNA683669_P_NODE_30240_length_246_cov_0.890173_g30008_i0 | PRJNA683669 | 30240 | 246 | 0.890173 | 2.18982558 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.69e-5 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g30008 | i0 | 88.235 | 1.50813008130081 | 51 | 6 | 21 | 0 | 179 | 229 | 1141831 | 1141781 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 371 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24891165 | 24891165 | PRJNA683669_P_NODE_32680_length_243_cov_0.905882_g32448_i0 | PRJNA683669 | 32680 | 243 | 0.905882 | 2.20129326 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.71e-4 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g32448 | i0 | 88.235 | 0.670781893004115 | 51 | 3 | 20 | 2 | 73 | 120 | 23545702 | 23545652 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 163 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus |
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);;