contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJEB12296" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26044916 | 26044916 | PRJEB12296_S_NODE_10485_length_171_cov_1.389706_g10453_i0 | PRJEB12296 | 10485 | 171 | 1.389706 | 2.37639726 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 70.5 | 2e-14 | NR | ORZ29652.1 | 765915 | g10453 | i0 | 67.4 | 0.807017543859649 | 46 | 15 | 80.7 | 0 | 169 | 32 | 21 | 66 | ORZ29652.1 ribosomal protein S28e, partial [Catenaria anguillulae PL171] | diamond | 138 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 26423140 | 26423140 | PRJEB12296_S_NODE_1727_length_309_cov_407.835766_g1695_i0 | PRJEB12296 | 1727 | 309 | 407.835766 | 1260.21251694 | Eukaryota | 2759 | Fungi | Fungi | 68.6 | 6.7e-13 | NR | ORY35885.1 | 71784 | g1695 | i0 | 66 | 0.970873786407767 | 50 | 17 | 48.5 | 0 | 281 | 132 | 17 | 66 | ORY35885.1 40S ribosomal protein S30 [Naematelia encephala] | diamond | 300 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 32908012 | 32908012 | PRJEB12296_S_NODE_10425_length_171_cov_4.036765_g10393_i0 | PRJEB12296 | 10425 | 171 | 4.036765 | 6.90286815 | Nephila pilipes | 299642 | Arthropoda | Arthropoda | 55.5 | 7.8e-8 | NR | GFT29937.1 | 299642 | g10393 | i0 | 81.8 | 2.52631578947368 | 33 | 6 | 57.9 | 0 | 5 | 103 | 101 | 133 | GFT29937.1 60S ribosomal protein L35a [Nephila pilipes] | diamond | 432 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Nephilidae | Nephila | Nephila pilipes | |
| 32925175 | 32925175 | PRJEB12296_S_NODE_5161_length_209_cov_4.258621_g5129_i0 | PRJEB12296 | 5161 | 209 | 4.258621 | 8.90051789 | Syncephalis fuscata | 1851187 | Fungi | Fungi | 44.3 | 0.00257 | NR | KAI9597338.1 | 1851187 | g5129 | i0 | 41.3 | 0.660287081339713 | 46 | 27 | 66 | 0 | 195 | 58 | 86 | 131 | KAI9597338.1 cofilin [Syncephalis fuscata] | diamond | 138 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis fuscata | |
| 32939436 | 32939436 | PRJEB12296_S_NODE_3393_length_244_cov_1.880383_g3361_i0 | PRJEB12296 | 3393 | 244 | 1.880383 | 4.58813452 | Xylaria | 37991 | Fungi | Fungi | 59.3 | 2.42e-8 | NR | KAI0547676.1 | 42375 | g3361 | i0 | 58.7 | 6.86065573770492 | 46 | 19 | 56.6 | 0 | 1 | 138 | 24 | 69 | KAI0547676.1 60s acidic ribosomal protein-domain-containing protein, partial [Xylaria curta] | diamond | 1674 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria curta | |
| 32976672 | 32976672 | PRJEB12296_S_NODE_5555_length_204_cov_3.023669_g5523_i0 | PRJEB12296 | 5555 | 204 | 3.023669 | 6.16828476 | Absidia glauca | 4829 | Fungi | Fungi | 44.3 | 0.00282 | NR | SAM04041.1 | 4829 | g5523 | i0 | 39.6 | 0.705882352941177 | 48 | 29 | 70.6 | 0 | 2 | 145 | 90 | 137 | SAM04041.1 hypothetical protein [Absidia glauca] | diamond | 144 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia glauca | |
| 32976705 | 32976705 | PRJEB12296_S_NODE_9723_length_174_cov_2.762590_g9691_i0 | PRJEB12296 | 9723 | 174 | 2.76259 | 4.8069066 | Dinochytrium kinnereticum | 1774096 | Fungi | Fungi | 62.4 | 3.18e-10 | NR | KAJ3220030.1 | 1774096 | g9691 | i0 | 62.2 | 1.53448275862069 | 45 | 17 | 77.6 | 0 | 13 | 147 | 118 | 162 | KAJ3220030.1 60S ribosomal protein L12 [Dinochytrium kinnereticum] | diamond | 267 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Dinochytrium | Dinochytrium kinnereticum | |
| 32990892 | 32990892 | PRJEB12296_S_NODE_3779_length_234_cov_7.422111_g3747_i0 | PRJEB12296 | 3779 | 234 | 7.422111 | 17.36773974 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 3.87e-4 | NR | Q4KTE2.1 | 55567 | g3747 | i0 | 45.8 | 1.24358974358974 | 48 | 26 | 61.5 | 0 | 6 | 149 | 190 | 237 | Q4KTE2.1 RecName: Full=Small ribosomal subunit protein uS2; AltName: Full=40S ribosomal protein SA [Suberites domuncula] | diamond | 291 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 33010652 | 33010652 | PRJEB12296_S_NODE_3180_length_250_cov_4.376744_g3148_i0 | PRJEB12296 | 3180 | 250 | 4.376744 | 10.94186 | Cercophora scortea | 314031 | Fungi | Fungi | 43.9 | 0.00572 | NR | KAK3335352.1 | 314031 | g3148 | i0 | 38.3 | 0.564 | 47 | 29 | 56.4 | 0 | 68 | 208 | 81 | 127 | KAK3335352.1 hypothetical protein B0T19DRAFT_5808 [Cercophora scortea] | diamond | 141 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Cercophora | Cercophora scortea | |
| 33010666 | 33010666 | PRJEB12296_S_NODE_4708_length_216_cov_2.386740_g4676_i0 | PRJEB12296 | 4708 | 216 | 2.38674 | 5.1553584 | Puccinia striiformis f. sp. tritici | 168172 | Fungi | Fungi | 40.4 | 0.0355 | NR | XP_047797933.1 | 168172 | g4676 | i0 | 82.1 | 0.777777777777778 | 28 | 5 | 38.9 | 0 | 12 | 95 | 54 | 81 | XP_047797933.1 hypothetical protein Pst134EA_028829 [Puccinia striiformis f. sp. tritici] | diamond | 168 | 40.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 33044703 | 33044703 | PRJEB12296_S_NODE_15021_length_158_cov_5.178862_g14989_i0 | PRJEB12296 | 15021 | 158 | 5.178862 | 8.18260196 | Coemansia brasiliensis | 2650707 | Fungi | Fungi | 43.1 | 0.00601 | NR | KAJ2848156.1 | 2650707 | g14989 | i0 | 61.1 | 2.73417721518987 | 36 | 14 | 68.4 | 0 | 51 | 158 | 60 | 95 | KAJ2848156.1 hypothetical protein IWW36_003466, partial [Coemansia brasiliensis] | diamond | 432 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia brasiliensis | |
| 33044764 | 33044764 | PRJEB12296_S_NODE_6525_length_194_cov_2.012579_g6493_i0 | PRJEB12296 | 6525 | 194 | 2.012579 | 3.90440326 | Idotea baltica | 82763 | Arthropoda | Arthropoda | 93.6 | 1.41e-21 | NR | MCL4112850.1 | 82763 | g6493 | i0 | 79.2 | 1.59278350515464 | 53 | 11 | 82 | 0 | 1 | 159 | 184 | 236 | MCL4112850.1 hypothetical protein [Idotea baltica] | diamond | 309 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Idoteidae | Idotea | Idotea baltica | |
| 33130095 | 33130095 | PRJEB12296_S_NODE_3655_length_237_cov_3.292079_g3623_i0 | PRJEB12296 | 3655 | 237 | 3.292079 | 7.80222723 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 60.8 | 1.96e-9 | NR | CAF0775232.1 | 104777 | g3623 | i0 | 53.7 | 0.683544303797468 | 54 | 25 | 68.4 | 0 | 237 | 76 | 90 | 143 | CAF0775232.1 unnamed protein product [Brachionus calyciflorus] | diamond | 162 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 33144214 | 33144214 | PRJEB12296_S_NODE_15127_length_158_cov_0.975610_g15095_i0 | PRJEB12296 | 15127 | 158 | 0.97561 | 1.5414638 | Opisthokonta | 33154 | Chordata | Chordata | 43.5 | 0.00258 | NR | XP_019639315.1 | 7741 | g15095 | i0 | 48.8 | 2.33544303797468 | 41 | 17 | 77.8 | 1 | 4 | 126 | 94 | 130 | XP_019639315.1 PREDICTED: profilin-1A-like [Branchiostoma belcheri] | diamond | 369 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri |
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);;