contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA781427" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4589772 | 4589772 | PRJNA781427_P_NODE_72964_length_253_cov_1.922222_g72080_i0 | PRJNA781427 | 72964 | 253 | 1.922222 | 4.86322166 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 353 | 5.62e-93 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g72080 | i0 | 92.339 | 11.3438735177866 | 248 | 19 | 98 | 0 | 4 | 251 | 26962 | 26715 | Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds | blastn | 2870 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 4589834 | 4589834 | PRJNA781427_P_NODE_75884_length_250_cov_2.734463_g75000_i0 | PRJNA781427 | 75884 | 250 | 2.734463 | 6.8361575 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 207 | 4.57e-49 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g75000 | i0 | 83.857 | 1.564 | 223 | 30 | 87 | 2 | 34 | 250 | 27726 | 27948 | Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds | blastn | 391 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 8413774 | 8413774 | PRJNA781427_P_NODE_4327_length_1363_cov_2.264341_g3925_i0 | PRJNA781427 | 4327 | 1363 | 2.264341 | 30.86296783 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 1495 | 0 | NTclustered | gi|402761731|gb|JX183997.1| | 104788 | g3925 | i0 | 86.51 | 52.3771093176816 | 1364 | 178 | 99 | 6 | 1 | 1361 | 34 | 1394 | Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 71390 | 1495 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 12240821 | 12240821 | PRJNA781427_P_NODE_62650_length_280_cov_1.400966_g61766_i0 | PRJNA781427 | 62650 | 280 | 1.400966 | 3.9227048 | Brachionus quadridentatus | 183142 | Rotifera | other_Eukaryota | 259 | 1.42e-64 | NTclustered | gi|403492653|gb|JX193065.1| | 183142 | g61766 | i0 | 83.333 | 49.4392857142857 | 276 | 44 | 98 | 2 | 6 | 280 | 323 | 49 | Brachionus quadridentatus isolate A458a alpha tubulin gene, partial cds | blastn | 13843 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus quadridentatus | |
| 13513862 | 13513862 | PRJNA781427_P_NODE_18071_length_579_cov_3.553360_g17216_i0 | PRJNA781427 | 18071 | 579 | 3.55336 | 20.5739544 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 379 | 2.31e-100 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g17216 | i0 | 79.371 | 35.5509499136442 | 572 | 93 | 97 | 22 | 20 | 579 | 11258 | 11816 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 20584 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 13513970 | 13513970 | PRJNA781427_P_NODE_22591_length_504_cov_1.429234_g21712_i0 | PRJNA781427 | 22591 | 504 | 1.429234 | 7.20333936 | Philodina sp. NPS-2005 | 317012 | Rotifera | other_Eukaryota | 440 | 9e-119 | NTclustered | gi|62362203|gb|AY942841.1| | 317012 | g21712 | i0 | 84.773 | 0.873015873015873 | 440 | 65 | 87 | 2 | 17 | 455 | 502 | 64 | Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds | blastn | 440 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. NPS-2005 | |
| 14789160 | 14789160 | PRJNA781427_P_NODE_38992_length_366_cov_1.576792_g38110_i0 | PRJNA781427 | 38992 | 366 | 1.576792 | 5.77105872 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 392 | 1.8e-104 | NTclustered | gi|62362191|gb|AY942835.1| | 249248 | g38110 | i0 | 86.389 | 1.95081967213115 | 360 | 47 | 98 | 2 | 1 | 359 | 168 | 526 | Adineta ricciae ribosomal protein L18a-like protein mRNA, complete cds | blastn | 714 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 18612536 | 18612536 | PRJNA781427_P_NODE_52135_length_311_cov_1.735294_g51252_i0 | PRJNA781427 | 52135 | 311 | 1.735294 | 5.39676434 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 176 | 1.65e-39 | NTclustered | gi|1252327087|gb|KY828435.1| | 1199090 | g51252 | i0 | 78.81 | 23.1768488745981 | 269 | 51 | 86 | 6 | 42 | 310 | 887 | 625 | Brachionus koreanus elongation factor 1 alpha mRNA, partial cds | blastn | 7208 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 19887923 | 19887923 | PRJNA781427_P_NODE_57576_length_294_cov_1.018100_g56692_i0 | PRJNA781427 | 57576 | 294 | 1.0181 | 2.993214 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 281 | 3.2000000000000007e-71 | NTclustered | gi|189313924|gb|EU637018.1| | 104782 | g56692 | i0 | 84.122 | 3.89795918367347 | 296 | 41 | 99 | 3 | 1 | 293 | 27516 | 27224 | Adineta vaga 7 transmembrane receptor 2, 7 transmembrane receptor 4, myosin alkali light chain, sodefrin precursor repeats A, sodefrin precursor repeats C, metal binding protein, tRNA methyltransferase, laminin-G, tetratricopeptide repeat containing protein, hsp82, hypothetical proteins, zinc carboxypeptidase, hypothetical protein, and saicars genes, complete cds; and hypothetical protein gene, partial cds | blastn | 1146 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 21162616 | 21162616 | PRJNA781427_P_NODE_18377_length_573_cov_1.932000_g17520_i0 | PRJNA781427 | 18377 | 573 | 1.932 | 11.07036 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 291 | 1.0999999999999999e-73 | NTclustered | gi|402761887|gb|JX184075.1| | 104788 | g17520 | i0 | 77.395 | 18.0174520069808 | 522 | 96 | 89 | 20 | 8 | 518 | 1044 | 534 | Macrotrachela quadricornifera isolate CR NADH dehydrogenase subunit 5 (ND5) gene, partial cds; mitochondrial | blastn | 10324 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 21162687 | 21162687 | PRJNA781427_P_NODE_21077_length_525_cov_3.984513_g20207_i0 | PRJNA781427 | 21077 | 525 | 3.984513 | 20.91869325 | Proales similis | 360698 | Rotifera | other_Eukaryota | 339 | 3.53e-88 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g20207 | i0 | 79.596 | 22.087619047619 | 495 | 84 | 93 | 16 | 1 | 487 | 12519 | 12034 | Proales similis mitochondrion, complete genome | blastn | 11596 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 21163742 | 21163742 | PRJNA781427_P_NODE_61997_length_282_cov_1.105263_g61113_i0 | PRJNA781427 | 61997 | 282 | 1.105263 | 3.11684166 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 344 | 3.83e-90 | NTclustered | gi|83285134|gb|DQ297775.1| | 96446 | g61113 | i0 | 88.652 | 100.124113475177 | 282 | 32 | 100 | 0 | 1 | 282 | 142 | 423 | Lecane bulla cytochrome c oxidase subunit I gene, partial cds; mitochondrial | blastn | 28235 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 21613608 | 21613608 | PRJNA781427_P_NODE_12477_length_734_cov_5.535552_g11696_i0 | PRJNA781427 | 12477 | 734 | 5.535552 | 40.63095168 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 634 | 5.739999999999999e-177 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g11696 | i0 | 82.597 | 19.3201634877384 | 747 | 102 | 100 | 25 | 1 | 734 | 1666 | 2397 | Rotaria rotatoria mitochondrion, complete genome | blastn | 14181 | 634 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 23714696 | 23714696 | PRJNA781427_P_NODE_91159_length_243_cov_1.358824_g90275_i0 | PRJNA781427 | 91159 | 243 | 1.358824 | 3.30194232 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 206 | 1.59e-48 | NTclustered | gi|2105975276|gb|MZ706949.1| | 104777 | g90275 | i0 | 82.5 | 71.6460905349794 | 240 | 36 | 98 | 5 | 5 | 241 | 27023 | 26787 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 17410 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 24988082 | 24988082 | PRJNA781427_P_NODE_77880_length_250_cov_0.870056_g76996_i0 | PRJNA781427 | 77880 | 250 | 0.870056 | 2.17514 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 209 | 1.27e-49 | NTclustered | gi|402761793|gb|JX184028.1| | 104788 | g76996 | i0 | 81.855 | 38.44 | 248 | 45 | 99 | 0 | 2 | 249 | 760 | 1007 | Macrotrachela quadricornifera isolate CR cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 9610 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera |
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);;