contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA371613" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 399573 | 399573 | PRJNA371613_P_NODE_5321_length_205_cov_1.523810_g5145_i0 | PRJNA371613 | 5321 | 205 | 1.52381 | 3.1238105 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 379 | 7.229999999999999e-101 | NTclustered | gi|2743068143|ref|XM_065703147.1| | 6661 | g5145 | i0 | 100 | 7.70731707317073 | 205 | 0 | 100 | 0 | 1 | 205 | 863 | 659 | PREDICTED: Artemia franciscana large ribosomal subunit protein uL18-like (LOC136026514), mRNA | blastn | 1580 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 399607 | 399607 | PRJNA371613_P_NODE_9181_length_162_cov_1.024000_g9005_i0 | PRJNA371613 | 9181 | 162 | 1.024 | 1.65888 | Longitarsus dorsalis | 346795 | Arthropoda | Arthropoda | 52.8 | 0.013 | NTclustered | gi|2918386058|emb|OZ238101.1| | 346795 | g9005 | i0 | 96.774 | 0.191358024691358 | 31 | 1 | 19 | 0 | 14 | 44 | 17808223 | 17808193 | Longitarsus dorsalis genome assembly, chromosome: 8 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Chrysomelidae | Longitarsus | Longitarsus dorsalis | |
| 2950195 | 2950195 | PRJNA371613_P_NODE_8163_length_167_cov_0.984615_g7987_i0 | PRJNA371613 | 8163 | 167 | 0.984615 | 1.64430705 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 292 | 7.58e-75 | NTclustered | gi|2743077861|ref|XM_065708183.1| | 6661 | g7987 | i0 | 98.204 | 1 | 167 | 3 | 100 | 0 | 1 | 167 | 382 | 548 | PREDICTED: Artemia franciscana pyruvate carboxylase, mitochondrial-like (LOC136029681), mRNA | blastn | 167 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 4226712 | 4226712 | PRJNA371613_P_NODE_6524_length_180_cov_1.342657_g6348_i0 | PRJNA371613 | 6524 | 180 | 1.342657 | 2.4167826 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 333 | 4.87e-87 | NTclustered | gi|110467997|gb|DQ666087.1| | 6661 | g6348 | i0 | 100 | 2.97222222222222 | 180 | 0 | 100 | 0 | 1 | 180 | 184 | 5 | Artemia franciscana clone 16RPS129.05 ribosomal protein L36e mRNA, complete cds | blastn | 535 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 5503130 | 5503130 | PRJNA371613_P_NODE_5285_length_206_cov_1.869822_g5109_i0 | PRJNA371613 | 5285 | 206 | 1.869822 | 3.85183332 | Glaucopsyche melanops | 1002887 | Arthropoda | Arthropoda | 60.2 | 1.08e-4 | NTclustered | gi|2919538070|emb|OZ238348.1| | 1002887 | g5109 | i0 | 97.222 | 0.466019417475728 | 36 | 0 | 17 | 1 | 7 | 42 | 23637999 | 23637965 | Glaucopsyche melanops genome assembly, chromosome: 7 | blastn | 96 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Glaucopsyche | Glaucopsyche melanops | |
| 5503148 | 5503148 | PRJNA371613_P_NODE_9225_length_162_cov_1.024000_g9049_i0 | PRJNA371613 | 9225 | 162 | 1.024 | 1.65888 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 294 | 2.03e-75 | NTclustered | gi|2743047312|ref|XM_065719941.1| | 6661 | g9049 | i0 | 99.383 | 2 | 162 | 1 | 100 | 0 | 1 | 162 | 1809 | 1648 | PREDICTED: Artemia franciscana transforming growth factor-beta-induced protein ig-h3-like (LOC136037298), transcript variant X1, mRNA | blastn | 324 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 5503150 | 5503150 | PRJNA371613_P_NODE_9405_length_156_cov_2.134454_g9229_i0 | PRJNA371613 | 9405 | 156 | 2.134454 | 3.32974824 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 110 | 7.52e-20 | NTclustered | gi|2743072399|ref|XM_065705342.1| | 6661 | g9229 | i0 | 90.361 | 2.48717948717949 | 83 | 8 | 53 | 0 | 72 | 154 | 11768 | 11686 | PREDICTED: Artemia franciscana zinc finger protein 391-like (LOC136027906), transcript variant X2, mRNA | blastn | 388 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 7451406 | 7451406 | PRJNA371613_P_NODE_2126_length_406_cov_6.376694_g1951_i0 | PRJNA371613 | 2126 | 406 | 6.376694 | 25.88937764 | Artemia | 6660 | Arthropoda | Arthropoda | 750 | 0 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g1951 | i0 | 100 | 46.7733990147783 | 406 | 0 | 100 | 0 | 1 | 406 | 3249 | 3654 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 18990 | 750 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 7451407 | 7451407 | PRJNA371613_P_NODE_3566_length_275_cov_2.907563_g3390_i0 | PRJNA371613 | 3566 | 275 | 2.907563 | 7.99579825 | Artemia | 6660 | Arthropoda | Arthropoda | 503 | 5.809999999999998e-138 | NTclustered | gi|2743054335|ref|XR_010620511.1| | 6661 | g3390 | i0 | 99.636 | 99.1090909090909 | 275 | 1 | 100 | 0 | 1 | 275 | 890 | 616 | PREDICTED: Artemia franciscana small subunit ribosomal RNA (LOC136039680), rRNA | blastn | 27255 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 7451431 | 7451431 | PRJNA371613_P_NODE_9066_length_163_cov_1.000000_g8890_i0 | PRJNA371613 | 9066 | 163 | 1 | 1.63 | Metazoa | 33208 | Arthropoda | Arthropoda | 285 | 1.23e-72 | NTclustered | gi|5835051|ref|NC_001620.1| | 6661 | g8890 | i0 | 98.16 | 12 | 163 | 3 | 100 | 0 | 1 | 163 | 4248 | 4086 | Artemia franciscana clone pMA-1 & pMA-3 mitochondrion, complete genome | blastn | 1956 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 8052815 | 8052815 | PRJNA371613_P_NODE_8847_length_164_cov_1.007874_g8671_i0 | PRJNA371613 | 8847 | 164 | 1.007874 | 1.65291336 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 211 | 2.13e-50 | NTclustered | gi|2743030563|ref|XM_065711430.1| | 6661 | g8671 | i0 | 90.566 | 10.0487804878049 | 159 | 15 | 97 | 0 | 1 | 159 | 7998 | 8156 | PREDICTED: Artemia franciscana uncharacterized LOC136031723 (LOC136031723), transcript variant X3, mRNA | blastn | 1648 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 10603304 | 10603304 | PRJNA371613_P_NODE_6229_length_185_cov_1.668919_g6053_i0 | PRJNA371613 | 6229 | 185 | 1.668919 | 3.08750015 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 337 | 3.89e-88 | NTclustered | gi|2743060680|ref|XM_065724910.1| | 6661 | g6053 | i0 | 99.459 | 5 | 185 | 1 | 100 | 0 | 1 | 185 | 1196 | 1380 | PREDICTED: Artemia franciscana myosin-VIIa-like (LOC136040632), transcript variant X1, mRNA | blastn | 925 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 11878285 | 11878285 | PRJNA371613_P_NODE_8790_length_164_cov_1.007874_g8614_i0 | PRJNA371613 | 8790 | 164 | 1.007874 | 1.65291336 | Notodromas monacha | 399045 | Arthropoda | Arthropoda | 303 | 3.42e-78 | NTclustered | gi|1938057878|emb|OA889014.1| | 399045 | g8614 | i0 | 100 | 1 | 164 | 0 | 100 | 0 | 1 | 164 | 1763 | 1926 | Notodromas monacha | blastn | 164 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Cyprididae | Notodromas | Notodromas monacha | |
| 11878289 | 11878289 | PRJNA371613_P_NODE_9150_length_162_cov_1.024000_g8974_i0 | PRJNA371613 | 9150 | 162 | 1.024 | 1.65888 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 195 | 2.12e-45 | NTclustered | gi|2743030374|ref|XM_065711330.1| | 6661 | g8974 | i0 | 88.344 | 3 | 163 | 17 | 100 | 2 | 1 | 162 | 5024 | 4863 | PREDICTED: Artemia franciscana neogenin-like (LOC136031662), transcript variant X1, mRNA | blastn | 486 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 14428329 | 14428329 | PRJNA371613_P_NODE_7032_length_173_cov_0.941176_g6856_i0 | PRJNA371613 | 7032 | 173 | 0.941176 | 1.62823448 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 320 | 3.61e-83 | NTclustered | gi|2743037120|ref|XM_065714822.1| | 6661 | g6856 | i0 | 100 | 2 | 173 | 0 | 100 | 0 | 1 | 173 | 317 | 145 | PREDICTED: Artemia franciscana large ribosomal subunit protein eL13-like (LOC136033857), transcript variant X1, mRNA | blastn | 346 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 15702261 | 15702261 | PRJNA371613_P_NODE_5033_length_213_cov_1.340909_g4857_i0 | PRJNA371613 | 5033 | 213 | 1.340909 | 2.85613617 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 331 | 2.15e-86 | NTclustered | gi|2743070090|ref|XM_065704141.1| | 6661 | g4857 | i0 | 94.811 | 93.81220657277 | 212 | 11 | 99 | 0 | 2 | 213 | 4787 | 4576 | PREDICTED: Artemia franciscana ankyrin-1-like (LOC136027156), mRNA | blastn | 19982 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 15702274 | 15702274 | PRJNA371613_P_NODE_7353_length_171_cov_0.955224_g7177_i0 | PRJNA371613 | 7353 | 171 | 0.955224 | 1.63343304 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 228 | 2.219999999999999e-55 | NTclustered | gi|2743074797|ref|XM_065706600.1| | 6661 | g7177 | i0 | 100 | 11.1754385964912 | 123 | 0 | 72 | 0 | 1 | 123 | 2653 | 2775 | PREDICTED: Artemia franciscana F-box/WD repeat-containing protein 7-like (LOC136028728), transcript variant X2, mRNA | blastn | 1911 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 15702296 | 15702296 | PRJNA371613_P_NODE_9213_length_162_cov_1.024000_g9037_i0 | PRJNA371613 | 9213 | 162 | 1.024 | 1.65888 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 243 | 7.45e-60 | NTclustered | gi|2743052016|ref|XM_065722362.1| | 6661 | g9037 | i0 | 93.865 | 6.03703703703704 | 163 | 6 | 100 | 3 | 1 | 162 | 8113 | 7954 | PREDICTED: Artemia franciscana transcriptional regulator ATRX homolog (LOC136038891), transcript variant X3, mRNA | blastn | 978 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 18251185 | 18251185 | PRJNA371613_P_NODE_6975_length_173_cov_0.941176_g6799_i0 | PRJNA371613 | 6975 | 173 | 0.941176 | 1.62823448 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 320 | 3.61e-83 | NTclustered | gi|5835051|ref|NC_001620.1| | 6661 | g6799 | i0 | 100 | 42.8728323699422 | 173 | 0 | 100 | 0 | 1 | 173 | 10454 | 10626 | Artemia franciscana clone pMA-1 & pMA-3 mitochondrion, complete genome | blastn | 7417 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 19525410 | 19525410 | PRJNA371613_P_NODE_8476_length_165_cov_1.625000_g8300_i0 | PRJNA371613 | 8476 | 165 | 1.625 | 2.68125 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 294 | 2.08e-75 | NTclustered | gi|2743073584|ref|XM_065705952.1| | 6661 | g8300 | i0 | 98.788 | 1 | 165 | 2 | 100 | 0 | 1 | 165 | 5324 | 5488 | PREDICTED: Artemia franciscana anillin-like (LOC136028228), mRNA | blastn | 165 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 22076077 | 22076077 | PRJNA371613_P_NODE_3898_length_259_cov_1.049550_g3722_i0 | PRJNA371613 | 3898 | 259 | 1.04955 | 2.7183345 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 477 | 3.2799999999999986e-130 | NTclustered | gi|2743083419|ref|XM_065711067.1| | 6661 | g3722 | i0 | 100 | 3.98455598455598 | 258 | 0 | 99 | 0 | 1 | 258 | 133 | 390 | PREDICTED: Artemia franciscana large ribosomal subunit protein uL29-like (LOC136031455), transcript variant X3, mRNA | blastn | 1032 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 22076097 | 22076097 | PRJNA371613_P_NODE_9198_length_162_cov_1.024000_g9022_i0 | PRJNA371613 | 9198 | 162 | 1.024 | 1.65888 | Procambarus clarkii | 6728 | Arthropoda | Arthropoda | 67.6 | 4.81e-7 | NTclustered | gi|2837479122|ref|XM_069321398.1| | 6728 | g9022 | i0 | 100 | 6.01851851851852 | 36 | 0 | 25 | 0 | 58 | 93 | 701 | 666 | PREDICTED: Procambarus clarkii vesicle-associated protein-like (LOC138362830), mRNA | blastn | 975 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Cambaridae | Procambarus | Procambarus clarkii | |
| 24025239 | 24025239 | PRJNA371613_P_NODE_7219_length_172_cov_0.948148_g7043_i0 | PRJNA371613 | 7219 | 172 | 0.948148 | 1.63081456 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.004 | NTclustered | gi|2918386009|emb|OZ238095.1| | 346795 | g7043 | i0 | 100 | 0.337209302325581 | 29 | 0 | 17 | 0 | 2 | 30 | 95422777 | 95422749 | Longitarsus dorsalis genome assembly, chromosome: 2 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Chrysomelidae | Longitarsus | Longitarsus dorsalis | |
| 24025248 | 24025248 | PRJNA371613_P_NODE_839_length_708_cov_5.451565_g695_i0 | PRJNA371613 | 839 | 708 | 5.451565 | 38.5970802 | Artemia | 6660 | Arthropoda | Arthropoda | 1214 | 0 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g695 | i0 | 100 | 73.2387005649718 | 657 | 0 | 93 | 0 | 52 | 708 | 1805 | 2461 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 51853 | 1214 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana |
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);;