contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJDB9741" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2560677 | 2560677 | PRJDB9741_P_NODE_1403_length_687_cov_9.526646_g1120_i0 | PRJDB9741 | 1403 | 687 | 9.526646 | 65.44805802 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 396 | 2.75e-105 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g1120 | i0 | 78.931 | 28.8034934497817 | 636 | 94 | 91 | 33 | 55 | 677 | 11790 | 11182 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 19788 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 3532542 | 3532542 | PRJDB9741_P_NODE_5203_length_277_cov_7.482456_g4887_i0 | PRJDB9741 | 5203 | 277 | 7.482456 | 20.72640312 | Metazoa | 33208 | Rotifera | other_Eukaryota | 505 | 1.63e-138 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g4887 | i0 | 99.638 | 55.9097472924188 | 276 | 1 | 99 | 0 | 2 | 277 | 1475 | 1200 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 15487 | 510 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 5113276 | 5113276 | PRJDB9741_P_NODE_24385_length_171_cov_1.516393_g24068_i0 | PRJDB9741 | 24385 | 171 | 1.516393 | 2.59303203 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 268 | 1.31e-67 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g24068 | i0 | 96.319 | 2.7719298245614 | 163 | 6 | 95 | 0 | 1 | 163 | 10236 | 10398 | 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 | 474 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 14039124 | 14039124 | PRJDB9741_P_NODE_5212_length_277_cov_2.210526_g4896_i0 | PRJDB9741 | 5212 | 277 | 2.210526 | 6.12315702 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 507 | 4.53e-139 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g4896 | i0 | 99.639 | 68.0938628158845 | 277 | 1 | 100 | 0 | 1 | 277 | 1949 | 2225 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 18862 | 507 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 18833632 | 18833632 | PRJDB9741_P_NODE_35395_length_163_cov_1.350877_g35078_i0 | PRJDB9741 | 35395 | 163 | 1.350877 | 2.20192951 | Metazoa | 33208 | Rotifera | other_Eukaryota | 294 | 2.04e-75 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g35078 | i0 | 99.383 | 93.638036809816 | 162 | 1 | 99 | 0 | 2 | 163 | 1406 | 1245 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 15263 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 20411684 | 20411684 | PRJDB9741_P_NODE_5177_length_278_cov_3.873362_g4861_i0 | PRJDB9741 | 5177 | 278 | 3.873362 | 10.76794636 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 501 | 2.11e-137 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g4861 | i0 | 99.278 | 83.3669064748201 | 277 | 2 | 99 | 0 | 2 | 278 | 3150 | 2874 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 23176 | 501 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 22962948 | 22962948 | PRJDB9741_P_NODE_6759_length_241_cov_2.838542_g6442_i0 | PRJDB9741 | 6759 | 241 | 2.838542 | 6.84088622 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 298 | 2.52e-76 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g6442 | i0 | 89.3 | 81.0165975103734 | 243 | 19 | 100 | 6 | 1 | 241 | 2154 | 1917 | Philodina citrina complete mitochondrial genome | blastn | 19525 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 25207904 | 25207904 | PRJDB9741_P_NODE_1780_length_580_cov_5.163842_g1479_i0 | PRJDB9741 | 1780 | 580 | 5.163842 | 29.9502836 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 944 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g1479 | i0 | 96.041 | 43.7724137931034 | 581 | 22 | 100 | 1 | 1 | 580 | 1513 | 2093 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 25388 | 950 | 0.993684210526316 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;