contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA527965" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10700865 | 10700865 | PRJNA527965_S_NODE_3289_length_210_cov_2.788571_g3206_i0 | PRJNA527965 | 3289 | 210 | 2.788571 | 5.8559991 | Daphnia pulex | 6669 | Arthropoda | Arthropoda | 136 | 2.77e-37 | NR | EFX60189.1 | 6669 | g3206 | i0 | 100 | 0.985714285714286 | 69 | 0 | 98.6 | 0 | 209 | 3 | 124 | 192 | EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] | diamond | 207 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pulex | |
| 26856127 | 26856127 | PRJNA527965_S_NODE_6181_length_151_cov_1.620690_g6098_i0 | PRJNA527965 | 6181 | 151 | 1.62069 | 2.4472419 | Ogataea polymorpha | 460523 | Fungi | Fungi | 60.8 | 4.14e-9 | NR | KAG7902685.1 | 460523 | g6098 | i0 | 70.7 | 0.814569536423841 | 41 | 12 | 81.5 | 0 | 6 | 128 | 251 | 291 | KAG7902685.1 hypothetical protein KL935_001593 [Ogataea polymorpha] | diamond | 123 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | Ogataea polymorpha | |
| 27772587 | 27772587 | PRJNA527965_S_NODE_6144_length_151_cov_2.810345_g6061_i0 | PRJNA527965 | 6144 | 151 | 2.810345 | 4.24362095 | Aspergillus novofumigatus IBT 168 | 340412 | Fungi | Fungi | 50.4 | 2.58e-6 | NR | PKX88305.1 | 1392255 | g6061 | i0 | 64.9 | 2.94039735099338 | 37 | 13 | 73.5 | 0 | 6 | 116 | 5 | 41 | PKX88305.1 hypothetical protein P174DRAFT_75185 [Aspergillus novofumigatus IBT 16806] | diamond | 444 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus novofumigatus | |
| 27804073 | 27804073 | PRJNA527965_S_NODE_2624_length_237_cov_1.891089_g2541_i0 | PRJNA527965 | 2624 | 237 | 1.891089 | 4.48188093 | Trichonephila clavipes | 2585209 | Arthropoda | Arthropoda | 44.7 | 0.00272 | NR | GFX36245.1 | 2585209 | g2541 | i0 | 52.2 | 1.0379746835443 | 46 | 22 | 58.2 | 0 | 199 | 62 | 24 | 69 | GFX36245.1 uncharacterized protein TNCV_2065831 [Trichonephila clavipes] | diamond | 246 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Nephilidae | Trichonephila | Trichonephila clavipes | |
| 27882270 | 27882270 | PRJNA527965_S_NODE_2305_length_254_cov_4.077626_g2222_i0 | PRJNA527965 | 2305 | 254 | 4.077626 | 10.35717004 | Metazoa | 33208 | Mollusca | Mollusca | 55.1 | 3.6e-7 | NR | RUS68435.1 | 188477 | g2222 | i0 | 43.8 | 8.81102362204724 | 89 | 43 | 98 | 2 | 251 | 3 | 28 | 115 | RUS68435.1 hypothetical protein EGW08_023803 [Elysia chlorotica] | diamond | 2238 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 28056403 | 28056403 | PRJNA527965_S_NODE_4945_length_168_cov_2.428571_g4862_i0 | PRJNA527965 | 4945 | 168 | 2.428571 | 4.07999928 | Amoeboaphelidium protococcarum | 1243177 | Root_unresolved | Root_unresolved | 50.4 | 1.9e-5 | NR | KAI3643625.1 | 1243177 | g4862 | i0 | 62.9 | 1.25 | 35 | 13 | 62.5 | 0 | 48 | 152 | 41 | 75 | KAI3643625.1 hypothetical protein MP228_013180 [Amoeboaphelidium protococcarum] | diamond | 210 | 50.4 | 1 | Eukaryota | Opisthokonta | Aphelidea | Amoeboaphelidium | Amoeboaphelidium protococcarum | |||||
| 28309175 | 28309175 | PRJNA527965_S_NODE_1226_length_342_cov_3.824104_g1143_i0 | PRJNA527965 | 1226 | 342 | 3.824104 | 13.07843568 | Daphnia pulex | 6669 | Arthropoda | Arthropoda | 169 | 2.2e-49 | NR | EFX60189.1 | 6669 | g1143 | i0 | 94.5 | 0.798245614035088 | 91 | 5 | 79.8 | 0 | 275 | 3 | 207 | 297 | EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] | diamond | 273 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pulex | |
| 29225025 | 29225025 | PRJNA527965_S_NODE_2289_length_255_cov_2.836364_g2206_i0 | PRJNA527965 | 2289 | 255 | 2.836364 | 7.2327282 | Daphnia pulex | 6669 | Arthropoda | Arthropoda | 144 | 3.78e-40 | NR | EFX60189.1 | 6669 | g2206 | i0 | 94.9 | 0.917647058823529 | 78 | 4 | 91.8 | 0 | 3 | 236 | 136 | 213 | EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] | diamond | 234 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pulex | |
| 29666455 | 29666455 | PRJNA527965_S_NODE_4890_length_169_cov_1.865672_g4807_i0 | PRJNA527965 | 4890 | 169 | 1.865672 | 3.15298568 | Daphnia pulex | 6669 | Arthropoda | Arthropoda | 112 | 1.82e-28 | NR | EFX60189.1 | 6669 | g4807 | i0 | 100 | 0.994082840236686 | 56 | 0 | 99.4 | 0 | 169 | 2 | 259 | 314 | EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] | diamond | 168 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pulex | |
| 30045641 | 30045641 | PRJNA527965_S_NODE_4911_length_169_cov_1.350746_g4828_i0 | PRJNA527965 | 4911 | 169 | 1.350746 | 2.28276074 | Capitella teleta | 283909 | Annelida | Annelida | 39.3 | 0.0435 | NR | ELU05767.1 | 283909 | g4828 | i0 | 57.1 | 0.621301775147929 | 35 | 10 | 62.1 | 1 | 1 | 105 | 38 | 67 | ELU05767.1 hypothetical protein CAPTEDRAFT_142127, partial [Capitella teleta] | diamond | 105 | 39.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30299015 | 30299015 | PRJNA527965_S_NODE_4172_length_185_cov_3.400000_g4089_i0 | PRJNA527965 | 4172 | 185 | 3.4 | 6.29 | Zootermopsis nevadensis | 136037 | Arthropoda | Arthropoda | 54.7 | 1e-7 | NR | KDQ71533.1 | 136037 | g4089 | i0 | 69.7 | 1.60540540540541 | 33 | 10 | 53.5 | 0 | 86 | 184 | 56 | 88 | KDQ71533.1 hypothetical protein L798_10643, partial [Zootermopsis nevadensis] | diamond | 297 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Termopsidae | Zootermopsis | Zootermopsis nevadensis | |
| 31057200 | 31057200 | PRJNA527965_S_NODE_5615_length_158_cov_1.471545_g5532_i0 | PRJNA527965 | 5615 | 158 | 1.471545 | 2.3250411 | Nowakowskiella sp. JEL | 2012159 | Fungi | Fungi | 43.5 | 0.00266 | NR | KAJ1554024.1 | 2732417 | g5532 | i0 | 49.1 | 1.00632911392405 | 53 | 26 | 98.7 | 1 | 1 | 156 | 49 | 101 | KAJ1554024.1 hypothetical protein HK096_005307 [Nowakowskiella sp. JEL0078] | diamond | 159 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JEL0078 | |
| 31151240 | 31151240 | PRJNA527965_S_NODE_5335_length_162_cov_2.141732_g5252_i0 | PRJNA527965 | 5335 | 162 | 2.141732 | 3.46960584 | Cyclocybe aegerita | 1973307 | Fungi | Fungi | 41.2 | 0.0454 | NR | CAA7271615.1 | 1973307 | g5252 | i0 | 45.2 | 0.777777777777778 | 42 | 23 | 77.8 | 0 | 153 | 28 | 24 | 65 | CAA7271615.1 unnamed protein product [Cyclocybe aegerita] | diamond | 126 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Bolbitiaceae | Cyclocybe | Cyclocybe aegerita | |
| 32337532 | 32337532 | PRJNA527965_S_NODE_3439_length_205_cov_1.329412_g3356_i0 | PRJNA527965 | 3439 | 205 | 1.329412 | 2.7252946 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 75.5 | 6.32e-14 | NR | CAL4098822.1 | 48144 | g3356 | i0 | 44.3 | 2.04878048780488 | 70 | 37 | 99.5 | 1 | 204 | 1 | 376 | 445 | CAL4098822.1 unnamed protein product, partial [Meganyctiphanes norvegica] | diamond | 420 | 75.9 | 0.994729907773386 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Euphausiacea | Euphausiidae | Meganyctiphanes | Meganyctiphanes norvegica |
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);;