contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJEB55250" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1396067 | 1396067 | PRJEB55250_P_NODE_12222_length_250_cov_0.870056_g12098_i0 | PRJEB55250 | 12222 | 250 | 0.870056 | 2.17514 | Manduca sexta | 7130 | Arthropoda | Arthropoda | 71.3 | 6.25e-8 | NTclustered | gi|268306473|gb|GU084325.1| | 7130 | g12098 | i0 | 81.928 | 1.008 | 83 | 15 | 33 | 0 | 3 | 85 | 148 | 230 | Manduca sexta ribosomal protein L29 (rpl29) mRNA, complete cds | blastn | 252 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Sphingidae | Manduca | Manduca sexta | |
| 2671802 | 2671802 | PRJEB55250_P_NODE_15143_length_244_cov_0.900585_g15019_i0 | PRJEB55250 | 15143 | 244 | 0.900585 | 2.1974274 | Aptenodytes forsteri | 9233 | Chordata | Chordata | 390 | 4.11e-104 | NTclustered | gi|1110999049|ref|XM_019470459.1| | 9233 | g15019 | i0 | 95.492 | 1.11885245901639 | 244 | 11 | 100 | 0 | 1 | 244 | 862 | 619 | PREDICTED: Aptenodytes forsteri prophage integrase IntA-like (LOC109279286), mRNA | blastn | 273 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Sphenisciformes | Spheniscidae | Aptenodytes | Aptenodytes forsteri | |
| 3542396 | 3542396 | PRJEB55250_P_NODE_16183_length_242_cov_0.911243_g16059_i0 | PRJEB55250 | 16183 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 448 | 2.3799999999999995e-121 | NTclustered | gi|74207406|dbj|AK152023.1| | 10090 | g16059 | i0 | 100 | 40.9214876033058 | 242 | 0 | 100 | 0 | 1 | 242 | 1236 | 1477 | Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830045H07 product:p21 (CDKN1A)-activated kinase 2, full insert sequence | blastn | 9903 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 3947709 | 3947709 | PRJEB55250_P_NODE_10724_length_256_cov_1.513661_g10600_i0 | PRJEB55250 | 10724 | 256 | 1.513661 | 3.87497216 | Diaphorina citri | 121845 | Arthropoda | Arthropoda | 468 | 1.95e-127 | NTclustered | gi|1494774796|ref|XR_003394590.1| | 121845 | g10600 | i0 | 99.609 | 100.5234375 | 256 | 1 | 100 | 0 | 1 | 256 | 1491 | 1746 | PREDICTED: Diaphorina citri large subunit ribosomal RNA (LOC113472154), rRNA | blastn | 25734 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Psyllidae | Diaphorina | Diaphorina citri | |
| 3947760 | 3947760 | PRJEB55250_P_NODE_13064_length_248_cov_0.880000_g12940_i0 | PRJEB55250 | 13064 | 248 | 0.88 | 2.1824 | Acyrthosiphon pisum | 7029 | Arthropoda | Arthropoda | 403 | 5.38e-108 | NTclustered | gi|149944780|gb|AC202223.6| | 7029 | g12940 | i0 | 95.984 | 3.36290322580645 | 249 | 9 | 100 | 1 | 1 | 248 | 52244 | 52492 | Acyrthosiphon pisum BAC VMRC38-10-A9 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence | blastn | 834 | 403 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Acyrthosiphon | Acyrthosiphon pisum | |
| 3947910 | 3947910 | PRJEB55250_P_NODE_5164_length_312_cov_0.962343_g5040_i0 | PRJEB55250 | 5164 | 312 | 0.962343 | 3.00251016 | Cybister sp. CYE1 | 1075885 | Arthropoda | Arthropoda | 577 | 3.89e-160 | NTclustered | gi|353169492|gb|JN840674.1| | 1075885 | g5040 | i0 | 100 | 99.9423076923077 | 312 | 0 | 100 | 0 | 1 | 312 | 635 | 324 | Cybister sp. CYE1 voucher BMNH:721669 cytochrome c oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 31182 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Dytiscidae | Cybister | Cybister sp. CYE1 | |
| 4819883 | 4819883 | PRJEB55250_P_NODE_8424_length_273_cov_1.540000_g8300_i0 | PRJEB55250 | 8424 | 273 | 1.54 | 4.2042 | Bovidae | 9895 | Chordata | Chordata | 104 | 6.82e-18 | NTclustered | gi|2633720223|ref|XR_009740456.1| | 9906 | g8300 | i0 | 89.157 | 21.5604395604396 | 83 | 9 | 30 | 0 | 7 | 89 | 11397 | 11479 | PREDICTED: Bos javanicus uncharacterized LOC133259584 (LOC133259584), ncRNA | blastn | 5886 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos javanicus | |
| 5224382 | 5224382 | PRJEB55250_P_NODE_8205_length_275_cov_1.143564_g8081_i0 | PRJEB55250 | 8205 | 275 | 1.143564 | 3.144801 | Lysiphlebia japonica | 104022 | Arthropoda | Arthropoda | 58.4 | 5.43e-4 | NTclustered | gi|1251773062|gb|KY809859.1| | 104022 | g8081 | i0 | 97.059 | 0.123636363636364 | 34 | 1 | 12 | 0 | 94 | 127 | 1869 | 1836 | Lysiphlebia japonica elongation factor 1-alpha mRNA, complete cds | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Lysiphlebia | Lysiphlebia japonica | |
| 8645015 | 8645015 | PRJEB55250_P_NODE_2107_length_448_cov_1.434667_g1984_i0 | PRJEB55250 | 2107 | 448 | 1.434667 | 6.42730816 | root | 1 | Root_unresolved | Root_unresolved | 789 | 0 | NTclustered | gi|78097481|gb|AC167665.2| | 7176 | g1984 | i0 | 98.438 | 98 | 448 | 7 | 100 | 0 | 1 | 448 | 79185 | 79632 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940135D9, complete sequence | blastn | 43904 | 795 | 0.992452830188679 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 8645074 | 8645074 | PRJEB55250_P_NODE_8847_length_270_cov_1.289340_g8723_i0 | PRJEB55250 | 8847 | 270 | 1.28934 | 3.481218 | root | 1 | Root_unresolved | Root_unresolved | 483 | 7.409999999999998e-132 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g8723 | i0 | 98.889 | 32.8296296296296 | 270 | 3 | 100 | 0 | 1 | 270 | 5038 | 5307 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 8864 | 483 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 9049085 | 9049085 | PRJEB55250_P_NODE_568_length_868_cov_2.357233_g468_i0 | PRJEB55250 | 568 | 868 | 2.357233 | 20.46078244 | Meriones unguiculatus | 10047 | Chordata | Chordata | 69.4 | 8.69e-7 | NTclustered | gi|2599590958|ref|XM_060390852.1| | 10047 | g468 | i0 | 90.566 | 0.42741935483871 | 53 | 3 | 6 | 2 | 155 | 205 | 302 | 250 | PREDICTED: Meriones unguiculatus calpain 7 (Capn7), transcript variant X3, mRNA | blastn | 371 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Meriones | Meriones unguiculatus | |
| 12875370 | 12875370 | PRJEB55250_P_NODE_3671_length_354_cov_1.505338_g3547_i0 | PRJEB55250 | 3671 | 354 | 1.505338 | 5.32889652 | Timema monikensis | 170555 | Arthropoda | Arthropoda | 58.4 | 7.2e-4 | NTclustered | gi|1946411097|emb|OB793204.1| | 170555 | g3547 | i0 | 97.059 | 0.254237288135593 | 34 | 1 | 10 | 0 | 29 | 62 | 168510 | 168543 | 3_Tms_b3v08 | blastn | 90 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema monikensis | |
| 14150215 | 14150215 | PRJEB55250_P_NODE_6152_length_291_cov_1.766055_g6028_i0 | PRJEB55250 | 6152 | 291 | 1.766055 | 5.13922005 | Dermatophagoides pteronyssinus | 6956 | Arthropoda | Arthropoda | 56.5 | 0.002 | NTclustered | gi|1535914965|ref|XM_027343730.1| | 6956 | g6028 | i0 | 100 | 1.72852233676976 | 30 | 0 | 10 | 0 | 108 | 137 | 876 | 905 | PREDICTED: Dermatophagoides pteronyssinus uncharacterized LOC113793668 (LOC113793668), mRNA | blastn | 503 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Pyroglyphidae | Dermatophagoides | Dermatophagoides pteronyssinus | |
| 15424072 | 15424072 | PRJEB55250_P_NODE_13153_length_248_cov_0.880000_g13029_i0 | PRJEB55250 | 13153 | 248 | 0.88 | 2.1824 | Mus musculus | 10090 | Chordata | Chordata | 459 | 1.13e-124 | NTclustered | gi|1061975057|ref|NM_001331048.1| | 10090 | g13029 | i0 | 100 | 6 | 248 | 0 | 100 | 0 | 1 | 248 | 4998 | 4751 | Mus musculus hyaluronan synthase 3 (Has3), transcript variant 2, mRNA | blastn | 1488 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 15424164 | 15424164 | PRJEB55250_P_NODE_16853_length_237_cov_2.292683_g16729_i0 | PRJEB55250 | 16853 | 237 | 2.292683 | 5.43365871 | Mus musculus | 10090 | Chordata | Chordata | 54.7 | 0.006 | NTclustered | gi|71533340|gb|AC156162.2| | 10090 | g16729 | i0 | 100 | 0.122362869198312 | 29 | 0 | 12 | 0 | 30 | 58 | 100755 | 100783 | Mus musculus BAC clone RP24-342A17 from chromosome 9, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 16294572 | 16294572 | PRJEB55250_P_NODE_4753_length_322_cov_0.927711_g4629_i0 | PRJEB55250 | 4753 | 322 | 0.927711 | 2.98722942 | root | 1 | Root_unresolved | Root_unresolved | 584 | 2.41e-162 | NTclustered | gi|21727344|emb|AL627314.6| | 10090 | g4629 | i0 | 99.379 | 100.88198757764 | 322 | 2 | 100 | 0 | 1 | 322 | 35120 | 34799 | Mouse DNA sequence from clone RP23-354H24 on chromosome 4, complete sequence | blastn | 32484 | 584 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 17569685 | 17569685 | PRJEB55250_P_NODE_15354_length_243_cov_1.676471_g15230_i0 | PRJEB55250 | 15354 | 243 | 1.676471 | 4.0738245300000004 | root | 1 | Root_unresolved | Root_unresolved | 440 | 4e-119 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g15230 | i0 | 99.585 | 94.3868312757202 | 241 | 1 | 99 | 0 | 3 | 243 | 49999 | 50239 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 22936 | 444 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 19247365 | 19247365 | PRJEB55250_P_NODE_2456_length_419_cov_2.291908_g2333_i0 | PRJEB55250 | 2456 | 419 | 2.291908 | 9.60309452 | Euproctis chrysorrhoea | 987934 | Arthropoda | Arthropoda | 54.7 | 0.011 | NTclustered | gi|2918370018|emb|OZ237905.1| | 987934 | g2333 | i0 | 96.97 | 0.0787589498806683 | 33 | 0 | 8 | 1 | 156 | 187 | 14694390 | 14694358 | Euproctis chrysorrhoea genome assembly, chromosome: 1 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Erebidae | Euproctis | Euproctis chrysorrhoea | |
| 19247469 | 19247469 | PRJEB55250_P_NODE_8416_length_273_cov_1.540000_g8292_i0 | PRJEB55250 | 8416 | 273 | 1.54 | 4.2042 | Stegostoma tigrinum | 3053191 | Chordata | Chordata | 52.8 | 0.025 | NTclustered | gi|2579323054|ref|XM_048560041.2| | 3053191 | g8292 | i0 | 100 | 0.41025641025641 | 28 | 0 | 10 | 0 | 129 | 156 | 4890 | 4863 | PREDICTED: Stegostoma tigrinum BTB/POZ domain-containing protein 2-like (LOC125465982), transcript variant X1, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Stegostomatidae | Stegostoma | Stegostoma tigrinum | |
| 20118310 | 20118310 | PRJEB55250_P_NODE_10716_length_256_cov_1.568306_g10592_i0 | PRJEB55250 | 10716 | 256 | 1.568306 | 4.01486336 | root | 1 | Root_unresolved | Root_unresolved | 468 | 1.95e-127 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g10592 | i0 | 99.609 | 84.18359375 | 256 | 1 | 100 | 0 | 1 | 256 | 45284 | 45539 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 21551 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 20522596 | 20522596 | PRJEB55250_P_NODE_13357_length_247_cov_1.770115_g13233_i0 | PRJEB55250 | 13357 | 247 | 1.770115 | 4.37218405 | Bubalus bubalis | 89462 | Chordata | Chordata | 316 | 7.17e-82 | NTclustered | gi|2148424236|ref|XR_006552564.2| | 89462 | g13233 | i0 | 96.825 | 1.16599190283401 | 189 | 6 | 77 | 0 | 59 | 247 | 1 | 189 | PREDICTED: Bubalus bubalis uncharacterized LOC123334545 (LOC123334545), ncRNA | blastn | 288 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bubalus | Bubalus bubalis | |
| 21393961 | 21393961 | PRJEB55250_P_NODE_3497_length_360_cov_1.609756_g3373_i0 | PRJEB55250 | 3497 | 360 | 1.609756 | 5.7951216 | root | 1 | Root_unresolved | Root_unresolved | 660 | 0 | NTclustered | gi|686598286|ref|XM_009277024.1| | 9233 | g3373 | i0 | 99.722 | 11.0888888888889 | 360 | 1 | 100 | 0 | 1 | 360 | 582 | 223 | PREDICTED: Aptenodytes forsteri allantoicase (ALLC), partial mRNA | blastn | 3992 | 665 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Sphenisciformes | Spheniscidae | Aptenodytes | Aptenodytes forsteri | |
| 22668780 | 22668780 | PRJEB55250_P_NODE_3718_length_352_cov_11.121864_g3594_i0 | PRJEB55250 | 3718 | 352 | 11.121864 | 39.14896128 | Leptothecata | 500008 | Cnidaria | other_Eukaryota | 187 | 8.74e-43 | NTclustered | gi|66864859|gb|AY920799.1| | 6100 | g3594 | i0 | 90.714 | 845.991477272727 | 140 | 13 | 40 | 0 | 3 | 142 | 2392 | 2253 | Aequorea victoria large subunit 28S ribosomal RNA gene, partial sequence | blastn | 297789 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Aequoreidae | Aequorea | Aequorea victoria | |
| 22668826 | 22668826 | PRJEB55250_P_NODE_7718_length_278_cov_1.921951_g7594_i0 | PRJEB55250 | 7718 | 278 | 1.921951 | 5.34302378 | Formicidae | 36668 | Arthropoda | Arthropoda | 503 | 5.88e-138 | NTclustered | gi|1419211181|emb|LT977143.1| | 67763 | g7594 | i0 | 99.281 | 99.931654676259 | 278 | 2 | 100 | 0 | 1 | 278 | 149 | 426 | Lasius flavus partial 28S rRNA gene, specimen voucher MCZ:Ent:654750 | blastn | 27781 | 508 | 0.990157480314961 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Lasius | Lasius flavus | |
| 24347602 | 24347602 | PRJEB55250_P_NODE_15860_length_242_cov_1.609467_g15736_i0 | PRJEB55250 | 15860 | 242 | 1.609467 | 3.89491014 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 448 | 2.3799999999999995e-121 | NTclustered | gi|2743035377|ref|XM_065713940.1| | 6661 | g15736 | i0 | 100 | 1 | 242 | 0 | 100 | 0 | 1 | 242 | 1113 | 872 | PREDICTED: Artemia franciscana SERPINE1 mRNA-binding protein 1-like (LOC136033227), mRNA | blastn | 242 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 25217984 | 25217984 | PRJEB55250_P_NODE_5180_length_311_cov_2.289916_g5056_i0 | PRJEB55250 | 5180 | 311 | 2.289916 | 7.12163876 | root | 1 | Root_unresolved | Root_unresolved | 575 | 1.3899999999999995e-159 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g5056 | i0 | 100 | 25.2347266881029 | 311 | 0 | 100 | 0 | 1 | 311 | 68174 | 67864 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 7848 | 575 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus |
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);;