contig_metadata
18 rows where bioproject = "PRJEB64798" and tax_phylum = "Brachiopoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2677707 | 2677707 | PRJEB64798_P_NODE_180703_length_174_cov_2.752000_g178937_i0 | PRJEB64798 | 180703 | 174 | 2.752 | 4.78848 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 97.8 | 4.8e-22 | NR | XP_013389396.1 | 7574 | g178937 | i0 | 76.8 | 14.4827586206897 | 56 | 13 | 96.6 | 0 | 168 | 1 | 416 | 471 | XP_013389396.1 LOW QUALITY PROTEIN: protein disulfide-isomerase A3-like [Lingula anatina] | diamond | 2520 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 7780212 | 7780212 | PRJEB64798_P_NODE_195427_length_168_cov_18.193277_g193661_i0 | PRJEB64798 | 195427 | 168 | 18.193277 | 30.56470536 | Novocrania anomala | 317945 | Brachiopoda | other_Eukaryota | 78.7 | 2.33e-10 | NTclustered | gi|188572442|gb|EU558324.1| | 317945 | g193661 | i0 | 91.228 | 0.720238095238095 | 57 | 5 | 34 | 0 | 61 | 117 | 411 | 355 | Novocrania anomala putative 60S ribosomal protein RPL27 mRNA, complete cds | blastn | 121 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Craniata | Craniida | Craniidae | Novocrania | Novocrania anomala | |
| 9055634 | 9055634 | PRJEB64798_P_NODE_236688_length_156_cov_5.252336_g234922_i0 | PRJEB64798 | 236688 | 156 | 5.252336 | 8.19364416 | Novocrania anomala | 317945 | Brachiopoda | other_Eukaryota | 62.1 | 2.13e-5 | NTclustered | gi|188572412|gb|EU558309.1| | 317945 | g234922 | i0 | 97.222 | 0.230769230769231 | 36 | 1 | 23 | 0 | 1 | 36 | 156 | 121 | Novocrania anomala putative 60S ribosomal protein RPL7 mRNA, partial cds | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Craniata | Craniida | Craniidae | Novocrania | Novocrania anomala | |
| 21805601 | 21805601 | PRJEB64798_P_NODE_37638_length_322_cov_4.586081_g35878_i0 | PRJEB64798 | 37638 | 322 | 4.586081 | 14.76718082 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 195 | 4.7499999999999995e-45 | NTclustered | gi|1351337795|ref|XM_013546979.2| | 7574 | g35878 | i0 | 89.542 | 41.1180124223603 | 153 | 16 | 48 | 0 | 129 | 281 | 1452 | 1300 | PREDICTED: Lingula anatina tubulin alpha-1A chain (LOC106168052), mRNA | blastn | 13240 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 26615139 | 26615139 | PRJEB64798_P_NODE_16541_length_490_cov_3.312925_g14841_i0 | PRJEB64798 | 16541 | 490 | 3.312925 | 16.2333325 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 96.3 | 7.09e-20 | NR | XP_013395991.1 | 7574 | g14841 | i0 | 36.4 | 11.8408163265306 | 129 | 75 | 75.9 | 2 | 464 | 93 | 266 | 392 | XP_013395991.1 ornithine decarboxylase-like [Lingula anatina] | diamond | 5802 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 26875835 | 26875835 | PRJEB64798_P_NODE_201961_length_167_cov_0.881356_g200195_i0 | PRJEB64798 | 201961 | 167 | 0.881356 | 1.47186452 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 47.4 | 2.74e-4 | NR | XP_013412764.1 | 7574 | g200195 | i0 | 37 | 1.94011976047904 | 54 | 32 | 93.4 | 1 | 163 | 8 | 55 | 108 | XP_013412764.1 COMM domain-containing protein 6 isoform X2 [Lingula anatina] | diamond | 324 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27065391 | 27065391 | PRJEB64798_P_NODE_64762_length_241_cov_9.369792_g62997_i0 | PRJEB64798 | 64762 | 241 | 9.369792 | 22.58119872 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 124 | 3.21e-32 | NR | XP_013409929.1 | 7574 | g62997 | i0 | 75.3 | 1.91701244813278 | 77 | 19 | 95.9 | 0 | 231 | 1 | 91 | 167 | XP_013409929.1 cathepsin B [Lingula anatina] | diamond | 462 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27349997 | 27349997 | PRJEB64798_P_NODE_118923_length_207_cov_3.455696_g117157_i0 | PRJEB64798 | 118923 | 207 | 3.455696 | 7.15329072 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 70.1 | 5.37e-12 | NR | XP_013408704.1 | 7574 | g117157 | i0 | 52.5 | 3.72463768115942 | 61 | 29 | 88.4 | 0 | 189 | 7 | 67 | 127 | XP_013408704.1 vigilin-like [Lingula anatina] | diamond | 771 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27602742 | 27602742 | PRJEB64798_P_NODE_46724_length_287_cov_5.483193_g44959_i0 | PRJEB64798 | 46724 | 287 | 5.483193 | 15.73676391 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 44.7 | 0.0136 | NR | XP_013406430.1 | 7574 | g44959 | i0 | 31 | 1.53658536585366 | 84 | 49 | 82.6 | 4 | 3 | 239 | 642 | 721 | XP_013406430.1 A disintegrin and metalloproteinase with thrombospondin motifs 7 isoform X1 [Lingula anatina] | diamond | 441 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29079652 | 29079652 | PRJEB64798_P_NODE_81188_length_214_cov_4.084848_g79422_i0 | PRJEB64798 | 81188 | 214 | 4.084848 | 8.74157472 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 82 | 1.46e-16 | NR | XP_013396966.1 | 7574 | g79422 | i0 | 66.7 | 8.01869158878505 | 57 | 19 | 79.9 | 0 | 42 | 212 | 202 | 258 | XP_013396966.1 60S acidic ribosomal protein P0-like [Lingula anatina] | diamond | 1716 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29086535 | 29086535 | PRJEB64798_P_NODE_143448_length_191_cov_21.471831_g141682_i0 | PRJEB64798 | 143448 | 191 | 21.471831 | 41.01119721 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 44.3 | 0.00549 | NR | XP_023932585.1 | 7574 | g141682 | i0 | 39.6 | 4.03664921465969 | 48 | 27 | 72.3 | 1 | 52 | 189 | 290 | 337 | XP_023932585.1 sperm-associated antigen 17 [Lingula anatina] | diamond | 771 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29496876 | 29496876 | PRJEB64798_P_NODE_175110_length_176_cov_7.440945_g173344_i0 | PRJEB64798 | 175110 | 176 | 7.440945 | 13.0960632 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 66.6 | 3.39e-11 | NR | XP_013398583.1 | 7574 | g173344 | i0 | 63 | 1.6875 | 54 | 19 | 92 | 1 | 8 | 169 | 65 | 117 | XP_013398583.1 transcription factor AP-1 [Lingula anatina] | diamond | 297 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29710639 | 29710639 | PRJEB64798_P_NODE_170290_length_178_cov_12.860465_g168524_i0 | PRJEB64798 | 170290 | 178 | 12.860465 | 22.8916277 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 51.6 | 1.15e-5 | NR | XP_013401794.2 | 7574 | g168524 | i0 | 44.6 | 11.3426966292135 | 56 | 27 | 94.4 | 1 | 172 | 5 | 173 | 224 | XP_013401794.2 DBH-like monooxygenase protein 1 [Lingula anatina] | diamond | 2019 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29812579 | 29812579 | PRJEB64798_P_NODE_248031_length_152_cov_7.271845_g246265_i0 | PRJEB64798 | 248031 | 152 | 7.271845 | 11.0532044 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 48.1 | 1.34e-4 | NR | XP_013419198.1 | 7574 | g246265 | i0 | 51.4 | 0.690789473684211 | 35 | 17 | 69.1 | 0 | 125 | 21 | 875 | 909 | XP_013419198.1 sushi domain-containing protein 2 [Lingula anatina] | diamond | 105 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 30350320 | 30350320 | PRJEB64798_P_NODE_253472_length_150_cov_5.683168_g251706_i0 | PRJEB64798 | 253472 | 150 | 5.683168 | 8.524752 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 96.3 | 1.17e-22 | NR | XP_013414049.1 | 7574 | g251706 | i0 | 75.5 | 2.94 | 49 | 12 | 98 | 0 | 148 | 2 | 200 | 248 | XP_013414049.1 countin-1-like [Lingula anatina] | diamond | 441 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31480851 | 31480851 | PRJEB64798_P_NODE_118556_length_207_cov_4.746835_g116790_i0 | PRJEB64798 | 118556 | 207 | 4.746835 | 9.82594845 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 85.1 | 2.76e-17 | NR | XP_023932407.1 | 7574 | g116790 | i0 | 70.7 | 5.17391304347826 | 58 | 15 | 84.1 | 1 | 179 | 6 | 4188 | 4243 | XP_023932407.1 dynein heavy chain 3, axonemal [Lingula anatina] | diamond | 1071 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31487731 | 31487731 | PRJEB64798_P_NODE_236976_length_156_cov_4.355140_g235210_i0 | PRJEB64798 | 236976 | 156 | 4.35514 | 6.7940184 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 48.5 | 1.02e-4 | NR | XP_013384673.1 | 7574 | g235210 | i0 | 47.1 | 0.980769230769231 | 51 | 27 | 98.1 | 0 | 2 | 154 | 483 | 533 | XP_013384673.1 glucosylceramidase [Lingula anatina] | diamond | 153 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 32814956 | 32814956 | PRJEB64798_P_NODE_178280_length_175_cov_2.960317_g176514_i0 | PRJEB64798 | 178280 | 175 | 2.960317 | 5.18055475 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 45.8 | 0.00124 | NR | XP_013384833.1 | 7574 | g176514 | i0 | 32.7 | 0.891428571428571 | 52 | 35 | 89.1 | 0 | 165 | 10 | 550 | 601 | XP_013384833.1 general transcription factor 3C polypeptide 1-like [Lingula anatina] | diamond | 156 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina |
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);;