contig_metadata
13 rows where bioproject = "PRJNA898105", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873898 | 873898 | PRJNA898105_P_NODE_7101_length_247_cov_0.885057_g6901_i0 | PRJNA898105 | 7101 | 247 | 0.885057 | 2.18609079 | Meleagris gallopavo | 9103 | Chordata | Chordata | 457 | 4.05e-124 | NTclustered | gi|2721460913|emb|HG999695.4| | 9103 | g6901 | i0 | 100 | 8.87449392712551 | 247 | 0 | 100 | 0 | 1 | 247 | 12382031 | 12382277 | Meleagris gallopavo genome assembly, chromosome: 15 | blastn | 2192 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 3424665 | 3424665 | PRJNA898105_P_NODE_6703_length_249_cov_0.875000_g6503_i0 | PRJNA898105 | 6703 | 249 | 0.875 | 2.17875 | Equus asinus | 9793 | Chordata | Chordata | 237 | 5.8e-58 | NTclustered | gi|2871626609|ref|XR_011505737.1| | 9793 | g6503 | i0 | 84.064 | 1.00803212851406 | 251 | 35 | 100 | 5 | 1 | 249 | 773 | 1020 | PREDICTED: Equus asinus uncharacterized lncRNA (LOC106832150), ncRNA | blastn | 251 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus asinus | |
| 8526655 | 8526655 | PRJNA898105_P_NODE_5647_length_260_cov_1.609626_g5447_i0 | PRJNA898105 | 5647 | 260 | 1.609626 | 4.1850276 | Canis lupus | 9612 | Chordata | Chordata | 481 | 2.55e-131 | NTclustered | gi|168986554|gb|AC209276.7| | 9615 | g5447 | i0 | 100 | 277.115384615385 | 260 | 0 | 100 | 0 | 1 | 260 | 86847 | 87106 | Canis familiaris, clone XX-275J19, complete sequence | blastn | 72050 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 11077328 | 11077328 | PRJNA898105_P_NODE_4589_length_279_cov_2.368932_g4389_i0 | PRJNA898105 | 4589 | 279 | 2.368932 | 6.60932028 | Sus scrofa | 9823 | Chordata | Chordata | 516 | 7.58e-142 | NTclustered | gi|300394049|emb|FP102128.5| | 9823 | g4389 | i0 | 100 | 77.9247311827957 | 279 | 0 | 100 | 0 | 1 | 279 | 79433 | 79155 | Pig DNA sequence from clone CH242-348J2 on chromosome X, complete sequence | blastn | 21741 | 516 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 11447987 | 11447987 | PRJNA898105_P_NODE_6769_length_248_cov_0.885714_g6569_i0 | PRJNA898105 | 6769 | 248 | 0.885714 | 2.19657072 | Artiodactyla | 91561 | Chordata | Chordata | 361 | 3.2799999999999995e-95 | NTclustered | gi|2633691831|ref|XM_061429258.1| | 9906 | g6569 | i0 | 92.8 | 1118.64919354839 | 250 | 16 | 100 | 2 | 1 | 248 | 3753 | 4002 | PREDICTED: Bos javanicus solute carrier family 10 member 1 (SLC10A1), mRNA | blastn | 277425 | 364 | 0.991758241758242 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos javanicus | |
| 14901843 | 14901843 | PRJNA898105_P_NODE_7592_length_244_cov_2.508772_g7392_i0 | PRJNA898105 | 7592 | 244 | 2.508772 | 6.12140368 | Mus musculus | 10090 | Chordata | Chordata | 451 | 1.86e-122 | NTclustered | gi|6970310|dbj|AB019212.1| | 10090 | g7392 | i0 | 100 | 31.8811475409836 | 244 | 0 | 100 | 0 | 1 | 244 | 1164 | 921 | Mus musculus mRNA for syntaxin 7, complete cds | blastn | 7779 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 16176580 | 16176580 | PRJNA898105_P_NODE_6773_length_248_cov_0.880000_g6573_i0 | PRJNA898105 | 6773 | 248 | 0.88 | 2.1824 | Ranitomeya imitator | 111125 | Chordata | Chordata | 91.6 | 4.75e-14 | NTclustered | gi|2851970705|ref|XM_069737400.1| | 111125 | g6573 | i0 | 83 | 0.806451612903226 | 100 | 17 | 40 | 0 | 14 | 113 | 3907 | 4006 | PREDICTED: Ranitomeya imitator vascular cell adhesion molecule 1 (VCAM1), transcript variant X1, mRNA | blastn | 200 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 16546753 | 16546753 | PRJNA898105_P_NODE_5613_length_261_cov_1.255319_g5413_i0 | PRJNA898105 | 5613 | 261 | 1.255319 | 3.27638259 | Canis | 9611 | Chordata | Chordata | 477 | 3.3099999999999986e-130 | NTclustered | gi|1952984317|ref|XR_005370342.1| | 9615 | g5413 | i0 | 99.617 | 4 | 261 | 1 | 100 | 0 | 1 | 261 | 444 | 704 | PREDICTED: Canis lupus familiaris uncharacterized LOC102157132 (LOC102157132), ncRNA | blastn | 1044 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 17452070 | 17452070 | PRJNA898105_P_NODE_6594_length_249_cov_0.875000_g6394_i0 | PRJNA898105 | 6594 | 249 | 0.875 | 2.17875 | Canis lupus | 9612 | Chordata | Chordata | 99 | 2.85e-16 | NTclustered | gi|124286935|gb|AC188664.7| | 9615 | g6394 | i0 | 90.789 | 78.8835341365462 | 76 | 4 | 33 | 3 | 94 | 167 | 93657 | 93583 | Canis Familiaris chromosome 11, clone XX-510I12, complete sequence | blastn | 19642 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 27055857 | 27055857 | PRJNA898105_P_NODE_2282_length_390_cov_2.186120_g2082_i0 | PRJNA898105 | 2282 | 390 | 2.18612 | 8.525868 | Staurois parvus | 386267 | Chordata | Chordata | 58.5 | 5e-8 | NR | CAI9533415.1 | 386267 | g2082 | i0 | 40 | 2.6 | 110 | 47 | 70 | 4 | 306 | 34 | 1 | 110 | CAI9533415.1 unnamed protein product [Staurois parvus] | diamond | 1014 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28413866 | 28413866 | PRJNA898105_P_NODE_6186_length_251_cov_0.865169_g5986_i0 | PRJNA898105 | 6186 | 251 | 0.865169 | 2.17157419 | Bufotes viridis | 30338 | Chordata | Chordata | 48.1 | 5.04e-4 | NR | CAK8609802.1 | 30338 | g5986 | i0 | 61.8 | 0.406374501992032 | 34 | 13 | 40.6 | 0 | 150 | 251 | 1 | 34 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 102 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 29045388 | 29045388 | PRJNA898105_P_NODE_8288_length_241_cov_0.916667_g8088_i0 | PRJNA898105 | 8288 | 241 | 0.916667 | 2.20916747 | Staurois parvus | 386267 | Chordata | Chordata | 74.3 | 3.94e-15 | NR | CAI9618505.1 | 386267 | g8088 | i0 | 48.2 | 1.03319502074689 | 83 | 36 | 98.3 | 3 | 3 | 239 | 13 | 92 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 249 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31738361 | 31738361 | PRJNA898105_P_NODE_7937_length_243_cov_0.905882_g7737_i0 | PRJNA898105 | 7937 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Chordata | Chordata | 57 | 3.6e-7 | NR | KAI8478467.1 | 7741 | g7737 | i0 | 41.6 | 3.03703703703704 | 77 | 40 | 88.9 | 1 | 7 | 222 | 39 | 115 | KAI8478467.1 WD repeat-containing protein 26 [Branchiostoma belcheri] | diamond | 738 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri |
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);;