contig_metadata
12 rows where bioproject = "PRJEB43370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5162484 | 5162484 | PRJEB43370_P_NODE_1365_length_372_cov_1.606811_g1322_i0 | PRJEB43370 | 1365 | 372 | 1.606811 | 5.97733692 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 127 | 1.87e-32 | NR | ELT95474.1 | 283909 | g1322 | i0 | 52.5 | 1.64516129032258 | 101 | 45 | 79 | 1 | 309 | 16 | 106 | 206 | ELT95474.1 hypothetical protein CAPTEDRAFT_151610 [Capitella teleta] | diamond | 612 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 6438325 | 6438325 | PRJEB43370_P_NODE_1906_length_315_cov_1.488722_g1863_i0 | PRJEB43370 | 1906 | 315 | 1.488722 | 4.6894743 | Owenia fusiformis | 6347 | Annelida | Annelida | 118 | 3.4600000000000003e-29 | NR | CAH1773728.1 | 6347 | g1863 | i0 | 59.5 | 0.8 | 84 | 32 | 78.1 | 1 | 56 | 301 | 299 | 382 | CAH1773728.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 252 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26837076 | 26837076 | PRJEB43370_P_NODE_5581_length_192_cov_2.013986_g5538_i0 | PRJEB43370 | 5581 | 192 | 2.013986 | 3.86685312 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.9 | 1.69e-21 | NR | XP_009025700.1 | 6412 | g5538 | i0 | 72.2 | 28.84375 | 54 | 15 | 84.4 | 0 | 30 | 191 | 10 | 63 | XP_009025700.1 hypothetical protein HELRODRAFT_163628 [Helobdella robusta] | diamond | 5538 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 26837078 | 26837078 | PRJEB43370_P_NODE_7881_length_168_cov_0.873950_g7838_i0 | PRJEB43370 | 7881 | 168 | 0.87395 | 1.468236 | Rotosphaerida | 2686024 | Annelida | Annelida | 83.6 | 5.35e-17 | NR | ELT93872.1 | 283909 | g7838 | i0 | 79.2 | 3.67857142857143 | 48 | 10 | 85.7 | 0 | 23 | 166 | 8 | 55 | ELT93872.1 hypothetical protein CAPTEDRAFT_161470 [Capitella teleta] | diamond | 618 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27191389 | 27191389 | PRJEB43370_P_NODE_8282_length_167_cov_1.322034_g8239_i0 | PRJEB43370 | 8282 | 167 | 1.322034 | 2.20779678 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 55.5 | 4.34e-7 | NR | KAK2154279.1 | 53620 | g8239 | i0 | 52.1 | 1.8502994011976 | 48 | 23 | 86.2 | 0 | 166 | 23 | 197 | 244 | KAK2154279.1 hypothetical protein LSH36_272g05058 [Paralvinella palmiformis] | diamond | 309 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28195235 | 28195235 | PRJEB43370_P_NODE_4126_length_219_cov_1.223529_g4083_i0 | PRJEB43370 | 4126 | 219 | 1.223529 | 2.67952851 | Metazoa | 33208 | Annelida | Annelida | 114 | 7.08e-30 | NR | ABB29596.1 | 6359 | g4083 | i0 | 76.4 | 97.6438356164384 | 72 | 17 | 98.6 | 0 | 3 | 218 | 33 | 104 | ABB29596.1 ribosomal protein 3 small subunit, partial [Platynereis dumerilii] | diamond | 21384 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 28707368 | 28707368 | PRJEB43370_P_NODE_3887_length_224_cov_2.365714_g3844_i0 | PRJEB43370 | 3887 | 224 | 2.365714 | 5.29919936 | Owenia fusiformis | 6347 | Annelida | Annelida | 76.3 | 4.65e-14 | NR | CAH1790116.1 | 6347 | g3844 | i0 | 49.3 | 4.94196428571429 | 73 | 37 | 97.8 | 0 | 221 | 3 | 7299 | 7371 | CAH1790116.1 unnamed protein product [Owenia fusiformis] | diamond | 1107 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30026932 | 30026932 | PRJEB43370_P_NODE_10711_length_162_cov_0.920354_g10668_i0 | PRJEB43370 | 10711 | 162 | 0.920354 | 1.49097348 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.5 | 1.19e-10 | NR | CAH1789408.1 | 6347 | g10668 | i0 | 54.9 | 20.2592592592593 | 51 | 23 | 94.4 | 0 | 159 | 7 | 350 | 400 | CAH1789408.1 unnamed protein product [Owenia fusiformis] | diamond | 3282 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30152929 | 30152929 | PRJEB43370_P_NODE_8252_length_167_cov_1.762712_g8209_i0 | PRJEB43370 | 8252 | 167 | 1.762712 | 2.94372904 | Metazoa | 33208 | Annelida | Annelida | 63.9 | 2.68e-10 | NR | KAK2159225.1 | 53620 | g8209 | i0 | 58.3 | 6.84431137724551 | 48 | 20 | 86.2 | 0 | 166 | 23 | 219 | 266 | KAK2159225.1 hypothetical protein LSH36_156g08009 [Paralvinella palmiformis] | diamond | 1143 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31170672 | 31170672 | PRJEB43370_P_NODE_8515_length_167_cov_0.881356_g8472_i0 | PRJEB43370 | 8515 | 167 | 0.881356 | 1.47186452 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 42.7 | 0.0136 | NR | KAK2146601.1 | 53620 | g8472 | i0 | 40 | 1.97604790419162 | 60 | 31 | 98.8 | 3 | 165 | 1 | 424 | 483 | KAK2146601.1 hypothetical protein LSH36_595g03027 [Paralvinella palmiformis] | diamond | 330 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32373125 | 32373125 | PRJEB43370_P_NODE_1679_length_339_cov_2.134483_g1636_i0 | PRJEB43370 | 1679 | 339 | 2.134483 | 7.23589737 | Owenia fusiformis | 6347 | Annelida | Annelida | 81.6 | 3.16e-17 | NR | CAH1781962.1 | 6347 | g1636 | i0 | 36.3 | 1 | 113 | 71 | 99.1 | 1 | 338 | 3 | 5 | 117 | CAH1781962.1 unnamed protein product [Owenia fusiformis] | diamond | 339 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32493009 | 32493009 | PRJEB43370_P_NODE_7279_length_170_cov_1.289256_g7236_i0 | PRJEB43370 | 7279 | 170 | 1.289256 | 2.1917352 | Opisthokonta | 33154 | Annelida | Annelida | 51.2 | 5.27e-6 | NR | CAH1795453.1 | 6347 | g7236 | i0 | 41.5 | 10.5352941176471 | 53 | 31 | 93.5 | 0 | 165 | 7 | 99 | 151 | CAH1795453.1 unnamed protein product [Owenia fusiformis] | diamond | 1791 | 51.2 | 1 | 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);;