contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1959142 | 1959142 | PRJNA700095_P_NODE_24422_length_348_cov_7.407273_g23158_i0 | PRJNA700095 | 24422 | 348 | 7.407273 | 25.77731004 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 632 | 9.25e-177 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g23158 | i0 | 99.425 | 68.6005747126437 | 348 | 2 | 100 | 0 | 1 | 348 | 2460 | 2807 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 23873 | 632 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 4511164 | 4511164 | PRJNA700095_P_NODE_24784_length_345_cov_16.283088_g23520_i0 | PRJNA700095 | 24784 | 345 | 16.283088 | 56.1766536 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 632 | 9.17e-177 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g23520 | i0 | 99.71 | 4.4 | 345 | 1 | 100 | 0 | 1 | 345 | 10394 | 10050 | 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 | 1518 | 632 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 10112754 | 10112754 | PRJNA700095_P_NODE_16708_length_444_cov_3.153639_g15445_i0 | PRJNA700095 | 16708 | 444 | 3.153639 | 14.00215716 | Philodinida | 104783 | Rotifera | other_Eukaryota | 525 | 2.1099999999999993e-144 | NTclustered | gi|402761757|gb|JX184010.1| | 104786 | g15445 | i0 | 88.09 | 34.6734234234234 | 445 | 49 | 99 | 3 | 1 | 443 | 194 | 636 | Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 15395 | 525 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 12162263 | 12162263 | PRJNA700095_P_NODE_18030_length_422_cov_15.495702_g16767_i0 | PRJNA700095 | 18030 | 422 | 15.495702 | 65.39186244 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 780 | 0 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g16767 | i0 | 100 | 84.1706161137441 | 422 | 0 | 100 | 0 | 1 | 422 | 4171 | 4592 | 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 | 35520 | 780 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13436843 | 13436843 | PRJNA700095_P_NODE_10211_length_608_cov_3.792523_g8977_i0 | PRJNA700095 | 10211 | 608 | 3.792523 | 23.05853984 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 558 | 2.91e-154 | NTclustered | gi|402761773|gb|JX184018.1| | 104786 | g8977 | i0 | 83.416 | 2.56414473684211 | 603 | 98 | 99 | 2 | 1 | 602 | 25 | 626 | Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial | blastn | 1559 | 558 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 17261300 | 17261300 | PRJNA700095_P_NODE_8314_length_685_cov_4.282680_g7142_i0 | PRJNA700095 | 8314 | 685 | 4.28268 | 29.336358 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 675 | 0 | NTclustered | gi|402761805|gb|JX184034.1| | 104786 | g7142 | i0 | 84.728 | 13.7416058394161 | 681 | 97 | 99 | 6 | 4 | 679 | 28 | 706 | Habrotrocha constricta NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 9413 | 675 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 18535178 | 18535178 | PRJNA700095_P_NODE_6675_length_768_cov_44.955396_g5582_i0 | PRJNA700095 | 6675 | 768 | 44.955396 | 345.25744128 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 793 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g5582 | i0 | 86.193 | 25.7760416666667 | 746 | 87 | 96 | 15 | 3 | 741 | 1657 | 2393 | Philodina citrina complete mitochondrial genome | blastn | 19796 | 793 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 19035946 | 19035946 | PRJNA700095_P_NODE_22535_length_366_cov_27.498294_g21271_i0 | PRJNA700095 | 22535 | 366 | 27.498294 | 100.64375604 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 643 | 4.5099999999999985e-180 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g21271 | i0 | 98.361 | 77.7814207650273 | 366 | 6 | 100 | 0 | 1 | 366 | 7010 | 6645 | 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 | 28468 | 649 | 0.99075500770416 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 20310472 | 20310472 | PRJNA700095_P_NODE_10976_length_582_cov_12.383104_g9735_i0 | PRJNA700095 | 10976 | 582 | 12.383104 | 72.06966528 | Adineta | 104781 | Rotifera | other_Eukaryota | 1064 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g9735 | i0 | 99.656 | 43.585910652921 | 582 | 2 | 100 | 0 | 1 | 582 | 2103 | 1522 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 25367 | 1064 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 20310523 | 20310523 | PRJNA700095_P_NODE_26616_length_331_cov_12.740310_g25352_i0 | PRJNA700095 | 26616 | 331 | 12.74031 | 42.1704261 | Adinetidae | 104780 | Rotifera | other_Eukaryota | 601 | 2.4699999999999994e-167 | NTclustered | gi|2537903787|gb|KM043252.2| | 104782 | g25352 | i0 | 99.396 | 99.987915407855 | 331 | 2 | 100 | 0 | 1 | 331 | 919 | 589 | Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence | blastn | 33096 | 601 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22360518 | 22360518 | PRJNA700095_P_NODE_6218_length_795_cov_2.570637_g5149_i0 | PRJNA700095 | 6218 | 795 | 2.570637 | 20.43656415 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 857 | 0 | NTclustered | gi|402761779|gb|JX184021.1| | 104788 | g5149 | i0 | 86.164 | 40.4452830188679 | 795 | 108 | 99 | 2 | 1 | 794 | 902 | 109 | Macrotrachela quadricornifera isolate HR cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 32154 | 857 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 24909414 | 24909414 | PRJNA700095_P_NODE_14320_length_492_cov_6.744630_g13061_i0 | PRJNA700095 | 14320 | 492 | 6.74463 | 33.1835796 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 776 | 0 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g13061 | i0 | 95.132 | 97.4959349593496 | 493 | 22 | 100 | 2 | 1 | 492 | 7507 | 7016 | 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 | 47968 | 776 | 1 | 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);;