contig_metadata
28 rows where analysis = "blastn", bioproject = "PRJEB25583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5125406 | 5125406 | PRJEB25583_P_NODE_5985_length_170_cov_1.451128_g5808_i0 | PRJEB25583 | 5985 | 170 | 1.451128 | 2.4669176 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 292 | 7.69e-75 | NTclustered | gi|2743025003|ref|XR_010621486.1| | 6661 | g5808 | i0 | 97.647 | 24.6882352941176 | 170 | 4 | 100 | 0 | 1 | 170 | 576 | 745 | PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA | blastn | 4197 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 5125409 | 5125409 | PRJEB25583_P_NODE_6465_length_165_cov_1.187500_g6288_i0 | PRJEB25583 | 6465 | 165 | 1.1875 | 1.959375 | Leptochiton asellus | 211853 | Mollusca | Mollusca | 111 | 2.24e-20 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g6288 | i0 | 89.011 | 5.33939393939394 | 91 | 8 | 55 | 2 | 22 | 112 | 2595 | 2683 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 881 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus | |
| 6089518 | 6089518 | PRJEB25583_P_NODE_4025_length_202_cov_2.739394_g3848_i0 | PRJEB25583 | 4025 | 202 | 2.739394 | 5.53357588 | Artemia | 6660 | Arthropoda | Arthropoda | 374 | 3.3e-99 | NTclustered | gi|2295022767|gb|OP365120.1| | 6661 | g3848 | i0 | 100 | 100.237623762376 | 202 | 0 | 100 | 0 | 1 | 202 | 210 | 9 | Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence | blastn | 20248 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 6401135 | 6401135 | PRJEB25583_P_NODE_5986_length_170_cov_1.443609_g5809_i0 | PRJEB25583 | 5986 | 170 | 1.443609 | 2.4541353 | Penaeus chinensis | 139456 | Arthropoda | Arthropoda | 62.1 | 2.36e-5 | NTclustered | gi|2220187893|ref|XM_047618202.1| | 139456 | g5809 | i0 | 100 | 15.4764705882353 | 33 | 0 | 19 | 0 | 27 | 59 | 1000 | 1032 | PREDICTED: Penaeus chinensis probable serine/threonine-protein kinase clkA (LOC125028722), partial mRNA | blastn | 2631 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus chinensis | |
| 6401149 | 6401149 | PRJEB25583_P_NODE_8306_length_151_cov_1.026316_g8129_i0 | PRJEB25583 | 8306 | 151 | 1.026316 | 1.54973716 | Panthera onca | 9690 | Chordata | Chordata | 154 | 3.28e-33 | NTclustered | gi|2614064246|ref|XM_060611915.1| | 9690 | g8129 | i0 | 97.753 | 164.94701986755 | 89 | 2 | 59 | 0 | 63 | 151 | 9626 | 9714 | PREDICTED: Panthera onca BTB domain containing 3 (BTBD3), transcript variant X1, mRNA | blastn | 24907 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Panthera | Panthera onca | |
| 7675255 | 7675255 | PRJEB25583_P_NODE_3867_length_206_cov_1.810651_g3690_i0 | PRJEB25583 | 3867 | 206 | 1.810651 | 3.72994106 | Cotesia chilonis | 89804 | Arthropoda | Arthropoda | 145 | 2.89e-30 | NTclustered | gi|2129410486|gb|MW299760.1| | 89804 | g3690 | i0 | 81.977 | 15.2038834951456 | 172 | 29 | 83 | 2 | 27 | 197 | 60 | 230 | Cotesia chilonis egg surface protein ES-54 mRNA, partial cds | blastn | 3132 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Cotesia | Cotesia chilonis | |
| 7675265 | 7675265 | PRJEB25583_P_NODE_4967_length_184_cov_1.693878_g4790_i0 | PRJEB25583 | 4967 | 184 | 1.693878 | 3.11673552 | Cricotopus sp. 2 SRM-2010 | 891489 | Arthropoda | Arthropoda | 291 | 3.05e-74 | NTclustered | gi|346681867|gb|HQ440581.1| | 891489 | g4790 | i0 | 95.109 | 81.6141304347826 | 184 | 9 | 100 | 0 | 1 | 184 | 402 | 585 | Cricotopus sp. 2 SRM-2010 voucher CAM04 18S ribosomal RNA gene, partial sequence | blastn | 15017 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Cricotopus | Cricotopus sp. 2 SRM-2010 | |
| 8639495 | 8639495 | PRJEB25583_P_NODE_2667_length_249_cov_6.075472_g2490_i0 | PRJEB25583 | 2667 | 249 | 6.075472 | 15.12792528 | Ploima | 84394 | Rotifera | other_Eukaryota | 233 | 7.5e-57 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g2490 | i0 | 86.301 | 9.56224899598394 | 219 | 25 | 87 | 4 | 20 | 235 | 12300 | 12516 | Proales similis mitochondrion, complete genome | blastn | 2381 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 8949999 | 8949999 | PRJEB25583_P_NODE_5248_length_179_cov_60.204225_g5071_i0 | PRJEB25583 | 5248 | 179 | 60.204225 | 107.76556275 | Lumbriculus sp. EZ-2019 | 2480966 | Annelida | Annelida | 281 | 1.78e-71 | NTclustered | gi|1494622620|gb|MK076419.1| | 2480966 | g5071 | i0 | 97.561 | 75.731843575419 | 164 | 4 | 92 | 0 | 13 | 176 | 3283 | 3446 | Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence | blastn | 13556 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus sp. EZ-2019 | |
| 9914557 | 9914557 | PRJEB25583_P_NODE_3288_length_223_cov_2.553763_g3111_i0 | PRJEB25583 | 3288 | 223 | 2.553763 | 5.69489149 | Chironomidae | 7149 | Arthropoda | Arthropoda | 387 | 4.779999999999998e-103 | NTclustered | gi|38422425|emb|AJ586562.1| | 59808 | g3111 | i0 | 98.624 | 96.7892376681614 | 218 | 3 | 98 | 0 | 1 | 218 | 2169 | 1952 | Acricotopus lucens partial 28S rRNA gene, clone AlSo28S-42 | blastn | 21584 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Acricotopus | Acricotopus lucens | |
| 9914567 | 9914567 | PRJEB25583_P_NODE_4088_length_201_cov_1.847561_g3911_i0 | PRJEB25583 | 4088 | 201 | 1.847561 | 3.71359761 | Aphididae | 27482 | Arthropoda | Arthropoda | 327 | 2.59e-85 | NTclustered | gi|2620630428|ref|XR_009661998.1| | 40932 | g3911 | i0 | 97.906 | 91.6517412935323 | 191 | 0 | 93 | 1 | 15 | 201 | 3965 | 3775 | PREDICTED: Rhopalosiphum padi large subunit ribosomal RNA (LOC132928126), rRNA | blastn | 18422 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Rhopalosiphum | Rhopalosiphum padi | |
| 9914588 | 9914588 | PRJEB25583_P_NODE_6108_length_168_cov_5.145038_g5931_i0 | PRJEB25583 | 6108 | 168 | 5.1450379999999996 | 8.64366384 | Brachytrupes | 208857 | Arthropoda | Arthropoda | 104 | 3.84e-18 | NTclustered | gi|27463971|gb|AF514547.1| | 208856 | g5931 | i0 | 95.385 | 35.5952380952381 | 65 | 3 | 39 | 0 | 87 | 151 | 653 | 589 | Brachytrupes membranaceus 18S ribosomal RNA gene, partial sequence | blastn | 5980 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Gryllidae | Brachytrupes | Brachytrupes membranaceus | |
| 12776574 | 12776574 | PRJEB25583_P_NODE_5351_length_178_cov_1.680851_g5174_i0 | PRJEB25583 | 5351 | 178 | 1.680851 | 2.99191478 | Mus musculus | 10090 | Chordata | Chordata | 279 | 6.35e-71 | NTclustered | gi|2904935163|gb|PQ738086.1| | 10090 | g5174 | i0 | 94.972 | 70.7078651685393 | 179 | 8 | 100 | 1 | 1 | 178 | 633 | 811 | Mus musculus lncRNA, complete sequence | blastn | 12586 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 14051120 | 14051120 | PRJEB25583_P_NODE_4312_length_196_cov_4.471698_g4135_i0 | PRJEB25583 | 4312 | 196 | 4.471698 | 8.76452808 | Testechiniscus spitsbergensis | 1028634 | Tardigrada | other_Eukaryota | 113 | 7.670000000000001e-21 | NTclustered | gi|1386751360|gb|MH286186.1| | 1028634 | g4135 | i0 | 91.463 | 18.9642857142857 | 82 | 7 | 42 | 0 | 44 | 125 | 70 | 151 | Testechiniscus spitsbergensis strain Tes.spi_NO.004.04 large subunit ribosomal RNA gene, partial sequence | blastn | 3717 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Heterotardigrada | Echiniscoidea | Echiniscidae | Testechiniscus | Testechiniscus spitsbergensis | |
| 15325137 | 15325137 | PRJEB25583_P_NODE_2913_length_237_cov_8.395000_g2736_i0 | PRJEB25583 | 2913 | 237 | 8.395 | 19.89615 | Eukoenenia mirabilis | 1539568 | Arthropoda | Arthropoda | 102 | 2.08e-17 | NTclustered | gi|746815351|gb|KF823854.1| | 1539568 | g2736 | i0 | 95.385 | 27.746835443038 | 65 | 2 | 27 | 1 | 21 | 85 | 5 | 68 | Eukoenenia mirabilis voucher MCZ:IZ-127901 28S ribosomal RNA gene, partial sequence | blastn | 6576 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Palpigradi | Eukoeneniidae | Eukoenenia | Eukoenenia mirabilis | |
| 16289147 | 16289147 | PRJEB25583_P_NODE_5753_length_173_cov_1.139706_g5576_i0 | PRJEB25583 | 5753 | 173 | 1.139706 | 1.97169138 | Phasianidae | 9005 | Chordata | Chordata | 285 | 1.32e-72 | NTclustered | gi|2919603018|emb|OZ238772.1| | 9079 | g5576 | i0 | 97.059 | 1.98265895953757 | 170 | 4 | 98 | 1 | 4 | 173 | 13270521 | 13270353 | Alectoris rufa genome assembly, chromosome: 7 | blastn | 343 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 16599782 | 16599782 | PRJEB25583_P_NODE_1174_length_418_cov_3.010499_g998_i0 | PRJEB25583 | 1174 | 418 | 3.010499 | 12.58388582 | Timema monikensis | 170555 | Arthropoda | Arthropoda | 58.4 | 8.65e-4 | NTclustered | gi|1946411097|emb|OB793204.1| | 170555 | g998 | i0 | 97.059 | 0.215311004784689 | 34 | 1 | 8 | 0 | 99 | 132 | 168510 | 168543 | 3_Tms_b3v08 | blastn | 90 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema monikensis | |
| 17564256 | 17564256 | PRJEB25583_P_NODE_2314_length_270_cov_4.334764_g2137_i0 | PRJEB25583 | 2314 | 270 | 4.334764 | 11.7038628 | Isotomidae | 36141 | Arthropoda | Arthropoda | 102 | 2.42e-17 | NTclustered | gi|388565132|gb|JN981050.1| | 281420 | g2137 | i0 | 89.873 | 1.86296296296296 | 79 | 8 | 29 | 0 | 185 | 263 | 2113 | 2191 | Folsomia quadrioculata voucher Potapov 0904 28S ribosomal RNA gene, partial sequence | blastn | 503 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Collembola | Entomobryomorpha | Isotomidae | Folsomia | Folsomia quadrioculata | |
| 17874575 | 17874575 | PRJEB25583_P_NODE_1995_length_297_cov_1.565385_g1818_i0 | PRJEB25583 | 1995 | 297 | 1.565385 | 4.64919345 | Sus scrofa | 9823 | Chordata | Chordata | 279 | 1.16e-70 | NTclustered | gi|225543075|emb|CU468696.15| | 9823 | g1818 | i0 | 88.066 | 143.946127946128 | 243 | 19 | 79 | 5 | 64 | 297 | 8855 | 9096 | Pig DNA sequence from clone CH242-204N7 on chromosome X, complete sequence | blastn | 42752 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 17874583 | 17874583 | PRJEB25583_P_NODE_2935_length_237_cov_1.520000_g2758_i0 | PRJEB25583 | 2935 | 237 | 1.52 | 3.6024 | Sipha flava | 143950 | Arthropoda | Arthropoda | 246 | 9.09e-61 | NTclustered | gi|1418918320|ref|XM_025560906.1| | 143950 | g2758 | i0 | 85.532 | 1.9789029535865 | 235 | 34 | 99 | 0 | 1 | 235 | 385 | 151 | PREDICTED: Sipha flava uncharacterized LOC112687919 (LOC112687919), mRNA | blastn | 469 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Sipha | Sipha flava | |
| 17874606 | 17874606 | PRJEB25583_P_NODE_6115_length_168_cov_2.801527_g5938_i0 | PRJEB25583 | 6115 | 168 | 2.801527 | 4.70656536 | Mus musculus | 10090 | Chordata | Chordata | 89.8 | 1.08e-13 | NTclustered | gi|2904935057|gb|PQ737980.1| | 10090 | g5938 | i0 | 87.342 | 17.6071428571429 | 79 | 9 | 47 | 1 | 90 | 168 | 384 | 307 | Mus musculus lncRNA390 lncRNA, complete sequence | blastn | 2958 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 18838234 | 18838234 | PRJEB25583_P_NODE_2955_length_236_cov_2.030151_g2778_i0 | PRJEB25583 | 2955 | 236 | 2.030151 | 4.79115636 | Artemia | 6660 | Arthropoda | Arthropoda | 414 | 2.34e-111 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g2778 | i0 | 98.305 | 38.0508474576271 | 236 | 4 | 100 | 0 | 1 | 236 | 100 | 335 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 8980 | 414 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 19148486 | 19148486 | PRJEB25583_P_NODE_6956_length_160_cov_1.951220_g6779_i0 | PRJEB25583 | 6956 | 160 | 1.95122 | 3.121952 | Lipaphis pseudobrassicae | 511022 | Arthropoda | Arthropoda | 289 | 9.29e-74 | NTclustered | gi|2459370135|ref|NC_072150.1| | 511022 | g6779 | i0 | 99.371 | 100.3875 | 159 | 1 | 99 | 0 | 2 | 160 | 14800 | 14642 | Lipaphis pseudobrassicae mitochondrion, complete genome | blastn | 16062 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Lipaphis | Lipaphis pseudobrassicae | |
| 20423697 | 20423697 | PRJEB25583_P_NODE_4937_length_185_cov_1.040541_g4760_i0 | PRJEB25583 | 4937 | 185 | 1.040541 | 1.92500085 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 143 | 9.11e-30 | NTclustered | gi|2707457153|ref|XM_054897077.2| | 7653 | g4760 | i0 | 83.544 | 31.5189189189189 | 158 | 20 | 84 | 6 | 1 | 155 | 1882 | 1728 | PREDICTED: Lytechinus pictus tubulin alpha chain-like (LOC129258838), transcript variant X2, mRNA | blastn | 5831 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 22663419 | 22663419 | PRJEB25583_P_NODE_7298_length_158_cov_0.925620_g7121_i0 | PRJEB25583 | 7298 | 158 | 0.92562 | 1.4624796 | Opisthokonta | 33154 | Chordata | Chordata | 292 | 7.07e-75 | NTclustered | gi|74203961|dbj|AK149617.1| | 10090 | g7121 | i0 | 100 | 2 | 158 | 0 | 100 | 0 | 1 | 158 | 1408 | 1565 | Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:G530002K15 product:unclassifiable, full insert sequence | blastn | 316 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22974980 | 22974980 | PRJEB25583_P_NODE_7219_length_158_cov_1.760331_g7042_i0 | PRJEB25583 | 7219 | 158 | 1.760331 | 2.78132298 | Sus scrofa | 9823 | Chordata | Chordata | 87.9 | 3.58e-13 | NTclustered | gi|299507935|emb|CU928840.6| | 9823 | g7042 | i0 | 85.542 | 1.36708860759494 | 83 | 12 | 53 | 0 | 59 | 141 | 10831 | 10749 | Pig DNA sequence from clone CH242-486G13 on chromosome X, complete sequence | blastn | 216 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 24248821 | 24248821 | PRJEB25583_P_NODE_4760_length_188_cov_1.390728_g4583_i0 | PRJEB25583 | 4760 | 188 | 1.390728 | 2.61456864 | Sus scrofa | 9823 | Chordata | Chordata | 126 | 9.36e-25 | NTclustered | gi|294988734|gb|GU983681.1| | 9823 | g4583 | i0 | 80.814 | 1.82978723404255 | 172 | 23 | 90 | 3 | 1 | 169 | 1646 | 1810 | Sus scrofa mucin 4 transcript variant 4 (MUC4) gene, complete cds, alternatively spliced | blastn | 344 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 25212553 | 25212553 | PRJEB25583_P_NODE_5740_length_173_cov_1.411765_g5563_i0 | PRJEB25583 | 5740 | 173 | 1.411765 | 2.44235345 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.001 | NTclustered | gi|2911451938|emb|OZ223580.1| | 8472 | g5563 | i0 | 100 | 129.277456647399 | 30 | 0 | 17 | 0 | 101 | 130 | 23254435 | 23254464 | Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 22 | blastn | 22365 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys kempii |
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);;