contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Xenacoelomorpha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3544251 | 3544251 | PRJEB64798_P_NODE_76323_length_220_cov_12.988304_g74557_i0 | PRJEB64798 | 76323 | 220 | 12.988304 | 28.5742688 | Acoela | 31265 | Xenacoelomorpha | other_Eukaryota | 124 | 4.07e-24 | NTclustered | gi|378781063|emb|FR837817.1| | 996693 | g74557 | i0 | 83.333 | 36.7954545454545 | 138 | 19 | 62 | 4 | 1 | 136 | 2080 | 1945 | Philomecynostomum sp. UJ-2011 partial 28S rRNA gene, specimen voucher AWSp-41 | blastn | 8095 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Mecynostomidae | Philomecynostomum | Philomecynostomum sp. UJ-2011 | ||
| 3955910 | 3955910 | PRJEB64798_P_NODE_9204_length_656_cov_53.578254_g7134_i1 | PRJEB64798 | 9204 | 656 | 53.578254 | 351.47334624 | Sterreria lundini | 1547312 | Xenacoelomorpha | other_Eukaryota | 147 | 2.91e-30 | NTclustered | gi|686136443|gb|KM062841.1| | 1547312 | g7134 | i1 | 88.983 | 28.6981707317073 | 118 | 13 | 18 | 0 | 539 | 656 | 1215 | 1098 | Sterreria lundini voucher SMNH<SWE>:MCG11 28S ribosomal RNA gene, partial sequence | blastn | 18826 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Nemertodermatida | Nemertodermatidae | Sterreria | Sterreria lundini | ||
| 6096445 | 6096445 | PRJEB64798_P_NODE_231085_length_158_cov_5.192661_g229319_i0 | PRJEB64798 | 231085 | 158 | 5.192661 | 8.20440438 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.2 | 7.8e-5 | NTclustered | gi|378781067|emb|FR837821.1| | 996671 | g229319 | i0 | 92.683 | 21.8860759493671 | 41 | 3 | 26 | 0 | 39 | 79 | 889 | 929 | Praeconvoluta castinea partial 28S rRNA gene, specimen voucher MHMa7 | blastn | 3458 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Convolutidae | Praeconvoluta | Praeconvoluta castinea | ||
| 6506393 | 6506393 | PRJEB64798_P_NODE_219266_length_162_cov_4.283186_g217500_i0 | PRJEB64798 | 219266 | 162 | 4.283186 | 6.93876132 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 78.7 | 2.22e-10 | NTclustered | gi|2701362129|ref|XR_010163696.1| | 84072 | g217500 | i0 | 90.164 | 37.6172839506173 | 61 | 5 | 37 | 1 | 99 | 158 | 68 | 8 | PREDICTED: Symsagittifera roscoffensis U2 spliceosomal RNA (LOC134849684), ncRNA | blastn | 6094 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 6506609 | 6506609 | PRJEB64798_P_NODE_235626_length_156_cov_16.654206_g233860_i0 | PRJEB64798 | 235626 | 156 | 16.654206 | 25.98056136 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 93.5 | 7.57e-15 | NTclustered | gi|2701361670|ref|XR_010163236.1| | 84072 | g233860 | i0 | 83.838 | 20.1602564102564 | 99 | 14 | 63 | 2 | 11 | 108 | 4 | 101 | PREDICTED: Symsagittifera roscoffensis 5S ribosomal RNA (LOC134849198), rRNA | blastn | 3145 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 8646718 | 8646718 | PRJEB64798_P_NODE_66287_length_238_cov_6.724868_g64522_i0 | PRJEB64798 | 66287 | 238 | 6.724868 | 16.00518584 | Nemertodermatida | 52050 | Xenacoelomorpha | other_Eukaryota | 97.1 | 9.74e-16 | NTclustered | gi|1019367217|gb|KT698955.1| | 450194 | g64522 | i0 | 83.495 | 3.10924369747899 | 103 | 17 | 43 | 0 | 136 | 238 | 429 | 327 | Flagellophora apelti voucher SMNH-UJ-13110 28S large subunit ribosomal RNA gene, partial sequence | blastn | 740 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Nemertodermatida | Nemertodermatidae | Flagellophora | Flagellophora apelti | ||
| 9921542 | 9921542 | PRJEB64798_P_NODE_27448_length_375_cov_137.273006_g25693_i0 | PRJEB64798 | 27448 | 375 | 137.273006 | 514.7737725 | Acoela | 31265 | Xenacoelomorpha | other_Eukaryota | 82.4 | 4.55e-11 | NTclustered | gi|378781076|emb|FR837830.1| | 996676 | g25693 | i0 | 86.667 | 1.616 | 75 | 8 | 20 | 2 | 23 | 96 | 981 | 1054 | Pseudohaplogonaria rodmani partial 28S rRNA gene, specimen voucher MHPh | blastn | 606 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Haploposthiidae | Pseudohaplogonaria | Pseudohaplogonaria rodmani | ||
| 10331382 | 10331382 | PRJEB64798_P_NODE_232269_length_158_cov_2.577982_g230503_i0 | PRJEB64798 | 232269 | 158 | 2.577982 | 4.07321156 | Myopea sp. cf. callaeum | 188053 | Xenacoelomorpha | other_Eukaryota | 97.1 | 5.95e-16 | NTclustered | gi|378781045|emb|FR837799.1| | 188053 | g230503 | i0 | 90.411 | 21.3481012658228 | 73 | 7 | 46 | 0 | 61 | 133 | 1015 | 943 | Myopea sp. cf. callaeum partial 28S rRNA gene, specimen voucher MHMc | blastn | 3373 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Solenofilomorphidae | Myopea | Myopea sp. cf. callaeum | ||
| 11608086 | 11608086 | PRJEB64798_P_NODE_75670_length_221_cov_13.912791_g73904_i0 | PRJEB64798 | 75670 | 221 | 13.912791 | 30.74726811 | Hofstenia cf. miamia | 3135051 | Xenacoelomorpha | other_Eukaryota | 89.8 | 1.49e-13 | NTclustered | gi|2704011507|gb|PP536126.1| | 3135051 | g73904 | i0 | 82.857 | 2.07239819004525 | 105 | 12 | 45 | 2 | 3 | 101 | 2282 | 2386 | Hofstenia cf. miamia large subunit ribosomal RNA gene, partial sequence | blastn | 458 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Hofsteniidae | Hofstenia | Hofstenia cf. miamia | ||
| 14156560 | 14156560 | PRJEB64798_P_NODE_220412_length_162_cov_2.035398_g218646_i0 | PRJEB64798 | 220412 | 162 | 2.035398 | 3.29734476 | Childia sp. MR-2009 | 662517 | Xenacoelomorpha | other_Eukaryota | 113 | 6.1e-21 | NTclustered | gi|255733359|gb|FJ555371.1| | 662517 | g218646 | i0 | 79.874 | 3.73456790123457 | 159 | 28 | 97 | 3 | 1 | 157 | 816 | 660 | Childia sp. MR-2009 ATP synthase beta subunit mRNA, partial cds | blastn | 605 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Childiidae | Childia | Childia sp. MR-2009 | ||
| 20120176 | 20120176 | PRJEB64798_P_NODE_59056_length_253_cov_20.024510_g57291_i0 | PRJEB64798 | 59056 | 253 | 20.02451 | 50.6620103 | Nemertoderma | 172107 | Xenacoelomorpha | other_Eukaryota | 110 | 1.34e-19 | NTclustered | gi|1019367212|gb|KT698950.1| | 172108 | g57291 | i0 | 86.735 | 4.31620553359684 | 98 | 13 | 39 | 0 | 155 | 252 | 2047 | 2144 | Nemertoderma bathycola voucher SMNH-UJ-12116 28S large subunit ribosomal RNA gene, partial sequence | blastn | 1092 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Nemertodermatida | Nemertodermatidae | Nemertoderma | Nemertoderma bathycola | ||
| 23081637 | 23081637 | PRJEB64798_P_NODE_8539_length_677_cov_50.019108_g7134_i0 | PRJEB64798 | 8539 | 677 | 50.019108 | 338.62936116 | Sterreria lundini | 1547312 | Xenacoelomorpha | other_Eukaryota | 147 | 3.01e-30 | NTclustered | gi|686136443|gb|KM062841.1| | 1547312 | g7134 | i0 | 88.983 | 27.7045790251108 | 118 | 13 | 17 | 0 | 560 | 677 | 1215 | 1098 | Sterreria lundini voucher SMNH<SWE>:MCG11 28S ribosomal RNA gene, partial sequence | blastn | 18756 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Nemertodermatida | Nemertodermatidae | Sterreria | Sterreria lundini |
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);;