contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA806354" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27410956 | 27410956 | PRJNA806354_P_NODE_35503_length_250_cov_5.621469_g35394_i0 | PRJNA806354 | 35503 | 250 | 5.621469 | 14.0536725 | Rodentia | 9989 | Chordata | Chordata | 53.9 | 4.62e-6 | NR | XP_032744025.1 | 10117 | g35394 | i0 | 81.8 | 0.792 | 33 | 6 | 39.6 | 0 | 244 | 146 | 65 | 97 | XP_032744025.1 cAMP-dependent protein kinase catalytic subunit alpha [Rattus rattus] | diamond | 198 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus rattus | |
| 28285696 | 28285696 | PRJNA806354_P_NODE_40146_length_243_cov_0.905882_g40037_i0 | PRJNA806354 | 40146 | 243 | 0.905882 | 2.20129326 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 57 | 1.52e-7 | NR | XP_065581157.1 | 6661 | g40037 | i0 | 90.3 | 0.382716049382716 | 31 | 2 | 38.3 | 1 | 241 | 149 | 122 | 151 | XP_065581157.1 shematrin-like protein 1 [Artemia franciscana] | diamond | 93 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 28736832 | 28736832 | PRJNA806354_P_NODE_37727_length_247_cov_0.885057_g37618_i0 | PRJNA806354 | 37727 | 247 | 0.885057 | 2.18609079 | Lasiosphaeria | 92901 | Fungi | Fungi | 92.8 | 9.07e-20 | NR | KAK3358447.1 | 92902 | g37618 | i0 | 52.4 | 3.97165991902834 | 82 | 37 | 97.2 | 1 | 7 | 246 | 347 | 428 | KAK3358447.1 quinon protein alcohol dehydrogenase-like superfamily [Lasiosphaeria ovina] | diamond | 981 | 93.2 | 0.995708154506438 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Lasiosphaeria | Lasiosphaeria ovina | |
| 29138647 | 29138647 | PRJNA806354_P_NODE_37629_length_247_cov_0.885057_g37520_i0 | PRJNA806354 | 37629 | 247 | 0.885057 | 2.18609079 | Mustela nigripes | 77151 | Chordata | Chordata | 51.6 | 2.75e-5 | NR | XP_059227156.1 | 77151 | g37520 | i0 | 96.2 | 0.753036437246964 | 26 | 1 | 31.6 | 0 | 128 | 51 | 91 | 116 | XP_059227156.1 uncharacterized protein LOC131998696 [Mustela nigripes] | diamond | 186 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Mustela | Mustela nigripes | |
| 30307427 | 30307427 | PRJNA806354_P_NODE_38692_length_245_cov_0.895349_g38583_i0 | PRJNA806354 | 38692 | 245 | 0.895349 | 2.19360505 | Malaya genurostris | 325434 | Arthropoda | Arthropoda | 48.5 | 3.59e-4 | NR | XP_058449439.1 | 325434 | g38583 | i0 | 32.5 | 0.942857142857143 | 77 | 51 | 94.3 | 1 | 234 | 4 | 316 | 391 | XP_058449439.1 uncharacterized protein LOC131429378 [Malaya genurostris] | diamond | 231 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Malaya | Malaya genurostris | |
| 30496656 | 30496656 | PRJNA806354_P_NODE_13193_length_390_cov_2.703470_g13084_i0 | PRJNA806354 | 13193 | 390 | 2.70347 | 10.543533 | Staurois parvus | 386267 | Chordata | Chordata | 53.1 | 5.16e-6 | NR | CAI9557087.1 | 386267 | g13084 | i0 | 65.7 | 0.538461538461538 | 35 | 10 | 25.4 | 1 | 258 | 356 | 24 | 58 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 210 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30654356 | 30654356 | PRJNA806354_P_NODE_35193_length_251_cov_1.483146_g35084_i0 | PRJNA806354 | 35193 | 251 | 1.483146 | 3.72269646 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 115 | 4.32e-31 | NR | KAK2721100.1 | 6661 | g35084 | i0 | 73.8 | 0.956175298804781 | 80 | 21 | 95.6 | 0 | 3 | 242 | 31 | 110 | KAK2721100.1 hypothetical protein QYM36_003394 [Artemia franciscana] | diamond | 240 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 31002123 | 31002123 | PRJNA806354_P_NODE_36334_length_249_cov_0.875000_g36225_i0 | PRJNA806354 | 36334 | 249 | 0.875 | 2.17875 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 42.7 | 0.042 | NR | PFX33712.1 | 50429 | g36225 | i0 | 38.1 | 0.506024096385542 | 42 | 26 | 50.6 | 0 | 249 | 124 | 1052 | 1093 | PFX33712.1 DNA helicase B [Stylophora pistillata] | diamond | 126 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31254801 | 31254801 | PRJNA806354_P_NODE_42995_length_202_cov_5.395349_g42886_i0 | PRJNA806354 | 42995 | 202 | 5.395349 | 10.89860498 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 96.7 | 2.28e-21 | NR | XP_065571297.1 | 6661 | g42886 | i0 | 79.1 | 1.99009900990099 | 67 | 14 | 99.5 | 0 | 201 | 1 | 740 | 806 | XP_065571297.1 GATA zinc finger domain-containing protein 14-like [Artemia franciscana] | diamond | 402 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 31602896 | 31602896 | PRJNA806354_P_NODE_19656_length_327_cov_1.807087_g19547_i0 | PRJNA806354 | 19656 | 327 | 1.807087 | 5.90917449 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 198 | 6.16e-61 | NR | KAK2712081.1 | 6661 | g19547 | i0 | 86.9 | 0.981651376146789 | 107 | 14 | 98.2 | 0 | 326 | 6 | 139 | 245 | KAK2712081.1 hypothetical protein QYM36_010939 [Artemia franciscana] | diamond | 321 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 31602897 | 31602897 | PRJNA806354_P_NODE_33116_length_258_cov_2.378378_g33007_i0 | PRJNA806354 | 33116 | 258 | 2.378378 | 6.13621524 | Pleurostoma richardsiae | 41990 | Fungi | Fungi | 75.5 | 1.18e-13 | NR | KAJ9156173.1 | 41990 | g33007 | i0 | 49.4 | 0.988372093023256 | 85 | 42 | 98.8 | 1 | 1 | 255 | 257 | 340 | KAJ9156173.1 GPI-anchored cell wall organization protein ecm33 [Pleurostoma richardsiae] | diamond | 255 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Calosphaeriales | Pleurostomataceae | Pleurostoma | Pleurostoma richardsiae | |
| 31729213 | 31729213 | PRJNA806354_P_NODE_28237_length_278_cov_1.970732_g28128_i0 | PRJNA806354 | 28237 | 278 | 1.970732 | 5.47863496 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 70.9 | 5.51e-12 | NR | KAK2726085.1 | 6661 | g28128 | i0 | 40.2 | 0.992805755395683 | 92 | 55 | 99.3 | 0 | 2 | 277 | 176 | 267 | KAK2726085.1 hypothetical protein QYM36_000516 [Artemia franciscana] | diamond | 276 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 32552182 | 32552182 | PRJNA806354_P_NODE_26619_length_286_cov_1.239437_g26510_i0 | PRJNA806354 | 26619 | 286 | 1.239437 | 3.54478982 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 125 | 5.2e-31 | NR | XP_065571297.1 | 6661 | g26510 | i0 | 76.6 | 1.97202797202797 | 94 | 21 | 98.6 | 1 | 284 | 3 | 592 | 684 | XP_065571297.1 GATA zinc finger domain-containing protein 14-like [Artemia franciscana] | diamond | 564 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 32614981 | 32614981 | PRJNA806354_P_NODE_33920_length_255_cov_2.318681_g33811_i0 | PRJNA806354 | 33920 | 255 | 2.318681 | 5.91263655 | Echinops telfairi | 9371 | Chordata | Chordata | 58.2 | 1.6e-7 | NR | XP_045151757.1 | 9371 | g33811 | i0 | 88.1 | 2.47058823529412 | 42 | 5 | 49.4 | 0 | 245 | 120 | 552 | 593 | XP_045151757.1 centrosome and spindle pole-associated protein 1 isoform X7 [Echinops telfairi] | diamond | 630 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Tenrecidae | Echinops | Echinops telfairi | ||
| 32803778 | 32803778 | PRJNA806354_P_NODE_42780_length_222_cov_4.523490_g42671_i0 | PRJNA806354 | 42780 | 222 | 4.52349 | 10.0421478 | Palaemon carinicauda | 392227 | Arthropoda | Arthropoda | 102 | 3.5399999999999995e-24 | NR | XP_068225707.1 | 392227 | g42671 | i0 | 74.1 | 0.783783783783784 | 58 | 15 | 78.4 | 0 | 2 | 175 | 261 | 318 | XP_068225707.1 aldo-keto reductase family 1 member B1-like isoform X1 [Palaemon carinicauda] | diamond | 174 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Palaemonidae | Palaemon | Palaemon carinicauda |
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);;