contig_metadata
12 rows where bioproject = "PRJNA408129", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5522331 | 5522331 | PRJNA408129_S_NODE_5165_length_265_cov_2.210526_g5147_i0 | PRJNA408129 | 5165 | 265 | 2.210526 | 5.8578939 | Helobdella robusta | 6412 | Annelida | Annelida | 60.2 | 1.45e-4 | NTclustered | gi|675865245|ref|XM_009019935.1| | 6412 | g5147 | i0 | 100 | 0.120754716981132 | 32 | 0 | 12 | 0 | 202 | 233 | 1090 | 1059 | Helobdella robusta hypothetical protein partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 11897407 | 11897407 | PRJNA408129_S_NODE_7730_length_238_cov_4.054726_g7712_i0 | PRJNA408129 | 7730 | 238 | 4.054726 | 9.65024788 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.021 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g7712 | i0 | 100 | 0.117647058823529 | 28 | 0 | 12 | 0 | 163 | 190 | 10195107 | 10195080 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13172149 | 13172149 | PRJNA408129_S_NODE_24051_length_169_cov_2.151515_g24033_i0 | PRJNA408129 | 24051 | 169 | 2.151515 | 3.63606035 | Siboglinum plumosum | 3080496 | Annelida | Annelida | 63.9 | 6.52e-6 | NTclustered | gi|2627901219|ref|NC_084115.1| | 3080496 | g24033 | i0 | 100 | 8.21301775147929 | 34 | 0 | 20 | 0 | 134 | 167 | 5628 | 5661 | Siboglinum plumosum mitochondrion, complete genome | blastn | 1388 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Siboglinum | Siboglinum plumosum | |
| 18270044 | 18270044 | PRJNA408129_S_NODE_24515_length_168_cov_2.259542_g24497_i0 | PRJNA408129 | 24515 | 168 | 2.259542 | 3.79603056 | Metazoa | 33208 | Annelida | Annelida | 99 | 1.65e-24 | NR | CAH1794136.1 | 6347 | g24497 | i0 | 95.9 | 132.125 | 49 | 2 | 87.5 | 0 | 20 | 166 | 85 | 133 | CAH1794136.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 22197 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26726970 | 26726970 | PRJNA408129_S_NODE_9441_length_225_cov_3.377660_g9423_i0 | PRJNA408129 | 9441 | 225 | 3.37766 | 7.599735 | Helobdella robusta | 6412 | Annelida | Annelida | 46.6 | 0.00125 | NR | XP_009010422.1 | 6412 | g9423 | i0 | 61.8 | 1.94666666666667 | 34 | 13 | 45.3 | 0 | 92 | 193 | 72 | 105 | XP_009010422.1 hypothetical protein HELRODRAFT_167028 [Helobdella robusta] | diamond | 438 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 26885901 | 26885901 | PRJNA408129_S_NODE_13261_length_203_cov_3.909639_g13243_i0 | PRJNA408129 | 13261 | 203 | 3.909639 | 7.93656717 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 89.7 | 6.18e-19 | NR | KAI0224060.1 | 104711 | g13243 | i0 | 65.6 | 2.83743842364532 | 64 | 22 | 94.6 | 0 | 10 | 201 | 627 | 690 | KAI0224060.1 hypothetical protein LSAT2_024917 [Lamellibrachia satsuma] | diamond | 576 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 29349264 | 29349264 | PRJNA408129_S_NODE_1289_length_365_cov_6.591463_g1271_i0 | PRJNA408129 | 1289 | 365 | 6.591463 | 24.05883995 | Ridgeia piscesae | 27915 | Annelida | Annelida | 157 | 1.13e-42 | NR | KAK2148258.1 | 27915 | g1271 | i0 | 63.6 | 15.9123287671233 | 121 | 44 | 99.5 | 0 | 363 | 1 | 383 | 503 | KAK2148258.1 hypothetical protein NP493_3255g00004 [Ridgeia piscesae] | diamond | 5808 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29696122 | 29696122 | PRJNA408129_S_NODE_9910_length_222_cov_3.691892_g9892_i0 | PRJNA408129 | 9910 | 222 | 3.691892 | 8.19600024 | Helobdella robusta | 6412 | Annelida | Annelida | 77.8 | 1.04e-14 | NR | XP_009011980.1 | 6412 | g9892 | i0 | 71.4 | 0.662162162162162 | 49 | 14 | 66.2 | 0 | 189 | 43 | 196 | 244 | XP_009011980.1 hypothetical protein HELRODRAFT_168035 [Helobdella robusta] | diamond | 147 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30123606 | 30123606 | PRJNA408129_S_NODE_16032_length_191_cov_4.779221_g16014_i0 | PRJNA408129 | 16032 | 191 | 4.779221 | 9.12831211 | Metazoa | 33208 | Annelida | Annelida | 71.2 | 1.58e-12 | NR | KAK2152523.1 | 53620 | g16014 | i0 | 71.4 | 11.8743455497382 | 63 | 18 | 99 | 0 | 190 | 2 | 10 | 72 | KAK2152523.1 hypothetical protein LSH36_326g04091 [Paralvinella palmiformis] | diamond | 2268 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30580836 | 30580836 | PRJNA408129_S_NODE_18013_length_184_cov_6.795918_g17995_i0 | PRJNA408129 | 18013 | 184 | 6.795918 | 12.50448912 | Helobdella robusta | 6412 | Annelida | Annelida | 54.3 | 1.33e-6 | NR | XP_009031819.1 | 6412 | g17995 | i0 | 42.1 | 1.85869565217391 | 57 | 33 | 92.9 | 0 | 174 | 4 | 44 | 100 | XP_009031819.1 hypothetical protein HELRODRAFT_182845 [Helobdella robusta] | diamond | 342 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31276162 | 31276162 | PRJNA408129_S_NODE_8575_length_231_cov_6.567010_g8557_i0 | PRJNA408129 | 8575 | 231 | 6.56701 | 15.1697931 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 119 | 2.94e-32 | NR | KAI0220942.1 | 104711 | g8557 | i0 | 75 | 2.98701298701299 | 76 | 19 | 98.7 | 0 | 4 | 231 | 42 | 117 | KAI0220942.1 hypothetical protein LSAT2_027608, partial [Lamellibrachia satsuma] | diamond | 690 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32604746 | 32604746 | PRJNA408129_S_NODE_12600_length_207_cov_2.152941_g12582_i0 | PRJNA408129 | 12600 | 207 | 2.152941 | 4.45658787 | Ridgeia piscesae | 27915 | Annelida | Annelida | 58.9 | 4.43e-8 | NR | KAK2147952.1 | 27915 | g12582 | i0 | 57.4 | 3.66666666666667 | 54 | 23 | 78.3 | 0 | 200 | 39 | 43 | 96 | KAK2147952.1 hypothetical protein NP493_3328g00004 [Ridgeia piscesae] | diamond | 759 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;