contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA627467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27617810 | 27617810 | PRJNA627467_P_NODE_21364_length_152_cov_3.650485_g21295_i0 | PRJNA627467 | 21364 | 152 | 3.650485 | 5.5487372 | Mustela lutreola | 9666 | Chordata | Chordata | 41.6 | 0.0275 | NR | XP_059011827.1 | 9666 | g21295 | i0 | 74.1 | 0.532894736842105 | 27 | 7 | 53.3 | 0 | 26 | 106 | 272 | 298 | XP_059011827.1 UPF0602 protein C4orf47 homolog isoform X1 [Mustela lutreola] | diamond | 81 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Mustela | Mustela lutreola | |
| 27838540 | 27838540 | PRJNA627467_P_NODE_13644_length_175_cov_2.753968_g13575_i0 | PRJNA627467 | 13644 | 175 | 2.753968 | 4.819444 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 63.5 | 5.99e-10 | NR | CAD7684924.1 | 34880 | g13575 | i0 | 96.6 | 0.497142857142857 | 29 | 1 | 49.7 | 0 | 134 | 48 | 239 | 267 | CAD7684924.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 87 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 27996697 | 27996697 | PRJNA627467_P_NODE_12905_length_178_cov_1.542636_g12836_i0 | PRJNA627467 | 12905 | 178 | 1.542636 | 2.74589208 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.1 | 0.00522 | NR | KAG2471189.1 | 55291 | g12836 | i0 | 57.1 | 0.589887640449438 | 35 | 15 | 59 | 0 | 160 | 56 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28059649 | 28059649 | PRJNA627467_P_NODE_14265_length_173_cov_2.346774_g14196_i0 | PRJNA627467 | 14265 | 173 | 2.346774 | 4.05991902 | Callorhinus ursinus | 34884 | Chordata | Chordata | 46.2 | 5.64e-4 | NR | XP_025745449.1 | 34884 | g14196 | i0 | 44.1 | 1.02312138728324 | 59 | 25 | 90.2 | 2 | 162 | 7 | 127 | 184 | XP_025745449.1 nucleolin-like isoform X1 [Callorhinus ursinus] | diamond | 177 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Otariidae | Callorhinus | Callorhinus ursinus | |
| 28280547 | 28280547 | PRJNA627467_P_NODE_16186_length_167_cov_2.262712_g16117_i0 | PRJNA627467 | 16186 | 167 | 2.262712 | 3.77872904 | Canis lupus familiaris | 9615 | Chordata | Chordata | 46.2 | 7.87e-4 | NR | XP_022277081.1 | 9615 | g16117 | i0 | 56.1 | 0.736526946107784 | 41 | 17 | 73.7 | 1 | 43 | 165 | 306 | 345 | XP_022277081.1 protein C1orf43 homolog isoform X13 [Canis lupus familiaris] | diamond | 123 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 28375394 | 28375394 | PRJNA627467_P_NODE_10606_length_185_cov_4.102941_g10537_i0 | PRJNA627467 | 10606 | 185 | 4.102941 | 7.59044085 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 50.8 | 6.98e-6 | NR | KAF6441178.1 | 9407 | g10537 | i0 | 51 | 0.794594594594595 | 49 | 24 | 79.5 | 0 | 5 | 151 | 28 | 76 | KAF6441178.1 hypothetical protein HJG63_012328 [Rousettus aegyptiacus] | diamond | 147 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 28785746 | 28785746 | PRJNA627467_P_NODE_18547_length_162_cov_3.115044_g18478_i0 | PRJNA627467 | 18547 | 162 | 3.115044 | 5.04637128 | Ailuropoda melanoleuca | 9646 | Chordata | Chordata | 58.9 | 2.3e-9 | NR | EFB17246.1 | 9646 | g18478 | i0 | 64.3 | 3.81481481481481 | 42 | 15 | 77.8 | 0 | 3 | 128 | 51 | 92 | EFB17246.1 hypothetical protein PANDA_006643, partial [Ailuropoda melanoleuca] | diamond | 618 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ailuropoda | Ailuropoda melanoleuca | |
| 29146382 | 29146382 | PRJNA627467_P_NODE_10889_length_184_cov_5.437037_g10820_i0 | PRJNA627467 | 10889 | 184 | 5.437037 | 10.00414808 | Squamata | 8509 | Chordata | Chordata | 46.6 | 7.51e-4 | NR | KAG8128033.1 | 35670 | g10820 | i0 | 52.5 | 4.89130434782609 | 40 | 19 | 65.2 | 0 | 64 | 183 | 562 | 601 | KAG8128033.1 hypothetical protein E2320_014903 [Naja naja] | diamond | 900 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Naja | Naja naja | |
| 29228199 | 29228199 | PRJNA627467_P_NODE_14149_length_173_cov_5.177419_g14080_i0 | PRJNA627467 | 14149 | 173 | 5.177419 | 8.95693487 | Diceros bicornis minor | 77932 | Chordata | Chordata | 55.1 | 6.34e-7 | NR | XP_058408570.1 | 77932 | g14080 | i0 | 49.1 | 0.953757225433526 | 55 | 25 | 95.4 | 1 | 169 | 5 | 110 | 161 | XP_058408570.1 uncharacterized protein LOC131412688 [Diceros bicornis minor] | diamond | 165 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Rhinocerotidae | Diceros | Diceros bicornis | |
| 29448700 | 29448700 | PRJNA627467_P_NODE_18690_length_162_cov_1.769912_g18621_i0 | PRJNA627467 | 18690 | 162 | 1.769912 | 2.86725744 | Anas platyrhynchos | 8839 | Chordata | Chordata | 48.9 | 7.85e-5 | NR | EOA98792.1 | 8839 | g18621 | i0 | 57.8 | 0.833333333333333 | 45 | 19 | 83.3 | 0 | 22 | 156 | 225 | 269 | EOA98792.1 hypothetical protein Anapl_02947 [Anas platyrhynchos] | diamond | 135 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anas | Anas platyrhynchos | |
| 29480230 | 29480230 | PRJNA627467_P_NODE_6230_length_309_cov_1.784615_g6162_i0 | PRJNA627467 | 6230 | 309 | 1.784615 | 5.51446035 | Ailuropoda melanoleuca | 9646 | Chordata | Chordata | 42 | 0.0213 | NR | EFB17980.1 | 9646 | g6162 | i0 | 62.1 | 0.563106796116505 | 29 | 11 | 28.2 | 0 | 91 | 5 | 40 | 68 | EFB17980.1 hypothetical protein PANDA_008628, partial [Ailuropoda melanoleuca] | diamond | 174 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ailuropoda | Ailuropoda melanoleuca | |
| 29796120 | 29796120 | PRJNA627467_P_NODE_5291_length_316_cov_1.588015_g5223_i0 | PRJNA627467 | 5291 | 316 | 1.588015 | 5.0181274 | Mirounga leonina | 9715 | Chordata | Chordata | 60.1 | 4.57e-8 | NR | KAF3823747.1 | 9715 | g5223 | i0 | 93.3 | 0.284810126582278 | 30 | 2 | 28.5 | 0 | 305 | 216 | 90 | 119 | KAF3823747.1 hypothetical protein GH733_007215, partial [Mirounga leonina] | diamond | 90 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga leonina | |
| 30585962 | 30585962 | PRJNA627467_P_NODE_9153_length_191_cov_2.619718_g9084_i0 | PRJNA627467 | 9153 | 191 | 2.619718 | 5.00366138 | Molossus molossus | 27622 | Chordata | Chordata | 42 | 0.0229 | NR | KAF6462343.1 | 27622 | g9084 | i0 | 45.6 | 0.895287958115183 | 57 | 30 | 89.5 | 1 | 187 | 17 | 54 | 109 | KAF6462343.1 hypothetical protein HJG59_011370 [Molossus molossus] | diamond | 171 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Molossidae | Molossus | Molossus molossus | |
| 30617619 | 30617619 | PRJNA627467_P_NODE_19873_length_159_cov_2.454545_g19804_i0 | PRJNA627467 | 19873 | 159 | 2.454545 | 3.90272655 | Lynx pardinus | 191816 | Chordata | Chordata | 41.6 | 0.03 | NR | VFV17242.1 | 191816 | g19804 | i0 | 54 | 0.943396226415094 | 50 | 21 | 94.3 | 1 | 5 | 154 | 1 | 48 | VFV17242.1 serine protease 42-like [Lynx pardinus] | diamond | 150 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Lynx | Lynx pardinus | |
| 30807317 | 30807317 | PRJNA627467_P_NODE_14474_length_172_cov_3.869919_g14405_i0 | PRJNA627467 | 14474 | 172 | 3.869919 | 6.65626068 | Pipistrellus kuhlii | 59472 | Chordata | Chordata | 42.7 | 0.00537 | NR | KAF6392699.1 | 59472 | g14405 | i0 | 51.6 | 2.16279069767442 | 31 | 15 | 54.1 | 0 | 94 | 2 | 56 | 86 | KAF6392699.1 hypothetical protein mPipKuh1_007878 [Pipistrellus kuhlii] | diamond | 372 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Pipistrellus | Pipistrellus kuhlii | |
| 31566217 | 31566217 | PRJNA627467_P_NODE_18176_length_163_cov_2.043860_g18107_i0 | PRJNA627467 | 18176 | 163 | 2.04386 | 3.3314918 | Rhineura floridana | 261503 | Chordata | Chordata | 42.7 | 0.0124 | NR | XP_061451723.1 | 261503 | g18107 | i0 | 65.7 | 5.07975460122699 | 35 | 6 | 53.4 | 1 | 53 | 139 | 26 | 60 | XP_061451723.1 acidic leucine-rich nuclear phosphoprotein 32 family member A isoform X1 [Rhineura floridana] | diamond | 828 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Rhineuridae | Rhineura | Rhineura floridana | |
| 32767162 | 32767162 | PRJNA627467_P_NODE_9160_length_191_cov_2.211268_g9091_i0 | PRJNA627467 | 9160 | 191 | 2.211268 | 4.22352188 | Phyllostomus discolor | 89673 | Chordata | Chordata | 43.5 | 0.00987 | NR | XP_028379252.1 | 89673 | g9091 | i0 | 39.2 | 0.801047120418848 | 51 | 27 | 80.1 | 1 | 158 | 6 | 105 | 151 | XP_028379252.1 ornithine carbamoyltransferase, mitochondrial [Phyllostomus discolor] | diamond | 153 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor |
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);;