contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA380416" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27548876 | 27548876 | PRJNA380416_P_NODE_13884_length_161_cov_0.910714_g13737_i0 | PRJNA380416 | 13884 | 161 | 0.910714 | 1.46624954 | Staurois parvus | 386267 | Chordata | Chordata | 63.9 | 1.72e-11 | NR | CAI9618505.1 | 386267 | g13737 | i0 | 67.6 | 1.37888198757764 | 37 | 12 | 68.9 | 0 | 50 | 160 | 7 | 43 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 222 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28085629 | 28085629 | PRJNA380416_P_NODE_6925_length_218_cov_1.254438_g6778_i0 | PRJNA380416 | 6925 | 218 | 1.254438 | 2.73467484 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 45.4 | 0.00197 | NR | XP_068103809.1 | 752182 | g6778 | i0 | 70 | 0.412844036697248 | 30 | 9 | 41.3 | 0 | 124 | 213 | 1 | 30 | XP_068103809.1 zinc finger protein 418-like [Hyperolius riggenbachi] | diamond | 90 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 28180222 | 28180222 | PRJNA380416_P_NODE_13606_length_162_cov_0.902655_g13459_i0 | PRJNA380416 | 13606 | 162 | 0.902655 | 1.4623011 | Lipotes vexillifer | 118797 | Chordata | Chordata | 46.6 | 1.49e-4 | NR | XP_007466294.1 | 118797 | g13459 | i0 | 73.1 | 0.481481481481481 | 26 | 7 | 48.1 | 0 | 21 | 98 | 35 | 60 | XP_007466294.1 PREDICTED: LOW QUALITY PROTEIN: putative viral protein-binding protein C1-like [Lipotes vexillifer] | diamond | 78 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Lipotidae | Lipotes | Lipotes vexillifer | |
| 28260417 | 28260417 | PRJNA380416_P_NODE_12786_length_164_cov_0.886957_g12639_i0 | PRJNA380416 | 12786 | 164 | 0.886957 | 1.45460948 | Chordata | 7711 | Chordata | Chordata | 59.3 | 1.82e-8 | NR | XP_036899618.1 | 192404 | g12639 | i0 | 49 | 8.14024390243902 | 51 | 26 | 93.3 | 0 | 160 | 8 | 2475 | 2525 | XP_036899618.1 dynein heavy chain 7, axonemal [Sturnira hondurensis] | diamond | 1335 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Sturnira | Sturnira hondurensis | |
| 28450211 | 28450211 | PRJNA380416_P_NODE_12626_length_164_cov_0.886957_g12479_i0 | PRJNA380416 | 12626 | 164 | 0.886957 | 1.45460948 | Rodentia | 9989 | Chordata | Chordata | 61.6 | 2.05e-9 | NR | VTJ66147.1 | 9995 | g12479 | i0 | 51.9 | 2.85365853658537 | 52 | 25 | 95.1 | 0 | 164 | 9 | 166 | 217 | VTJ66147.1 Hypothetical predicted protein [Marmota monax] | diamond | 468 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 28702746 | 28702746 | PRJNA380416_P_NODE_11627_length_166_cov_0.871795_g11480_i0 | PRJNA380416 | 11627 | 166 | 0.871795 | 1.4471797 | Chordata | 7711 | Chordata | Chordata | 61.2 | 3.94e-9 | NR | XP_040388086.1 | 8869 | g11480 | i0 | 100 | 73.1927710843374 | 30 | 0 | 54.2 | 0 | 166 | 77 | 555 | 584 | XP_040388086.1 T-complex protein 1 subunit zeta isoform X1 [Cygnus olor] | diamond | 12150 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Cygnus | Cygnus olor | |
| 28811598 | 28811598 | PRJNA380416_P_NODE_13988_length_161_cov_0.910714_g13841_i0 | PRJNA380416 | 13988 | 161 | 0.910714 | 1.46624954 | Staurois parvus | 386267 | Chordata | Chordata | 53.5 | 1.01e-7 | NR | CAI9540006.1 | 386267 | g13841 | i0 | 57.9 | 0.708074534161491 | 38 | 16 | 70.8 | 0 | 35 | 148 | 1 | 38 | CAI9540006.1 unnamed protein product, partial [Staurois parvus] | diamond | 114 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29050061 | 29050061 | PRJNA380416_P_NODE_14348_length_150_cov_5.009901_g14201_i0 | PRJNA380416 | 14348 | 150 | 5.009901 | 7.5148515 | root | 1 | Root_unresolved | Root_unresolved | 40.8 | 0.0496 | NR | XP_040210338.1 | 8407 | g14201 | i0 | 50 | 1.76 | 38 | 18 | 76 | 1 | 28 | 141 | 194 | 230 | XP_040210338.1 POU domain, class 6, transcription factor 2-like [Rana temporaria] | diamond | 264 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 29159431 | 29159431 | PRJNA380416_P_NODE_11029_length_169_cov_0.950000_g10882_i0 | PRJNA380416 | 11029 | 169 | 0.95 | 1.6055 | Ranitomeya imitator | 111125 | Chordata | Chordata | 45.4 | 0.0015 | NR | CAJ0952439.1 | 111125 | g10882 | i0 | 43.4 | 1.86390532544379 | 53 | 30 | 94.1 | 0 | 161 | 3 | 656 | 708 | CAJ0952439.1 unnamed protein product [Ranitomeya imitator] | diamond | 315 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29159433 | 29159433 | PRJNA380416_P_NODE_13489_length_162_cov_0.902655_g13342_i0 | PRJNA380416 | 13489 | 162 | 0.902655 | 1.4623011 | Ranitomeya imitator | 111125 | Chordata | Chordata | 45.1 | 0.0018600000000000001 | NR | CAJ0963020.1 | 111125 | g13342 | i0 | 51.4 | 1.7962962962963 | 35 | 17 | 64.8 | 0 | 3 | 107 | 11 | 45 | CAJ0963020.1 unnamed protein product [Ranitomeya imitator] | diamond | 291 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29348776 | 29348776 | PRJNA380416_P_NODE_13649_length_162_cov_0.646018_g13502_i0 | PRJNA380416 | 13649 | 162 | 0.646018 | 1.04654916 | Staurois parvus | 386267 | Chordata | Chordata | 70.5 | 4.42e-14 | NR | CAI9547784.1 | 386267 | g13502 | i0 | 54.7 | 0.981481481481482 | 53 | 24 | 98.1 | 0 | 3 | 161 | 31 | 83 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 159 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29664045 | 29664045 | PRJNA380416_P_NODE_11070_length_168_cov_1.705882_g10923_i0 | PRJNA380416 | 11070 | 168 | 1.705882 | 2.86588176 | Dryobates pubescens | 118200 | Chordata | Chordata | 56.2 | 4.3e-8 | NR | KFV61095.1 | 118200 | g10923 | i0 | 52.2 | 0.821428571428571 | 46 | 20 | 78.6 | 1 | 137 | 6 | 25 | 70 | KFV61095.1 hypothetical protein N307_11170, partial [Dryobates pubescens] | diamond | 138 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Piciformes | Picidae | Dryobates | Dryobates pubescens | |
| 29948696 | 29948696 | PRJNA380416_P_NODE_5451_length_249_cov_1.045000_g5304_i0 | PRJNA380416 | 5451 | 249 | 1.045 | 2.60205 | Ranitomeya imitator | 111125 | Chordata | Chordata | 56.2 | 6.99e-7 | NR | CAJ0920470.1 | 111125 | g5304 | i0 | 68.4 | 0.91566265060241 | 38 | 12 | 45.8 | 0 | 2 | 115 | 709 | 746 | CAJ0920470.1 unnamed protein product [Ranitomeya imitator] | diamond | 228 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 30628954 | 30628954 | PRJNA380416_P_NODE_11353_length_167_cov_0.864407_g11206_i0 | PRJNA380416 | 11353 | 167 | 0.864407 | 1.44355969 | Opisthokonta | 33154 | Chordata | Chordata | 97.4 | 1.04e-22 | NR | NP_001104213.1 | 8355 | g11206 | i0 | 90.9 | 39.5209580838323 | 55 | 5 | 98.8 | 0 | 1 | 165 | 7 | 61 | NP_001104213.1 uncharacterized protein LOC100126642 [Xenopus laevis] | diamond | 6600 | 97.8 | 0.995910020449898 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 31148819 | 31148819 | PRJNA380416_P_NODE_12175_length_165_cov_0.879310_g12028_i0 | PRJNA380416 | 12175 | 165 | 0.87931 | 1.4508615 | Sciurus carolinensis | 30640 | Chordata | Chordata | 45.4 | 0.00144 | NR | MBZ3891560.1 | 30640 | g12028 | i0 | 54.7 | 2.85454545454545 | 53 | 24 | 96.4 | 0 | 161 | 3 | 235 | 287 | MBZ3891560.1 Neuron navigator 2 [Sciurus carolinensis] | diamond | 471 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 31844942 | 31844942 | PRJNA380416_P_NODE_13797_length_161_cov_0.910714_g13650_i0 | PRJNA380416 | 13797 | 161 | 0.910714 | 1.46624954 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 58.2 | 4.2e-8 | NR | XP_019641040.1 | 7741 | g13650 | i0 | 57.9 | 1.41614906832298 | 38 | 16 | 70.8 | 0 | 143 | 30 | 115 | 152 | XP_019641040.1 PREDICTED: WD repeat-containing protein 31-like [Branchiostoma belcheri] | diamond | 228 | 58.2 | 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);;