contig_metadata
18 rows where bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22774132 | 22774132 | PRJNA478247_P_NODE_3458_length_157_cov_1.148438_g3352_i0 | PRJNA478247 | 3458 | 157 | 1.148438 | 1.80304766 | Phallusia mammillata | 59560 | Chordata | Chordata | 100 | 2.919999999999999e-23 | NR | CAB3263465.1 | 59560 | g3352 | i0 | 88.5 | 0.993630573248408 | 52 | 6 | 99.4 | 0 | 156 | 1 | 309 | 360 | CAB3263465.1 adenosylhomocysteinase [Phallusia mammillata] | diamond | 156 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 24673865 | 24673865 | PRJNA478247_P_NODE_3460_length_156_cov_4.535433_g3354_i0 | PRJNA478247 | 3460 | 156 | 4.535433 | 7.07527548 | Tinamus guttatus | 94827 | Chordata | Chordata | 176 | 7.31e-40 | NTclustered | gi|719743150|ref|XM_010212026.1| | 94827 | g3354 | i0 | 93.277 | 73.1025641025641 | 119 | 8 | 76 | 0 | 38 | 156 | 70 | 188 | PREDICTED: Tinamus guttatus eukaryotic translation elongation factor 1 alpha 1 (EEF1A1), mRNA | blastn | 11404 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Tinamiformes | Tinamidae | Tinamus | Tinamus guttatus | |
| 26601144 | 26601144 | PRJNA478247_P_NODE_321_length_855_cov_2.675545_g246_i0 | PRJNA478247 | 321 | 855 | 2.675545 | 22.87590975 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 371 | 1.18e-125 | NR | CAI9170285.1 | 3082113 | g246 | i0 | 64.8 | 1.95789473684211 | 281 | 75 | 93 | 5 | 10 | 804 | 4 | 276 | CAI9170285.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 1674 | 371 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 26934151 | 26934151 | PRJNA478247_P_NODE_2942_length_181_cov_2.197368_g2836_i0 | PRJNA478247 | 2942 | 181 | 2.197368 | 3.97723608 | Metazoa | 33208 | Chordata | Chordata | 40 | 0.0316 | NR | XP_007883268.1 | 7868 | g2836 | i0 | 77.3 | 1.0939226519337 | 22 | 5 | 36.5 | 0 | 115 | 180 | 16 | 37 | XP_007883268.1 histone H2A-like [Callorhinchus milii] | diamond | 198 | 40.4 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 27076262 | 27076262 | PRJNA478247_P_NODE_1722_length_275_cov_2.849593_g1616_i0 | PRJNA478247 | 1722 | 275 | 2.849593 | 7.83638075 | Lagopus muta | 64668 | Chordata | Chordata | 44.3 | 0.0148 | NR | XP_048789181.1 | 64668 | g1616 | i0 | 49.4 | 0.883636363636364 | 81 | 33 | 80.7 | 3 | 8 | 229 | 34 | 113 | XP_048789181.1 uncharacterized protein LOC125687893 isoform X1 [Lagopus muta] | diamond | 243 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Lagopus | Lagopus muta | |
| 28008523 | 28008523 | PRJNA478247_P_NODE_2045_length_243_cov_2.046729_g1939_i0 | PRJNA478247 | 2045 | 243 | 2.046729 | 4.97355147 | Metazoa | 33208 | Chordata | Chordata | 60.1 | 1.14e-8 | NR | XP_035658935.1 | 7739 | g1939 | i0 | 55.2 | 3.30864197530864 | 67 | 19 | 82.7 | 2 | 43 | 243 | 1 | 56 | XP_035658935.1 40S ribosomal protein S8-like [Branchiostoma floridae] | diamond | 804 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 28134797 | 28134797 | PRJNA478247_P_NODE_2265_length_224_cov_2.143590_g2159_i0 | PRJNA478247 | 2265 | 224 | 2.14359 | 4.8016416 | Aves | 8782 | Chordata | Chordata | 87 | 4.28e-18 | NR | NWH26725.1 | 9117 | g2159 | i0 | 61.3 | 13.0178571428571 | 75 | 28 | 99.1 | 1 | 2 | 223 | 135 | 209 | NWH26725.1 PEPA protein [Grus americana] | diamond | 2916 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus americana | |
| 28387187 | 28387187 | PRJNA478247_P_NODE_1786_length_268_cov_1.635983_g1680_i0 | PRJNA478247 | 1786 | 268 | 1.635983 | 4.38443444 | Anura | 8342 | Chordata | Chordata | 86.7 | 1.75e-17 | NR | NP_001087675.1 | 8355 | g1680 | i0 | 54.2 | 9.59328358208955 | 72 | 33 | 80.6 | 0 | 217 | 2 | 213 | 284 | NP_001087675.1 annexin A7 S homeolog [Xenopus laevis] | diamond | 2571 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 29397596 | 29397596 | PRJNA478247_P_NODE_1949_length_251_cov_1.684685_g1843_i0 | PRJNA478247 | 1949 | 251 | 1.684685 | 4.22855935 | Metazoa | 33208 | Chordata | Chordata | 90.5 | 6.980000000000001e-21 | NR | PIO16379.1 | 8400 | g1843 | i0 | 53.7 | 14.4980079681275 | 82 | 35 | 98 | 2 | 3 | 248 | 21 | 99 | PIO16379.1 hypothetical protein AB205_0001690, partial [Aquarana catesbeiana] | diamond | 3639 | 91.3 | 0.991237677984666 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 29934590 | 29934590 | PRJNA478247_P_NODE_3331_length_161_cov_2.128788_g3225_i0 | PRJNA478247 | 3331 | 161 | 2.128788 | 3.42734868 | Gymnophiona | 8445 | Chordata | Chordata | 42 | 0.00214 | NR | XP_029463224.1 | 194408 | g3225 | i0 | 63.4 | 2.04968944099379 | 41 | 13 | 72.7 | 1 | 119 | 3 | 1 | 41 | XP_029463224.1 thymosin beta-15B [Rhinatrema bivittatum] | diamond | 330 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Rhinatrematidae | Rhinatrema | Rhinatrema bivittatum | |
| 29997741 | 29997741 | PRJNA478247_P_NODE_1431_length_315_cov_5.933566_g1325_i0 | PRJNA478247 | 1431 | 315 | 5.933566 | 18.6907329 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 143 | 5.659999999999998e-42 | NR | XP_031797815.1 | 9305 | g1325 | i0 | 78.2 | 48.6761904761905 | 87 | 18 | 81.9 | 1 | 12 | 269 | 12 | 98 | XP_031797815.1 40S ribosomal protein S27 isoform X2 [Sarcophilus harrisii] | diamond | 15333 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Dasyuromorphia | Dasyuridae | Sarcophilus | Sarcophilus harrisii | |
| 29997743 | 29997743 | PRJNA478247_P_NODE_491_length_643_cov_5.659609_g396_i0 | PRJNA478247 | 491 | 643 | 5.659609 | 36.39128587 | Metazoa | 33208 | Chordata | Chordata | 246 | 3.33e-79 | NR | XP_035660024.1 | 7739 | g396 | i0 | 69.4 | 15.6951788491446 | 170 | 52 | 79.3 | 0 | 577 | 68 | 39 | 208 | XP_035660024.1 60S ribosomal protein L11 isoform X1 [Branchiostoma floridae] | diamond | 10092 | 247 | 0.995951417004049 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 30076154 | 30076154 | PRJNA478247_P_NODE_2952_length_180_cov_2.264901_g2846_i0 | PRJNA478247 | 2952 | 180 | 2.264901 | 4.0768218 | Muntiacus muntjak | 9888 | Chordata | Chordata | 50.4 | 2.45e-5 | NR | KAB0351856.1 | 9888 | g2846 | i0 | 55.3 | 3.8 | 38 | 17 | 63.3 | 0 | 6 | 119 | 181 | 218 | KAB0351856.1 hypothetical protein FD754_016713 [Muntiacus muntjak] | diamond | 684 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus muntjak | |
| 30739743 | 30739743 | PRJNA478247_P_NODE_2174_length_231_cov_1.811881_g2068_i0 | PRJNA478247 | 2174 | 231 | 1.811881 | 4.18544511 | Styela clava | 7725 | Chordata | Chordata | 67.8 | 4.72e-11 | NR | XP_039263216.1 | 7725 | g2068 | i0 | 43.2 | 0.961038961038961 | 74 | 41 | 94.8 | 1 | 230 | 12 | 44 | 117 | XP_039263216.1 uncharacterized protein LOC120339198 [Styela clava] | diamond | 222 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 31087331 | 31087331 | PRJNA478247_P_NODE_335_length_836_cov_4.946716_g258_i0 | PRJNA478247 | 335 | 836 | 4.946716 | 41.35454576 | Narcine bancroftii | 1343680 | Chordata | Chordata | 249 | 3.25e-78 | NR | XP_069787765.1 | 1343680 | g258 | i0 | 56.2 | 18.8217703349282 | 235 | 98 | 82.5 | 2 | 119 | 808 | 68 | 302 | XP_069787765.1 large ribosomal subunit protein eL8 [Narcine bancroftii] | diamond | 15735 | 249 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Torpediniformes | Narcinidae | Narcine | Narcine bancroftii | |
| 31577818 | 31577818 | PRJNA478247_P_NODE_1136_length_373_cov_2.447674_g1030_i0 | PRJNA478247 | 1136 | 373 | 2.447674 | 9.12982402 | Opisthokonta | 33154 | Chordata | Chordata | 81.3 | 5.14e-15 | NR | XP_028677543.1 | 27687 | g1030 | i0 | 41.7 | 6.28954423592493 | 103 | 54 | 78.8 | 2 | 349 | 56 | 5 | 106 | XP_028677543.1 tripeptidyl-peptidase 1 [Erpetoichthys calabaricus] | diamond | 2346 | 81.6 | 0.996323529411765 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 32257993 | 32257993 | PRJNA478247_P_NODE_2898_length_184_cov_1.651613_g2792_i0 | PRJNA478247 | 2898 | 184 | 1.651613 | 3.03896792 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 43.9 | 0.00666 | NR | CAK8692237.1 | 159417 | g2792 | i0 | 37.1 | 2.05434782608696 | 62 | 35 | 97.8 | 3 | 1 | 180 | 53 | 112 | CAK8692237.1 unnamed protein product [Clavelina lepadiformis] | diamond | 378 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 32511094 | 32511094 | PRJNA478247_P_NODE_619_length_557_cov_2.660985_g515_i0 | PRJNA478247 | 619 | 557 | 2.660985 | 14.82168645 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 186 | 7.22e-51 | NR | CAK8689709.1 | 159417 | g515 | i0 | 60 | 0.99640933572711 | 185 | 74 | 99.6 | 0 | 557 | 3 | 596 | 780 | CAK8689709.1 unnamed protein product [Clavelina lepadiformis] | diamond | 555 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis |
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);;