contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJDB4470" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8936912 | 8936912 | PRJDB4470_P_NODE_94348_length_177_cov_1.171875_g93193_i0 | PRJDB4470 | 94348 | 177 | 1.171875 | 2.07421875 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g93193 | i0 | 92.5 | 0.740112994350282 | 40 | 1 | 23 | 2 | 8 | 47 | 3045108 | 3045071 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 131 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10212153 | 10212153 | PRJDB4470_P_NODE_23009_length_495_cov_1.515695_g21887_i0 | PRJDB4470 | 23009 | 495 | 1.515695 | 7.50269025 | Stylaria sp. THS-2006 | 397589 | Annelida | Annelida | 643 | 6.2699999999999974e-180 | NTclustered | gi|112144557|gb|DQ813403.1| | 397589 | g21887 | i0 | 90.101 | 90.3313131313131 | 495 | 49 | 100 | 0 | 1 | 495 | 1044 | 550 | Stylaria sp. THS-2006 elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds | blastn | 44714 | 643 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria sp. THS-2006 | |
| 11486957 | 11486957 | PRJDB4470_P_NODE_10170_length_768_cov_3.720445_g9312_i0 | PRJDB4470 | 10170 | 768 | 3.720445 | 28.5730176 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 359 | 4.06e-94 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g9312 | i0 | 81.25 | 22.2356770833333 | 464 | 70 | 59 | 12 | 260 | 711 | 14 | 472 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 17077 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 11487433 | 11487433 | PRJDB4470_P_NODE_38850_length_351_cov_1.582781_g37698_i0 | PRJDB4470 | 38850 | 351 | 1.582781 | 5.55556131 | Platynereis dumerilii | 6359 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|146189520|emb|AM697674.1| | 6359 | g37698 | i0 | 100 | 1.80911680911681 | 30 | 0 | 9 | 0 | 4 | 33 | 172 | 201 | Platynereis dumerilii mRNA for hypothetical protein (ORF1), isolate 2 | blastn | 635 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 15009283 | 15009283 | PRJDB4470_P_NODE_70892_length_218_cov_2.295858_g69737_i0 | PRJDB4470 | 70892 | 218 | 2.295858 | 5.00497044 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|146189520|emb|AM697674.1| | 6359 | g69737 | i0 | 100 | 0.26605504587156 | 29 | 0 | 13 | 0 | 190 | 218 | 205 | 177 | Platynereis dumerilii mRNA for hypothetical protein (ORF1), isolate 2 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 16586610 | 16586610 | PRJDB4470_P_NODE_68174_length_225_cov_1.772727_g67019_i0 | PRJDB4470 | 68174 | 225 | 1.772727 | 3.98863575 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 86.1 | 1.97e-12 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g67019 | i0 | 79.832 | 0.528888888888889 | 119 | 22 | 52 | 2 | 58 | 175 | 31164464 | 31164581 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 119 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21686133 | 21686133 | PRJDB4470_P_NODE_47318_length_302_cov_4.075099_g46165_i0 | PRJDB4470 | 47318 | 302 | 4.075099 | 12.30679898 | Pristina longiseta | 188231 | Annelida | Annelida | 431 | 3.09e-116 | NTclustered | gi|2169792353|gb|OM001222.1| | 188231 | g46165 | i0 | 97.984 | 77.4006622516556 | 248 | 5 | 82 | 0 | 55 | 302 | 527 | 280 | Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 23375 | 431 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina longiseta | |
| 21686551 | 21686551 | PRJDB4470_P_NODE_96118_length_174_cov_1.664000_g94963_i0 | PRJDB4470 | 96118 | 174 | 1.664 | 2.89536 | Mesenchytraeus solifugus | 223748 | Annelida | Annelida | 75 | 3.12e-9 | NTclustered | gi|1068289173|gb|KU728930.1| | 223748 | g94963 | i0 | 92.308 | 1.77586206896552 | 52 | 4 | 30 | 0 | 118 | 169 | 148 | 97 | Mesenchytraeus solifugus 16S large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 309 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Mesenchytraeus | Mesenchytraeus solifugus |
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);;