contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA807836" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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);;