contig_metadata
25 rows where bioproject = "PRJNA606583", tax_clade = "Opisthokonta" and tax_phylum = "Arthropoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1146495 | 1146495 | PRJNA606583_P_NODE_30581_length_190_cov_5.183007_g30152_i0 | PRJNA606583 | 30581 | 190 | 5.183007 | 9.8477133 | Lepidoptera | 7088 | Arthropoda | Arthropoda | 351 | 1.4399999999999997e-92 | NTclustered | gi|84310304|gb|DQ347469.1| | 7119 | g30152 | i0 | 100 | 534.542105263158 | 190 | 0 | 100 | 0 | 1 | 190 | 1748 | 1559 | Antheraea pernyi 18S ribosomal RNA gene, complete sequence | blastn | 101563 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Saturniidae | Antheraea | Antheraea pernyi | |
| 3134421 | 3134421 | PRJNA606583_P_NODE_29963_length_193_cov_4.173077_g29534_i0 | PRJNA606583 | 29963 | 193 | 4.173077 | 8.05403861 | Glaucopsyche melanops | 1002887 | Arthropoda | Arthropoda | 52.8 | 0.017 | NTclustered | gi|2919550840|emb|OZ238361.1| | 1002887 | g29534 | i0 | 100 | 0.145077720207254 | 28 | 0 | 15 | 0 | 110 | 137 | 14100601 | 14100628 | Glaucopsyche melanops genome assembly, chromosome: 20 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Glaucopsyche | Glaucopsyche melanops | |
| 4411203 | 4411203 | PRJNA606583_P_NODE_25824_length_218_cov_1.077348_g25395_i0 | PRJNA606583 | 25824 | 218 | 1.077348 | 2.34861864 | Sphaeridia pumilis | 212016 | Arthropoda | Arthropoda | 388 | 1.29e-103 | NTclustered | gi|2522517245|gb|OR149200.1| | 212016 | g25395 | i0 | 98.636 | 102.307339449541 | 220 | 1 | 100 | 1 | 1 | 218 | 3273 | 3492 | Sphaeridia pumilis voucher CS411-Spum-01 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22303 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Collembola | Symphypleona | Sminthurididae | Sphaeridia | Sphaeridia pumilis | |
| 5687203 | 5687203 | PRJNA606583_P_NODE_12965_length_362_cov_2.843077_g12537_i0 | PRJNA606583 | 12965 | 362 | 2.843077 | 10.29193874 | Ostrinia nubilalis | 29057 | Arthropoda | Arthropoda | 658 | 0 | NTclustered | gi|2703949389|ref|XR_010259752.1| | 29057 | g12537 | i0 | 99.448 | 313.17679558011 | 362 | 2 | 100 | 0 | 1 | 362 | 3492 | 3853 | PREDICTED: Ostrinia nubilalis large subunit ribosomal RNA (LOC135084002), rRNA | blastn | 113370 | 658 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Crambidae | Ostrinia | Ostrinia nubilalis | |
| 6961900 | 6961900 | PRJNA606583_P_NODE_33766_length_177_cov_0.964286_g33337_i0 | PRJNA606583 | 33766 | 177 | 0.964286 | 1.70678622 | Culicoides variipennis | 46212 | Arthropoda | Arthropoda | 257 | 2.9500000000000003e-64 | NTclustered | gi|1230594|gb|U48380.1|CVU48380 | 46212 | g33337 | i0 | 93.182 | 100.372881355932 | 176 | 10 | 99 | 2 | 3 | 177 | 328 | 154 | Culicoides variipennis 5.8S ribosomal RNA gene, complete sequence, 18S ribosomal RNA and 28S ribosomal RNA genes, partial sequence, and internal transcribed spacers 1 and 2 | blastn | 17766 | 257 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Ceratopogonidae | Culicoides | Culicoides variipennis | |
| 6961922 | 6961922 | PRJNA606583_P_NODE_36526_length_167_cov_1.453846_g36097_i0 | PRJNA606583 | 36526 | 167 | 1.453846 | 2.42792282 | Drymonia dodonaea | 988176 | Arthropoda | Arthropoda | 250 | 4.63e-62 | NTclustered | gi|2918369749|emb|OZ237815.1| | 988176 | g36097 | i0 | 93.182 | 278.874251497006 | 176 | 3 | 100 | 8 | 1 | 167 | 8415145 | 8415320 | Drymonia dodonaea genome assembly, chromosome: 22 | blastn | 46572 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Notodontidae | Drymonia | Drymonia dodonaea | |
| 7524266 | 7524266 | PRJNA606583_P_NODE_33726_length_177_cov_1.128571_g33297_i0 | PRJNA606583 | 33726 | 177 | 1.128571 | 1.99757067 | Sciaridae | 7184 | Arthropoda | Arthropoda | 327 | 2.2199999999999996e-85 | NTclustered | gi|422898975|gb|JQ613698.1| | 335710 | g33297 | i0 | 100 | 99.9209039548023 | 177 | 0 | 100 | 0 | 1 | 177 | 784 | 960 | Bradysia difformis voucher 122 28S ribosomal RNA gene, partial sequence | blastn | 17686 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Sciaridae | Bradysia | Bradysia impatiens | |
| 11349590 | 11349590 | PRJNA606583_P_NODE_13489_length_353_cov_3.943038_g13061_i0 | PRJNA606583 | 13489 | 353 | 3.943038 | 13.91892414 | Lepidoptera | 7088 | Arthropoda | Arthropoda | 621 | 2.0299999999999997e-173 | NTclustered | gi|2919985616|emb|OZ208589.1| | 7091 | g13061 | i0 | 98.31 | 404.543909348442 | 355 | 4 | 100 | 1 | 1 | 353 | 4364339 | 4364693 | Bombyx mori genome assembly, chromosome: 11 | blastn | 142804 | 625 | 0.9936 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 12625299 | 12625299 | PRJNA606583_P_NODE_22090_length_247_cov_2.066667_g21661_i0 | PRJNA606583 | 22090 | 247 | 2.066667 | 5.10466749 | Lepidoptera | 7088 | Arthropoda | Arthropoda | 429 | 8.83e-116 | NTclustered | gi|1220130977|gb|KY440299.1| | 1453155 | g21661 | i0 | 97.976 | 153.838056680162 | 247 | 5 | 100 | 0 | 1 | 247 | 42 | 288 | Histia rhodope voucher NSYSU-MP-Z289 28S ribosomal RNA gene, partial sequence | blastn | 37998 | 433 | 0.990762124711316 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Zygaenidae | Histia | Histia rhodope | |
| 14612618 | 14612618 | PRJNA606583_P_NODE_38992_length_159_cov_93.065574_g38563_i0 | PRJNA606583 | 38992 | 159 | 93.065574 | 147.97426266 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 60.2 | 7.87e-5 | NTclustered | gi|2899174507|ref|XM_016049079.3| | 114398 | g38563 | i0 | 100 | 0.786163522012579 | 32 | 0 | 38 | 0 | 76 | 107 | 217 | 186 | PREDICTED: Parasteatoda tepidariorum uncharacterized protein (LOC107437169), mRNA | blastn | 125 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum | |
| 14612630 | 14612630 | PRJNA606583_P_NODE_40432_length_156_cov_1.142857_g40003_i0 | PRJNA606583 | 40432 | 156 | 1.142857 | 1.78285692 | Xanthocrambus lucellus | 2107618 | Arthropoda | Arthropoda | 250 | 4.25e-62 | NTclustered | gi|1353774866|gb|KY816543.1| | 2107618 | g40003 | i0 | 95.541 | 100.987179487179 | 157 | 5 | 100 | 2 | 1 | 156 | 257 | 102 | Xanthocrambus lucellus voucher BJCP1507031 28S ribosomal RNA gene, partial sequence | blastn | 15754 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Crambidae | Xanthocrambus | Xanthocrambus lucellus | |
| 15174605 | 15174605 | PRJNA606583_P_NODE_25552_length_219_cov_3.879121_g25123_i0 | PRJNA606583 | 25552 | 219 | 3.879121 | 8.49527499 | Lepidoptera | 7088 | Arthropoda | Arthropoda | 396 | 7.769999999999997e-106 | NTclustered | gi|2918370012|emb|OZ237899.1| | 624169 | g25123 | i0 | 99.539 | 500.963470319635 | 217 | 1 | 99 | 0 | 2 | 218 | 4017412 | 4017196 | Euthrix potatoria genome assembly, chromosome: 27 | blastn | 109711 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lasiocampidae | Euthrix | Euthrix potatoria | |
| 15886521 | 15886521 | PRJNA606583_P_NODE_28073_length_204_cov_1.586826_g27644_i0 | PRJNA606583 | 28073 | 204 | 1.586826 | 3.23712504 | Neomusotima fuscolinealis | 2661721 | Arthropoda | Arthropoda | 294 | 2.68e-75 | NTclustered | gi|1772354084|gb|MK777006.1| | 2661721 | g27644 | i0 | 92.647 | 127.789215686275 | 204 | 15 | 100 | 0 | 1 | 204 | 410 | 207 | Neomusotima fuscolinealis voucher Takebecho 28S ribosomal RNA gene, partial sequence | blastn | 26069 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Crambidae | Neomusotima | Neomusotima fuscolinealis | |
| 17161404 | 17161404 | PRJNA606583_P_NODE_40714_length_155_cov_1.652542_g40285_i0 | PRJNA606583 | 40714 | 155 | 1.652542 | 2.5614401 | Teleiodes vulgella | 1594352 | Arthropoda | Arthropoda | 231 | 1.53e-56 | NTclustered | gi|2918369815|emb|OZ237921.1| | 1594352 | g40285 | i0 | 93.548 | 47.6129032258064 | 155 | 10 | 100 | 0 | 1 | 155 | 17194784 | 17194938 | Teleiodes vulgella genome assembly, chromosome: 2 | blastn | 7380 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Gelechiidae | Teleiodes | Teleiodes vulgella | |
| 17724436 | 17724436 | PRJNA606583_P_NODE_37794_length_163_cov_1.238095_g37365_i0 | PRJNA606583 | 37794 | 163 | 1.238095 | 2.01809485 | root | 1 | Root_unresolved | Root_unresolved | 298 | 1.58e-76 | NTclustered | gi|46409165|gb|BT012469.1| | 7227 | g37365 | i0 | 100 | 52.5092024539877 | 161 | 0 | 99 | 0 | 1 | 161 | 3673 | 3513 | Drosophila melanogaster RE33854 full insert cDNA | blastn | 8559 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila melanogaster | |
| 17724445 | 17724445 | PRJNA606583_P_NODE_38174_length_162_cov_0.968000_g37745_i0 | PRJNA606583 | 38174 | 162 | 0.968 | 1.56816 | Drosophila | 7215 | Arthropoda | Arthropoda | 294 | 2.03e-75 | NTclustered | gi|1509833716|ref|XR_003408266.1| | 7220 | g37745 | i0 | 99.383 | 100 | 162 | 1 | 100 | 0 | 1 | 162 | 1068 | 907 | PREDICTED: Drosophila erecta large subunit ribosomal RNA (LOC113564728), rRNA | blastn | 16200 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila erecta | |
| 17724507 | 17724507 | PRJNA606583_P_NODE_42074_length_152_cov_1.356522_g41645_i0 | PRJNA606583 | 42074 | 152 | 1.356522 | 2.06191344 | Phoridae | 36164 | Arthropoda | Arthropoda | 281 | 1.46e-71 | NTclustered | gi|425869822|gb|KC177721.1| | 36166 | g41645 | i0 | 100 | 97.1118421052632 | 152 | 0 | 100 | 0 | 1 | 152 | 1327 | 1176 | Megaselia scalaris 28S ribosomal RNA gene, partial sequence | blastn | 14761 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Phoridae | Megaselia | Megaselia scalaris | |
| 18997884 | 18997884 | PRJNA606583_P_NODE_32835_length_180_cov_2.839161_g32406_i0 | PRJNA606583 | 32835 | 180 | 2.839161 | 5.1104898 | Lepidoptera | 7088 | Arthropoda | Arthropoda | 333 | 4.87e-87 | NTclustered | gi|1786026645|gb|MK987117.1| | 93504 | g32406 | i0 | 100 | 722.816666666667 | 180 | 0 | 100 | 0 | 1 | 180 | 1313 | 1492 | Ostrinia furnacalis haplotype 11 18S ribosomal RNA gene, complete sequence | blastn | 130107 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Crambidae | Ostrinia | Ostrinia furnacalis | |
| 19710143 | 19710143 | PRJNA606583_P_NODE_24096_length_230_cov_68.880829_g23667_i0 | PRJNA606583 | 24096 | 230 | 68.880829 | 158.4259067 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 165 | 2.53e-36 | NTclustered | gi|2899174507|ref|XM_016049079.3| | 114398 | g23667 | i0 | 97.895 | 13.0869565217391 | 95 | 2 | 56 | 0 | 22 | 116 | 186 | 280 | PREDICTED: Parasteatoda tepidariorum uncharacterized protein (LOC107437169), mRNA | blastn | 3010 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum | |
| 20985956 | 20985956 | PRJNA606583_P_NODE_34237_length_175_cov_1.355072_g33808_i0 | PRJNA606583 | 34237 | 175 | 1.355072 | 2.371376 | Drosophila melanogaster | 7227 | Arthropoda | Arthropoda | 318 | 1.32e-82 | NTclustered | gi|442624003|ref|NM_001274115.1| | 7227 | g33808 | i0 | 99.429 | 98.3714285714286 | 175 | 1 | 100 | 0 | 1 | 175 | 1259 | 1085 | Drosophila melanogaster muscleblind (mbl), transcript variant P, mRNA | blastn | 17215 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila melanogaster | |
| 22260747 | 22260747 | PRJNA606583_P_NODE_36598_length_167_cov_1.192308_g36169_i0 | PRJNA606583 | 36598 | 167 | 1.192308 | 1.99115436 | Penaeus vannamei | 6689 | Arthropoda | Arthropoda | 281 | 1.64e-71 | NTclustered | gi|34604283|gb|AY382951.1| | 6689 | g36169 | i0 | 97.006 | 106.664670658683 | 167 | 5 | 100 | 0 | 1 | 167 | 104 | 270 | Litopenaeus vannamei microsatellite TUMXLV7.72 sequence | blastn | 17813 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus vannamei | |
| 22823785 | 22823785 | PRJNA606583_P_NODE_33558_length_177_cov_2.871429_g33129_i0 | PRJNA606583 | 33558 | 177 | 2.871429 | 5.08242933 | Ostrinia | 29056 | Arthropoda | Arthropoda | 291 | 2.91e-74 | NTclustered | gi|2703949389|ref|XR_010259752.1| | 29057 | g33129 | i0 | 96.61 | 713.525423728814 | 177 | 3 | 100 | 2 | 1 | 177 | 1608 | 1781 | PREDICTED: Ostrinia nubilalis large subunit ribosomal RNA (LOC135084002), rRNA | blastn | 126294 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Crambidae | Ostrinia | Ostrinia nubilalis | |
| 24809988 | 24809988 | PRJNA606583_P_NODE_8040_length_477_cov_6.511364_g7620_i0 | PRJNA606583 | 8040 | 477 | 6.511364 | 31.05920628 | Glaucopsyche melanops | 1002887 | Arthropoda | Arthropoda | 52.8 | 0.046 | NTclustered | gi|2919550840|emb|OZ238361.1| | 1002887 | g7620 | i0 | 100 | 0.0587002096436059 | 28 | 0 | 6 | 0 | 327 | 354 | 14100601 | 14100628 | Glaucopsyche melanops genome assembly, chromosome: 20 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Glaucopsyche | Glaucopsyche melanops | |
| 28406619 | 28406619 | PRJNA606583_P_NODE_41606_length_153_cov_1.344828_g41177_i0 | PRJNA606583 | 41606 | 153 | 1.344828 | 2.05758684 | Coccinella septempunctata | 41139 | Arthropoda | Arthropoda | 61.2 | 1.86e-9 | NR | XP_044764172.1 | 41139 | g41177 | i0 | 63.3 | 1.94117647058824 | 49 | 11 | 82.4 | 2 | 23 | 148 | 128 | 176 | XP_044764172.1 uncharacterized protein LOC123320804 [Coccinella septempunctata] | diamond | 297 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Coccinellidae | Coccinella | Coccinella septempunctata | |
| 30933243 | 30933243 | PRJNA606583_P_NODE_40434_length_156_cov_1.142857_g40005_i0 | PRJNA606583 | 40434 | 156 | 1.142857 | 1.78285692 | Timema bartmani | 61472 | Arthropoda | Arthropoda | 41.2 | 0.0113 | NR | CAD7451667.1 | 61472 | g40005 | i0 | 48.9 | 0.903846153846154 | 47 | 23 | 88.5 | 1 | 3 | 140 | 32 | 78 | CAD7451667.1 unnamed protein product [Timema bartmani] | diamond | 141 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema bartmani |
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);;