contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA484127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1723407 | 1723407 | PRJNA484127_P_NODE_36542_length_244_cov_4.000000_g36393_i0 | PRJNA484127 | 36542 | 244 | 4 | 9.76 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 174 | 4.5e-39 | NTclustered | gi|1800329609|gb|MN417951.1| | 104777 | g36393 | i0 | 79.508 | 8.37295081967213 | 244 | 50 | 100 | 0 | 1 | 244 | 10088 | 9845 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 2043 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 4275523 | 4275523 | PRJNA484127_P_NODE_24404_length_273_cov_1.530000_g24255_i0 | PRJNA484127 | 24404 | 273 | 1.53 | 4.1769 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 294 | 3.77e-75 | NTclustered | gi|1999716438|gb|MT875426.1| | 396692 | g24255 | i0 | 86.131 | 92.7655677655678 | 274 | 36 | 100 | 2 | 1 | 273 | 958 | 686 | Brachionus angularis chromosome II mitochondrion, complete sequence | blastn | 25325 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 5552307 | 5552307 | PRJNA484127_P_NODE_3705_length_577_cov_2.301587_g3560_i0 | PRJNA484127 | 3705 | 577 | 2.301587 | 13.28015699 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 361 | 8.329999999999999e-95 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g3560 | i0 | 79.292 | 24.57712305026 | 565 | 79 | 95 | 30 | 30 | 577 | 2406 | 1863 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 14181 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 6825936 | 6825936 | PRJNA484127_P_NODE_17286_length_311_cov_1.966387_g17137_i0 | PRJNA484127 | 17286 | 311 | 1.966387 | 6.11546357 | Brachionus sp. JMP-2011 | 1068660 | Rotifera | other_Eukaryota | 195 | 4.56e-45 | NTclustered | gi|340748003|gb|JN035900.1| | 1068660 | g17137 | i0 | 78.413 | 34.7202572347267 | 315 | 57 | 99 | 10 | 2 | 311 | 6 | 314 | Brachionus sp. JMP-2011 clone 45_PET8_29 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 10798 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus sp. JMP-2011 | |
| 9376064 | 9376064 | PRJNA484127_P_NODE_10348_length_378_cov_1.278689_g10199_i0 | PRJNA484127 | 10348 | 378 | 1.278689 | 4.83344442 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 553 | 8.099999999999998e-153 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g10199 | i0 | 93.103 | 54.0476190476191 | 377 | 26 | 99 | 0 | 1 | 377 | 1697 | 2073 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 20430 | 553 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 10652237 | 10652237 | PRJNA484127_P_NODE_25969_length_266_cov_1.906736_g25820_i0 | PRJNA484127 | 25969 | 266 | 1.906736 | 5.07191776 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 329 | 1e-85 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g25820 | i0 | 89.313 | 63.4022556390977 | 262 | 28 | 98 | 0 | 5 | 266 | 568 | 829 | Philodina citrina complete mitochondrial genome | blastn | 16865 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 10652486 | 10652486 | PRJNA484127_P_NODE_5249_length_498_cov_2.007059_g5101_i0 | PRJNA484127 | 5249 | 498 | 2.007059 | 9.99515382 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 372 | 3.29e-98 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g5101 | i0 | 80.318 | 40.6305220883534 | 503 | 89 | 100 | 10 | 1 | 498 | 679 | 182 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 20234 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 11927450 | 11927450 | PRJNA484127_P_NODE_5770_length_478_cov_3.844444_g5622_i0 | PRJNA484127 | 5770 | 478 | 3.844444 | 18.37644232 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 448 | 5.0799999999999984e-121 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g5622 | i0 | 84.11 | 25.0753138075314 | 472 | 65 | 98 | 9 | 9 | 478 | 1744 | 2207 | Philodina citrina complete mitochondrial genome | blastn | 11986 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 13201877 | 13201877 | PRJNA484127_P_NODE_10811_length_371_cov_2.006711_g10662_i0 | PRJNA484127 | 10811 | 371 | 2.006711 | 7.44489781 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 422 | 2.33e-113 | NTclustered | gi|6018198|gb|AF143851.1|AF143851 | 96448 | g10662 | i0 | 87.778 | 34.5256064690027 | 360 | 44 | 97 | 0 | 10 | 369 | 648 | 289 | Philodina roseola 82 kD heat shock protein 1 (hsp82-1) gene, partial cds | blastn | 12809 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 14476940 | 14476940 | PRJNA484127_P_NODE_17372_length_311_cov_1.239496_g17223_i0 | PRJNA484127 | 17372 | 311 | 1.239496 | 3.85483256 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 272 | 2.0499999999999993e-68 | NTclustered | gi|183178937|gb|EU432547.1| | 96448 | g17223 | i0 | 85.878 | 10.7459807073955 | 262 | 30 | 83 | 4 | 1 | 257 | 29619 | 29360 | Philodina roseola TAR protein gene, partial cds; U1-like Zn-finger-containing protein (U1Zn_1), unknown (PruORF0001_1), unknown (PrPCG0001_1), methione sulfide reductase B (MSRB_1), Strabismus, serine-threonin kinase copy 1, plasma membrane calcium-dependent ATPase (CAse_1), myosin essential light chain (MELC_1), and 82 kDa heat shock protein (hsp82_1) genes, complete cds; FBoxLRR_1 gene, complete sequence; and TPRA_1 (TPRA_1) gene, complete cds | blastn | 3342 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 14477312 | 14477312 | PRJNA484127_P_NODE_38332_length_242_cov_2.272189_g38183_i0 | PRJNA484127 | 38332 | 242 | 2.272189 | 5.49869738 | Adineta sp. SCL-15-7 | 2843316 | Rotifera | other_Eukaryota | 267 | 7.15e-67 | NTclustered | gi|2049839123|gb|MT997071.1| | 2843316 | g38183 | i0 | 85.774 | 89.7190082644628 | 239 | 34 | 99 | 0 | 2 | 240 | 30 | 268 | Adineta sp. SCL-15-7 actin gene, partial cds | blastn | 21712 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta sp. SCL-15-7 | |
| 14477369 | 14477369 | PRJNA484127_P_NODE_4952_length_510_cov_1.633867_g4805_i0 | PRJNA484127 | 4952 | 510 | 1.633867 | 8.3327217 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 571 | 3.0999999999999998e-158 | NTclustered | gi|403492655|gb|JX193066.1| | 204736 | g4805 | i0 | 86.561 | 98.2529411764706 | 506 | 68 | 99 | 0 | 2 | 507 | 235 | 740 | Brachionus urceolaris isolate A458b alpha tubulin gene, partial cds | blastn | 50109 | 571 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 15125315 | 15125315 | PRJNA484127_P_NODE_7912_length_419_cov_3.465318_g7764_i0 | PRJNA484127 | 7912 | 419 | 3.465318 | 14.51968242 | Brachionus | 10194 | Rotifera | other_Eukaryota | 261 | 6.16e-65 | NTclustered | gi|1066800225|gb|KX364936.1| | 96890 | g7764 | i0 | 79.688 | 52.4439140811456 | 384 | 60 | 90 | 16 | 44 | 419 | 9473 | 9846 | Brachionus rotundiformis chromosome I mitochondrion, complete sequence | blastn | 21974 | 263 | 0.992395437262357 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 17026102 | 17026102 | PRJNA484127_P_NODE_7794_length_422_cov_2.340974_g7646_i0 | PRJNA484127 | 7794 | 422 | 2.340974 | 9.87891028 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 440 | 7.419999999999997e-119 | NTclustered | gi|183178949|gb|EU432548.1| | 96448 | g7646 | i0 | 85.511 | 3.99526066350711 | 421 | 61 | 99 | 0 | 2 | 422 | 39558 | 39978 | Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds | blastn | 1686 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 19574557 | 19574557 | PRJNA484127_P_NODE_40836_length_199_cov_5.968254_g40687_i0 | PRJNA484127 | 40836 | 199 | 5.968254 | 11.87682546 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 220 | 4.47e-53 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g40687 | i0 | 86.935 | 2.89949748743719 | 199 | 23 | 99 | 3 | 1 | 198 | 2207 | 2403 | Rotaria rotatoria mitochondrion, complete genome | blastn | 577 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 23400895 | 23400895 | PRJNA484127_P_NODE_31459_length_251_cov_0.876404_g31310_i0 | PRJNA484127 | 31459 | 251 | 0.876404 | 2.19977404 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 244 | 3.5000000000000003e-60 | NTclustered | gi|572455682|gb|KF159020.1| | 96448 | g31310 | i0 | 87.5 | 70.2151394422311 | 216 | 22 | 86 | 5 | 37 | 251 | 659 | 448 | Philodina roseola myosin heavy chain type II mRNA, partial cds | blastn | 17624 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 23401077 | 23401077 | PRJNA484127_P_NODE_6199_length_465_cov_1.377551_g6051_i0 | PRJNA484127 | 6199 | 465 | 1.377551 | 6.40561215 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 479 | 1.7499999999999995e-130 | NTclustered | gi|403492655|gb|JX193066.1| | 204736 | g6051 | i0 | 84.881 | 97.8064516129032 | 463 | 70 | 99 | 0 | 1 | 463 | 721 | 259 | Brachionus urceolaris isolate A458b alpha tubulin gene, partial cds | blastn | 45480 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 24049203 | 24049203 | PRJNA484127_P_NODE_3099_length_625_cov_4.902174_g2956_i0 | PRJNA484127 | 3099 | 625 | 4.902174 | 30.6385875 | Ploima | 84394 | Rotifera | other_Eukaryota | 353 | 1.52e-92 | NTclustered | gi|1800329609|gb|MN417951.1| | 104777 | g2956 | i0 | 79.584 | 52.9408 | 529 | 80 | 83 | 22 | 34 | 551 | 11421 | 10910 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 33088 | 353 | 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);;