contig_metadata
10 rows where bioproject = "PRJEB7614", tax_kingdom = "Metazoa" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25797731 | 25797731 | PRJEB7614b_S_NODE_555_length_258_cov_53296.466368_g553_i0 | PRJEB7614 | 555 | 258 | 53296.466368 | 137504.88322944 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 93.5 | 1.38e-14 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g553 | i0 | 98.148 | 21.0658914728682 | 54 | 0 | 21 | 1 | 205 | 258 | 533 | 585 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 5435 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 25888351 | 25888351 | PRJEB7614a_S_NODE_75443_length_219_cov_1997.038043_g74239_i0 | PRJEB7614 | 75443 | 219 | 1997.038043 | 4373.51331417 | root | 1 | Root_unresolved | Root_unresolved | 100 | 6.82e-17 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g74239 | i0 | 98.246 | 27.5251141552511 | 57 | 1 | 26 | 0 | 1 | 57 | 594 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6028 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26024682 | 26024682 | PRJEB7614b_S_NODE_772_length_232_cov_64930.365482_g770_i0 | PRJEB7614 | 772 | 232 | 64930.365482 | 150638.44791824 | root | 1 | Root_unresolved | Root_unresolved | 108 | 4.37e-19 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g770 | i0 | 98.387 | 26.5603448275862 | 62 | 0 | 27 | 1 | 1 | 62 | 595 | 535 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6162 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26069943 | 26069943 | PRJEB7614b_S_NODE_253_length_324_cov_41253.173010_g251_i0 | PRJEB7614 | 253 | 324 | 41253.17301 | 133660.2805524 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 89.8 | 2.32e-13 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g251 | i0 | 92.188 | 16.0833333333333 | 64 | 3 | 19 | 2 | 263 | 324 | 519 | 582 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 5211 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26160824 | 26160824 | PRJEB7614a_S_NODE_21605_length_372_cov_1117.590504_g20414_i0 | PRJEB7614 | 21605 | 372 | 1117.590504 | 4157.43667488 | root | 1 | Root_unresolved | Root_unresolved | 100 | 1.25e-16 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g20414 | i0 | 98.246 | 16.1370967741935 | 57 | 1 | 15 | 0 | 1 | 57 | 594 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6003 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26160863 | 26160863 | PRJEB7614e_S_NODE_661_length_271_cov_36063.156780_g653_i0 | PRJEB7614 | 661 | 271 | 36063.15678 | 97731.1548738 | root | 1 | Root_unresolved | Root_unresolved | 113 | 1.12e-20 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g653 | i0 | 97.015 | 25.3394833948339 | 67 | 2 | 25 | 0 | 205 | 271 | 536 | 602 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6867 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26296605 | 26296605 | PRJEB7614c_S_NODE_918_length_214_cov_453.335196_g917_i0 | PRJEB7614 | 918 | 214 | 453.335196 | 970.13731944 | root | 1 | Root_unresolved | Root_unresolved | 95.3 | 3.09e-15 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g917 | i0 | 98.148 | 27.6869158878505 | 54 | 1 | 25 | 0 | 1 | 54 | 591 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 5925 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26432626 | 26432626 | PRJEB7614b_S_NODE_7_length_616_cov_23000.666093_g6_i0 | PRJEB7614 | 7 | 616 | 23000.666093 | 141684.10313288 | root | 1 | Root_unresolved | Root_unresolved | 108 | 1.29e-18 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g6 | i0 | 100 | 9.87824675324675 | 58 | 0 | 9 | 0 | 1 | 58 | 595 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6085 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26568606 | 26568606 | PRJEB7614a_S_NODE_36872_length_308_cov_1337.494505_g35668_i0 | PRJEB7614 | 36872 | 308 | 1337.494505 | 4119.4830754 | root | 1 | Root_unresolved | Root_unresolved | 100 | 1.01e-16 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g35668 | i0 | 91.781 | 19.6428571428571 | 73 | 5 | 23 | 1 | 237 | 308 | 522 | 594 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6050 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26568629 | 26568629 | PRJEB7614b_S_NODE_296_length_312_cov_46143.400722_g294_i0 | PRJEB7614 | 296 | 312 | 46143.400722 | 143967.41025264 | root | 1 | Root_unresolved | Root_unresolved | 108 | 6.14e-19 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g294 | i0 | 100 | 19.6923076923077 | 58 | 0 | 19 | 0 | 1 | 58 | 595 | 538 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6144 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;