contig_metadata
7 rows where bioproject = "PRJEB12296", tax_clade = "Opisthokonta" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25500875 | 25500875 | PRJEB12296_S_NODE_961_length_369_cov_4.470060_g929_i0 | PRJEB12296 | 961 | 369 | 4.47006 | 16.4945214 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 472 | 2.27e-128 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g929 | i0 | 90.704 | 4.11653116531165 | 355 | 31 | 96 | 2 | 16 | 369 | 2399 | 2046 | Philodina citrina complete mitochondrial genome | blastn | 1519 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 25606879 | 25606879 | PRJEB12296_S_NODE_5425_length_205_cov_13015.329412_g5393_i0 | PRJEB12296 | 5425 | 205 | 13015.329412 | 26681.4252946 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 315 | 2.0699999999999998e-81 | NTclustered | gi|146157270|gb|EF485012.1| | 96448 | g5393 | i0 | 100 | 82.9268292682927 | 170 | 0 | 83 | 0 | 2 | 171 | 454 | 285 | Philodina roseola clone Pr_TEL_M telomeric repeat and subterminal DNA junction | blastn | 17000 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 25743152 | 25743152 | PRJEB12296_S_NODE_906_length_376_cov_21.519062_g874_i0 | PRJEB12296 | 906 | 376 | 21.519062 | 80.91167312 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 616 | 1.0099999999999999e-171 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g874 | i0 | 98.023 | 70.8085106382979 | 354 | 7 | 94 | 0 | 1 | 354 | 6991 | 6638 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 26624 | 621 | 0.99194847020934 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26181124 | 26181124 | PRJEB12296_S_NODE_1766_length_307_cov_3.654412_g1734_i0 | PRJEB12296 | 1766 | 307 | 3.654412 | 11.21904484 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 366 | 9.009999999999999e-97 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g1734 | i0 | 89.492 | 5.00651465798046 | 295 | 24 | 95 | 5 | 1 | 292 | 2109 | 2399 | Philodina citrina complete mitochondrial genome | blastn | 1537 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 26287313 | 26287313 | PRJEB12296_S_NODE_7390_length_187_cov_2.539474_g7358_i0 | PRJEB12296 | 7390 | 187 | 2.539474 | 4.74881638 | Adineta | 104781 | Rotifera | other_Eukaryota | 307 | 3.09e-79 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g7358 | i0 | 100 | 22.6791443850267 | 166 | 0 | 89 | 0 | 1 | 166 | 1665 | 1500 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 4241 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26453058 | 26453058 | PRJEB12296_S_NODE_10200_length_172_cov_2.598540_g10168_i0 | PRJEB12296 | 10200 | 172 | 2.59854 | 4.4694888 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 318 | 1.2899999999999999e-82 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g10168 | i0 | 100 | 58.25 | 172 | 0 | 100 | 0 | 1 | 172 | 1747 | 1576 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 10019 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 33130095 | 33130095 | PRJEB12296_S_NODE_3655_length_237_cov_3.292079_g3623_i0 | PRJEB12296 | 3655 | 237 | 3.292079 | 7.80222723 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 60.8 | 1.96e-9 | NR | CAF0775232.1 | 104777 | g3623 | i0 | 53.7 | 0.683544303797468 | 54 | 25 | 68.4 | 0 | 237 | 76 | 90 | 143 | CAF0775232.1 unnamed protein product [Brachionus calyciflorus] | diamond | 162 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;