contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3961255 | 3961255 | PRJEB73599_P_NODE_1784_length_555_cov_3.891635_g1548_i0 | PRJEB73599 | 1784 | 555 | 3.891635 | 21.59857425 | Opisthokonta | 33154 | Chordata | Chordata | 305 | 3.9999999999999993e-103 | NR | XP_035672114.1 | 7739 | g1548 | i0 | 85.4 | 16.8972972972973 | 164 | 24 | 88.6 | 0 | 528 | 37 | 37 | 200 | XP_035672114.1 peptidyl-prolyl cis-trans isomerase-like [Branchiostoma floridae] | diamond | 9378 | 308 | 0.99025974025974 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 21811943 | 21811943 | PRJEB73599_P_NODE_3758_length_360_cov_5.942598_g3472_i0 | PRJEB73599 | 3758 | 360 | 5.942598 | 21.3933528 | Opisthokonta | 33154 | Chordata | Chordata | 161 | 6.69e-46 | NR | XP_021036129.1 | 10089 | g3472 | i0 | 78.9 | 564.5 | 109 | 21 | 89.2 | 1 | 2 | 322 | 230 | 338 | XP_021036129.1 uncharacterized protein LOC110308115 [Mus caroli] | diamond | 203220 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus caroli | |
| 28076331 | 28076331 | PRJEB73599_P_NODE_345_length_1239_cov_2.834711_g269_i0 | PRJEB73599 | 345 | 1239 | 2.834711 | 35.12206929 | Ciona intestinalis | 7719 | Chordata | Chordata | 282 | 1.3299999999999995e-82 | NR | XP_026693114.1 | 7719 | g269 | i0 | 43.3 | 1.34140435835351 | 277 | 156 | 67.1 | 1 | 187 | 1017 | 561 | 836 | XP_026693114.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Ciona intestinalis] | diamond | 1662 | 282 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 29048176 | 29048176 | PRJEB73599_P_NODE_1208_length_683_cov_2.463303_g1017_i0 | PRJEB73599 | 1208 | 683 | 2.463303 | 16.82435949 | Mammalia | 40674 | Chordata | Chordata | 153 | 2.5899999999999998e-42 | NR | XP_045843934.1 | 9662 | g1017 | i0 | 50.3 | 27.1581259150805 | 155 | 77 | 68.1 | 0 | 550 | 86 | 63 | 217 | XP_045843934.1 60S ribosomal protein L13a isoform X1 [Meles meles] | diamond | 18549 | 154 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 29869006 | 29869006 | PRJEB73599_P_NODE_4011_length_345_cov_2.420886_g3724_i0 | PRJEB73599 | 4011 | 345 | 2.420886 | 8.3520567 | Cervidae | 9850 | Chordata | Chordata | 187 | 9.019999999999998e-56 | NR | OWK11568.1 | 46360 | g3724 | i0 | 70.4 | 12.0869565217391 | 125 | 25 | 98.3 | 1 | 341 | 3 | 68 | 192 | OWK11568.1 hypothetical protein Celaphus_00003504 [Cervus elaphus hippelaphus] | diamond | 4170 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 29907926 | 29907926 | PRJEB73599_P_NODE_351_length_1230_cov_2.837635_g269_i1 | PRJEB73599 | 351 | 1230 | 2.837635 | 34.9029105 | Ciona intestinalis | 7719 | Chordata | Chordata | 282 | 1.2099999999999999e-82 | NR | XP_026693114.1 | 7719 | g269 | i1 | 43.3 | 1.35121951219512 | 277 | 156 | 67.6 | 1 | 1011 | 181 | 561 | 836 | XP_026693114.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Ciona intestinalis] | diamond | 1662 | 282 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 29939517 | 29939517 | PRJEB73599_P_NODE_4211_length_333_cov_2.305921_g3924_i0 | PRJEB73599 | 4211 | 333 | 2.305921 | 7.67871693 | Staurois parvus | 386267 | Chordata | Chordata | 59.7 | 2.24e-9 | NR | CAI9620946.1 | 386267 | g3924 | i0 | 70.3 | 0.333333333333333 | 37 | 11 | 33.3 | 0 | 135 | 245 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30950599 | 30950599 | PRJEB73599_P_NODE_1374_length_637_cov_2.468750_g1017_i1 | PRJEB73599 | 1374 | 637 | 2.46875 | 15.7259375 | Capra hircus | 9925 | Chordata | Chordata | 157 | 1.53e-41 | NR | XDB60276.1 | 9925 | g1017 | i1 | 42.8 | 17.1522762951334 | 194 | 93 | 82.9 | 1 | 25 | 552 | 296 | 489 | XDB60276.1 hypothetical protein ABFV05_013892 [Capra hircus] | diamond | 10926 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 32240115 | 32240115 | PRJEB73599_P_NODE_7298_length_210_cov_2.055249_g7011_i0 | PRJEB73599 | 7298 | 210 | 2.055249 | 4.3160229 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 2.41e-12 | NR | XP_035687608.1 | 7739 | g7011 | i0 | 43.8 | 5.82857142857143 | 73 | 34 | 95.7 | 2 | 5 | 205 | 197 | 268 | XP_035687608.1 EGF-like repeat and discoidin I-like domain-containing protein 3 [Branchiostoma floridae] | diamond | 1224 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae |
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);;