contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA436017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10634799 | 10634799 | PRJNA436017_P_NODE_2929_length_548_cov_2.426614_g2657_i0 | PRJNA436017 | 2929 | 548 | 2.426614 | 13.29784472 | Charadrius vociferus | 50402 | Chordata | Chordata | 186 | 2.4799999999999994e-54 | NR | XP_009892706.1 | 50402 | g2657 | i0 | 68.9 | 32.8138686131387 | 151 | 43 | 82.7 | 1 | 547 | 95 | 228 | 374 | XP_009892706.1 PREDICTED: uncharacterized protein LOC104294757 [Charadrius vociferus] | diamond | 17982 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Charadriidae | Charadrius | Charadrius vociferus | |
| 26886203 | 26886203 | PRJNA436017_P_NODE_22841_length_171_cov_1.149254_g22543_i0 | PRJNA436017 | 22841 | 171 | 1.149254 | 1.96522434 | Ranitomeya imitator | 111125 | Chordata | Chordata | 59.7 | 1.27e-8 | NR | XP_069595228.1 | 111125 | g22543 | i0 | 52.7 | 0.964912280701754 | 55 | 26 | 96.5 | 0 | 170 | 6 | 211 | 265 | XP_069595228.1 very-long-chain 3-oxoacyl-CoA reductase [Ranitomeya imitator] | diamond | 165 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 27328839 | 27328839 | PRJNA436017_P_NODE_28823_length_152_cov_1.330435_g28525_i0 | PRJNA436017 | 28823 | 152 | 1.330435 | 2.0222612 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 74.3 | 8.48e-15 | NR | CAD7688934.1 | 34880 | g28525 | i0 | 62 | 8.8421052631579 | 50 | 19 | 98.7 | 0 | 152 | 3 | 6 | 55 | CAD7688934.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 1344 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 27692778 | 27692778 | PRJNA436017_P_NODE_5764_length_374_cov_2.824926_g5468_i0 | PRJNA436017 | 5764 | 374 | 2.824926 | 10.56522324 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.7 | 1.08e-19 | NR | CAL5930649.1 | 7748 | g5468 | i0 | 51.5 | 5.8475935828877 | 97 | 46 | 77 | 1 | 290 | 3 | 136 | 232 | CAL5930649.1 unnamed protein product [Lampetra fluviatilis] | diamond | 2187 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 27833854 | 27833854 | PRJNA436017_P_NODE_12524_length_238_cov_7.880597_g12226_i0 | PRJNA436017 | 12524 | 238 | 7.880597 | 18.75582086 | Bufotes viridis | 30338 | Chordata | Chordata | 42.4 | 0.0466 | NR | CAK8629749.1 | 30338 | g12226 | i0 | 48.6 | 0.441176470588235 | 35 | 18 | 44.1 | 0 | 23 | 127 | 329 | 363 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 105 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28734506 | 28734506 | PRJNA436017_P_NODE_7947_length_314_cov_1.512635_g7650_i0 | PRJNA436017 | 7947 | 314 | 1.512635 | 4.7496739 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.8 | 2.1e-6 | NR | XP_002121122.3 | 7719 | g7650 | i0 | 39.6 | 1.76751592356688 | 91 | 53 | 86.9 | 1 | 2 | 274 | 447 | 535 | XP_002121122.3 acyloxyacyl hydrolase-like [Ciona intestinalis] | diamond | 555 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 29271001 | 29271001 | PRJNA436017_P_NODE_23309_length_169_cov_1.181818_g23011_i0 | PRJNA436017 | 23309 | 169 | 1.181818 | 1.99727242 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.4 | 2.76e-11 | NR | XP_061852563.1 | 57412 | g23011 | i0 | 56.6 | 7.54437869822485 | 53 | 22 | 94.1 | 1 | 159 | 1 | 188 | 239 | XP_061852563.1 acyloxyacyl hydrolase isoform X2 [Colius striatus] | diamond | 1275 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Coliiformes | Coliidae | Colius | Colius striatus | |
| 29839504 | 29839504 | PRJNA436017_P_NODE_15511_length_210_cov_1.791908_g15213_i0 | PRJNA436017 | 15511 | 210 | 1.791908 | 3.7630068 | Opisthokonta | 33154 | Chordata | Chordata | 45.4 | 0.00268 | NR | XP_053545809.1 | 8345 | g15213 | i0 | 39.7 | 3.92857142857143 | 68 | 31 | 97.1 | 1 | 3 | 206 | 126 | 183 | XP_053545809.1 tetratricopeptide repeat protein 12 [Bombina bombina] | diamond | 825 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 30201974 | 30201974 | PRJNA436017_P_NODE_23072_length_170_cov_1.172932_g22774_i0 | PRJNA436017 | 23072 | 170 | 1.172932 | 1.9939844 | Pelobates cultripes | 61616 | Chordata | Chordata | 59.3 | 4.98e-9 | NR | CAH2325358.1 | 61616 | g22774 | i0 | 53.6 | 6.17647058823529 | 56 | 24 | 95.3 | 1 | 7 | 168 | 51 | 106 | CAH2325358.1 60S acidic ribosomal P2 [Pelobates cultripes] | diamond | 1050 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pelobatidae | Pelobates | Pelobates cultripes | |
| 30518165 | 30518165 | PRJNA436017_P_NODE_24893_length_163_cov_2.674603_g24595_i0 | PRJNA436017 | 24893 | 163 | 2.674603 | 4.35960289 | Bufotes viridis | 30338 | Chordata | Chordata | 42.7 | 0.0128 | NR | CAK8629749.1 | 30338 | g24595 | i0 | 62.1 | 0.533742331288344 | 29 | 11 | 53.4 | 0 | 59 | 145 | 336 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 87 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30897497 | 30897497 | PRJNA436017_P_NODE_24554_length_165_cov_0.906250_g24256_i0 | PRJNA436017 | 24554 | 165 | 0.90625 | 1.4953125 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 41.2 | 0.0459 | NR | XP_019615944.1 | 7741 | g24256 | i0 | 44.2 | 0.945454545454545 | 52 | 29 | 94.5 | 0 | 157 | 2 | 661 | 712 | XP_019615944.1 PREDICTED: LOW QUALITY PROTEIN: ankyrin and armadillo repeat-containing protein-like [Branchiostoma belcheri] | diamond | 156 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 32495254 | 32495254 | PRJNA436017_P_NODE_20299_length_181_cov_1.895833_g20001_i0 | PRJNA436017 | 20299 | 181 | 1.895833 | 3.43145773 | Squamata | 8509 | Chordata | Chordata | 41.6 | 0.0422 | NR | XP_026547189.1 | 8663 | g20001 | i0 | 61.3 | 1.5414364640884 | 31 | 12 | 51.4 | 0 | 2 | 94 | 246 | 276 | XP_026547189.1 dynamin-1, partial [Notechis scutatus] | diamond | 279 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Notechis | Notechis scutatus | |
| 32605085 | 32605085 | PRJNA436017_P_NODE_19220_length_187_cov_0.920000_g18922_i0 | PRJNA436017 | 19220 | 187 | 0.92 | 1.7204 | Antrostomus carolinensis | 279965 | Chordata | Chordata | 41.2 | 0.0448 | NR | KFZ56356.1 | 279965 | g18922 | i0 | 48.7 | 0.625668449197861 | 39 | 20 | 62.6 | 0 | 172 | 56 | 50 | 88 | KFZ56356.1 Coiled-coil domain-containing protein 137, partial [Antrostomus carolinensis] | diamond | 117 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Caprimulgiformes | Caprimulgidae | Antrostomus | Antrostomus carolinensis |
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);;