contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA934472" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22588115 | 22588115 | PRJNA934472_P_NODE_33258_length_258_cov_1.448649_g32880_i0 | PRJNA934472 | 33258 | 258 | 1.448649 | 3.73751442 | Rattus norvegicus | 10116 | Chordata | Chordata | 64.3 | 1.93e-11 | NR | EDL86969.1 | 10116 | g32880 | i0 | 96.7 | 0.348837209302326 | 30 | 1 | 34.9 | 0 | 9 | 98 | 42 | 71 | EDL86969.1 rCG50536 [Rattus norvegicus] | diamond | 90 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 26644888 | 26644888 | PRJNA934472_P_NODE_10861_length_432_cov_1.097493_g10484_i0 | PRJNA934472 | 10861 | 432 | 1.097493 | 4.74116976 | Mus musculus | 10090 | Chordata | Chordata | 43.5 | 0.0346 | NR | EDL09486.1 | 10090 | g10484 | i0 | 84.2 | 0.131944444444444 | 19 | 3 | 13.2 | 0 | 79 | 23 | 28 | 46 | EDL09486.1 mCG147332 [Mus musculus] | diamond | 57 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 26771793 | 26771793 | PRJNA934472_P_NODE_19741_length_327_cov_2.125984_g19364_i0 | PRJNA934472 | 19741 | 327 | 2.125984 | 6.95196768 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 57.4 | 9.81e-8 | NR | CAD7692826.1 | 34880 | g19364 | i0 | 49.1 | 0.522935779816514 | 57 | 25 | 52.3 | 1 | 104 | 274 | 78 | 130 | CAD7692826.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 171 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 27214444 | 27214444 | PRJNA934472_P_NODE_6722_length_539_cov_1.684549_g6408_i0 | PRJNA934472 | 6722 | 539 | 1.684549 | 9.07971911 | Rattus norvegicus | 10116 | Chordata | Chordata | 54.7 | 3.24e-6 | NR | EDL97532.1 | 10116 | g6408 | i0 | 100 | 0.128014842300557 | 23 | 0 | 12.8 | 0 | 114 | 46 | 81 | 103 | EDL97532.1 rCG27612 [Rattus norvegicus] | diamond | 69 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 27657018 | 27657018 | PRJNA934472_P_NODE_39784_length_231_cov_2.215190_g39406_i0 | PRJNA934472 | 39784 | 231 | 2.21519 | 5.1170889 | Muntiacus muntjak | 9888 | Chordata | Chordata | 49.3 | 1.17e-5 | NR | KAB0344592.1 | 9888 | g39406 | i0 | 72.7 | 0.428571428571429 | 33 | 9 | 42.9 | 0 | 229 | 131 | 6 | 38 | KAB0344592.1 hypothetical protein FD754_021518 [Muntiacus muntjak] | diamond | 99 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus muntjak | |
| 27972568 | 27972568 | PRJNA934472_P_NODE_24305_length_298_cov_0.920000_g23927_i0 | PRJNA934472 | 24305 | 298 | 0.92 | 2.7416 | Apodemus speciosus | 105296 | Chordata | Chordata | 50.1 | 1.1e-4 | NR | GAB1295729.1 | 105296 | g23927 | i0 | 82.8 | 0.291946308724832 | 29 | 5 | 29.2 | 0 | 111 | 197 | 99 | 127 | GAB1295729.1 Biogenesis of lysosome-related organelles complex 1 subunit 1 [Apodemus speciosus] | diamond | 87 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 28042770 | 28042770 | PRJNA934472_P_NODE_22265_length_310_cov_1.426160_g21887_i0 | PRJNA934472 | 22265 | 310 | 1.42616 | 4.421096 | root | 1 | Root_unresolved | Root_unresolved | 210 | 5.99e-63 | NR | XP_030110853.2 | 10090 | g21887 | i0 | 99 | 15.7935483870968 | 102 | 1 | 98.7 | 0 | 308 | 3 | 113 | 214 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 4896 | 211 | 0.995260663507109 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 29330222 | 29330222 | PRJNA934472_P_NODE_37089_length_246_cov_0.890173_g36711_i0 | PRJNA934472 | 37089 | 246 | 0.890173 | 2.18982558 | Staurois parvus | 386267 | Chordata | Chordata | 84.3 | 5.01e-19 | NR | CAI9618505.1 | 386267 | g36711 | i0 | 46.3 | 1 | 82 | 43 | 98.8 | 1 | 1 | 243 | 13 | 94 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 246 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29930398 | 29930398 | PRJNA934472_P_NODE_27971_length_280_cov_1.140097_g27593_i0 | PRJNA934472 | 27971 | 280 | 1.140097 | 3.1922716 | Cricetulus griseus | 10029 | Chordata | Chordata | 63.2 | 3.61e-9 | NR | XP_027243225.1 | 10029 | g27593 | i0 | 57.1 | 1.2 | 56 | 24 | 60 | 0 | 75 | 242 | 294 | 349 | XP_027243225.1 Friend virus susceptibility protein 1 [Cricetulus griseus] | diamond | 336 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 30436016 | 30436016 | PRJNA934472_P_NODE_28653_length_277_cov_1.014706_g28275_i0 | PRJNA934472 | 28653 | 277 | 1.014706 | 2.81073562 | Rattus norvegicus | 10116 | Chordata | Chordata | 189 | 1.2299999999999999e-60 | NR | EDM00394.1 | 10116 | g28275 | i0 | 100 | 0.963898916967509 | 89 | 0 | 96.4 | 0 | 270 | 4 | 1 | 89 | EDM00394.1 rCG37799, partial [Rattus norvegicus] | diamond | 267 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 30814824 | 30814824 | PRJNA934472_P_NODE_24454_length_297_cov_1.205357_g24076_i0 | PRJNA934472 | 24454 | 297 | 1.205357 | 3.57991029 | Rattus norvegicus | 10116 | Chordata | Chordata | 117 | 1.4399999999999999e-32 | NR | EDL78643.1 | 10116 | g24076 | i0 | 98.2 | 0.555555555555556 | 55 | 1 | 55.6 | 0 | 53 | 217 | 1 | 55 | EDL78643.1 rCG55933 [Rattus norvegicus] | diamond | 165 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 31162132 | 31162132 | PRJNA934472_P_NODE_32435_length_261_cov_2.202128_g32057_i0 | PRJNA934472 | 32435 | 261 | 2.202128 | 5.74755408 | Rattus norvegicus | 10116 | Chordata | Chordata | 53.1 | 2.02e-7 | NR | EDL86677.1 | 10116 | g32057 | i0 | 100 | 0.275862068965517 | 24 | 0 | 27.6 | 0 | 158 | 229 | 1 | 24 | EDL86677.1 rCG41242, isoform CRA_b [Rattus norvegicus] | diamond | 72 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 31510459 | 31510459 | PRJNA934472_P_NODE_33756_length_256_cov_1.508197_g33378_i0 | PRJNA934472 | 33756 | 256 | 1.508197 | 3.86098432 | Psammomys obesus | 48139 | Chordata | Chordata | 45.1 | 0.00645 | NR | XP_055469103.1 | 48139 | g33378 | i0 | 41.7 | 0.5625 | 48 | 25 | 52.7 | 1 | 196 | 62 | 50 | 97 | XP_055469103.1 diacylglycerol kinase alpha-like isoform X1 [Psammomys obesus] | diamond | 144 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Psammomys | Psammomys obesus | |
| 31573740 | 31573740 | PRJNA934472_P_NODE_20536_length_321_cov_2.366935_g20159_i0 | PRJNA934472 | 20536 | 321 | 2.366935 | 7.59786135 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 70.5 | 1.18e-11 | NR | XP_051791274.1 | 27687 | g20159 | i0 | 73.5 | 2.80373831775701 | 49 | 12 | 44.9 | 1 | 203 | 60 | 156 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 900 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 32396218 | 32396218 | PRJNA934472_P_NODE_38799_length_241_cov_1.380952_g38421_i0 | PRJNA934472 | 38799 | 241 | 1.380952 | 3.32809432 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 43.5 | 0.0063 | NR | KAF6435704.1 | 9407 | g38421 | i0 | 61.3 | 0.385892116182573 | 31 | 12 | 38.6 | 0 | 145 | 237 | 1 | 31 | KAF6435704.1 hypothetical protein HJG63_012462 [Rousettus aegyptiacus] | diamond | 93 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 32522977 | 32522977 | PRJNA934472_P_NODE_13139_length_394_cov_1.289720_g12762_i0 | PRJNA934472 | 13139 | 394 | 1.28972 | 5.0814968 | Apodemus speciosus | 105296 | Chordata | Chordata | 46.2 | 0.0112 | NR | GAB1298786.1 | 105296 | g12762 | i0 | 56.8 | 0.33502538071066 | 44 | 19 | 33.5 | 0 | 139 | 8 | 441 | 484 | GAB1298786.1 AP-5 complex subunit mu-1 [Apodemus speciosus] | diamond | 132 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 32522978 | 32522978 | PRJNA934472_P_NODE_31759_length_264_cov_1.445026_g31381_i0 | PRJNA934472 | 31759 | 264 | 1.445026 | 3.81486864 | Cricetulus griseus | 10029 | Chordata | Chordata | 40.4 | 0.0474 | NR | EGW04989.1 | 10029 | g31381 | i0 | 43.4 | 0.602272727272727 | 53 | 29 | 59.1 | 1 | 183 | 28 | 5 | 57 | EGW04989.1 hypothetical protein I79_003494 [Cricetulus griseus] | diamond | 159 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 32586059 | 32586059 | PRJNA934472_P_NODE_34539_length_253_cov_1.750000_g34161_i0 | PRJNA934472 | 34539 | 253 | 1.75 | 4.4275 | Cricetulus griseus | 10029 | Chordata | Chordata | 56.2 | 6.38e-7 | NR | XP_035315827.1 | 10029 | g34161 | i0 | 47.2 | 1.05533596837945 | 89 | 31 | 99.6 | 4 | 253 | 2 | 78 | 155 | XP_035315827.1 caskin-2-like [Cricetulus griseus] | diamond | 267 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 32680060 | 32680060 | PRJNA934472_P_NODE_13460_length_389_cov_3.658228_g13083_i0 | PRJNA934472 | 13460 | 389 | 3.658228 | 14.23050692 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0322 | NR | KAG2471189.1 | 55291 | g13083 | i0 | 57.1 | 0.269922879177378 | 35 | 15 | 27 | 0 | 188 | 84 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus |
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);;