contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3320401 | 3320401 | PRJNA788929_P_NODE_1603_length_1660_cov_38.093258_g1396_i0 | PRJNA788929 | 1603 | 1660 | 38.093258 | 632.3480828 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 422 | 3.8e-139 | NR | XP_019614975.1 | 7741 | g1396 | i0 | 47 | 8.62590361445783 | 485 | 249 | 86.7 | 6 | 1606 | 167 | 1 | 482 | XP_019614975.1 PREDICTED: protein disulfide-isomerase-like isoform X2 [Branchiostoma belcheri] | diamond | 14319 | 426 | 0.990610328638498 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 5873064 | 5873064 | PRJNA788929_P_NODE_4085_length_1010_cov_213.812166_g3595_i0 | PRJNA788929 | 4085 | 1010 | 213.812166 | 2159.5028766 | Petromyzon marinus | 7757 | Chordata | Chordata | 283 | 6.46e-91 | NR | XP_032831682.1 | 7757 | g3595 | i0 | 57.5 | 11.3851485148515 | 259 | 107 | 76.3 | 2 | 70 | 840 | 1 | 258 | XP_032831682.1 40S ribosomal protein S3a [Petromyzon marinus] | diamond | 11499 | 285 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 15242567 | 15242567 | PRJNA788929_P_NODE_17252_length_399_cov_34.708589_g16593_i0 | PRJNA788929 | 17252 | 399 | 34.708589 | 138.48727011 | Metazoa | 33208 | Chordata | Chordata | 131 | 9.999999999999999e-33 | NR | XP_043553952.1 | 36176 | g16593 | i0 | 62 | 20.8947368421053 | 108 | 41 | 81.2 | 0 | 325 | 2 | 3 | 110 | XP_043553952.1 diphthine--ammonia ligase isoform X2 [Chiloscyllium plagiosum] | diamond | 8337 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Hemiscylliidae | Chiloscyllium | Chiloscyllium plagiosum | |
| 26714422 | 26714422 | PRJNA788929_P_NODE_49261_length_203_cov_5.923077_g48600_i0 | PRJNA788929 | 49261 | 203 | 5.923077 | 12.02384631 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.4 | 5.14e-4 | NR | XP_040189257.1 | 8407 | g48600 | i0 | 54.1 | 8.68965517241379 | 37 | 17 | 54.7 | 0 | 201 | 91 | 582 | 618 | XP_040189257.1 heat shock-related 70 kDa protein 2 isoform X1 [Rana temporaria] | diamond | 1764 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 26736769 | 26736769 | PRJNA788929_P_NODE_7001_length_716_cov_59.345257_g6370_i0 | PRJNA788929 | 7001 | 716 | 59.345257 | 424.91204012 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 69.3 | 1.58e-9 | NR | CAK8691441.1 | 159417 | g6370 | i0 | 41 | 1.21508379888268 | 100 | 51 | 41.9 | 2 | 140 | 439 | 435 | 526 | CAK8691441.1 unnamed protein product [Clavelina lepadiformis] | diamond | 870 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 28515758 | 28515758 | PRJNA788929_P_NODE_2967_length_1215_cov_42.215412_g2589_i0 | PRJNA788929 | 2967 | 1215 | 42.215412 | 512.9172558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 249 | 1.14e-72 | NR | XP_035676518.1 | 7739 | g2589 | i0 | 42.7 | 5.36543209876543 | 314 | 175 | 76.8 | 3 | 152 | 1084 | 25 | 336 | XP_035676518.1 uncharacterized protein LOC118415774 [Branchiostoma floridae] | diamond | 6519 | 250 | 0.996 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 28705245 | 28705245 | PRJNA788929_P_NODE_40387_length_245_cov_12.982558_g39726_i0 | PRJNA788929 | 40387 | 245 | 12.982558 | 31.8072671 | Metazoa | 33208 | Chordata | Chordata | 60.8 | 8.64e-9 | NR | XP_026721565.1 | 194338 | g39726 | i0 | 61.7 | 2.43673469387755 | 47 | 18 | 57.6 | 0 | 88 | 228 | 53 | 99 | XP_026721565.1 peptidyl-prolyl cis-trans isomerase C [Athene cunicularia] | diamond | 597 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Strigiformes | Strigidae | Athene | Athene cunicularia | |
| 29201240 | 29201240 | PRJNA788929_P_NODE_15089_length_433_cov_22.975000_g14430_i0 | PRJNA788929 | 15089 | 433 | 22.975 | 99.48175 | Echinops telfairi | 9371 | Chordata | Chordata | 44.7 | 0.0464 | NR | XP_004710168.2 | 9371 | g14430 | i0 | 30.3 | 0.755196304849885 | 109 | 59 | 74.1 | 4 | 386 | 66 | 122 | 215 | XP_004710168.2 ankyrin repeat domain-containing protein SOWAHD [Echinops telfairi] | diamond | 327 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Tenrecidae | Echinops | Echinops telfairi | ||
| 29241901 | 29241901 | PRJNA788929_P_NODE_2909_length_1225_cov_43.783854_g2535_i0 | PRJNA788929 | 2909 | 1225 | 43.783854 | 536.3522115 | Chordata | 7711 | Chordata | Chordata | 111 | 5.409999999999999e-23 | NR | XP_016006122.2 | 9407 | g2535 | i0 | 61.1 | 6.28897959183673 | 95 | 27 | 20.8 | 2 | 360 | 106 | 296 | 390 | XP_016006122.2 tRNA (cytosine(38)-C(5))-methyltransferase isoform X2 [Rousettus aegyptiacus] | diamond | 7704 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 30022269 | 30022269 | PRJNA788929_P_NODE_16011_length_418_cov_12.701449_g15352_i0 | PRJNA788929 | 16011 | 418 | 12.701449 | 53.09205682 | Dendropsophus ebraccatus | 150705 | Chordata | Chordata | 47.8 | 0.00421 | NR | XP_069840101.1 | 150705 | g15352 | i0 | 33.8 | 0.997607655502392 | 65 | 38 | 43.1 | 1 | 235 | 414 | 26 | 90 | XP_069840101.1 transcription factor E4F1 isoform X1 [Dendropsophus ebraccatus] | diamond | 417 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Dendropsophus | Dendropsophus ebraccatus | |
| 30148277 | 30148277 | PRJNA788929_P_NODE_13132_length_474_cov_19.448878_g12475_i0 | PRJNA788929 | 13132 | 474 | 19.448878 | 92.18768172 | Heteronotia binoei | 13085 | Chordata | Chordata | 62.4 | 2.09e-9 | NR | XP_060092830.1 | 13085 | g12475 | i0 | 37.3 | 1.05063291139241 | 83 | 52 | 52.5 | 0 | 378 | 130 | 13 | 95 | XP_060092830.1 cystatin-A-like [Heteronotia binoei] | diamond | 498 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Heteronotia | Heteronotia binoei | |
| 30496181 | 30496181 | PRJNA788929_P_NODE_43793_length_235_cov_7.969136_g43132_i0 | PRJNA788929 | 43793 | 235 | 7.969136 | 18.7274696 | Protopterus annectens | 7888 | Chordata | Chordata | 53.9 | 1.55e-6 | NR | XP_043937589.1 | 7888 | g43132 | i0 | 66.7 | 1.26382978723404 | 33 | 11 | 42.1 | 0 | 214 | 116 | 148 | 180 | XP_043937589.1 sepiapterin reductase [Protopterus annectens] | diamond | 297 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 32361855 | 32361855 | PRJNA788929_P_NODE_13379_length_468_cov_77.939241_g12722_i0 | PRJNA788929 | 13379 | 468 | 77.939241 | 364.75564788 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 94 | 1.04e-21 | NR | KAJ7320054.1 | 171643 | g12722 | i0 | 46.9 | 0.628205128205128 | 98 | 52 | 62.8 | 0 | 75 | 368 | 1 | 98 | KAJ7320054.1 hypothetical protein JRQ81_019565 [Phrynocephalus forsythii] | diamond | 294 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii |
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);;