contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA806354" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3356968 | 3356968 | PRJNA806354_P_NODE_34023_length_255_cov_1.648352_g33914_i0 | PRJNA806354 | 34023 | 255 | 1.648352 | 4.2032976 | Karenia selliformis | 262428 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 7.37e-47 | NR | AEK64786.1 | 262428 | g33914 | i0 | 88.1 | 0.988235294117647 | 84 | 10 | 98.8 | 0 | 253 | 2 | 122 | 205 | AEK64786.1 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit, partial [Karenia selliformis] | diamond | 252 | 158 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Kareniaceae | Karenia | Karenia selliformis | |||
| 7600507 | 7600507 | PRJNA806354_P_NODE_40606_length_242_cov_0.911243_g40497_i0 | PRJNA806354 | 40606 | 242 | 0.911243 | 2.20520806 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 105 | 7.94e-28 | NR | EPY31723.1 | 28005 | g40497 | i0 | 80.7 | 1.41322314049587 | 57 | 11 | 70.7 | 0 | 31 | 201 | 1 | 57 | EPY31723.1 small subunit ribosomal protein S29e [Strigomonas culicis] | diamond | 342 | 106 | 0.990566037735849 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Strigomonas | Strigomonas culicis | ||
| 21208303 | 21208303 | PRJNA806354_P_NODE_31637_length_264_cov_2.209424_g31528_i0 | PRJNA806354 | 31637 | 264 | 2.209424 | 5.83287936 | Karenia mikimotoi | 225107 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 1.41e-53 | NR | AIG99628.1 | 225107 | g31528 | i0 | 88.5 | 1.97727272727273 | 87 | 10 | 98.9 | 0 | 3 | 263 | 1 | 87 | AIG99628.1 photosystem II protein D2, partial [Karenia mikimotoi] | diamond | 522 | 178 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Kareniaceae | Karenia | Karenia mikimotoi | |||
| 26800904 | 26800904 | PRJNA806354_P_NODE_40781_length_242_cov_0.911243_g40672_i0 | PRJNA806354 | 40781 | 242 | 0.911243 | 2.20520806 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 1.04e-10 | NR | OLP93353.1 | 2951 | g40672 | i0 | 79.4 | 1.68595041322314 | 34 | 7 | 42.1 | 0 | 242 | 141 | 516 | 549 | OLP93353.1 Eukaryotic translation initiation factor 3 subunit G [Symbiodinium microadriaticum] | diamond | 408 | 67 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 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 | |
| 27686352 | 27686352 | PRJNA806354_P_NODE_43024_length_199_cov_10.531746_g42915_i0 | PRJNA806354 | 43024 | 199 | 10.531746 | 20.95817454 | Bauhinia variegata | 167791 | Plants | Plants | 40 | 0.0357 | NR | KAI4297952.1 | 167791 | g42915 | i0 | 55 | 0.603015075376884 | 40 | 18 | 60.3 | 0 | 52 | 171 | 9 | 48 | KAI4297952.1 hypothetical protein L6164_037806 [Bauhinia variegata] | diamond | 120 | 40 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Bauhinia | Bauhinia variegata | |
| 27970114 | 27970114 | PRJNA806354_P_NODE_40185_length_243_cov_0.900000_g40076_i0 | PRJNA806354 | 40185 | 243 | 0.9 | 2.187 | Symbiodinium pilosum | 2952 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.33e-4 | NR | CAE7649784.1 | 2952 | g40076 | i0 | 45.3 | 0.654320987654321 | 53 | 29 | 65.4 | 0 | 1 | 159 | 158 | 210 | CAE7649784.1 unnamed protein product [Symbiodinium pilosum] | diamond | 159 | 49.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium pilosum | |||
| 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 | |
| 28862976 | 28862976 | PRJNA806354_P_NODE_38068_length_246_cov_0.890173_g37959_i0 | PRJNA806354 | 38068 | 246 | 0.890173 | 2.18982558 | Symbiodiniaceae | 252141 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 3.85e-18 | NR | CAE6912105.1 | 878477 | g37959 | i0 | 59.2 | 5.5609756097561 | 76 | 31 | 92.7 | 0 | 17 | 244 | 356 | 431 | CAE6912105.1 unnamed protein product [Symbiodinium natans] | diamond | 1368 | 88.6 | 0.99548532731377 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium natans | |||
| 28949185 | 28949185 | PRJNA806354_P_NODE_28588_length_277_cov_1.416667_g28479_i0 | PRJNA806354 | 28588 | 277 | 1.416667 | 3.92416759 | Symbiodinium natans | 878477 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 3.1e-14 | NR | CAE7247584.1 | 878477 | g28479 | i0 | 45.1 | 4.92779783393502 | 91 | 50 | 98.6 | 0 | 275 | 3 | 256 | 346 | CAE7247584.1 scn4ab [Symbiodinium natans] | diamond | 1365 | 77.4 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium natans | |||
| 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 | |
| 29368330 | 29368330 | PRJNA806354_P_NODE_36529_length_249_cov_0.875000_g36420_i0 | PRJNA806354 | 36529 | 249 | 0.875 | 2.17875 | Suessiales | 89954 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 9.49e-19 | NR | CAE8603987.1 | 89957 | g36420 | i0 | 54.4 | 1.78313253012048 | 79 | 28 | 91.6 | 2 | 17 | 244 | 25 | 98 | CAE8603987.1 unnamed protein product, partial [Polarella glacialis] | diamond | 444 | 89.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 30022742 | 30022742 | PRJNA806354_P_NODE_36991_length_248_cov_0.880000_g36882_i0 | PRJNA806354 | 36991 | 248 | 0.88 | 2.1824 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 4.2499999999999997e-38 | NR | CAE8653977.1 | 89957 | g36882 | i0 | 82.9 | 4.95967741935484 | 82 | 14 | 99.2 | 0 | 247 | 2 | 207 | 288 | CAE8653977.1 unnamed protein product, partial [Polarella glacialis] | diamond | 1230 | 140 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 30284614 | 30284614 | PRJNA806354_P_NODE_26212_length_288_cov_1.255814_g26103_i0 | PRJNA806354 | 26212 | 288 | 1.255814 | 3.61674432 | Bacillariophyta | 2836 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 7.15e-13 | NR | GFH50519.1 | 426638 | g26103 | i0 | 46.5 | 1.60416666666667 | 71 | 38 | 74 | 0 | 58 | 270 | 3 | 73 | GFH50519.1 hypothetical protein CTEN210_06995 [Chaetoceros tenuissimus] | diamond | 462 | 73.9 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 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 | |
| 30821337 | 30821337 | PRJNA806354_P_NODE_42954_length_206_cov_11.654135_g42845_i0 | PRJNA806354 | 42954 | 206 | 11.654135 | 24.0075181 | Fabaceae | 3803 | Plants | Plants | 45.4 | 4.31e-4 | NR | XLS74234.1 | 3818 | g42845 | i0 | 54.8 | 4.29611650485437 | 42 | 19 | 61.2 | 0 | 4 | 129 | 49 | 90 | XLS74234.1 hypothetical protein HN51_031099, partial [Arachis hypogaea] | diamond | 885 | 45.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis hypogaea | |
| 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);;