contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1002570" 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 |
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);;