contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1145574" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4115744 | 4115744 | PRJNA1145574_P_NODE_64_length_2317_cov_4.367647_g43_i0 | PRJNA1145574 | 64 | 2317 | 4.367647 | 101.19838099 | Metazoa | 33208 | Mollusca | Mollusca | 725 | 2.0599999999999996e-252 | NR | XP_013082114.1 | 6526 | g43 | i0 | 62.6 | 182.922313336211 | 594 | 204 | 74.7 | 2 | 2299 | 569 | 7 | 599 | XP_013082114.1 heat shock 70 kDa protein cognate 4 [Biomphalaria glabrata] | diamond | 423831 | 731 | 0.991792065663475 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 7941655 | 7941655 | PRJNA1145574_P_NODE_10667_length_257_cov_1.271739_g10483_i0 | PRJNA1145574 | 10667 | 257 | 1.271739 | 3.26836923 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 130 | 6.92e-36 | NR | MCL4117824.1 | 82763 | g10483 | i0 | 68.2 | 7.85603112840467 | 85 | 27 | 99.2 | 0 | 256 | 2 | 50 | 134 | MCL4117824.1 hypothetical protein [Idotea baltica] | diamond | 2019 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Idoteidae | Idotea | Idotea baltica | |
| 28049675 | 28049675 | PRJNA1145574_P_NODE_13505_length_246_cov_0.901734_g13321_i0 | PRJNA1145574 | 13505 | 246 | 0.901734 | 2.21826564 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 124 | 2.9899999999999998e-34 | NR | CAI9154273.1 | 3082113 | g13321 | i0 | 82.7 | 0.914634146341463 | 75 | 13 | 91.5 | 0 | 22 | 246 | 1 | 75 | CAI9154273.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 225 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 28890937 | 28890937 | PRJNA1145574_P_NODE_14848_length_242_cov_0.923077_g14664_i0 | PRJNA1145574 | 14848 | 242 | 0.923077 | 2.23384634 | Passeriformes | 9126 | Chordata | Chordata | 94.7 | 1.86e-20 | NR | XP_064267235.1 | 48849 | g14664 | i0 | 50 | 13.8223140495868 | 78 | 39 | 96.7 | 0 | 234 | 1 | 784 | 861 | XP_064267235.1 endogenous retrovirus group K member 6 Pol protein [Passer domesticus] | diamond | 3345 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Passeridae | Passer | Passer domesticus | |
| 29091746 | 29091746 | PRJNA1145574_P_NODE_9028_length_286_cov_1.361502_g8844_i0 | PRJNA1145574 | 9028 | 286 | 1.361502 | 3.89389572 | Crocuta crocuta | 9678 | Chordata | Chordata | 88.6 | 3.7e-19 | NR | KAF0884676.1 | 9678 | g8844 | i0 | 66.2 | 0.681818181818182 | 65 | 22 | 68.2 | 0 | 3 | 197 | 35 | 99 | KAF0884676.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 195 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 29470209 | 29470209 | PRJNA1145574_P_NODE_12710_length_248_cov_0.891429_g12526_i0 | PRJNA1145574 | 12710 | 248 | 0.891429 | 2.21074392 | Gryllus longicercus | 2509291 | Arthropoda | Arthropoda | 158 | 1.4200000000000001e-44 | NR | KAK7869359.1 | 2509291 | g12526 | i0 | 100 | 0.931451612903226 | 77 | 0 | 93.1 | 0 | 232 | 2 | 1 | 77 | KAK7869359.1 hypothetical protein R5R35_012903 [Gryllus longicercus] | diamond | 231 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Gryllidae | Gryllus | Gryllus longicercus | |
| 29533672 | 29533672 | PRJNA1145574_P_NODE_12090_length_250_cov_0.881356_g11906_i0 | PRJNA1145574 | 12090 | 250 | 0.881356 | 2.20339 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 53.9 | 4.67e-6 | NR | XP_064629129.1 | 88925 | g11906 | i0 | 88 | 1.5 | 25 | 3 | 30 | 0 | 166 | 240 | 458 | 482 | XP_064629129.1 asparagine synthetase [glutamine-hydrolyzing]-like [Lineus longissimus] | diamond | 375 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 30038923 | 30038923 | PRJNA1145574_P_NODE_4351_length_399_cov_5.806748_g4167_i0 | PRJNA1145574 | 4351 | 399 | 5.806748 | 23.16892452 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 83.6 | 1.17e-15 | NR | CAD5121248.1 | 2664684 | g4167 | i0 | 55.9 | 0.932330827067669 | 59 | 26 | 44.4 | 0 | 51 | 227 | 1043 | 1101 | CAD5121248.1 DgyrCDS9780 [Dimorphilus gyrociliatus] | diamond | 372 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 30090895 | 30090895 | PRJNA1145574_P_NODE_4132_length_408_cov_4.576119_g3948_i0 | PRJNA1145574 | 4132 | 408 | 4.576119 | 18.67056552 | Chironomidae | 7149 | Arthropoda | Arthropoda | 47.4 | 0.00467 | NR | CAG9807182.1 | 315576 | g3948 | i0 | 38.1 | 1.65441176470588 | 63 | 39 | 46.3 | 0 | 218 | 406 | 204 | 266 | CAG9807182.1 unnamed protein product [Chironomus riparius] | diamond | 675 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomus | Chironomus riparius | |
| 30165154 | 30165154 | PRJNA1145574_P_NODE_6192_length_344_cov_1.151292_g6008_i0 | PRJNA1145574 | 6192 | 344 | 1.151292 | 3.96044448 | Rissa tridactyla | 75485 | Chordata | Chordata | 52 | 6.68e-5 | NR | XP_054037764.1 | 75485 | g6008 | i0 | 58.3 | 0.418604651162791 | 48 | 20 | 41.9 | 0 | 243 | 100 | 543 | 590 | XP_054037764.1 uncharacterized protein LOC128900532 [Rissa tridactyla] | diamond | 144 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Laridae | Rissa | Rissa tridactyla | |
| 30355432 | 30355432 | PRJNA1145574_P_NODE_4952_length_378_cov_2.347541_g4768_i0 | PRJNA1145574 | 4952 | 378 | 2.347541 | 8.87370498 | Glossina fuscipes | 7396 | Arthropoda | Arthropoda | 118 | 8.58e-31 | NR | XP_037894365.1 | 7396 | g4768 | i0 | 54.1 | 4.53174603174603 | 111 | 45 | 88.1 | 1 | 45 | 377 | 49 | 153 | XP_037894365.1 ADP-ribose glycohydrolase OARD1 isoform X1 [Glossina fuscipes] | diamond | 1713 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Glossinidae | Glossina | Glossina fuscipes | |
| 30734032 | 30734032 | PRJNA1145574_P_NODE_13134_length_247_cov_0.896552_g12950_i0 | PRJNA1145574 | 13134 | 247 | 0.896552 | 2.21448344 | Calidris pugnax | 198806 | Chordata | Chordata | 58.9 | 7.82e-8 | NR | XP_014808060.1 | 198806 | g12950 | i0 | 51.6 | 0.753036437246964 | 62 | 29 | 74.1 | 1 | 20 | 202 | 220 | 281 | XP_014808060.1 PREDICTED: uncharacterized protein LOC106894085 [Calidris pugnax] | diamond | 186 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Scolopacidae | Calidris | Calidris pugnax | |
| 31967004 | 31967004 | PRJNA1145574_P_NODE_14618_length_243_cov_0.917647_g14434_i0 | PRJNA1145574 | 14618 | 243 | 0.917647 | 2.22988221 | Agelaius tricolor | 9191 | Chordata | Chordata | 42.7 | 0.0356 | NR | XP_071304911.1 | 9191 | g14434 | i0 | 42.4 | 0.814814814814815 | 66 | 36 | 81.5 | 1 | 199 | 2 | 62 | 125 | XP_071304911.1 uncharacterized protein [Agelaius tricolor] | diamond | 198 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Icteridae | Agelaius | Agelaius tricolor | |
| 32061990 | 32061990 | PRJNA1145574_P_NODE_12778_length_248_cov_0.891429_g12594_i0 | PRJNA1145574 | 12778 | 248 | 0.891429 | 2.21074392 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 130 | 1.16e-35 | NR | XP_024508765.1 | 34506 | g12594 | i0 | 73.8 | 9.67741935483871 | 80 | 21 | 96.8 | 0 | 241 | 2 | 6 | 85 | XP_024508765.1 Splicing factor 3A subunit 2 [Strongyloides ratti] | diamond | 2400 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 32220311 | 32220311 | PRJNA1145574_P_NODE_12318_length_249_cov_0.920455_g12134_i0 | PRJNA1145574 | 12318 | 249 | 0.920455 | 2.29193295 | Tupaia chinensis | 246437 | Chordata | Chordata | 56.6 | 5.22e-7 | NR | ELW65328.1 | 246437 | g12134 | i0 | 54.9 | 0.855421686746988 | 71 | 30 | 83.1 | 1 | 1 | 207 | 370 | 440 | ELW65328.1 Pre-mRNA-splicing factor 38B [Tupaia chinensis] | diamond | 213 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Scandentia | Tupaiidae | Tupaia | Tupaia chinensis | |
| 32840506 | 32840506 | PRJNA1145574_P_NODE_6780_length_331_cov_1.189922_g6596_i0 | PRJNA1145574 | 6780 | 331 | 1.189922 | 3.93864182 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 142 | 1.99e-40 | NR | KAA3677532.1 | 34504 | g6596 | i0 | 66.7 | 24.2447129909366 | 96 | 32 | 87 | 0 | 42 | 329 | 1 | 96 | KAA3677532.1 Ras-related C3 botulinum toxin substrate 1 [Paragonimus westermani] | diamond | 8025 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani |
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);;