contig_metadata
8 rows where bioproject = "PRJNA792582", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6319380 | 6319380 | PRJNA792582_P_NODE_30605_length_311_cov_10.571429_g29791_i0 | PRJNA792582 | 30605 | 311 | 10.571429 | 32.87714419 | Haemadipsidae | 27387 | Annelida | Annelida | 206 | 2.11e-48 | NTclustered | gi|316927165|gb|HQ203119.1| | 933824 | g29791 | i0 | 79.618 | 101.24115755627 | 314 | 43 | 100 | 12 | 1 | 311 | 1351 | 1056 | Domanibdella palmyrae isolate APY 28S ribosomal RNA gene, partial sequence | blastn | 31486 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Haemadipsidae | Domanibdella | Domanibdella palmyrae | |
| 9705084 | 9705084 | PRJNA792582_P_NODE_15008_length_444_cov_1.905660_g14195_i0 | PRJNA792582 | 15008 | 444 | 1.90566 | 8.4611304 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 91.6 | 9.1e-14 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g14195 | i0 | 77.778 | 7.73873873873874 | 162 | 26 | 35 | 10 | 138 | 294 | 11170887 | 11170731 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 3436 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16079516 | 16079516 | PRJNA792582_P_NODE_42233_length_272_cov_1.226131_g41419_i0 | PRJNA792582 | 42233 | 272 | 1.226131 | 3.33507632 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.15e-5 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g41419 | i0 | 97.297 | 2.47058823529412 | 37 | 1 | 14 | 0 | 20 | 56 | 329341 | 329377 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 672 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26864231 | 26864231 | PRJNA792582_P_NODE_44601_length_265_cov_1.828125_g43787_i0 | PRJNA792582 | 44601 | 265 | 1.828125 | 4.84453125 | Owenia fusiformis | 6347 | Annelida | Annelida | 103 | 1.94e-23 | NR | CAH1772664.1 | 6347 | g43787 | i0 | 57 | 0.973584905660377 | 86 | 36 | 96.2 | 1 | 3 | 257 | 656 | 741 | CAH1772664.1 unnamed protein product [Owenia fusiformis] | diamond | 258 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26936321 | 26936321 | PRJNA792582_P_NODE_14942_length_445_cov_1.252688_g14129_i0 | PRJNA792582 | 14942 | 445 | 1.252688 | 5.5744616 | Metazoa | 33208 | Annelida | Annelida | 59.3 | 5.38e-7 | NR | KAK2140645.1 | 53620 | g14129 | i0 | 51 | 0.923595505617978 | 49 | 23 | 32.4 | 1 | 9 | 152 | 492 | 540 | KAK2140645.1 hypothetical protein LSH36_1285g00055 [Paralvinella palmiformis] | diamond | 411 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27094539 | 27094539 | PRJNA792582_P_NODE_17542_length_411_cov_5.162722_g16728_i0 | PRJNA792582 | 17542 | 411 | 5.162722 | 21.21878742 | Metazoa | 33208 | Annelida | Annelida | 193 | 1.18e-54 | NR | CAH1774938.1 | 6347 | g16728 | i0 | 69.6 | 142.85401459854 | 135 | 41 | 98.5 | 0 | 406 | 2 | 388 | 522 | CAH1774938.1 unnamed protein product [Owenia fusiformis] | diamond | 58713 | 194 | 0.994845360824742 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28285275 | 28285275 | PRJNA792582_P_NODE_55386_length_245_cov_1.174419_g54572_i0 | PRJNA792582 | 55386 | 245 | 1.174419 | 2.87732655 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 43.1 | 0.0267 | NR | KAK2156904.1 | 53620 | g54572 | i0 | 32.9 | 0.893877551020408 | 73 | 48 | 89.4 | 1 | 17 | 235 | 253 | 324 | KAK2156904.1 hypothetical protein LSH36_202g04001 [Paralvinella palmiformis] | diamond | 219 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32686541 | 32686541 | PRJNA792582_P_NODE_52500_length_248_cov_1.320000_g51686_i0 | PRJNA792582 | 52500 | 248 | 1.32 | 3.2736 | Metazoa | 33208 | Annelida | Annelida | 149 | 1.9e-40 | NR | CAH1782481.1 | 6347 | g51686 | i0 | 85.4 | 42.6290322580645 | 82 | 12 | 99.2 | 0 | 2 | 247 | 79 | 160 | CAH1782481.1 unnamed protein product [Owenia fusiformis] | diamond | 10572 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;