contig_metadata
6 rows where bioproject = "PRJNA849172", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2109723 | 2109723 | PRJNA849172_P_NODE_106942_length_242_cov_20.088757_g106582_i0 | PRJNA849172 | 106942 | 242 | 20.088757 | 48.61479194 | Claudrilus corderoi | 3262671 | Annelida | Annelida | 91.6 | 4.62e-14 | NTclustered | gi|923872644|gb|KJ451231.1| | 3262671 | g106582 | i0 | 91.045 | 3.2603305785124 | 67 | 6 | 28 | 0 | 9 | 75 | 261 | 195 | Claudrilus corderoi 28S ribosomal RNA gene, partial sequence | blastn | 789 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Protodrilidae | Claudrilus | Claudrilus corderoi | ||
| 3783853 | 3783853 | PRJNA849172_P_NODE_12043_length_610_cov_17.685289_g11688_i0 | PRJNA849172 | 12043 | 610 | 17.685289 | 107.8802629 | Placobdella | 6414 | Annelida | Annelida | 84.2 | 2.14e-11 | NTclustered | gi|1028609206|emb|LT159850.1| | 60933 | g11688 | i0 | 100 | 1.2327868852459 | 45 | 0 | 7 | 0 | 554 | 598 | 4821 | 4865 | Placobdella parasitica strain ONAP mitochondrion, partial genome | blastn | 752 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Placobdella | Placobdella parasitica | |
| 15260934 | 15260934 | PRJNA849172_P_NODE_79032_length_260_cov_5.860963_g78672_i0 | PRJNA849172 | 79032 | 260 | 5.860963 | 15.2385038 | root | 1 | Root_unresolved | Root_unresolved | 90.5 | 5.45e-19 | NR | ELU17401.1 | 283909 | g78672 | i0 | 86 | 26.1923076923077 | 50 | 7 | 57.7 | 0 | 259 | 110 | 396 | 445 | ELU17401.1 hypothetical protein CAPTEDRAFT_127356 [Capitella teleta] | diamond | 6810 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27655294 | 27655294 | PRJNA849172_P_NODE_30144_length_373_cov_28.840000_g29785_i0 | PRJNA849172 | 30144 | 373 | 28.84 | 107.5732 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 57.4 | 1.14e-6 | NR | CAD5119222.1 | 2664684 | g29785 | i0 | 45.5 | 1.68096514745308 | 55 | 29 | 43.4 | 1 | 3 | 164 | 472 | 526 | CAD5119222.1 DgyrCDS7854 [Dimorphilus gyrociliatus] | diamond | 627 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29328399 | 29328399 | PRJNA849172_P_NODE_11049_length_641_cov_20.588028_g10697_i0 | PRJNA849172 | 11049 | 641 | 20.588028 | 131.96925948 | Owenia fusiformis | 6347 | Annelida | Annelida | 91.3 | 1.03e-18 | NR | CAH1799946.1 | 6347 | g10697 | i0 | 39.7 | 6.21528861154446 | 194 | 110 | 87.5 | 2 | 588 | 28 | 4 | 197 | CAH1799946.1 unnamed protein product [Owenia fusiformis] | diamond | 3984 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30979614 | 30979614 | PRJNA849172_P_NODE_136914_length_211_cov_6.260870_g136554_i0 | PRJNA849172 | 136914 | 211 | 6.26087 | 13.2104357 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 4.01e-4 | NR | KAK2165860.1 | 27915 | g136554 | i0 | 36.5 | 2.55924170616114 | 63 | 38 | 86.7 | 1 | 206 | 24 | 279 | 341 | KAK2165860.1 hypothetical protein NP493_1347g00016 [Ridgeia piscesae] | diamond | 540 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;