contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26141 | 26141 | PRJEB2925_P_NODE_9481_length_383_cov_3.807471_g8211_i0 | PRJEB2925 | 9481 | 383 | 3.807471 | 14.58261393 | Mus musculus | 10090 | Chordata | Chordata | 318 | 3.26e-82 | NTclustered | gi|2904935057|gb|PQ737980.1| | 10090 | g8211 | i0 | 84.337 | 8.38381201044386 | 332 | 44 | 86 | 8 | 16 | 344 | 58 | 384 | Mus musculus lncRNA390 lncRNA, complete sequence | blastn | 3211 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 1300322 | 1300322 | PRJEB2925_P_NODE_1262_length_1896_cov_6.332617_g936_i1 | PRJEB2925 | 1262 | 1896 | 6.332617 | 120.06641832 | Bos taurus | 9913 | Chordata | Chordata | 2152 | 0 | NTclustered | gi|693|emb|V00115.1| | 9913 | g936 | i1 | 99.245 | 47.4430379746835 | 1192 | 9 | 88 | 0 | 704 | 1895 | 1413 | 222 | Bos taurus 1.711a satellite DNA with insert INS-1.711A. (extends from base 501 to 1151) | blastn | 89952 | 2152 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 1300341 | 1300341 | PRJEB2925_P_NODE_1462_length_1592_cov_15.949261_g1077_i0 | PRJEB2925 | 1462 | 1592 | 15.949261 | 253.91223512 | Bos javanicus | 9906 | Chordata | Chordata | 2610 | 0 | NTclustered | gi|2633679277|ref|XR_009735251.1| | 9906 | g1077 | i0 | 96.241 | 135.509422110553 | 1596 | 55 | 100 | 3 | 1 | 1592 | 1301 | 2895 | PREDICTED: Bos javanicus uncharacterized LOC133244008 (LOC133244008), ncRNA | blastn | 215731 | 2610 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos javanicus | |
| 1300433 | 1300433 | PRJEB2925_P_NODE_7702_length_452_cov_3.357314_g6499_i0 | PRJEB2925 | 7702 | 452 | 3.357314 | 15.17505928 | Lampetra fluviatilis | 7748 | Chordata | Chordata | 52.8 | 0.044 | NTclustered | gi|2805736765|emb|OZ078441.1| | 7748 | g6499 | i0 | 100 | 0.0619469026548673 | 28 | 0 | 6 | 0 | 168 | 195 | 3545871 | 3545844 | Lampetra fluviatilis genome assembly, chromosome: 38 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 3538690 | 3538690 | PRJEB2925_P_NODE_4503_length_649_cov_8.768730_g3553_i0 | PRJEB2925 | 4503 | 649 | 8.76873 | 56.9090577 | Chordata | 7711 | Chordata | Chordata | 326 | 3.44e-84 | NTclustered | gi|2851771758|ref|XM_069635237.1| | 8296 | g3553 | i0 | 80.089 | 68.1587057010786 | 447 | 81 | 68 | 7 | 100 | 542 | 295 | 737 | PREDICTED: Ambystoma mexicanum ribosomal protein S18 (RPS18), mRNA | blastn | 44235 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 3538709 | 3538709 | PRJEB2925_P_NODE_8363_length_426_cov_2.304348_g7126_i0 | PRJEB2925 | 8363 | 426 | 2.304348 | 9.81652248 | Chordata | 7711 | Chordata | Chordata | 56.5 | 0.003 | NTclustered | gi|2805731953|emb|OZ078406.1| | 7748 | g7126 | i0 | 100 | 0.971830985915493 | 30 | 0 | 7 | 0 | 233 | 262 | 1493136 | 1493107 | Lampetra fluviatilis genome assembly, chromosome: 3 | blastn | 414 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 3852222 | 3852222 | PRJEB2925_P_NODE_13944_length_276_cov_1.423237_g12666_i0 | PRJEB2925 | 13944 | 276 | 1.423237 | 3.92813412 | Xenopus tropicalis | 8364 | Chordata | Chordata | 494 | 3.51e-135 | NTclustered | gi|119709865|gb|AC149897.2| | 8364 | g12666 | i0 | 98.913 | 176.989130434783 | 276 | 3 | 100 | 0 | 1 | 276 | 54962 | 55237 | Xenopus tropicalis clone ISB-308M24, complete sequence | blastn | 48849 | 494 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 5128445 | 5128445 | PRJEB2925_P_NODE_13325_length_286_cov_2.123506_g12048_i0 | PRJEB2925 | 13325 | 286 | 2.123506 | 6.07322716 | Rattus norvegicus | 10116 | Chordata | Chordata | 244 | 4.06e-60 | NTclustered | gi|23268692|gb|AF540887.1| | 10116 | g12048 | i0 | 97.222 | 334.643356643357 | 144 | 4 | 99 | 0 | 142 | 285 | 895 | 1038 | Rattus norvegicus DMBT1 4.7 kb transcript variant mRNA, complete cds | blastn | 95708 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 6404316 | 6404316 | PRJEB2925_P_NODE_17526_length_196_cov_149.105590_g16248_i0 | PRJEB2925 | 17526 | 196 | 149.10559 | 292.2469564 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 217 | 5.679999999999999e-52 | NTclustered | gi|2801455573|ref|XM_068244652.1| | 752182 | g16248 | i0 | 86.735 | 1 | 196 | 24 | 99 | 2 | 1 | 194 | 1255 | 1450 | PREDICTED: Hyperolius riggenbachi methyltransferase 22, Kin17 lysine (METTL22), transcript variant X2, mRNA | blastn | 196 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 8953039 | 8953039 | PRJEB2925_P_NODE_10108_length_363_cov_1.935976_g8836_i0 | PRJEB2925 | 10108 | 363 | 1.935976 | 7.02759288 | Rattus norvegicus | 10116 | Chordata | Chordata | 671 | 0 | NTclustered | gi|2775691896|ref|NM_001431745.1| | 10116 | g8836 | i0 | 100 | 14.2093663911846 | 363 | 0 | 100 | 0 | 1 | 363 | 116 | 478 | Rattus norvegicus lipocalin 4 like 2 (Lcn4l2), transcript variant 2, mRNA | blastn | 5158 | 671 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 8953151 | 8953151 | PRJEB2925_P_NODE_6768_length_496_cov_2.841649_g5615_i0 | PRJEB2925 | 6768 | 496 | 2.841649 | 14.09457904 | Bos taurus | 9913 | Chordata | Chordata | 699 | 0 | NTclustered | gi|2587618257|ref|XR_009493754.1| | 9913 | g5615 | i0 | 99.481 | 46.5665322580645 | 385 | 1 | 100 | 1 | 112 | 496 | 121 | 504 | PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344790), transcript variant X2, ncRNA | blastn | 23097 | 699 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 10228881 | 10228881 | PRJEB2925_P_NODE_1689_length_1370_cov_2.201498_g1249_i0 | PRJEB2925 | 1689 | 1370 | 2.201498 | 30.1605226 | Bos taurus | 9913 | Chordata | Chordata | 2338 | 0 | NTclustered | gi|2587618257|ref|XR_009493754.1| | 9913 | g1249 | i0 | 96.931 | 38.7430656934307 | 1401 | 11 | 100 | 4 | 1 | 1370 | 7025 | 5626 | PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344790), transcript variant X2, ncRNA | blastn | 53078 | 2338 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 11504136 | 11504136 | PRJEB2925_P_NODE_13150_length_290_cov_1.396078_g11873_i0 | PRJEB2925 | 13150 | 290 | 1.396078 | 4.0486262 | Mus musculus | 10090 | Chordata | Chordata | 185 | 2.5399999999999998e-42 | NTclustered | gi|755497338|ref|XM_006497873.2| | 10090 | g11873 | i0 | 100 | 7.13448275862069 | 100 | 0 | 65 | 0 | 191 | 290 | 303 | 204 | PREDICTED: Mus musculus odorant binding protein 2A (Obp2a), transcript variant X3, mRNA | blastn | 2069 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 11504180 | 11504180 | PRJEB2925_P_NODE_3010_length_856_cov_2.142509_g2285_i0 | PRJEB2925 | 3010 | 856 | 2.142509 | 18.33987704 | Bos taurus | 9913 | Chordata | Chordata | 1079 | 0 | NTclustered | gi|2587618203|ref|XR_009493738.1| | 9913 | g2285 | i0 | 100 | 130.711448598131 | 584 | 0 | 99 | 0 | 272 | 855 | 8045 | 8628 | PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344779), transcript variant X2, ncRNA | blastn | 111889 | 1079 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 11504185 | 11504185 | PRJEB2925_P_NODE_3590_length_752_cov_10.433752_g2763_i0 | PRJEB2925 | 3590 | 752 | 10.433752 | 78.46181504 | Rattus norvegicus | 10116 | Chordata | Chordata | 1345 | 0 | NTclustered | gi|2678927550|ref|XM_063283187.1| | 10116 | g2763 | i0 | 99.33 | 29.3284574468085 | 746 | 0 | 99 | 1 | 7 | 752 | 1686 | 946 | PREDICTED: Rattus norvegicus odorant binding protein 2B (Obp2b), transcript variant X6, mRNA | blastn | 22055 | 1345 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 16602903 | 16602903 | PRJEB2925_P_NODE_15914_length_249_cov_1.724299_g14636_i0 | PRJEB2925 | 15914 | 249 | 1.724299 | 4.29350451 | Bos taurus | 9913 | Chordata | Chordata | 455 | 1.47e-123 | NTclustered | gi|2587618042|ref|XR_009493711.1| | 9913 | g14636 | i0 | 99.598 | 99.0923694779116 | 249 | 1 | 100 | 0 | 1 | 249 | 265 | 513 | PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344761), ncRNA | blastn | 24674 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 16602913 | 16602913 | PRJEB2925_P_NODE_17354_length_208_cov_143.450867_g16076_i0 | PRJEB2925 | 17354 | 208 | 143.450867 | 298.37780336 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 220 | 4.72e-53 | NTclustered | gi|2801455573|ref|XM_068244652.1| | 752182 | g16076 | i0 | 85.99 | 0.995192307692308 | 207 | 27 | 99 | 2 | 2 | 206 | 1244 | 1450 | PREDICTED: Hyperolius riggenbachi methyltransferase 22, Kin17 lysine (METTL22), transcript variant X2, mRNA | blastn | 207 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 16602967 | 16602967 | PRJEB2925_P_NODE_6514_length_509_cov_3.588608_g5380_i0 | PRJEB2925 | 6514 | 509 | 3.588608 | 18.26601472 | Sorex fumeus | 62283 | Chordata | Chordata | 270 | 1.26e-67 | NTclustered | gi|2506778439|ref|XM_056138892.1| | 62283 | g5380 | i0 | 79.345 | 71.2829076620825 | 397 | 72 | 77 | 9 | 68 | 459 | 92 | 483 | PREDICTED: Sorex fumeus ribosomal protein S15a (RPS15A), mRNA | blastn | 36283 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Sorex | Sorex fumeus | |
| 17565944 | 17565944 | PRJEB2925_P_NODE_15594_length_253_cov_2.311927_g14316_i0 | PRJEB2925 | 15594 | 253 | 2.311927 | 5.84917531 | Mammalia | 40674 | Chordata | Chordata | 143 | 1.32e-29 | NTclustered | gi|1934644986|ref|XM_037824123.1| | 27675 | g14316 | i0 | 81.215 | 59.7865612648221 | 181 | 30 | 71 | 4 | 14 | 192 | 2424 | 2602 | PREDICTED: Choloepus didactylus eukaryotic translation elongation factor 2 (EEF2), mRNA | blastn | 15126 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pilosa | Megalonychidae | Choloepus | Choloepus didactylus | |
| 20426771 | 20426771 | PRJEB2925_P_NODE_1257_length_1900_cov_6.277212_g936_i0 | PRJEB2925 | 1257 | 1900 | 6.277212 | 119.267028 | Bos taurus | 9913 | Chordata | Chordata | 2104 | 0 | NTclustered | gi|693|emb|V00115.1| | 9913 | g936 | i0 | 98.329 | 42.1973684210526 | 1197 | 14 | 88 | 2 | 2 | 1197 | 222 | 1413 | Bos taurus 1.711a satellite DNA with insert INS-1.711A. (extends from base 501 to 1151) | blastn | 80175 | 2104 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 21390234 | 21390234 | PRJEB2925_P_NODE_13317_length_286_cov_2.936255_g12040_i0 | PRJEB2925 | 13317 | 286 | 2.936255 | 8.3976893 | Bovidae | 9895 | Chordata | Chordata | 466 | 7.97e-127 | NTclustered | gi|2878412464|ref|XM_070769344.1| | 9915 | g12040 | i0 | 97.436 | 209.615384615385 | 273 | 7 | 95 | 0 | 3 | 275 | 294 | 22 | PREDICTED: Bos indicus RIMS binding protein 2 (RIMBP2), transcript variant X3, mRNA | blastn | 59950 | 470 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos indicus | |
| 21702825 | 21702825 | PRJEB2925_P_NODE_15638_length_253_cov_1.055046_g14360_i0 | PRJEB2925 | 15638 | 253 | 1.055046 | 2.66926638 | Sus scrofa | 9823 | Chordata | Chordata | 291 | 4.4699999999999996e-74 | NTclustered | gi|121410603|emb|CT737281.12| | 9823 | g14360 | i0 | 87.402 | 47.1541501976285 | 254 | 31 | 100 | 1 | 1 | 253 | 57989 | 57736 | Pig DNA sequence from clone CH242-102G9 on chromosome 7, complete sequence | blastn | 11930 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 21702828 | 21702828 | PRJEB2925_P_NODE_16058_length_247_cov_2.103774_g14780_i0 | PRJEB2925 | 16058 | 247 | 2.103774 | 5.19632178 | Marmota flaviventris | 93162 | Chordata | Chordata | 139 | 1.67e-28 | NTclustered | gi|2919376850|ref|XM_034636785.2| | 93162 | g14780 | i0 | 91.919 | 91.6882591093117 | 99 | 8 | 40 | 0 | 137 | 235 | 630 | 728 | PREDICTED: Marmota flaviventris ubiquitin C (Ubc), mRNA | blastn | 22647 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota flaviventris | |
| 21702874 | 21702874 | PRJEB2925_P_NODE_5478_length_571_cov_3.436567_g4439_i0 | PRJEB2925 | 5478 | 571 | 3.436567 | 19.62279757 | Condylura cristata | 143302 | Chordata | Chordata | 300 | 1.82e-76 | NTclustered | gi|830229738|ref|XM_004694853.2| | 143302 | g4439 | i0 | 83.974 | 76.2977232924694 | 312 | 50 | 55 | 0 | 223 | 534 | 1001 | 690 | PREDICTED: Condylura cristata uncharacterized LOC101618719 (LOC101618719), mRNA | blastn | 43566 | 302 | 0.993377483443709 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Talpidae | Condylura | Condylura cristata | |
| 22978110 | 22978110 | PRJEB2925_P_NODE_3839_length_723_cov_11.300872_g2968_i0 | PRJEB2925 | 3839 | 723 | 11.300872 | 81.70530456 | Rattus norvegicus | 10116 | Chordata | Chordata | 1325 | 0 | NTclustered | gi|2006397910|ref|NM_001128139.3| | 10116 | g2968 | i0 | 100 | 26.8215767634855 | 717 | 0 | 99 | 0 | 7 | 723 | 1 | 717 | Rattus norvegicus odorant binding protein 2A (Obp2a), mRNA | blastn | 19392 | 1325 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 22978132 | 22978132 | PRJEB2925_P_NODE_5399_length_577_cov_2.588561_g4363_i0 | PRJEB2925 | 5399 | 577 | 2.588561 | 14.93599697 | Rattus norvegicus | 10116 | Chordata | Chordata | 1022 | 0 | NTclustered | gi|2736089698|ref|NM_001430809.1| | 10116 | g4363 | i0 | 100 | 24.1871750433276 | 553 | 0 | 96 | 0 | 1 | 553 | 20 | 572 | Rattus norvegicus lipocalin 3 (Lcn3), mRNA | blastn | 13956 | 1022 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 23940467 | 23940467 | PRJEB2925_P_NODE_7559_length_458_cov_2.742317_g6368_i0 | PRJEB2925 | 7559 | 458 | 2.742317 | 12.55981186 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.044 | NTclustered | gi|2805737127|emb|OZ078444.1| | 7748 | g6368 | i0 | 100 | 0.305676855895196 | 28 | 0 | 6 | 0 | 127 | 154 | 6732342 | 6732369 | Lampetra fluviatilis genome assembly, chromosome: 41 | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis |
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);;