contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB6584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25523815 | 25523815 | PRJEB6584h_S_NODE_15897_length_185_cov_2.626667_g15835_i0 | PRJEB6584 | 15897 | 185 | 2.626667 | 4.85933395 | Rotaria sp. | 3383503 | Rotifera | other_Eukaryota | 213 | 6.85e-51 | NTclustered | gi|2863702047|gb|PQ666788.1| | 3383503 | g15835 | i0 | 88.636 | 4.15135135135135 | 176 | 19 | 95 | 1 | 1 | 176 | 175 | 1 | Rotaria sp. isolate AMW1.1 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 768 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. | |
| 25523830 | 25523830 | PRJEB6584h_S_NODE_4369_length_257_cov_2.819820_g4307_i0 | PRJEB6584 | 4369 | 257 | 2.81982 | 7.2469374 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 193 | 1.32e-44 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g4307 | i0 | 80.233 | 35.9105058365759 | 258 | 49 | 100 | 2 | 1 | 257 | 845 | 589 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 9229 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 25524202 | 25524202 | PRJEB6584n_S_NODE_361_length_235_cov_1.370000_g355_i0 | PRJEB6584 | 361 | 235 | 1.37 | 3.2195 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 272 | 1.4899999999999996e-68 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g355 | i0 | 87.815 | 3.93191489361702 | 238 | 21 | 99 | 6 | 2 | 235 | 2079 | 2312 | Philodina citrina complete mitochondrial genome | blastn | 924 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 25751997 | 25751997 | PRJEB6584b_S_NODE_1594_length_254_cov_8.493151_g1576_i0 | PRJEB6584 | 1594 | 254 | 8.493151 | 21.57260354 | Embata | 468648 | Rotifera | other_Eukaryota | 470 | 5.37e-128 | NTclustered | gi|281323392|gb|GQ922297.1| | 317506 | g1576 | i0 | 100 | 100.027559055118 | 254 | 0 | 100 | 0 | 1 | 254 | 27 | 280 | Uncultured bdelloid rotifer clone F11_Rot_AGL 18S ribosomal RNA gene, partial sequence | blastn | 25407 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Bdelloidea environmental sample | ||||
| 25795760 | 25795760 | PRJEB6584h_S_NODE_10371_length_201_cov_2521.855422_g10309_i0 | PRJEB6584 | 10371 | 201 | 2521.855422 | 5068.92939822 | Lepadella triba | 497826 | Rotifera | other_Eukaryota | 255 | 1.24e-63 | NTclustered | gi|166014122|gb|EU252111.1| | 497826 | g10309 | i0 | 99.291 | 19.4378109452736 | 141 | 1 | 70 | 0 | 61 | 201 | 193 | 53 | Lepadella triba internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 3907 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella triba | |
| 25796275 | 25796275 | PRJEB6584o_S_NODE_11843_length_255_cov_3.977273_g11735_i0 | PRJEB6584 | 11843 | 255 | 3.977273 | 10.14204615 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 309 | 1.25e-79 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g11735 | i0 | 89.2 | 6.56078431372549 | 250 | 24 | 98 | 3 | 6 | 255 | 2423 | 2177 | Rotaria rotatoria mitochondrion, complete genome | blastn | 1673 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 25887894 | 25887894 | PRJEB6584h_S_NODE_9963_length_203_cov_6.172619_g9901_i0 | PRJEB6584 | 9963 | 203 | 6.172619 | 12.53041657 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1104767204|gb|KT989538.1| | 10195 | g9901 | i0 | 90.476 | 1.31527093596059 | 42 | 3 | 21 | 1 | 1 | 42 | 6 | 46 | Brachionus plicatilis homeodomain transcription factor Hox2 (Hox2) mRNA, complete cds | blastn | 267 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 25888162 | 25888162 | PRJEB6584o_S_NODE_35867_length_175_cov_6.792857_g35759_i0 | PRJEB6584 | 35867 | 175 | 6.792857 | 11.88749975 | Brachionus | 10194 | Rotifera | other_Eukaryota | 78.7 | 2.43e-10 | NTclustered | gi|254587481|dbj|AB513493.1| | 10195 | g35759 | i0 | 97.778 | 2.14285714285714 | 45 | 1 | 26 | 0 | 110 | 154 | 1382 | 1338 | Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds | blastn | 375 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 26204168 | 26204168 | PRJEB6584b_S_NODE_550_length_390_cov_14.938028_g532_i0 | PRJEB6584 | 550 | 390 | 14.938028 | 58.2583092 | Philodinavus paradoxus | 468666 | Rotifera | other_Eukaryota | 676 | 0 | NTclustered | gi|2537903913|gb|JX494731.2| | 468666 | g532 | i0 | 97.949 | 100.002564102564 | 390 | 8 | 100 | 0 | 1 | 390 | 542 | 931 | Philodinavus paradoxus isolate A533 18S ribosomal RNA gene, partial sequence | blastn | 39001 | 676 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinavida | Philodinavidae | Philodinavus | Philodinavus paradoxus | |
| 26204232 | 26204232 | PRJEB6584c_S_NODE_206_length_317_cov_3.663121_g200_i0 | PRJEB6584 | 206 | 317 | 3.663121 | 11.61209357 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 327 | 4.41e-85 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g200 | i0 | 87.241 | 1.7192429022082 | 290 | 33 | 91 | 4 | 30 | 317 | 2423 | 2136 | Rotaria rotatoria mitochondrion, complete genome | blastn | 545 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 26204349 | 26204349 | PRJEB6584h_S_NODE_3814_length_269_cov_6.179487_g3752_i0 | PRJEB6584 | 3814 | 269 | 6.179487 | 16.62282003 | Plationus patulus | 360686 | Rotifera | other_Eukaryota | 272 | 1.74e-68 | NTclustered | gi|83285203|gb|DQ297750.1| | 360686 | g3752 | i0 | 86.694 | 67.2267657992565 | 248 | 30 | 91 | 3 | 1 | 246 | 547 | 301 | Plationus patulus 28S ribosomal RNA gene, partial sequence | blastn | 18084 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Plationus | Plationus patulus | |
| 26296089 | 26296089 | PRJEB6584h_S_NODE_1558_length_352_cov_9.936909_g1496_i0 | PRJEB6584 | 1558 | 352 | 9.936909 | 34.97791968 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 577 | 4.4399999999999985e-160 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g1496 | i0 | 98.182 | 69.7272727272727 | 330 | 6 | 94 | 0 | 1 | 330 | 6967 | 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 | 24544 | 582 | 0.991408934707904 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26296214 | 26296214 | PRJEB6584m_S_NODE_1542_length_175_cov_1.392857_g1530_i0 | PRJEB6584 | 1542 | 175 | 1.392857 | 2.43749975 | Metazoa | 33208 | Rotifera | other_Eukaryota | 324 | 2.83e-84 | NTclustered | gi|1399047|gb|U41281.1|PAU41281 | 44582 | g1530 | i0 | 100 | 99.9885714285714 | 175 | 0 | 100 | 0 | 1 | 175 | 401 | 227 | Philodina acuticornis 18S rRNA gene | blastn | 17498 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina acuticornis | |
| 26432215 | 26432215 | PRJEB6584m_S_NODE_1591_length_173_cov_2.753623_g1579_i0 | PRJEB6584 | 1591 | 173 | 2.753623 | 4.76376779 | Adineta | 104781 | Rotifera | other_Eukaryota | 309 | 7.81e-80 | NTclustered | gi|2537903787|gb|KM043252.2| | 104782 | g1579 | i0 | 98.844 | 100.034682080925 | 173 | 2 | 100 | 0 | 1 | 173 | 620 | 792 | Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence | blastn | 17306 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26478157 | 26478157 | PRJEB6584p_S_NODE_1272_length_266_cov_4.735931_g1241_i0 | PRJEB6584 | 1272 | 266 | 4.735931 | 12.59757646 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 248 | 2.89e-61 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g1241 | i0 | 88.78 | 15.9360902255639 | 205 | 19 | 76 | 4 | 35 | 237 | 2423 | 2221 | Rotaria rotatoria mitochondrion, complete genome | blastn | 4239 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 26567971 | 26567971 | PRJEB6584b_S_NODE_10632_length_155_cov_2.766667_g10614_i0 | PRJEB6584 | 10632 | 155 | 2.766667 | 4.28833385 | Metazoa | 33208 | Rotifera | other_Eukaryota | 287 | 3.21e-73 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g10614 | i0 | 100 | 78.9354838709677 | 155 | 0 | 100 | 0 | 1 | 155 | 1790 | 1636 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 12235 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 26568098 | 26568098 | PRJEB6584h_S_NODE_10592_length_200_cov_11.472727_g10530_i0 | PRJEB6584 | 10592 | 200 | 11.472727 | 22.945454 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|1104767204|gb|KT989538.1| | 10195 | g10530 | i0 | 100 | 9.56 | 30 | 0 | 15 | 0 | 171 | 200 | 34 | 5 | Brachionus plicatilis homeodomain transcription factor Hox2 (Hox2) mRNA, complete cds | blastn | 1912 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;