contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA893346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2143263 | 2143263 | PRJNA893346_P_NODE_14382_length_411_cov_1.310651_g13894_i0 | PRJNA893346 | 14382 | 411 | 1.310651 | 5.38677561 | Metazoa | 33208 | Annelida | Annelida | 168 | 8.7e-48 | NR | XP_009028927.1 | 6412 | g13894 | i0 | 65.6 | 7.56204379562044 | 128 | 43 | 93.4 | 1 | 388 | 5 | 1 | 127 | XP_009028927.1 hypothetical protein HELRODRAFT_95902 [Helobdella robusta] | diamond | 3108 | 169 | 0.994082840236686 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 3418915 | 3418915 | PRJNA893346_P_NODE_25583_length_300_cov_1.334802_g25093_i0 | PRJNA893346 | 25583 | 300 | 1.334802 | 4.004406 | Capitella teleta | 283909 | Annelida | Annelida | 170 | 2.25e-48 | NR | ELT92846.1 | 283909 | g25093 | i0 | 74.7 | 4.95 | 99 | 25 | 99 | 0 | 3 | 299 | 345 | 443 | ELT92846.1 hypothetical protein CAPTEDRAFT_224067 [Capitella teleta] | diamond | 1485 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 3419194 | 3419194 | PRJNA893346_P_NODE_38123_length_243_cov_1.729412_g37633_i0 | PRJNA893346 | 38123 | 243 | 1.729412 | 4.20247116 | Helobdella robusta | 6412 | Annelida | Annelida | 85.1 | 3.8e-17 | NR | XP_009009650.1 | 6412 | g37633 | i0 | 52.2 | 0.827160493827161 | 67 | 32 | 82.7 | 0 | 201 | 1 | 362 | 428 | XP_009009650.1 hypothetical protein HELRODRAFT_93565 [Helobdella robusta] | diamond | 201 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 16170858 | 16170858 | PRJNA893346_P_NODE_24973_length_304_cov_1.484848_g24483_i0 | PRJNA893346 | 24973 | 304 | 1.484848 | 4.51393792 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 159 | 1.94e-44 | NR | KAI0241993.1 | 104711 | g24483 | i0 | 74 | 47.2105263157895 | 100 | 26 | 98.7 | 0 | 2 | 301 | 311 | 410 | KAI0241993.1 Eukaryotic initiation factor 4A-II [Lamellibrachia satsuma] | diamond | 14352 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 22544871 | 22544871 | PRJNA893346_P_NODE_19918_length_345_cov_2.264706_g19429_i0 | PRJNA893346 | 19918 | 345 | 2.264706 | 7.8132357 | Opisthokonta | 33154 | Annelida | Annelida | 144 | 3.2e-42 | NR | ABW23184.1 | 6344 | g19429 | i0 | 69.5 | 18.3217391304348 | 105 | 32 | 91.3 | 0 | 321 | 7 | 1 | 105 | ABW23184.1 ribosomal protein rpl30 [Arenicola marina] | diamond | 6321 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 26992147 | 26992147 | PRJNA893346_P_NODE_30342_length_269_cov_1.571429_g29852_i0 | PRJNA893346 | 30342 | 269 | 1.571429 | 4.22714401 | Owenia fusiformis | 6347 | Annelida | Annelida | 56.2 | 9.44e-7 | NR | CAH1780542.1 | 6347 | g29852 | i0 | 39.3 | 0.936802973977695 | 84 | 48 | 92.6 | 3 | 8 | 256 | 468 | 549 | CAH1780542.1 unnamed protein product [Owenia fusiformis] | diamond | 252 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27719485 | 27719485 | PRJNA893346_P_NODE_34944_length_249_cov_0.875000_g34454_i0 | PRJNA893346 | 34944 | 249 | 0.875 | 2.17875 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 123 | 7.939999999999999e-32 | NR | KAI0230605.1 | 104711 | g34454 | i0 | 78.7 | 5.63855421686747 | 75 | 16 | 90.4 | 0 | 227 | 3 | 56 | 130 | KAI0230605.1 ADP,ATP carrier protein 3, mitochondrial [Lamellibrachia satsuma] | diamond | 1404 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 27821697 | 27821697 | PRJNA893346_P_NODE_27224_length_289_cov_1.069444_g26734_i0 | PRJNA893346 | 27224 | 289 | 1.069444 | 3.09069316 | Metazoa | 33208 | Annelida | Annelida | 130 | 2.06e-33 | NR | KAK2180270.1 | 27915 | g26734 | i0 | 62.1 | 4.93079584775086 | 95 | 36 | 98.6 | 0 | 3 | 287 | 378 | 472 | KAK2180270.1 hypothetical protein NP493_448g00003 [Ridgeia piscesae] | diamond | 1425 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28737187 | 28737187 | PRJNA893346_P_NODE_6707_length_621_cov_2.344891_g6237_i0 | PRJNA893346 | 6707 | 621 | 2.344891 | 14.56177311 | Metazoa | 33208 | Annelida | Annelida | 171 | 5.91e-50 | NR | ABW23140.1 | 6344 | g6237 | i0 | 48.9 | 8.76328502415459 | 180 | 89 | 85.5 | 2 | 10 | 540 | 9 | 188 | ABW23140.1 ribosomal protein rps7 [Arenicola marina] | diamond | 5442 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 29400185 | 29400185 | PRJNA893346_P_NODE_37969_length_244_cov_0.900585_g37479_i0 | PRJNA893346 | 37969 | 244 | 0.900585 | 2.1974274 | Opisthokonta | 33154 | Annelida | Annelida | 133 | 4.94e-38 | NR | XP_009025700.1 | 6412 | g37479 | i0 | 79 | 41.8155737704918 | 81 | 17 | 99.6 | 0 | 1 | 243 | 3 | 83 | XP_009025700.1 hypothetical protein HELRODRAFT_163628 [Helobdella robusta] | diamond | 10203 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30726840 | 30726840 | PRJNA893346_P_NODE_33214_length_251_cov_1.123596_g32724_i0 | PRJNA893346 | 33214 | 251 | 1.123596 | 2.82022596 | Metazoa | 33208 | Annelida | Annelida | 131 | 4.05e-36 | NR | KAK2182991.1 | 27915 | g32724 | i0 | 74.7 | 34.5776892430279 | 83 | 21 | 99.2 | 0 | 1 | 249 | 132 | 214 | KAK2182991.1 hypothetical protein NP493_328g01013 [Ridgeia piscesae] | diamond | 8679 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31161073 | 31161073 | PRJNA893346_P_NODE_17575_length_369_cov_1.621622_g17086_i0 | PRJNA893346 | 17575 | 369 | 1.621622 | 5.98378518 | Sipunculus nudus | 6446 | Annelida | Annelida | 72 | 6.99e-13 | NR | ABW90355.1 | 6446 | g17086 | i0 | 59.2 | 2.64227642276423 | 71 | 29 | 57.7 | 0 | 157 | 369 | 28 | 98 | ABW90355.1 putative ribosomal protein L23a [Sipunculus nudus] | diamond | 975 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 31351283 | 31351283 | PRJNA893346_P_NODE_31396_length_262_cov_1.629630_g30906_i0 | PRJNA893346 | 31396 | 262 | 1.62963 | 4.2696306 | Helobdella robusta | 6412 | Annelida | Annelida | 60.5 | 4.65e-9 | NR | XP_009022633.1 | 6412 | g30906 | i0 | 37.9 | 1.08778625954198 | 95 | 37 | 83.6 | 2 | 259 | 41 | 61 | 155 | XP_009022633.1 hypothetical protein HELRODRAFT_185020 [Helobdella robusta] | diamond | 285 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32458589 | 32458589 | PRJNA893346_P_NODE_37299_length_245_cov_0.895349_g36809_i0 | PRJNA893346 | 37299 | 245 | 0.895349 | 2.19360505 | Owenia fusiformis | 6347 | Annelida | Annelida | 100 | 2.97e-24 | NR | CAH1784699.1 | 6347 | g36809 | i0 | 59.5 | 3.88163265306122 | 79 | 31 | 95.5 | 1 | 10 | 243 | 1 | 79 | CAH1784699.1 unnamed protein product [Owenia fusiformis] | diamond | 951 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32616393 | 32616393 | PRJNA893346_P_NODE_12200_length_449_cov_0.808511_g11715_i0 | PRJNA893346 | 12200 | 449 | 0.808511 | 3.63021439 | Helobdella robusta | 6412 | Annelida | Annelida | 207 | 3.53e-59 | NR | XP_009021598.1 | 6412 | g11715 | i0 | 67.8 | 10.9109131403118 | 149 | 48 | 99.6 | 0 | 1 | 447 | 723 | 871 | XP_009021598.1 hypothetical protein HELRODRAFT_101151 [Helobdella robusta] | diamond | 4899 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;