contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA557436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26794069 | 26794069 | PRJNA557436_S_NODE_421_length_537_cov_2.386454_g379_i0 | PRJNA557436 | 421 | 537 | 2.386454 | 12.81525798 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 141 | 1.4099999999999999e-40 | NR | MFH4985130.1 | 75299 | g379 | i0 | 91 | 0.374301675977654 | 67 | 6 | 37.4 | 0 | 253 | 53 | 1 | 67 | MFH4985130.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 201 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 27236830 | 27236830 | PRJNA557436_S_NODE_5143_length_182_cov_3.904762_g5095_i0 | PRJNA557436 | 5143 | 182 | 3.904762 | 7.10666684 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 115 | 1.78e-29 | NR | KAH2778379.1 | 746128 | g5095 | i0 | 100 | 0.989010989010989 | 60 | 0 | 98.9 | 0 | 181 | 2 | 217 | 276 | KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus] | diamond | 180 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 27868397 | 27868397 | PRJNA557436_S_NODE_8645_length_154_cov_1.478992_g8597_i0 | PRJNA557436 | 8645 | 154 | 1.478992 | 2.27764768 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 100 | 5.29e-25 | NR | KAH2841833.1 | 746128 | g8597 | i0 | 100 | 0.993506493506494 | 51 | 0 | 99.4 | 0 | 1 | 153 | 62 | 112 | KAH2841833.1 hypothetical protein KXW36_000816, partial [Aspergillus fumigatus] | diamond | 153 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 27963220 | 27963220 | PRJNA557436_S_NODE_3165_length_218_cov_2.967213_g3117_i0 | PRJNA557436 | 3165 | 218 | 2.967213 | 6.46852434 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 77.4 | 8.03e-15 | NR | KAH2778379.1 | 746128 | g3117 | i0 | 94.7 | 0.522935779816514 | 38 | 2 | 52.3 | 0 | 104 | 217 | 75 | 112 | KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus] | diamond | 114 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 28089451 | 28089451 | PRJNA557436_S_NODE_4125_length_197_cov_2.530864_g4077_i0 | PRJNA557436 | 4125 | 197 | 2.530864 | 4.98580208 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 54.3 | 1.68e-6 | NR | CAI9150999.1 | 3082113 | g4077 | i0 | 96.6 | 0.441624365482233 | 29 | 1 | 44.2 | 0 | 1 | 87 | 501 | 529 | CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus] | diamond | 87 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 28089463 | 28089463 | PRJNA557436_S_NODE_825_length_392_cov_2.806723_g777_i0 | PRJNA557436 | 825 | 392 | 2.806723 | 11.00235416 | Apiospora phragmitis | 2905665 | Fungi | Fungi | 60.8 | 6.84e-8 | NR | XP_066709719.1 | 2905665 | g777 | i0 | 37.6 | 0.650510204081633 | 85 | 40 | 55.1 | 1 | 387 | 172 | 147 | 231 | XP_066709719.1 uncharacterized protein PG994_013349 [Apiospora phragmitis] | diamond | 255 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora phragmitis | |
| 29226452 | 29226452 | PRJNA557436_S_NODE_4729_length_187_cov_2.440789_g4681_i0 | PRJNA557436 | 4729 | 187 | 2.440789 | 4.56427543 | Pararge aegeria aegeria | 348720 | Arthropoda | Arthropoda | 40.8 | 0.0333 | NR | CAH2246697.1 | 348720 | g4681 | i0 | 32.3 | 0.994652406417112 | 62 | 39 | 94.7 | 1 | 10 | 186 | 38 | 99 | CAH2246697.1 jg3536 [Pararge aegeria aegeria] | diamond | 186 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Nymphalidae | Pararge | Pararge aegeria | |
| 29352602 | 29352602 | PRJNA557436_S_NODE_3709_length_205_cov_2.517647_g3661_i0 | PRJNA557436 | 3709 | 205 | 2.517647 | 5.16117635 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 42 | 0.0441 | NR | PJF18462.1 | 1246581 | g3661 | i0 | 38.9 | 0.790243902439024 | 54 | 31 | 79 | 1 | 178 | 17 | 967 | 1018 | PJF18462.1 Wd-repeat-containing protein [Paramicrosporidium saccamoebae] | diamond | 162 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29952460 | 29952460 | PRJNA557436_S_NODE_1951_length_268_cov_1.733906_g1903_i0 | PRJNA557436 | 1951 | 268 | 1.733906 | 4.64686808 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 127 | 4.6099999999999995e-35 | NR | KAH2821898.1 | 746128 | g1903 | i0 | 97 | 0.75 | 67 | 2 | 75 | 0 | 201 | 1 | 20 | 86 | KAH2821898.1 hypothetical protein KXV85_002502, partial [Aspergillus fumigatus] | diamond | 201 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 29952462 | 29952462 | PRJNA557436_S_NODE_2391_length_245_cov_2.595238_g2343_i0 | PRJNA557436 | 2391 | 245 | 2.595238 | 6.3583331 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 164 | 3.22e-48 | NR | KAH2778379.1 | 746128 | g2343 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 3 | 245 | 111 | 191 | KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus] | diamond | 243 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 30489612 | 30489612 | PRJNA557436_S_NODE_6733_length_166_cov_2.175573_g6685_i0 | PRJNA557436 | 6733 | 166 | 2.175573 | 3.61145118 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 82.4 | 1.95e-18 | NR | KAH2843171.1 | 746128 | g6685 | i0 | 94.9 | 0.704819277108434 | 39 | 2 | 70.5 | 0 | 50 | 166 | 76 | 114 | KAH2843171.1 hypothetical protein KXW36_000308, partial [Aspergillus fumigatus] | diamond | 117 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 31135252 | 31135252 | PRJNA557436_S_NODE_6375_length_169_cov_2.074627_g6327_i0 | PRJNA557436 | 6375 | 169 | 2.074627 | 3.50611963 | root | 1 | Root_unresolved | Root_unresolved | 70.5 | 2.19e-12 | NR | KOC58562.1 | 597456 | g6327 | i0 | 61.1 | 5.48520710059172 | 54 | 21 | 95.9 | 0 | 3 | 164 | 915 | 968 | KOC58562.1 Uncharacterized protein yejH [Habropoda laboriosa] | diamond | 927 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Habropoda | Habropoda laboriosa | |
| 31451952 | 31451952 | PRJNA557436_S_NODE_7596_length_160_cov_1.600000_g7548_i0 | PRJNA557436 | 7596 | 160 | 1.6 | 2.56 | Saccharomyces | 4930 | Fungi | Fungi | 111 | 7.78e-27 | NR | ONH78992.1 | 4932 | g7548 | i0 | 98.1 | 2.925 | 52 | 1 | 97.5 | 0 | 2 | 157 | 413 | 464 | ONH78992.1 Alanine--glyoxylate aminotransferase 1 [Saccharomyces cerevisiae] | diamond | 468 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 32527709 | 32527709 | PRJNA557436_S_NODE_3519_length_209_cov_5.051724_g3471_i0 | PRJNA557436 | 3519 | 209 | 5.051724 | 10.55810316 | Artiodactyla | 91561 | Chordata | Chordata | 47.4 | 5.67e-4 | NR | XP_069396403.1 | 9728 | g3471 | i0 | 70.3 | 2.32535885167464 | 37 | 10 | 53.1 | 1 | 140 | 30 | 115 | 150 | XP_069396403.1 collagen alpha-1(I) chain-like, partial [Delphinus delphis] | diamond | 486 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Delphinus | Delphinus delphis | |
| 32796707 | 32796707 | PRJNA557436_S_NODE_3780_length_204_cov_1.343195_g3732_i0 | PRJNA557436 | 3780 | 204 | 1.343195 | 2.7401178 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 120 | 2.18e-32 | NR | KAH2823818.1 | 746128 | g3732 | i0 | 100 | 0.985294117647059 | 67 | 0 | 98.5 | 0 | 202 | 2 | 57 | 123 | KAH2823818.1 hypothetical protein KXV85_001434, partial [Aspergillus fumigatus] | diamond | 201 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus |
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);;