contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA922890" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26620339 | 26620339 | PRJNA922890_P_NODE_84981_length_193_cov_4.290323_g84571_i0 | PRJNA922890 | 84981 | 193 | 4.290323 | 8.28032339 | root | 1 | Root_unresolved | Root_unresolved | 130 | 1.6100000000000002e-33 | NR | XP_030109804.2 | 10090 | g84571 | i0 | 95.2 | 11.7512953367876 | 63 | 3 | 97.9 | 0 | 3 | 191 | 93 | 155 | XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] | diamond | 2268 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27126317 | 27126317 | PRJNA922890_P_NODE_57622_length_257_cov_2.702128_g57212_i0 | PRJNA922890 | 57622 | 257 | 2.702128 | 6.94446896 | root | 1 | Root_unresolved | Root_unresolved | 177 | 1.25e-50 | NR | XP_030110853.2 | 10090 | g57212 | i0 | 100 | 15.875486381323 | 85 | 0 | 99.2 | 0 | 3 | 257 | 137 | 221 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 4080 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27695658 | 27695658 | PRJNA922890_P_NODE_63024_length_245_cov_1.284091_g62614_i0 | PRJNA922890 | 63024 | 245 | 1.284091 | 3.14602295 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.0373 | NR | KAJ1194836.1 | 8319 | g62614 | i0 | 47.1 | 1.0530612244898 | 51 | 27 | 62.4 | 0 | 183 | 31 | 44 | 94 | KAJ1194836.1 hypothetical protein NDU88_004121 [Pleurodeles waltl] | diamond | 258 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 27845826 | 27845826 | PRJNA922890_P_NODE_76904_length_231_cov_0.901235_g76494_i0 | PRJNA922890 | 76904 | 231 | 0.901235 | 2.08185285 | Cricetulus griseus | 10029 | Chordata | Chordata | 46.6 | 0.00135 | NR | ERE67235.1 | 10029 | g76494 | i0 | 41 | 0.792207792207792 | 61 | 30 | 77.9 | 2 | 50 | 229 | 190 | 245 | ERE67235.1 MMP37-like protein [Cricetulus griseus] | diamond | 183 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 28098483 | 28098483 | PRJNA922890_P_NODE_67265_length_237_cov_0.869048_g66855_i0 | PRJNA922890 | 67265 | 237 | 0.869048 | 2.05964376 | Apodemus speciosus | 105296 | Chordata | Chordata | 44.7 | 0.00715 | NR | GAB1297857.1 | 105296 | g66855 | i0 | 61.5 | 0.493670886075949 | 39 | 14 | 49.4 | 1 | 186 | 70 | 1 | 38 | GAB1297857.1 Ig alpha chain C region [Apodemus speciosus] | diamond | 117 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 28509083 | 28509083 | PRJNA922890_P_NODE_72867_length_233_cov_0.890244_g72457_i0 | PRJNA922890 | 72867 | 233 | 0.890244 | 2.07426852 | Stegostoma tigrinum | 3053191 | Chordata | Chordata | 60.5 | 1.85e-8 | NR | XP_048415584.1 | 3053191 | g72457 | i0 | 100 | 1.80257510729614 | 28 | 0 | 36.1 | 0 | 233 | 150 | 830 | 857 | XP_048415584.1 elongation factor 2 [Stegostoma tigrinum] | diamond | 420 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Stegostomatidae | Stegostoma | Stegostoma tigrinum | |
| 29084752 | 29084752 | PRJNA922890_P_NODE_81688_length_229_cov_0.900000_g81278_i0 | PRJNA922890 | 81688 | 229 | 0.9 | 2.061 | Mammalia | 40674 | Chordata | Chordata | 43.9 | 0.0125 | NR | XP_046289624.2 | 9995 | g81278 | i0 | 98.7 | 5.97379912663755 | 76 | 1 | 99.6 | 0 | 2 | 229 | 266 | 341 | XP_046289624.2 DNA topoisomerase 1 [Marmota monax] | diamond | 1368 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 29109096 | 29109096 | PRJNA922890_P_NODE_74808_length_232_cov_0.895706_g74398_i0 | PRJNA922890 | 74808 | 232 | 0.895706 | 2.07803792 | Gymnogyps californianus | 33616 | Chordata | Chordata | 58.5 | 1.32e-8 | NR | XP_050758470.1 | 33616 | g74398 | i0 | 89.7 | 1.875 | 29 | 3 | 37.5 | 0 | 232 | 146 | 113 | 141 | XP_050758470.1 ras-related protein Rap-2b isoform X2 [Gymnogyps californianus] | diamond | 435 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Accipitriformes | Cathartidae | Gymnogyps | Gymnogyps californianus | |
| 29771810 | 29771810 | PRJNA922890_P_NODE_61131_length_249_cov_1.622222_g60721_i0 | PRJNA922890 | 61131 | 249 | 1.622222 | 4.03933278 | Rattus norvegicus | 10116 | Chordata | Chordata | 107 | 5.33e-28 | NR | EDL89811.1 | 10116 | g60721 | i0 | 100 | 0.530120481927711 | 44 | 0 | 53 | 0 | 133 | 2 | 1 | 44 | EDL89811.1 dehydrogenase/reductase (SDR family) X chromosome (predicted), isoform CRA_d [Rattus norvegicus] | diamond | 132 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 30158088 | 30158088 | PRJNA922890_P_NODE_25432_length_377_cov_2.350649_g25022_i0 | PRJNA922890 | 25432 | 377 | 2.350649 | 8.86194673 | Mammalia | 40674 | Chordata | Chordata | 251 | 2.87e-75 | NR | XP_038625183.1 | 9261 | g25022 | i0 | 98.4 | 69.6286472148541 | 125 | 2 | 99.5 | 0 | 377 | 3 | 196 | 320 | XP_038625183.1 nuclear factor NF-kappa-B p105 subunit [Tachyglossus aculeatus] | diamond | 26250 | 252 | 0.996031746031746 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Tachyglossidae | Tachyglossus | Tachyglossus aculeatus | |
| 30561532 | 30561532 | PRJNA922890_P_NODE_81853_length_229_cov_0.900000_g81443_i0 | PRJNA922890 | 81853 | 229 | 0.9 | 2.061 | Cnephaeus nilssonii | 3371016 | Chordata | Chordata | 42.7 | 0.0319 | NR | KAK1343539.1 | 3371016 | g81443 | i0 | 38.5 | 0.851528384279476 | 65 | 35 | 78.6 | 1 | 204 | 25 | 597 | 661 | KAK1343539.1 hypothetical protein QTO34_016319 [Cnephaeus nilssonii] | diamond | 195 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Cnephaeus | Cnephaeus nilssonii | |
| 31098764 | 31098764 | PRJNA922890_P_NODE_78075_length_231_cov_0.888889_g77665_i0 | PRJNA922890 | 78075 | 231 | 0.888889 | 2.05333359 | Eschrichtius robustus | 9764 | Chordata | Chordata | 44.3 | 0.00691 | NR | KAJ8795024.1 | 9764 | g77665 | i0 | 56.1 | 0.532467532467532 | 41 | 18 | 53.2 | 0 | 229 | 107 | 160 | 200 | KAJ8795024.1 hypothetical protein J1605_018611 [Eschrichtius robustus] | diamond | 123 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 31130220 | 31130220 | PRJNA922890_P_NODE_61655_length_248_cov_1.418994_g61245_i0 | PRJNA922890 | 61655 | 248 | 1.418994 | 3.51910512 | Eschrichtius robustus | 9764 | Chordata | Chordata | 43.1 | 0.0174 | NR | KAJ8792181.1 | 9764 | g61245 | i0 | 34.6 | 1.28225806451613 | 78 | 46 | 88.3 | 1 | 248 | 30 | 5 | 82 | KAJ8792181.1 hypothetical protein J1605_020032 [Eschrichtius robustus] | diamond | 318 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 31643583 | 31643583 | PRJNA922890_P_NODE_67916_length_236_cov_0.874251_g67506_i0 | PRJNA922890 | 67916 | 236 | 0.874251 | 2.06323236 | Mammalia | 40674 | Chordata | Chordata | 55.5 | 1.06e-6 | NR | XP_045155269.1 | 9371 | g67506 | i0 | 100 | 32.7966101694915 | 30 | 0 | 38.1 | 0 | 236 | 147 | 332 | 361 | XP_045155269.1 26S proteasome non-ATPase regulatory subunit 3 [Echinops telfairi] | diamond | 7740 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Tenrecidae | Echinops | Echinops telfairi |
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);;