contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA807836" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7185617 | 7185617 | PRJNA807836_S_NODE_546_length_1833_cov_10.002841_g503_i0 | PRJNA807836 | 546 | 1833 | 10.002841 | 183.35207553 | Lambiella insularis | 1397036 | Fungi | Fungi | 447 | 2.36e-149 | NR | MCJ1475766.1 | 1397036 | g503 | i0 | 56.2 | 1.33387888707038 | 411 | 170 | 66 | 5 | 1668 | 460 | 14 | 422 | MCJ1475766.1 hypothetical protein [Lambiella insularis] | diamond | 2445 | 447 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Lambiella | Lambiella insularis | |
| 27623078 | 27623078 | PRJNA807836_S_NODE_8924_length_516_cov_1.950339_g8650_i0 | PRJNA807836 | 8924 | 516 | 1.950339 | 10.06374924 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 50.1 | 0.00112 | NR | EPZ35427.1 | 988480 | g8650 | i0 | 36.6 | 0.412790697674419 | 71 | 42 | 39.5 | 1 | 204 | 407 | 218 | 288 | EPZ35427.1 hypothetical protein O9G_003686 [Rozella allomycis CSF55] | diamond | 213 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27875377 | 27875377 | PRJNA807836_S_NODE_1745_length_1273_cov_4.110000_g1628_i0 | PRJNA807836 | 1745 | 1273 | 4.11 | 52.3203 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 88.2 | 8.78e-15 | NR | XP_071033602.1 | 114398 | g1628 | i0 | 31.1 | 0.431264728986646 | 183 | 113 | 42.9 | 4 | 53 | 598 | 253 | 423 | XP_071033602.1 DBIRD complex subunit ZNF326 isoform X2 [Parasteatoda tepidariorum] | diamond | 549 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum | |
| 28222605 | 28222605 | PRJNA807836_S_NODE_15686_length_353_cov_1.560714_g15410_i0 | PRJNA807836 | 15686 | 353 | 1.560714 | 5.50932042 | Puccinia striiformis | 27350 | Fungi | Fungi | 66.2 | 7.18e-10 | NR | POW19195.1 | 27350 | g15410 | i0 | 47.9 | 1.19830028328612 | 71 | 36 | 59.5 | 1 | 211 | 2 | 112 | 182 | POW19195.1 hypothetical protein PSHT_04931 [Puccinia striiformis] | diamond | 423 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 28443972 | 28443972 | PRJNA807836_S_NODE_26946_length_253_cov_1.333333_g26670_i0 | PRJNA807836 | 26946 | 253 | 1.333333 | 3.37333249 | Piloderma croceum F 1598 | 765440 | Fungi | Fungi | 44.3 | 0.0122 | NR | KIM73463.1 | 765440 | g26670 | i0 | 33.8 | 0.806324110671937 | 68 | 44 | 80.6 | 1 | 25 | 228 | 376 | 442 | KIM73463.1 hypothetical protein PILCRDRAFT_15204 [Piloderma croceum F 1598] | diamond | 204 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Atheliales | Atheliaceae | Piloderma | Piloderma croceum | |
| 28507009 | 28507009 | PRJNA807836_S_NODE_11967_length_420_cov_2.481268_g11691_i0 | PRJNA807836 | 11967 | 420 | 2.481268 | 10.4213256 | Polypterus senegalus | 55291 | Chordata | Chordata | 62 | 4.29e-8 | NR | KAG2469303.1 | 55291 | g11691 | i0 | 70.7 | 0.878571428571429 | 41 | 12 | 29.3 | 0 | 164 | 286 | 11 | 51 | KAG2469303.1 SRPK2 kinase, partial [Polypterus senegalus] | diamond | 369 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28601779 | 28601779 | PRJNA807836_S_NODE_20787_length_299_cov_0.929204_g20511_i0 | PRJNA807836 | 20787 | 299 | 0.929204 | 2.77831996 | Araneus ventricosus | 182803 | Arthropoda | Arthropoda | 44.7 | 0.0156 | NR | GBN22170.1 | 182803 | g20511 | i0 | 31.1 | 0.74247491638796 | 74 | 48 | 71.2 | 1 | 247 | 35 | 1087 | 1160 | GBN22170.1 putative RNA-directed DNA polymerase from transposon X-element, partial [Araneus ventricosus] | diamond | 222 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 28633477 | 28633477 | PRJNA807836_S_NODE_31187_length_241_cov_0.916667_g30911_i0 | PRJNA807836 | 31187 | 241 | 0.916667 | 2.20916747 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 63.2 | 2.35e-9 | NR | XP_064384047.1 | 6063 | g30911 | i0 | 51.8 | 2.09128630705394 | 56 | 27 | 69.7 | 0 | 68 | 235 | 690 | 745 | XP_064384047.1 uncharacterized protein LOC135333044 [Halichondria panicea] | diamond | 504 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28759489 | 28759489 | PRJNA807836_S_NODE_24087_length_273_cov_1.155000_g23811_i0 | PRJNA807836 | 24087 | 273 | 1.155 | 3.15315 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 60.8 | 2.25e-8 | NR | XP_064392399.1 | 6063 | g23811 | i0 | 36.7 | 3.72527472527473 | 90 | 55 | 98.9 | 1 | 4 | 273 | 217 | 304 | XP_064392399.1 uncharacterized protein LOC135340042 [Halichondria panicea] | diamond | 1017 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28917178 | 28917178 | PRJNA807836_S_NODE_28308_length_248_cov_0.880000_g28032_i0 | PRJNA807836 | 28308 | 248 | 0.88 | 2.1824 | Ophiocordyceps sinensis | 72228 | Fungi | Fungi | 71.2 | 3.46e-12 | NR | KAF4509781.1 | 72228 | g28032 | i0 | 88.9 | 0.435483870967742 | 36 | 4 | 43.5 | 0 | 141 | 34 | 1 | 36 | KAF4509781.1 hypothetical protein G6O67_003919 [Ophiocordyceps sinensis] | diamond | 108 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps sinensis | |
| 28949228 | 28949228 | PRJNA807836_S_NODE_28128_length_249_cov_0.869318_g27852_i0 | PRJNA807836 | 28128 | 249 | 0.869318 | 2.16460182 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 171 | 5.74e-50 | NR | XP_069229731.1 | 1052096 | g27852 | i0 | 95.1 | 0.987951807228916 | 82 | 4 | 98.8 | 0 | 3 | 248 | 60 | 141 | XP_069229731.1 uncharacterized protein WHR41_04503 [Cladosporium halotolerans] | diamond | 246 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29043882 | 29043882 | PRJNA807836_S_NODE_20768_length_299_cov_1.159292_g20492_i0 | PRJNA807836 | 20768 | 299 | 1.159292 | 3.46628308 | Ophiocordyceps sinensis | 72228 | Fungi | Fungi | 141 | 1.3899999999999999e-40 | NR | KAF4504440.1 | 72228 | g20492 | i0 | 96.1 | 0.762541806020067 | 76 | 3 | 76.3 | 0 | 230 | 3 | 1 | 76 | KAF4504440.1 hypothetical protein G6O67_007890 [Ophiocordyceps sinensis] | diamond | 228 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps sinensis | |
| 29264561 | 29264561 | PRJNA807836_S_NODE_3449_length_930_cov_4.801634_g3257_i0 | PRJNA807836 | 3449 | 930 | 4.801634 | 44.6551962 | Ptychographa xylographoides | 223409 | Fungi | Fungi | 285 | 3.6599999999999997e-90 | NR | MCJ1409372.1 | 223409 | g3257 | i0 | 53.2 | 6.12903225806452 | 278 | 117 | 85.8 | 7 | 3 | 800 | 138 | 414 | MCJ1409372.1 hypothetical protein [Ptychographa xylographoides] | diamond | 5700 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Ptychographa | Ptychographa xylographoides | |
| 29738080 | 29738080 | PRJNA807836_S_NODE_29590_length_245_cov_0.895349_g29314_i0 | PRJNA807836 | 29590 | 245 | 0.895349 | 2.19360505 | Ophiocordyceps sinensis | 72228 | Fungi | Fungi | 174 | 1.4e-50 | NR | KAF4509043.1 | 72228 | g29314 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 243 | 1 | 129 | 209 | KAF4509043.1 hypothetical protein G6O67_005353 [Ophiocordyceps sinensis] | diamond | 243 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps sinensis | |
| 29864637 | 29864637 | PRJNA807836_S_NODE_28651_length_247_cov_0.885057_g28375_i0 | PRJNA807836 | 28651 | 247 | 0.885057 | 2.18609079 | Cricetulus griseus | 10029 | Chordata | Chordata | 44.7 | 0.00808 | NR | ERE88163.1 | 10029 | g28375 | i0 | 35.6 | 0.716599190283401 | 59 | 21 | 68 | 2 | 200 | 33 | 823 | 867 | ERE88163.1 CDKN2A-interacting protein [Cricetulus griseus] | diamond | 177 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 30157605 | 30157605 | PRJNA807836_S_NODE_21492_length_293_cov_1.050000_g21216_i0 | PRJNA807836 | 21492 | 293 | 1.05 | 3.0765 | Russulales | 452342 | Fungi | Fungi | 48.9 | 4.21e-4 | NR | KAI0060165.1 | 48021 | g21216 | i0 | 46.7 | 9.48122866894198 | 75 | 30 | 66.6 | 2 | 40 | 234 | 126 | 200 | KAI0060165.1 NAD-malate dehydrogenase [Artomyces pyxidatus] | diamond | 2778 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Auriscalpiaceae | Artomyces | Artomyces pyxidatus | |
| 30180501 | 30180501 | PRJNA807836_S_NODE_30372_length_243_cov_0.905882_g30096_i0 | PRJNA807836 | 30372 | 243 | 0.905882 | 2.20129326 | Gonioctena quinquepunctata | 63699 | Arthropoda | Arthropoda | 42.4 | 0.0441 | NR | KAG5875460.1 | 63699 | g30096 | i0 | 41.9 | 0.530864197530864 | 43 | 25 | 53.1 | 0 | 241 | 113 | 39 | 81 | KAG5875460.1 hypothetical protein JTB14_028835 [Gonioctena quinquepunctata] | diamond | 129 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Chrysomelidae | Gonioctena | Gonioctena quinquepunctata | |
| 30726491 | 30726491 | PRJNA807836_S_NODE_29914_length_244_cov_0.900585_g29638_i0 | PRJNA807836 | 29914 | 244 | 0.900585 | 2.1974274 | Lepidoptera | 7088 | Arthropoda | Arthropoda | 54.7 | 2.32e-6 | NR | KAI5651973.1 | 192464 | g29638 | i0 | 43.6 | 4.46311475409836 | 55 | 31 | 67.6 | 0 | 165 | 1 | 5 | 59 | KAI5651973.1 beta-eliminating lyase domain-containing protein [Phthorimaea operculella] | diamond | 1089 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Gelechiidae | Phthorimaea | Phthorimaea operculella | |
| 30812442 | 30812442 | PRJNA807836_S_NODE_27774_length_250_cov_0.870056_g27498_i0 | PRJNA807836 | 27774 | 250 | 0.870056 | 2.17514 | Ophiocordyceps sinensis | 72228 | Fungi | Fungi | 131 | 1.71e-33 | NR | KAF4510699.1 | 72228 | g27498 | i0 | 74.7 | 0.996 | 83 | 3 | 99.6 | 1 | 249 | 1 | 244 | 308 | KAF4510699.1 hypothetical protein G6O67_002573 [Ophiocordyceps sinensis] | diamond | 249 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps sinensis | |
| 30907485 | 30907485 | PRJNA807836_S_NODE_19734_length_308_cov_3.144681_g19458_i0 | PRJNA807836 | 19734 | 308 | 3.144681 | 9.68561748 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 43.9 | 0.0291 | NR | XP_062515793.1 | 121492 | g19458 | i0 | 36.4 | 0.642857142857143 | 66 | 42 | 64.3 | 0 | 97 | 294 | 88 | 153 | XP_062515793.1 uncharacterized protein LOC134191216 [Corticium candelabrum] | diamond | 198 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31760930 | 31760930 | PRJNA807836_S_NODE_7737_length_569_cov_6.786290_g7472_i0 | PRJNA807836 | 7737 | 569 | 6.78629 | 38.6139901 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 89.4 | 6.16e-17 | NR | CAF3692155.1 | 2762511 | g7472 | i0 | 49.5 | 1.64499121265378 | 109 | 45 | 56.9 | 3 | 2 | 325 | 136 | 235 | CAF3692155.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 936 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32615010 | 32615010 | PRJNA807836_S_NODE_12740_length_403_cov_1.793939_g12464_i0 | PRJNA807836 | 12740 | 403 | 1.793939 | 7.22957417 | Rhinatrema bivittatum | 194408 | Chordata | Chordata | 44.7 | 0.0389 | NR | XP_029445817.1 | 194408 | g12464 | i0 | 42.9 | 0.312655086848635 | 42 | 24 | 31.3 | 0 | 270 | 395 | 7 | 48 | XP_029445817.1 uncharacterized protein LOC115084722 isoform X4 [Rhinatrema bivittatum] | diamond | 126 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Rhinatrematidae | Rhinatrema | Rhinatrema bivittatum | |
| 32781070 | 32781070 | PRJNA807836_S_NODE_31080_length_241_cov_0.916667_g30804_i0 | PRJNA807836 | 31080 | 241 | 0.916667 | 2.20916747 | Rotaria | 231623 | Rotifera | other_Eukaryota | 113 | 1.33e-28 | NR | CAF0778557.1 | 2762511 | g30804 | i0 | 74.7 | 9.27385892116183 | 75 | 19 | 93.4 | 0 | 227 | 3 | 1 | 75 | CAF0778557.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 2235 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 |
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);;