contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11147780 | 11147780 | PRJNA971593_P_NODE_1609_length_912_cov_2.953516_g1498_i0 | PRJNA971593 | 1609 | 912 | 2.953516 | 26.93606592 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 470 | 2.15e-127 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g1498 | i0 | 82.664 | 31.0131578947368 | 548 | 77 | 59 | 14 | 14 | 552 | 11791 | 11253 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 28284 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 12423317 | 12423317 | PRJNA971593_P_NODE_11390_length_358_cov_2.161404_g11241_i0 | PRJNA971593 | 11390 | 358 | 2.161404 | 7.73782632 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 243 | 1.8700000000000001e-59 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g11241 | i0 | 79.109 | 34.3184357541899 | 359 | 70 | 99 | 5 | 1 | 357 | 11 | 366 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 12286 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 12423663 | 12423663 | PRJNA971593_P_NODE_970_length_1131_cov_58.889414_g878_i0 | PRJNA971593 | 970 | 1131 | 58.889414 | 666.03927234 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 414 | 1.2799999999999996e-110 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g878 | i0 | 76.982 | 16.1503094606543 | 782 | 145 | 68 | 30 | 5 | 769 | 11842 | 11079 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 18266 | 414 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 13697779 | 13697779 | PRJNA971593_P_NODE_10071_length_382_cov_1.245955_g9922_i0 | PRJNA971593 | 10071 | 382 | 1.245955 | 4.7595481 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 119 | 3.54e-22 | NTclustered | gi|1066800225|gb|KX364936.1| | 96890 | g9922 | i0 | 72.868 | 21.2879581151832 | 387 | 90 | 99 | 14 | 1 | 381 | 342 | 719 | Brachionus rotundiformis chromosome I mitochondrion, complete sequence | blastn | 8132 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 18796179 | 18796179 | PRJNA971593_P_NODE_455_length_1510_cov_5.814196_g391_i0 | PRJNA971593 | 455 | 1510 | 5.814196 | 87.7943596 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 1005 | 0 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g391 | i0 | 79.761 | 51.400662251655604 | 1423 | 258 | 93 | 23 | 25 | 1432 | 31 | 1438 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 77615 | 1005 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 22621269 | 22621269 | PRJNA971593_P_NODE_14198_length_319_cov_1.565041_g14049_i0 | PRJNA971593 | 14198 | 319 | 1.565041 | 4.99248079 | Lepadellidae sp. SHQC150123a | 1804024 | Rotifera | other_Eukaryota | 379 | 1.21e-100 | NTclustered | gi|1009658444|gb|KU720095.1| | 1804024 | g14049 | i0 | 88.328 | 98.5203761755486 | 317 | 35 | 99 | 2 | 4 | 319 | 605 | 290 | Lepadellidae sp. SHQC150123a cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 31428 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadellidae sp. SHQC150123a | ||
| 25170266 | 25170266 | PRJNA971593_P_NODE_12020_length_348_cov_2.174545_g11871_i0 | PRJNA971593 | 12020 | 348 | 2.174545 | 7.5674166 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 200 | 1.11e-46 | NTclustered | gi|218117260|emb|AM980958.1| | 10195 | g11871 | i0 | 81.377 | 1.31609195402299 | 247 | 44 | 71 | 2 | 103 | 348 | 74 | 319 | Brachionus plicatilis partial mRNA for 40S ribosomal protein S11, (RPS11 gene) | blastn | 458 | 200 | 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);;