contig_metadata
19 rows where bioproject = "PRJNA1002570", tax_clade = "Opisthokonta" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1427211 | 1427211 | PRJNA1002570_P_NODE_35922_length_251_cov_0.865169_g35727_i0 | PRJNA1002570 | 35922 | 251 | 0.865169 | 2.17157419 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 379 | 9.189999999999998e-101 | NTclustered | gi|2245734028|ref|XM_046495558.2| | 6454 | g35727 | i0 | 94.715 | 0.9800796812749 | 246 | 10 | 98 | 1 | 6 | 251 | 2408 | 2166 | PREDICTED: Haliotis rufescens potassium voltage-gated channel subfamily C member 3-like (LOC124131999), mRNA | blastn | 246 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 3978709 | 3978709 | PRJNA1002570_P_NODE_26044_length_277_cov_1.509804_g25849_i0 | PRJNA1002570 | 26044 | 277 | 1.509804 | 4.18215708 | Magallana gigas | 29159 | Mollusca | Mollusca | 507 | 4.53e-139 | NTclustered | gi|2751272144|ref|XM_011433329.4| | 29159 | g25849 | i0 | 99.639 | 4.37184115523466 | 277 | 1 | 100 | 0 | 1 | 277 | 1787 | 2063 | PREDICTED: Magallana gigas vitamin D3 receptor A (LOC105331219), transcript variant X1, mRNA | blastn | 1211 | 507 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 5255138 | 5255138 | PRJNA1002570_P_NODE_23885_length_282_cov_1.382775_g23690_i0 | PRJNA1002570 | 23885 | 282 | 1.382775 | 3.8994255 | Magallana gigas | 29159 | Mollusca | Mollusca | 516 | 7.67e-142 | NTclustered | gi|2633194874|emb|OY970755.1| | 29159 | g23690 | i0 | 99.645 | 26.1418439716312 | 282 | 1 | 100 | 0 | 1 | 282 | 2614 | 2895 | Magallana gigas genome assembly, organelle: mitochondrion | blastn | 7372 | 516 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 7378183 | 7378183 | PRJNA1002570_P_NODE_21226_length_288_cov_1.246512_g21031_i0 | PRJNA1002570 | 21226 | 288 | 1.246512 | 3.58995456 | Magallana | 147004 | Mollusca | Mollusca | 505 | 1.7e-138 | NTclustered | gi|2751269887|ref|XM_034460544.2| | 29159 | g21031 | i0 | 98.264 | 7 | 288 | 5 | 100 | 0 | 1 | 288 | 1059 | 772 | PREDICTED: Magallana gigas ubiquinol-cytochrome-c reductase complex assembly factor 1 (LOC105317156), transcript variant X2, mRNA | blastn | 2016 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 10355577 | 10355577 | PRJNA1002570_P_NODE_31929_length_262_cov_1.629630_g31734_i0 | PRJNA1002570 | 31929 | 262 | 1.62963 | 4.2696306 | Magallana gigas | 29159 | Mollusca | Mollusca | 433 | 7.31e-117 | NTclustered | gi|2751319582|ref|XM_034477616.2| | 29159 | g31734 | i0 | 96.552 | 3.76717557251908 | 261 | 9 | 99 | 0 | 2 | 262 | 112 | 372 | PREDICTED: Magallana gigas perlucin-like (LOC117691483), mRNA | blastn | 987 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 10355814 | 10355814 | PRJNA1002570_P_NODE_46029_length_207_cov_4.156716_g45834_i0 | PRJNA1002570 | 46029 | 207 | 4.156716 | 8.60440212 | Magallana gigas | 29159 | Mollusca | Mollusca | 372 | 1.2199999999999997e-98 | NTclustered | gi|2751218821|ref|XM_066076600.1| | 29159 | g45834 | i0 | 99.034 | 5 | 207 | 2 | 100 | 0 | 1 | 207 | 5135 | 5341 | PREDICTED: Magallana gigas uncharacterized protein (LOC117680547), transcript variant X5, mRNA | blastn | 1035 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 11631175 | 11631175 | PRJNA1002570_P_NODE_43450_length_242_cov_0.911243_g43255_i0 | PRJNA1002570 | 43450 | 242 | 0.911243 | 2.20520806 | Magallana gigas | 29159 | Mollusca | Mollusca | 392 | 1.1299999999999999e-104 | NTclustered | gi|2751286415|ref|XM_011416858.4| | 29159 | g43255 | i0 | 96.266 | 0.995867768595041 | 241 | 6 | 99 | 2 | 3 | 242 | 1479 | 1717 | PREDICTED: Magallana gigas legumain (LOC105319353), mRNA | blastn | 241 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 12906171 | 12906171 | PRJNA1002570_P_NODE_34851_length_254_cov_1.337017_g34656_i0 | PRJNA1002570 | 34851 | 254 | 1.337017 | 3.39602318 | Magallana gigas | 29159 | Mollusca | Mollusca | 451 | 1.95e-122 | NTclustered | gi|2751229960|ref|XR_010710309.1| | 29159 | g34656 | i0 | 98.814 | 0.996062992125984 | 253 | 3 | 99 | 0 | 2 | 254 | 362 | 110 | PREDICTED: Magallana gigas uncharacterized protein (LOC105341318), misc_RNA | blastn | 253 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 14181099 | 14181099 | PRJNA1002570_P_NODE_34612_length_254_cov_2.397790_g34417_i0 | PRJNA1002570 | 34612 | 254 | 2.39779 | 6.0903866 | Magallana angulata | 2784310 | Mollusca | Mollusca | 470 | 5.37e-128 | NTclustered | gi|2416949075|ref|XM_052863278.1| | 2784310 | g34417 | i0 | 100 | 4 | 254 | 0 | 100 | 0 | 1 | 254 | 588 | 335 | PREDICTED: Crassostrea angulata uncharacterized LOC128191194 (LOC128191194), transcript variant X2, mRNA | blastn | 1016 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 16303278 | 16303278 | PRJNA1002570_P_NODE_4253_length_522_cov_4.146993_g4059_i0 | PRJNA1002570 | 4253 | 522 | 4.146993 | 21.64730346 | Ostreidae | 6563 | Mollusca | Mollusca | 965 | 0 | NTclustered | gi|2633194874|emb|OY970755.1| | 29159 | g4059 | i0 | 100 | 48.6819923371648 | 522 | 0 | 100 | 0 | 1 | 522 | 9862 | 9341 | Magallana gigas genome assembly, organelle: mitochondrion | blastn | 25412 | 965 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 16729407 | 16729407 | PRJNA1002570_P_NODE_36434_length_250_cov_2.497175_g36239_i0 | PRJNA1002570 | 36434 | 250 | 2.497175 | 6.2429375 | Magallana gigas | 29159 | Mollusca | Mollusca | 390 | 4.22e-104 | NTclustered | gi|2751228822|ref|XM_066073412.1| | 29159 | g36239 | i0 | 94.8 | 3.376 | 250 | 13 | 100 | 0 | 1 | 250 | 577 | 328 | PREDICTED: Magallana gigas uncharacterized protein (LOC136272200), mRNA | blastn | 844 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 23104601 | 23104601 | PRJNA1002570_P_NODE_30419_length_266_cov_1.595855_g30224_i0 | PRJNA1002570 | 30419 | 266 | 1.595855 | 4.2449743 | Magallana angulata | 2784310 | Mollusca | Mollusca | 486 | 5.629999999999999e-133 | NTclustered | gi|2416976298|ref|XM_052827721.1| | 2784310 | g30224 | i0 | 99.624 | 5 | 266 | 1 | 100 | 0 | 1 | 266 | 29793 | 30058 | PREDICTED: Crassostrea angulata mucin-5AC-like (LOC128164012), transcript variant X2, mRNA | blastn | 1330 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 23953057 | 23953057 | PRJNA1002570_P_NODE_24379_length_281_cov_1.326923_g24184_i0 | PRJNA1002570 | 24379 | 281 | 1.326923 | 3.72865363 | Ostreidae | 6563 | Mollusca | Mollusca | 520 | 5.909999999999999e-143 | NTclustered | gi|678946009|gb|KJ855241.1| | 29159 | g24184 | i0 | 100 | 89.0711743772242 | 281 | 0 | 100 | 0 | 1 | 281 | 17176 | 16896 | Crassostrea gigas isolate CgJap23 mitochondrion, complete genome | blastn | 25029 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 23953179 | 23953179 | PRJNA1002570_P_NODE_4519_length_508_cov_6.075862_g4325_i0 | PRJNA1002570 | 4519 | 508 | 6.075862 | 30.86537896 | Ostreidae | 6563 | Mollusca | Mollusca | 939 | 0 | NTclustered | gi|678946009|gb|KJ855241.1| | 29159 | g4325 | i0 | 100 | 95.3503937007874 | 508 | 0 | 100 | 0 | 1 | 508 | 2311 | 1804 | Crassostrea gigas isolate CgJap23 mitochondrion, complete genome | blastn | 48438 | 939 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 28006403 | 28006403 | PRJNA1002570_P_NODE_16645_length_307_cov_3.217949_g16450_i0 | PRJNA1002570 | 16645 | 307 | 3.217949 | 9.87910343 | Metazoa | 33208 | Mollusca | Mollusca | 44.7 | 0.0156 | NR | XP_052102444.1 | 6549 | g16450 | i0 | 63.3 | 5.05211726384365 | 30 | 11 | 29.3 | 0 | 271 | 182 | 1 | 30 | XP_052102444.1 nicotinamide/nicotinic acid mononucleotide adenylyltransferase 1-like isoform X1 [Mytilus californianus] | diamond | 1551 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 28265952 | 28265952 | PRJNA1002570_P_NODE_35706_length_251_cov_1.730337_g35511_i0 | PRJNA1002570 | 35706 | 251 | 1.730337 | 4.34314587 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 45.4 | 0.00176 | NR | KAK7486354.1 | 370345 | g35511 | i0 | 71.4 | 0.49003984063745 | 21 | 6 | 25.1 | 0 | 63 | 1 | 36 | 56 | KAK7486354.1 hypothetical protein BaRGS_00022402 [Batillaria attramentaria] | diamond | 123 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 29434082 | 29434082 | PRJNA1002570_P_NODE_26330_length_276_cov_2.266010_g26135_i0 | PRJNA1002570 | 26330 | 276 | 2.26601 | 6.2541876 | Mya arenaria | 6604 | Mollusca | Mollusca | 56.2 | 8.89e-7 | NR | XP_052777926.1 | 6604 | g26135 | i0 | 36.4 | 0.717391304347826 | 66 | 42 | 71.7 | 0 | 48 | 245 | 82 | 147 | XP_052777926.1 probable G-protein coupled receptor 139 [Mya arenaria] | diamond | 198 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31765299 | 31765299 | PRJNA1002570_P_NODE_38997_length_247_cov_1.735632_g38802_i0 | PRJNA1002570 | 38997 | 247 | 1.735632 | 4.28701104 | Metazoa | 33208 | Mollusca | Mollusca | 64.7 | 7.16e-10 | NR | XP_064607456.1 | 13599 | g38802 | i0 | 49.4 | 6.38866396761134 | 77 | 29 | 93.5 | 3 | 245 | 15 | 1524 | 1590 | XP_064607456.1 tyrosine-protein phosphatase Lar-like isoform X1 [Liolophura japonica] | diamond | 1578 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 32626651 | 32626651 | PRJNA1002570_P_NODE_36480_length_250_cov_2.220339_g36285_i0 | PRJNA1002570 | 36480 | 250 | 2.220339 | 5.5508475 | Physella acuta | 109671 | Mollusca | Mollusca | 76.3 | 6.09e-14 | NR | XP_059178808.1 | 109671 | g36285 | i0 | 68.5 | 3.888 | 54 | 16 | 64.8 | 1 | 87 | 248 | 232 | 284 | XP_059178808.1 deoxynucleoside triphosphate triphosphohydrolase SAMHD1-like [Physella acuta] | diamond | 972 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta |
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);;