contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA770361" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746379 | 746379 | PRJNA770361_P_NODE_18821_length_242_cov_0.923077_g18726_i0 | PRJNA770361 | 18821 | 242 | 0.923077 | 2.23384634 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 150 | 7.509999999999998e-32 | NTclustered | gi|484400306|gb|KC176714.1| | 104777 | g18726 | i0 | 81.921 | 6.71900826446281 | 177 | 32 | 73 | 0 | 37 | 213 | 462 | 638 | Brachionus calyciflorus heat shock protein 70 (hsp70) mRNA, complete cds | blastn | 1626 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 3297683 | 3297683 | PRJNA770361_P_NODE_683_length_1093_cov_16.210784_g626_i0 | PRJNA770361 | 683 | 1093 | 16.210784 | 177.18386912 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 399 | 3.4499999999999997e-106 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g626 | i0 | 75.198 | 18.7895699908509 | 1008 | 166 | 89 | 73 | 32 | 1003 | 2372 | 1413 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 20537 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 7125195 | 7125195 | PRJNA770361_P_NODE_6066_length_380_cov_2.794788_g5971_i0 | PRJNA770361 | 6066 | 380 | 2.794788 | 10.6201944 | Lepadellidae sp. SHQC150123a | 1804024 | Rotifera | other_Eukaryota | 399 | 1.1199999999999995e-106 | NTclustered | gi|1009658444|gb|KU720095.1| | 1804024 | g5971 | i0 | 88.685 | 93.3710526315789 | 327 | 37 | 86 | 0 | 54 | 380 | 1 | 327 | Lepadellidae sp. SHQC150123a cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 35481 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadellidae sp. SHQC150123a | ||
| 8399642 | 8399642 | PRJNA770361_P_NODE_4607_length_438_cov_2.356164_g4512_i0 | PRJNA770361 | 4607 | 438 | 2.356164 | 10.31999832 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 311 | 6.32e-80 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g4512 | i0 | 80.313 | 12.2442922374429 | 447 | 58 | 99 | 24 | 4 | 435 | 1941 | 2372 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 5363 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 12226047 | 12226047 | PRJNA770361_P_NODE_1710_length_717_cov_2.453416_g1619_i0 | PRJNA770361 | 1710 | 717 | 2.453416 | 17.59099272 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 1009 | 0 | NTclustered | gi|167842611|gb|EU188928.1| | 96446 | g1619 | i0 | 92.806 | 92.1534170153417 | 695 | 49 | 97 | 1 | 9 | 702 | 709 | 15 | Lecane bulla isolate Cattail D cytochrome oxidase subunit I-like (cox1) gene, partial sequence; mitochondrial | blastn | 66074 | 1009 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 16048914 | 16048914 | PRJNA770361_P_NODE_1613_length_740_cov_10.926537_g1522_i0 | PRJNA770361 | 1613 | 740 | 10.926537 | 80.8563738 | Proales similis | 360698 | Rotifera | other_Eukaryota | 501 | 6.12e-137 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g1522 | i0 | 80.084 | 50.0108108108108 | 713 | 111 | 94 | 27 | 1 | 697 | 12459 | 11762 | Proales similis mitochondrion, complete genome | blastn | 37008 | 501 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 17784002 | 17784002 | PRJNA770361_P_NODE_2874_length_559_cov_2.512346_g2780_i0 | PRJNA770361 | 2874 | 559 | 2.512346 | 14.04401414 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 529 | 2.0899999999999992e-145 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g2780 | i0 | 85.659 | 22.0035778175313 | 516 | 58 | 91 | 16 | 1 | 509 | 2400 | 1894 | Rotaria rotatoria mitochondrion, complete genome | blastn | 12300 | 534 | 0.99063670411985 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 18598249 | 18598249 | PRJNA770361_P_NODE_875_length_982_cov_1.370737_g809_i0 | PRJNA770361 | 875 | 982 | 1.370737 | 13.46063734 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 470 | 2.32e-127 | NTclustered | gi|1999716438|gb|MT875426.1| | 396692 | g809 | i0 | 80.123 | 9.87576374745418 | 649 | 114 | 65 | 12 | 8 | 648 | 6425 | 7066 | Brachionus angularis chromosome II mitochondrion, complete sequence | blastn | 9698 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 22423611 | 22423611 | PRJNA770361_P_NODE_15638_length_249_cov_0.886364_g15543_i0 | PRJNA770361 | 15638 | 249 | 0.886364 | 2.20704636 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 267 | 7.39e-67 | NTclustered | gi|924266819|gb|KP993543.1| | 10195 | g15543 | i0 | 85.944 | 97.7389558232932 | 249 | 35 | 100 | 0 | 1 | 249 | 2704 | 2456 | Brachionus plicatilis beta-actin gene, complete cds | blastn | 24337 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 23699185 | 23699185 | PRJNA770361_P_NODE_10819_length_287_cov_1.093458_g10724_i0 | PRJNA770361 | 10819 | 287 | 1.093458 | 3.13822446 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 359 | 1.4e-94 | NTclustered | gi|403082251|gb|JX463650.1| | 104777 | g10724 | i0 | 89.437 | 95.0627177700348 | 284 | 30 | 99 | 0 | 2 | 285 | 989 | 706 | Brachionus calyciflorus cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 27283 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 24972850 | 24972850 | PRJNA770361_P_NODE_1100_length_882_cov_2.011125_g1024_i0 | PRJNA770361 | 1100 | 882 | 2.011125 | 17.7381225 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 824 | 0 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g1024 | i0 | 83.692 | 68.3526077097506 | 883 | 135 | 99 | 9 | 2 | 880 | 1288 | 411 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 60287 | 824 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens |
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);;