contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA782235" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17341423 | 17341423 | PRJNA782235_P_NODE_11694_length_278_cov_1.502439_g11505_i0 | PRJNA782235 | 11694 | 278 | 1.502439 | 4.17678042 | Ceratitis capitata | 7213 | Arthropoda | Arthropoda | 150 | 2.02e-40 | NR | CAD7015493.1 | 7213 | g11505 | i0 | 89.5 | 2.46043165467626 | 76 | 8 | 82 | 0 | 276 | 49 | 205 | 280 | CAD7015493.1 unnamed protein product [Ceratitis capitata] | diamond | 684 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Ceratitis | Ceratitis capitata | |
| 21166008 | 21166008 | PRJNA782235_P_NODE_26097_length_243_cov_0.905882_g25908_i0 | PRJNA782235 | 26097 | 243 | 0.905882 | 2.20129326 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 110 | 5.29e-29 | NR | CAI9168121.1 | 3082113 | g25908 | i0 | 76 | 0.925925925925926 | 75 | 18 | 92.6 | 0 | 243 | 19 | 64 | 138 | CAI9168121.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 225 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 26800361 | 26800361 | PRJNA782235_P_NODE_15801_length_253_cov_1.494444_g15612_i0 | PRJNA782235 | 15801 | 253 | 1.494444 | 3.78094332 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 114 | 4.38e-31 | NR | KAF1741074.1 | 59785 | g15612 | i0 | 67.9 | 0.924901185770751 | 78 | 25 | 92.5 | 0 | 235 | 2 | 1 | 78 | KAF1741074.1 hypothetical protein MXB_672, partial [Myxobolus squamalis] | diamond | 234 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 27496065 | 27496065 | PRJNA782235_P_NODE_17543_length_250_cov_0.870056_g17354_i0 | PRJNA782235 | 17543 | 250 | 0.870056 | 2.17514 | Camponotus floridanus | 104421 | Arthropoda | Arthropoda | 45.1 | 0.0062 | NR | XP_025265271.1 | 104421 | g17354 | i0 | 45.5 | 0.66 | 55 | 29 | 64.8 | 1 | 187 | 26 | 50 | 104 | XP_025265271.1 uncharacterized protein LOC112638231 [Camponotus floridanus] | diamond | 165 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Camponotus | Camponotus floridanus | |
| 27590925 | 27590925 | PRJNA782235_P_NODE_21604_length_247_cov_0.885057_g21415_i0 | PRJNA782235 | 21604 | 247 | 0.885057 | 2.18609079 | Physeter macrocephalus | 9755 | Chordata | Chordata | 47.4 | 9.4e-4 | NR | XP_054945354.1 | 9755 | g21415 | i0 | 75.9 | 0.352226720647773 | 29 | 7 | 35.2 | 0 | 106 | 20 | 175 | 203 | XP_054945354.1 LOW QUALITY PROTEIN: ATP-binding cassette sub-family C member 4-like [Physeter macrocephalus] | diamond | 87 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 27843127 | 27843127 | PRJNA782235_P_NODE_10244_length_288_cov_1.148837_g10055_i0 | PRJNA782235 | 10244 | 288 | 1.148837 | 3.30865056 | Trichonephila clavipes | 2585209 | Arthropoda | Arthropoda | 41.6 | 0.0447 | NR | GFW39564.1 | 2585209 | g10055 | i0 | 30.8 | 0.8125 | 78 | 47 | 75 | 2 | 275 | 60 | 29 | 105 | GFW39564.1 hypothetical protein TNCV_2530081 [Trichonephila clavipes] | diamond | 234 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Nephilidae | Trichonephila | Trichonephila clavipes | |
| 27852531 | 27852531 | PRJNA782235_P_NODE_18764_length_249_cov_0.875000_g18575_i0 | PRJNA782235 | 18764 | 249 | 0.875 | 2.17875 | Caenorhabditis | 6237 | Nematoda | Nematoda | 64.7 | 6.06e-10 | NR | XP_002635064.2 | 6238 | g18575 | i0 | 54.5 | 7.03614457831325 | 55 | 13 | 66.3 | 1 | 3 | 167 | 163 | 205 | XP_002635064.2 Protein CBR-GPA-2 [Caenorhabditis briggsae] | diamond | 1752 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 27938125 | 27938125 | PRJNA782235_P_NODE_25205_length_243_cov_1.752941_g25016_i0 | PRJNA782235 | 25205 | 243 | 1.752941 | 4.25964663 | Phyllostomus discolor | 89673 | Chordata | Chordata | 44.7 | 0.00491 | NR | KAF6074951.1 | 89673 | g25016 | i0 | 55.2 | 0.358024691358025 | 29 | 13 | 35.8 | 0 | 139 | 53 | 84 | 112 | KAF6074951.1 hypothetical protein HJG60_009361 [Phyllostomus discolor] | diamond | 87 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 27969553 | 27969553 | PRJNA782235_P_NODE_11965_length_277_cov_0.995098_g11776_i0 | PRJNA782235 | 11965 | 277 | 0.995098 | 2.75642146 | Euwallacea fornicatus | 995702 | Arthropoda | Arthropoda | 135 | 1.05e-35 | NR | XP_066152325.1 | 995702 | g11776 | i0 | 66.3 | 1.02888086642599 | 95 | 28 | 98.6 | 1 | 275 | 3 | 330 | 424 | XP_066152325.1 G protein-activated inward rectifier potassium channel 4-like isoform X2 [Euwallacea fornicatus] | diamond | 285 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Curculionidae | Euwallacea | Euwallacea fornicatus | |
| 27978881 | 27978881 | PRJNA782235_P_NODE_23565_length_245_cov_0.895349_g23376_i0 | PRJNA782235 | 23565 | 245 | 0.895349 | 2.19360505 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 80.9 | 1.19e-15 | NR | XP_008550924.1 | 69319 | g23376 | i0 | 56.3 | 2.91428571428571 | 80 | 34 | 98 | 1 | 240 | 1 | 336 | 414 | XP_008550924.1 aminomethyltransferase, mitochondrial [Microplitis demolitor] | diamond | 714 | 81.6 | 0.991421568627451 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Microplitis | Microplitis demolitor | |
| 28042129 | 28042129 | PRJNA782235_P_NODE_22185_length_246_cov_0.890173_g21996_i0 | PRJNA782235 | 22185 | 246 | 0.890173 | 2.18982558 | Insecta | 50557 | Arthropoda | Arthropoda | 115 | 2.43e-28 | NR | XP_024223007.1 | 132113 | g21996 | i0 | 65.4 | 20.7439024390244 | 81 | 28 | 98.8 | 0 | 246 | 4 | 309 | 389 | XP_024223007.1 probable hydroxyacid-oxoacid transhydrogenase, mitochondrial isoform X2 [Bombus impatiens] | diamond | 5103 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Bombus | Bombus impatiens | |
| 28159274 | 28159274 | PRJNA782235_P_NODE_27985_length_241_cov_0.916667_g27796_i0 | PRJNA782235 | 27985 | 241 | 0.916667 | 2.20916747 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 143 | 9.41e-40 | NR | CAI9153848.1 | 3082113 | g27796 | i0 | 87.2 | 0.970954356846473 | 78 | 10 | 97.1 | 0 | 234 | 1 | 23 | 100 | CAI9153848.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 234 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 28443396 | 28443396 | PRJNA782235_P_NODE_12706_length_272_cov_1.547739_g12517_i0 | PRJNA782235 | 12706 | 272 | 1.547739 | 4.20985008 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 45.4 | 0.0042 | NR | GFN81058.1 | 259542 | g12517 | i0 | 45.2 | 4.11397058823529 | 42 | 22 | 45.2 | 1 | 1 | 123 | 156 | 197 | GFN81058.1 ribonuclease hi [Plakobranchus ocellatus] | diamond | 1119 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 28569431 | 28569431 | PRJNA782235_P_NODE_11747_length_278_cov_1.429268_g11558_i0 | PRJNA782235 | 11747 | 278 | 1.429268 | 3.97336504 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 80.5 | 1.02e-15 | NR | XP_014679194.1 | 37621 | g11558 | i0 | 56.5 | 1.99640287769784 | 92 | 39 | 98.2 | 1 | 275 | 3 | 155 | 246 | XP_014679194.1 PREDICTED: uncharacterized protein LOC106819047 [Priapulus caudatus] | diamond | 555 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 28695979 | 28695979 | PRJNA782235_P_NODE_19187_length_249_cov_0.875000_g18998_i0 | PRJNA782235 | 19187 | 249 | 0.875 | 2.17875 | Heptranchias perlo | 212740 | Chordata | Chordata | 65.9 | 2.78e-10 | NR | XP_067841360.1 | 212740 | g18998 | i0 | 50.7 | 1.55421686746988 | 67 | 33 | 80.7 | 0 | 235 | 35 | 18 | 84 | XP_067841360.1 LOW QUALITY PROTEIN: S-adenosylmethionine-dependent nucleotide dehydratase RSAD2 [Heptranchias perlo] | diamond | 387 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Hexanchiformes | Hexanchidae | Heptranchias | Heptranchias perlo | |
| 28695980 | 28695980 | PRJNA782235_P_NODE_27627_length_241_cov_0.916667_g27438_i0 | PRJNA782235 | 27627 | 241 | 0.916667 | 2.20916747 | Aphis craccivora | 307492 | Arthropoda | Arthropoda | 50.4 | 9.11e-6 | NR | KAF0759511.1 | 307492 | g27438 | i0 | 100 | 0.29875518672199203 | 24 | 0 | 29.9 | 0 | 169 | 240 | 1 | 24 | KAF0759511.1 Uncharacterized protein FWK35_00006063 [Aphis craccivora] | diamond | 72 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Aphis | Aphis craccivora | |
| 29011881 | 29011881 | PRJNA782235_P_NODE_15848_length_253_cov_1.127778_g15659_i0 | PRJNA782235 | 15848 | 253 | 1.127778 | 2.85327834 | Dinothrombium tinctorium | 1965070 | Arthropoda | Arthropoda | 47.4 | 9.98e-4 | NR | RWS02945.1 | 1965070 | g15659 | i0 | 31.3 | 1.9802371541502 | 83 | 57 | 98.4 | 0 | 2 | 250 | 369 | 451 | RWS02945.1 hypothetical protein B4U79_10363 [Dinothrombium tinctorium] | diamond | 501 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombidiidae | Dinothrombium | Dinothrombium tinctorium | |
| 29715148 | 29715148 | PRJNA782235_P_NODE_12570_length_273_cov_1.330000_g12381_i0 | PRJNA782235 | 12570 | 273 | 1.33 | 3.6309 | Trombidiformes | 83136 | Arthropoda | Arthropoda | 179 | 2.95e-53 | NR | XP_015792934.1 | 32264 | g12381 | i0 | 92.2 | 4.94505494505495 | 90 | 7 | 98.9 | 0 | 2 | 271 | 153 | 242 | XP_015792934.1 pre-mRNA-splicing factor RBM22 [Tetranychus urticae] | diamond | 1350 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 30148169 | 30148169 | PRJNA782235_P_NODE_16652_length_251_cov_0.865169_g16463_i0 | PRJNA782235 | 16652 | 251 | 0.865169 | 2.17157419 | Crocuta crocuta | 9678 | Chordata | Chordata | 43.5 | 0.00395 | NR | KAF0876186.1 | 9678 | g16463 | i0 | 66.7 | 0.322709163346614 | 27 | 9 | 32.3 | 0 | 31 | 111 | 30 | 56 | KAF0876186.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 81 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 30179848 | 30179848 | PRJNA782235_P_NODE_19092_length_249_cov_0.875000_g18903_i0 | PRJNA782235 | 19092 | 249 | 0.875 | 2.17875 | Dermatophagoides pteronyssinus | 6956 | Arthropoda | Arthropoda | 76.6 | 2.62e-14 | NR | XP_027202866.1 | 6956 | g18903 | i0 | 57.3 | 0.987951807228916 | 82 | 1 | 98.8 | 1 | 2 | 247 | 225 | 272 | XP_027202866.1 ATPase ASNA1 homolog [Dermatophagoides pteronyssinus] | diamond | 246 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Pyroglyphidae | Dermatophagoides | Dermatophagoides pteronyssinus | |
| 30316208 | 30316208 | PRJNA782235_P_NODE_26052_length_243_cov_0.905882_g25863_i0 | PRJNA782235 | 26052 | 243 | 0.905882 | 2.20129326 | Artiodactyla | 91561 | Chordata | Chordata | 51.6 | 5.64e-6 | NR | KAJ1063486.1 | 9925 | g25863 | i0 | 45.7 | 1.76543209876543 | 70 | 37 | 85.2 | 1 | 31 | 237 | 32 | 101 | KAJ1063486.1 hypothetical protein K5549_021639, partial [Capra hircus] | diamond | 429 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 30748739 | 30748739 | PRJNA782235_P_NODE_23334_length_245_cov_0.895349_g23145_i0 | PRJNA782235 | 23334 | 245 | 0.895349 | 2.19360505 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 58.2 | 1.32e-7 | NR | CAI9152427.1 | 3082113 | g23145 | i0 | 93.5 | 0.759183673469388 | 31 | 2 | 38 | 0 | 4 | 96 | 337 | 367 | CAI9152427.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 186 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 30875078 | 30875078 | PRJNA782235_P_NODE_13674_length_266_cov_1.559585_g13485_i0 | PRJNA782235 | 13674 | 266 | 1.559585 | 4.1484961 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 79.3 | 1.91e-16 | NR | XP_028390691.1 | 151771 | g13485 | i0 | 46.7 | 1.66917293233083 | 75 | 40 | 84.6 | 0 | 6 | 230 | 75 | 149 | XP_028390691.1 ADP-ribose glycohydrolase OARD1-like [Dendronephthya gigantea] | diamond | 444 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31231781 | 31231781 | PRJNA782235_P_NODE_24815_length_244_cov_0.900585_g24626_i0 | PRJNA782235 | 24815 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Chordata | Chordata | 43.9 | 0.0141 | NR | XP_019335264.1 | 8496 | g24626 | i0 | 37 | 1.99180327868852 | 54 | 34 | 66.4 | 0 | 6 | 167 | 146 | 199 | XP_019335264.1 tigger transposable element-derived protein 1-like [Alligator mississippiensis] | diamond | 486 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Alligatoridae | Alligator | Alligator mississippiensis | ||
| 31317509 | 31317509 | PRJNA782235_P_NODE_14095_length_263_cov_2.115789_g13906_i0 | PRJNA782235 | 14095 | 263 | 2.115789 | 5.56452507 | Cyrtonyx montezumae | 9017 | Chordata | Chordata | 62 | 8.05e-9 | NR | XP_065609848.1 | 9017 | g13906 | i0 | 67.7 | 0.707224334600761 | 62 | 15 | 67.3 | 2 | 3 | 179 | 1219 | 1278 | XP_065609848.1 LOW QUALITY PROTEIN: tensin-2-like [Cyrtonyx montezumae] | diamond | 186 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Odontophoridae | Cyrtonyx | Cyrtonyx montezumae | |
| 32086024 | 32086024 | PRJNA782235_P_NODE_14038_length_264_cov_1.246073_g13849_i0 | PRJNA782235 | 14038 | 264 | 1.246073 | 3.28963272 | root | 1 | Root_unresolved | Root_unresolved | 52.4 | 1.82e-5 | NR | KAK9874503.1 | 420089 | g13849 | i0 | 36.8 | 1.68181818181818 | 76 | 39 | 76.1 | 2 | 39 | 239 | 139 | 214 | KAK9874503.1 hypothetical protein WA026_002854 [Henosepilachna vigintioctopunctata] | diamond | 444 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Coccinellidae | Henosepilachna | Henosepilachna vigintioctopunctata | |
| 32171850 | 32171850 | PRJNA782235_P_NODE_13278_length_269_cov_0.852041_g13089_i0 | PRJNA782235 | 13278 | 269 | 0.852041 | 2.29199029 | Nasutitermes takasagoensis | 62960 | Arthropoda | Arthropoda | 48.9 | 3.34e-4 | NR | BAM38487.2 | 62960 | g13089 | i0 | 37.3 | 0.925650557620818 | 83 | 45 | 92.6 | 2 | 16 | 264 | 386 | 461 | BAM38487.2 3-hydroxy-3-methylglutaryl coenzyme A synthase-2 [Nasutitermes takasagoensis] | diamond | 249 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Termitidae | Nasutitermes | Nasutitermes takasagoensis | |
| 32843988 | 32843988 | PRJNA782235_P_NODE_21240_length_247_cov_0.885057_g21051_i0 | PRJNA782235 | 21240 | 247 | 0.885057 | 2.18609079 | Diptera | 7147 | Arthropoda | Arthropoda | 157 | 2.85e-44 | NR | XP_002071678.1 | 7260 | g21051 | i0 | 89 | 18.8380566801619 | 82 | 9 | 99.6 | 0 | 246 | 1 | 167 | 248 | XP_002071678.1 bystin [Drosophila willistoni] | diamond | 4653 | 158 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila willistoni |
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);;