contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6399809 | 6399809 | PRJEB17675_P_NODE_286_length_1537_cov_5.145140_g231_i0 | PRJEB17675 | 286 | 1537 | 5.14514 | 79.0808018 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 1360 | 0 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g231 | i0 | 82.682 | 51.9121665582303 | 1536 | 262 | 99 | 4 | 2 | 1535 | 22 | 1555 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 79789 | 1360 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 7673954 | 7673954 | PRJEB17675_P_NODE_4787_length_444_cov_2.371638_g4489_i0 | PRJEB17675 | 4787 | 444 | 2.371638 | 10.53007272 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 300 | 1.39e-76 | NTclustered | gi|2105975276|gb|MZ706949.1| | 104777 | g4489 | i0 | 79.439 | 40.8738738738739 | 428 | 85 | 96 | 3 | 18 | 444 | 990 | 565 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 18148 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 8638933 | 8638933 | PRJEB17675_P_NODE_12567_length_236_cov_2.263682_g12263_i0 | PRJEB17675 | 12567 | 236 | 2.263682 | 5.34228952 | Lecane | 96445 | Rotifera | other_Eukaryota | 318 | 1.89e-82 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g12263 | i0 | 90.871 | 44.271186440678 | 241 | 16 | 100 | 2 | 1 | 236 | 2056 | 1817 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 10448 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 12775256 | 12775256 | PRJEB17675_P_NODE_271_length_1568_cov_12.669928_g222_i0 | PRJEB17675 | 271 | 1568 | 12.669928 | 198.66447104 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 1090 | 0 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g222 | i0 | 80.587 | 46.5707908163265 | 1432 | 262 | 91 | 15 | 4 | 1427 | 15 | 1438 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 73023 | 1090 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 12775267 | 12775267 | PRJEB17675_P_NODE_4291_length_472_cov_2.272311_g3994_i0 | PRJEB17675 | 4291 | 472 | 2.272311 | 10.72530792 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 231 | 5.49e-56 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g3994 | i0 | 76.887 | 3.57203389830508 | 424 | 88 | 89 | 10 | 12 | 430 | 9119 | 8701 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 1686 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 12775268 | 12775268 | PRJEB17675_P_NODE_4391_length_466_cov_5.030162_g4094_i0 | PRJEB17675 | 4391 | 466 | 5.030162 | 23.44055492 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 150 | 1.5599999999999998e-31 | NTclustered | gi|218117256|emb|AM980956.1| | 10195 | g4094 | i0 | 84.314 | 0.751072961373391 | 153 | 24 | 33 | 0 | 212 | 364 | 153 | 1 | Brachionus plicatilis partial mRNA for 60S ribosomal protein L39, (RPL39 gene) | blastn | 350 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 12775273 | 12775273 | PRJEB17675_P_NODE_4831_length_441_cov_7.325123_g4533_i0 | PRJEB17675 | 4831 | 441 | 7.325123 | 32.30379243 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 671 | 0 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g4533 | i0 | 94.118 | 77.1020408163265 | 442 | 25 | 100 | 1 | 1 | 441 | 733 | 292 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 34002 | 671 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 16598462 | 16598462 | PRJEB17675_P_NODE_174_length_1804_cov_7.318824_g137_i0 | PRJEB17675 | 174 | 1804 | 7.318824 | 132.03158496 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 499 | 5.52e-136 | NTclustered | gi|1066800230|gb|KX364937.1| | 96890 | g137 | i0 | 73.518 | 8.89745011086474 | 1484 | 324 | 80 | 54 | 5 | 1448 | 5598 | 7052 | Brachionus rotundiformis chromosome II mitochondrion, complete sequence | blastn | 16051 | 499 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 17873313 | 17873313 | PRJEB17675_P_NODE_5615_length_402_cov_4.136240_g5316_i0 | PRJEB17675 | 5615 | 402 | 4.13624 | 16.6276848 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 248 | 4.58e-61 | NTclustered | gi|218117265|emb|AM980960.1| | 10195 | g5316 | i0 | 81.09 | 1.33582089552239 | 312 | 57 | 77 | 2 | 92 | 402 | 13 | 323 | Brachionus plicatilis partial mRNA for 40S ribosomal protein S20, (RPS20 gene) | blastn | 537 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 19147116 | 19147116 | PRJEB17675_P_NODE_16156_length_200_cov_1.060606_g15852_i0 | PRJEB17675 | 16156 | 200 | 1.060606 | 2.121212 | Monostyla sp. MPN-2013 | 1443992 | Rotifera | other_Eukaryota | 154 | 4.63e-33 | NTclustered | gi|572455655|gb|KF159018.1| | 1443992 | g15852 | i0 | 85.161 | 17.59 | 155 | 17 | 76 | 6 | 1 | 152 | 238 | 389 | Monostyla sp. MPN-2013 methionine adenosyltransferase mRNA, partial cds | blastn | 3518 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Monostyla | Monostyla sp. MPN-2013 | |
| 19147161 | 19147161 | PRJEB17675_P_NODE_4156_length_481_cov_3.228700_g3862_i0 | PRJEB17675 | 4156 | 481 | 3.2287 | 15.530047 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 191 | 9.52e-44 | NTclustered | gi|1800329609|gb|MN417951.1| | 104777 | g3862 | i0 | 79.061 | 4.96673596673597 | 277 | 58 | 58 | 0 | 153 | 429 | 9835 | 10111 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 2389 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 20422411 | 20422411 | PRJEB17675_P_NODE_617_length_1158_cov_2.861086_g503_i0 | PRJEB17675 | 617 | 1158 | 2.861086 | 33.13137588 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 863 | 0 | NTclustered | gi|260063821|dbj|AB492236.1| | 10195 | g503 | i0 | 82.752 | 62.8635578583765 | 974 | 162 | 84 | 3 | 1 | 971 | 62 | 1032 | Brachionus plicatilis GAPDH mRNA for glyceraldehyde-3-phosphate dehydrogenase, complete cds | blastn | 72796 | 863 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 22973631 | 22973631 | PRJEB17675_P_NODE_1939_length_705_cov_3.953731_g1708_i0 | PRJEB17675 | 1939 | 705 | 3.953731 | 27.87380355 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 375 | 3.68e-99 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g1708 | i0 | 80.357 | 30.2992907801418 | 504 | 91 | 71 | 8 | 1 | 500 | 404 | 903 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 21361 | 375 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 22973681 | 22973681 | PRJEB17675_P_NODE_699_length_1087_cov_62.397338_g573_i0 | PRJEB17675 | 699 | 1087 | 62.397338 | 678.25906406 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 455 | 7.210000000000001e-123 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g573 | i0 | 80.308 | 21.8445262189512 | 650 | 88 | 58 | 32 | 436 | 1064 | 11198 | 11828 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 23745 | 455 | 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);;