contig_metadata
16 rows where bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6268871 | 6268871 | PRJNA670521_P_NODE_82585_length_246_cov_0.884393_g81840_i0 | PRJNA670521 | 82585 | 246 | 0.884393 | 2.17560678 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 151 | 1.61e-40 | NR | XP_013396956.1 | 7574 | g81840 | i0 | 90.1 | 49.2073170731707 | 81 | 8 | 98.8 | 0 | 244 | 2 | 111 | 191 | XP_013396956.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3B-like [Lingula anatina] | diamond | 12105 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 8291412 | 8291412 | PRJNA670521_P_NODE_52527_length_290_cov_1.018433_g51782_i0 | PRJNA670521 | 52527 | 290 | 1.018433 | 2.9534557 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 103 | 2.5699999999999998e-23 | NR | XP_013393991.1 | 7574 | g51782 | i0 | 61.1 | 4.82068965517241 | 95 | 37 | 98.3 | 0 | 286 | 2 | 38 | 132 | XP_013393991.1 ATPase family AAA domain-containing protein 3-A [Lingula anatina] | diamond | 1398 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 12117335 | 12117335 | PRJNA670521_P_NODE_3070_length_997_cov_10.535714_g1808_i1 | PRJNA670521 | 3070 | 997 | 10.535714 | 105.04106858 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 407 | 1.87e-108 | NTclustered | gi|919089027|ref|XM_013526062.1| | 7574 | g1808 | i1 | 82.965 | 45.4463390170512 | 452 | 75 | 45 | 2 | 47 | 497 | 102 | 552 | PREDICTED: Lingula anatina calmodulin (LOC106152471), transcript variant X2, mRNA | blastn | 45310 | 407 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 14667044 | 14667044 | PRJNA670521_P_NODE_18892_length_431_cov_7.343575_g18150_i0 | PRJNA670521 | 18892 | 431 | 7.343575 | 31.65080825 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 243 | 1.7400000000000002e-79 | NR | XP_013395382.2 | 7574 | g18150 | i0 | 93.8 | 52.6009280742459 | 129 | 8 | 89.8 | 0 | 7 | 393 | 83 | 211 | XP_013395382.2 ubiquitin-60S ribosomal protein L40 [Lingula anatina] | diamond | 22671 | 245 | 0.991836734693878 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 15940864 | 15940864 | PRJNA670521_P_NODE_2273_length_1157_cov_6.559963_g1808_i0 | PRJNA670521 | 2273 | 1157 | 6.559963 | 75.89877191 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 394 | 1.6999999999999995e-104 | NTclustered | gi|919089025|ref|XM_013526060.1| | 7574 | g1808 | i0 | 82.766 | 38.3630077787381 | 441 | 76 | 38 | 0 | 671 | 1111 | 543 | 103 | PREDICTED: Lingula anatina calmodulin (LOC106152471), transcript variant X1, mRNA | blastn | 44386 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 24116858 | 24116858 | PRJNA670521_P_NODE_8739_length_603_cov_1.854717_g8009_i0 | PRJNA670521 | 8739 | 603 | 1.854717 | 11.18394351 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 56.5 | 0.005 | NTclustered | gi|919041215|ref|XM_013548457.1| | 7574 | g8009 | i0 | 100 | 1.79436152570481 | 30 | 0 | 5 | 0 | 113 | 142 | 1939 | 1910 | PREDICTED: Lingula anatina zinc finger protein 236 (LOC106169102), transcript variant X2, mRNA | blastn | 1082 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 26650305 | 26650305 | PRJNA670521_P_NODE_20341_length_418_cov_1.785507_g19598_i0 | PRJNA670521 | 20341 | 418 | 1.785507 | 7.46341926 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 194 | 1.97e-59 | NR | XP_013387556.1 | 7574 | g19598 | i0 | 71.9 | 19.9306220095694 | 139 | 39 | 99.8 | 0 | 418 | 2 | 5 | 143 | XP_013387556.1 V-type proton ATPase subunit D [Lingula anatina] | diamond | 8331 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 26923550 | 26923550 | PRJNA670521_P_NODE_26862_length_376_cov_0.732673_g26118_i0 | PRJNA670521 | 26862 | 376 | 0.732673 | 2.75485048 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 118 | 1.76e-28 | NR | XP_013391427.1 | 7574 | g26118 | i0 | 47.6 | 0.98936170212766 | 124 | 60 | 98.1 | 2 | 3 | 371 | 71 | 190 | XP_013391427.1 lysophospholipid acyltransferase 5 [Lingula anatina] | diamond | 372 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27492537 | 27492537 | PRJNA670521_P_NODE_10043_length_565_cov_1.189024_g9311_i0 | PRJNA670521 | 10043 | 565 | 1.189024 | 6.7179856 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 76.6 | 3.28e-13 | NR | XP_013384316.1 | 7574 | g9311 | i0 | 32 | 0.812389380530973 | 153 | 100 | 79.1 | 2 | 31 | 477 | 1 | 153 | XP_013384316.1 surfeit locus protein 2 [Lingula anatina] | diamond | 459 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 27725865 | 27725865 | PRJNA670521_P_NODE_44284_length_311_cov_0.970588_g43539_i0 | PRJNA670521 | 44284 | 311 | 0.970588 | 3.01852868 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 69.7 | 2.84e-11 | NR | XP_013385103.1 | 7574 | g43539 | i0 | 47.7 | 1.98713826366559 | 65 | 32 | 60.8 | 1 | 2 | 190 | 506 | 570 | XP_013385103.1 neuroendocrine convertase 2-like [Lingula anatina] | diamond | 618 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 28325288 | 28325288 | PRJNA670521_P_NODE_68226_length_255_cov_1.269231_g67481_i0 | PRJNA670521 | 68226 | 255 | 1.269231 | 3.23653905 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 101 | 1.17e-22 | NR | XP_013384334.1 | 7574 | g67481 | i0 | 57.5 | 2.83529411764706 | 80 | 34 | 94.1 | 0 | 255 | 16 | 2022 | 2101 | XP_013384334.1 uncharacterized protein LOC106154518 [Lingula anatina] | diamond | 723 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 28439823 | 28439823 | PRJNA670521_P_NODE_35086_length_340_cov_1.153558_g34341_i0 | PRJNA670521 | 35086 | 340 | 1.153558 | 3.9220972 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 75.9 | 2.51e-13 | NR | XP_013414821.1 | 7574 | g34341 | i0 | 38 | 3.74117647058824 | 108 | 58 | 92.6 | 4 | 20 | 334 | 125 | 226 | XP_013414821.1 uncharacterized protein LOC106176828 isoform X1 [Lingula anatina] | diamond | 1272 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29639168 | 29639168 | PRJNA670521_P_NODE_13930_length_490_cov_1.661871_g13191_i0 | PRJNA670521 | 13930 | 490 | 1.661871 | 8.1431679 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 233 | 1.53e-74 | NR | XP_013414812.1 | 7574 | g13191 | i0 | 67.1 | 1.93469387755102 | 158 | 51 | 96.1 | 1 | 18 | 488 | 23 | 180 | XP_013414812.1 proteasome subunit beta type-6-like [Lingula anatina] | diamond | 948 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31199054 | 31199054 | PRJNA670521_P_NODE_41895_length_318_cov_0.881633_g41150_i0 | PRJNA670521 | 41895 | 318 | 0.881633 | 2.80359294 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 48.9 | 6.55e-4 | NR | XP_013392762.1 | 7574 | g41150 | i0 | 31.2 | 7.92452830188679 | 109 | 65 | 93.4 | 1 | 318 | 22 | 1487 | 1595 | XP_013392762.1 pecanex-like protein 1 [Lingula anatina] | diamond | 2520 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31230903 | 31230903 | PRJNA670521_P_NODE_13855_length_491_cov_1.471292_g13116_i0 | PRJNA670521 | 13855 | 491 | 1.471292 | 7.22404372 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 220 | 3.4000000000000007e-65 | NR | XP_013419927.1 | 7574 | g13116 | i0 | 67.5 | 18.9226069246436 | 163 | 52 | 99.6 | 1 | 491 | 3 | 409 | 570 | XP_013419927.1 transketolase [Lingula anatina] | diamond | 9291 | 221 | 0.995475113122172 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 32673703 | 32673703 | PRJNA670521_P_NODE_72780_length_250_cov_0.870056_g72035_i0 | PRJNA670521 | 72780 | 250 | 0.870056 | 2.17514 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 46.6 | 0.00171 | NR | XP_013396908.1 | 7574 | g72035 | i0 | 33.3 | 0.684 | 57 | 38 | 68.4 | 0 | 235 | 65 | 217 | 273 | XP_013396908.1 uncharacterized protein LOC106163774 [Lingula anatina] | diamond | 171 | 46.6 | 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);;