contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA495391" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10679637 | 10679637 | PRJNA495391_S_NODE_23129_length_250_cov_1.902326_g22077_i0 | PRJNA495391 | 23129 | 250 | 1.902326 | 4.755815 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 7.39e-38 | NR | XP_035672114.1 | 7739 | g22077 | i0 | 85.7 | 14.268 | 70 | 10 | 84 | 0 | 250 | 41 | 131 | 200 | XP_035672114.1 peptidyl-prolyl cis-trans isomerase-like [Branchiostoma floridae] | diamond | 3567 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 19601899 | 19601899 | PRJNA495391_S_NODE_21976_length_256_cov_2.004525_g20924_i0 | PRJNA495391 | 21976 | 256 | 2.004525 | 5.131584 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 85.5 | 4.07e-17 | NR | CAK8685090.1 | 159417 | g20924 | i0 | 50 | 1.96875 | 84 | 41 | 98.4 | 1 | 1 | 252 | 688 | 770 | CAK8685090.1 unnamed protein product [Clavelina lepadiformis] | diamond | 504 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 26982067 | 26982067 | PRJNA495391_S_NODE_31322_length_217_cov_1.587912_g30270_i0 | PRJNA495391 | 31322 | 217 | 1.587912 | 3.44576904 | Passer domesticus | 48849 | Chordata | Chordata | 73.6 | 3.52e-13 | NR | XP_064281669.1 | 48849 | g30270 | i0 | 57.1 | 21.9400921658986 | 63 | 21 | 87.1 | 1 | 21 | 209 | 375 | 431 | XP_064281669.1 pseudouridylate synthase RPUSD2 [Passer domesticus] | diamond | 4761 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Passeridae | Passer | Passer domesticus | |
| 27709236 | 27709236 | PRJNA495391_S_NODE_47824_length_178_cov_2.321678_g46772_i0 | PRJNA495391 | 47824 | 178 | 2.321678 | 4.13258684 | Bambusicola thoracicus | 9083 | Chordata | Chordata | 93.6 | 5.21e-22 | NR | POI30389.1 | 9083 | g46772 | i0 | 69.5 | 0.99438202247191 | 59 | 17 | 97.8 | 1 | 178 | 5 | 26 | 84 | POI30389.1 hypothetical protein CIB84_005861 [Bambusicola thoracicus] | diamond | 177 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Bambusicola | Bambusicola thoracicus | |
| 27866526 | 27866526 | PRJNA495391_S_NODE_58225_length_163_cov_2.023438_g57173_i0 | PRJNA495391 | 58225 | 163 | 2.023438 | 3.29820394 | Myotis myotis | 51298 | Chordata | Chordata | 42 | 0.0228 | NR | KAF6303689.1 | 51298 | g57173 | i0 | 54.8 | 0.570552147239264 | 31 | 13 | 57.1 | 1 | 3 | 95 | 274 | 303 | KAF6303689.1 DnaJ heat shock protein family (Hsp40) member C9 [Myotis myotis] | diamond | 93 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 28087533 | 28087533 | PRJNA495391_S_NODE_12485_length_339_cov_2.226974_g11433_i0 | PRJNA495391 | 12485 | 339 | 2.226974 | 7.54944186 | Bos mutus | 72004 | Chordata | Chordata | 149 | 6.2899999999999986e-40 | NR | MXQ84838.1 | 72004 | g11433 | i0 | 92.5 | 0.707964601769911 | 80 | 6 | 70.8 | 0 | 339 | 100 | 46 | 125 | MXQ84838.1 hypothetical protein [Bos mutus] | diamond | 240 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus | |
| 28782106 | 28782106 | PRJNA495391_S_NODE_11647_length_351_cov_1.949367_g10595_i0 | PRJNA495391 | 11647 | 351 | 1.949367 | 6.84227817 | Cervus canadensis | 1574408 | Chordata | Chordata | 163 | 8.069999999999999e-47 | NR | XP_043291415.1 | 1574408 | g10595 | i0 | 71 | 3.1965811965812 | 93 | 27 | 79.5 | 0 | 349 | 71 | 248 | 340 | XP_043291415.1 zinc finger protein 90 homolog isoform X3 [Cervus canadensis] | diamond | 1122 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus canadensis | |
| 29224616 | 29224616 | PRJNA495391_S_NODE_53729_length_169_cov_2.067164_g52677_i0 | PRJNA495391 | 53729 | 169 | 2.067164 | 3.49350716 | Chroicocephalus ridibundus | 1192867 | Chordata | Chordata | 41.2 | 0.0497 | NR | XP_063187770.1 | 1192867 | g52677 | i0 | 56.7 | 0.532544378698225 | 30 | 13 | 53.3 | 0 | 56 | 145 | 43 | 72 | XP_063187770.1 coiled-coil domain-containing protein 177 [Chroicocephalus ridibundus] | diamond | 90 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Laridae | Chroicocephalus | Chroicocephalus ridibundus | |
| 29555479 | 29555479 | PRJNA495391_S_NODE_66570_length_154_cov_1.848739_g65518_i0 | PRJNA495391 | 66570 | 154 | 1.848739 | 2.84705806 | Opisthokonta | 33154 | Chordata | Chordata | 81.3 | 2.56e-16 | NR | XP_043937132.1 | 7888 | g65518 | i0 | 69.4 | 6.72077922077922 | 49 | 15 | 95.5 | 0 | 152 | 6 | 17 | 65 | XP_043937132.1 tubulin alpha-8 chain-like [Protopterus annectens] | diamond | 1035 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 30645471 | 30645471 | PRJNA495391_S_NODE_14833_length_311_cov_1.300725_g13781_i0 | PRJNA495391 | 14833 | 311 | 1.300725 | 4.04525475 | Anolis carolinensis | 28377 | Chordata | Chordata | 94.7 | 2.48e-21 | NR | XP_008122103.1 | 28377 | g13781 | i0 | 69.2 | 0.627009646302251 | 65 | 20 | 62.7 | 0 | 210 | 16 | 81 | 145 | XP_008122103.1 protein GVQW3 [Anolis carolinensis] | diamond | 195 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dactyloidae | Anolis | Anolis carolinensis | |
| 30724381 | 30724381 | PRJNA495391_S_NODE_53354_length_170_cov_1.340741_g52302_i0 | PRJNA495391 | 53354 | 170 | 1.340741 | 2.2792597 | Metazoa | 33208 | Chordata | Chordata | 55.5 | 3.64e-8 | NR | XP_064418531.1 | 7897 | g52302 | i0 | 55.6 | 4.94117647058824 | 45 | 17 | 79.4 | 1 | 165 | 31 | 55 | 96 | XP_064418531.1 cathepsin K-like [Latimeria chalumnae] | diamond | 840 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 32290368 | 32290368 | PRJNA495391_S_NODE_49139_length_176_cov_1.964539_g48087_i0 | PRJNA495391 | 49139 | 176 | 1.964539 | 3.45758864 | Myxine glutinosa | 7769 | Chordata | Chordata | 102 | 1.13e-23 | NR | XP_067956421.1 | 7769 | g48087 | i0 | 82.8 | 0.988636363636364 | 58 | 10 | 98.9 | 0 | 3 | 176 | 191 | 248 | XP_067956421.1 inositol-3-phosphate synthase 1-A-like isoform X2 [Myxine glutinosa] | diamond | 174 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 32700510 | 32700510 | PRJNA495391_S_NODE_52440_length_171_cov_1.750000_g51388_i0 | PRJNA495391 | 52440 | 171 | 1.75 | 2.9925 | Caloenas nicobarica | 187106 | Chordata | Chordata | 58.5 | 3.71e-8 | NR | XP_065492949.1 | 187106 | g51388 | i0 | 65 | 2.54385964912281 | 40 | 14 | 70.2 | 0 | 31 | 150 | 90 | 129 | XP_065492949.1 inositol 1,4,5-trisphosphate receptor-interacting protein-like 1 [Caloenas nicobarica] | diamond | 435 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Caloenas | Caloenas nicobarica |
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);;