contig_metadata
10 rows where bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1295366 | 1295366 | PRJEB14664_P_NODE_16122_length_174_cov_1.417266_g15992_i0 | PRJEB14664 | 16122 | 174 | 1.417266 | 2.46604284 | Metazoa | 33208 | Annelida | Annelida | 112 | 4.2900000000000005e-27 | NR | CAH1782114.1 | 6347 | g15992 | i0 | 94.8 | 23 | 58 | 3 | 100 | 0 | 1 | 174 | 132 | 189 | CAH1782114.1 unnamed protein product [Owenia fusiformis] | diamond | 4002 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 5123657 | 5123657 | PRJEB14664_P_NODE_4325_length_419_cov_7.627604_g595_i1 | PRJEB14664 | 4325 | 419 | 7.627604 | 31.95966076 | Aeolosoma viride | 394736 | Annelida | Annelida | 176 | 2.29e-39 | NTclustered | gi|1151119857|gb|KY079092.1| | 394736 | g595 | i1 | 86.709 | 36.417661097852 | 158 | 21 | 38 | 0 | 262 | 419 | 1195 | 1038 | Aeolosoma viride actin mRNA, complete cds | blastn | 15259 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma viride | |
| 12774729 | 12774729 | PRJEB14664_P_NODE_11991_length_213_cov_1.123596_g11861_i0 | PRJEB14664 | 11991 | 213 | 1.123596 | 2.39325948 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.019 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g11861 | i0 | 100 | 0.131455399061033 | 28 | 0 | 13 | 0 | 186 | 213 | 32016326 | 32016299 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14049294 | 14049294 | PRJEB14664_P_NODE_14732_length_185_cov_1.600000_g14602_i0 | PRJEB14664 | 14732 | 185 | 1.6 | 2.96 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g14602 | i0 | 96.875 | 0.172972972972973 | 32 | 1 | 17 | 0 | 14 | 45 | 1170751 | 1170720 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 28605804 | 28605804 | PRJEB14664_P_NODE_16687_length_170_cov_1.481481_g16557_i0 | PRJEB14664 | 16687 | 170 | 1.481481 | 2.5185177 | Polychaeta | 6341 | Annelida | Annelida | 57.4 | 9.45e-8 | NR | CAH1777476.1 | 6347 | g16557 | i0 | 48.1 | 1.83529411764706 | 54 | 28 | 95.3 | 0 | 9 | 170 | 823 | 876 | CAH1777476.1 unnamed protein product [Owenia fusiformis] | diamond | 312 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28738466 | 28738466 | PRJEB14664_P_NODE_3587_length_470_cov_3.616092_g3462_i0 | PRJEB14664 | 3587 | 470 | 3.616092 | 16.9956324 | Sipunculus nudus | 6446 | Annelida | Annelida | 171 | 9.52e-52 | NR | ABW90364.1 | 6446 | g3462 | i0 | 64.9 | 2.60425531914894 | 134 | 45 | 85.5 | 1 | 448 | 47 | 3 | 134 | ABW90364.1 putative ribosomal protein L32 [Sipunculus nudus] | diamond | 1224 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 28864671 | 28864671 | PRJEB14664_P_NODE_3148_length_508_cov_1.957717_g3026_i0 | PRJEB14664 | 3148 | 508 | 1.957717 | 9.94520236 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 82 | 3.74e-15 | NR | KAK2146671.1 | 53620 | g3026 | i0 | 33.6 | 0.738188976377953 | 125 | 76 | 71.5 | 3 | 373 | 11 | 14 | 135 | KAK2146671.1 hypothetical protein LSH36_590g02061 [Paralvinella palmiformis] | diamond | 375 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31006131 | 31006131 | PRJEB14664_P_NODE_12294_length_209_cov_1.879310_g12164_i0 | PRJEB14664 | 12294 | 209 | 1.87931 | 3.9277579 | Metazoa | 33208 | Annelida | Annelida | 61.2 | 7.03e-9 | NR | CAH1772589.1 | 6347 | g12164 | i0 | 76.7 | 3.05741626794258 | 30 | 7 | 43.1 | 0 | 3 | 92 | 454 | 483 | CAH1772589.1 unnamed protein product [Owenia fusiformis] | diamond | 639 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31739625 | 31739625 | PRJEB14664_P_NODE_16377_length_172_cov_1.751825_g16247_i0 | PRJEB14664 | 16377 | 172 | 1.751825 | 3.013139 | Ridgeia piscesae | 27915 | Annelida | Annelida | 74.7 | 7.7e-14 | NR | KAK2187199.1 | 27915 | g16247 | i0 | 71.4 | 2.54651162790698 | 49 | 14 | 85.5 | 0 | 157 | 11 | 1 | 49 | KAK2187199.1 hypothetical protein NP493_175g01017 [Ridgeia piscesae] | diamond | 438 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32530977 | 32530977 | PRJEB14664_P_NODE_19799_length_152_cov_2.051282_g19669_i0 | PRJEB14664 | 19799 | 152 | 2.051282 | 3.11794864 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 47.4 | 2.5e-4 | NR | CAD5126039.1 | 2664684 | g19669 | i0 | 51 | 0.967105263157895 | 49 | 24 | 96.7 | 0 | 4 | 150 | 768 | 816 | CAD5126039.1 unnamed protein product [Dimorphilus gyrociliatus] | diamond | 147 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus |
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);;