contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904492 | 1904492 | PRJNA662254_P_NODE_5682_length_726_cov_3.831547_g5086_i0 | PRJNA662254 | 5682 | 726 | 3.831547 | 27.81703122 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 848 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g5086 | i0 | 87.805 | 85.504132231405 | 738 | 73 | 100 | 10 | 1 | 726 | 1151 | 419 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 62076 | 848 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 6265707 | 6265707 | PRJNA662254_P_NODE_14545_length_430_cov_4.364146_g13894_i0 | PRJNA662254 | 14545 | 430 | 4.364146 | 18.7658278 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 662 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g13894 | i0 | 94.432 | 99.553488372093 | 431 | 23 | 100 | 1 | 1 | 430 | 423 | 853 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 42808 | 667 | 0.992503748125937 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 8281586 | 8281586 | PRJNA662254_P_NODE_59907_length_244_cov_0.900585_g59256_i0 | PRJNA662254 | 59907 | 244 | 0.900585 | 2.1974274 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 62.1 | 3.66e-5 | NTclustered | gi|345452365|gb|JN235987.1| | 104782 | g59256 | i0 | 88.462 | 0.213114754098361 | 52 | 5 | 21 | 1 | 56 | 107 | 36273 | 36323 | Adineta vaga clone 111A10 genomic sequence | blastn | 52 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 10832539 | 10832539 | PRJNA662254_P_NODE_6189_length_690_cov_9.435981_g5580_i0 | PRJNA662254 | 6189 | 690 | 9.435981 | 65.1082689 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 1242 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g5580 | i0 | 99.13 | 41.5463768115942 | 690 | 6 | 100 | 0 | 1 | 690 | 1855 | 2544 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 28667 | 1242 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 12107646 | 12107646 | PRJNA662254_P_NODE_41230_length_261_cov_1.882979_g40579_i0 | PRJNA662254 | 41230 | 261 | 1.882979 | 4.91457519 | Brachionus manjavacas | 667381 | Rotifera | other_Eukaryota | 154 | 6.34e-33 | NTclustered | gi|2006240371|gb|MW559986.1| | 667381 | g40579 | i0 | 81.675 | 14.1072796934866 | 191 | 29 | 72 | 5 | 40 | 227 | 6337 | 6524 | Brachionus manjavacas isolate AU chromosome I mitochondrion, complete sequence | blastn | 3682 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus manjavacas | |
| 14657209 | 14657209 | PRJNA662254_P_NODE_31132_length_298_cov_0.924444_g30481_i0 | PRJNA662254 | 31132 | 298 | 0.924444 | 2.75484312 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 351 | 2.44e-92 | NTclustered | gi|188501695|gb|EU643494.1| | 104782 | g30481 | i0 | 88.294 | 1.52013422818792 | 299 | 27 | 100 | 5 | 1 | 298 | 4707 | 4998 | Adineta vaga clone 209H10 transposon hobo-like, retrotransposon Juno1.6, and transposon hobo-like, complete sequence; microsatellite sequence; retrotransposon Athena and transposon, complete sequence; hypothetical protein and putative lipoprotein-like protein genes, complete cds; and retrotransposon Athena, complete sequence | blastn | 453 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 14657392 | 14657392 | PRJNA662254_P_NODE_8132_length_591_cov_1.604247_g7502_i0 | PRJNA662254 | 8132 | 591 | 1.604247 | 9.48109977 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 473 | 1.0499999999999999e-128 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g7502 | i0 | 81.575 | 20.6429780033841 | 597 | 89 | 100 | 18 | 1 | 591 | 1681 | 2262 | Philodina citrina complete mitochondrial genome | blastn | 12200 | 473 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 16464730 | 16464730 | PRJNA662254_P_NODE_1513_length_1432_cov_3.986019_g1213_i0 | PRJNA662254 | 1513 | 1432 | 3.986019 | 57.07979208 | Ploima | 84394 | Rotifera | other_Eukaryota | 1258 | 0 | NTclustered | gi|1802791203|gb|MN256532.1| | 392764 | g1213 | i0 | 82.771 | 53.0013966480447 | 1422 | 233 | 99 | 11 | 1 | 1416 | 16 | 1431 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 75898 | 1258 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 17206209 | 17206209 | PRJNA662254_P_NODE_12394_length_467_cov_1.982234_g11743_i0 | PRJNA662254 | 12394 | 467 | 1.982234 | 9.25703278 | Brachionus patulus | 160652 | Rotifera | other_Eukaryota | 230 | 1.9499999999999994e-55 | NTclustered | gi|14276851|gb|AF325132.1|AF325132 | 160652 | g11743 | i0 | 82.143 | 38.5845824411135 | 280 | 38 | 59 | 10 | 26 | 300 | 273 | 1 | Brachionus patulus 16S ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 18019 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus patulus | |
| 21030982 | 21030982 | PRJNA662254_P_NODE_9277_length_548_cov_2.172632_g8635_i0 | PRJNA662254 | 9277 | 548 | 2.172632 | 11.90602336 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 350 | 1.71e-91 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g8635 | i0 | 78.388 | 18.286496350365 | 546 | 112 | 99 | 6 | 6 | 548 | 28 | 570 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 10021 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 21563888 | 21563888 | PRJNA662254_P_NODE_27357_length_316_cov_17.082305_g26706_i0 | PRJNA662254 | 27357 | 316 | 17.082305 | 53.9800838 | Metazoa | 33208 | Rotifera | other_Eukaryota | 584 | 2.359999999999999e-162 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g26706 | i0 | 100 | 53.4715189873418 | 316 | 0 | 100 | 0 | 1 | 316 | 1505 | 1820 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 16897 | 584 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 23580899 | 23580899 | PRJNA662254_P_NODE_2439_length_1143_cov_3.749533_g2048_i0 | PRJNA662254 | 2439 | 1143 | 3.749533 | 42.85716219 | Brachionus falcatus | 392765 | Rotifera | other_Eukaryota | 418 | 9.97e-112 | NTclustered | gi|2615504969|gb|OR665529.1| | 392765 | g2048 | i0 | 73.977 | 3.167104111986 | 1149 | 247 | 98 | 45 | 27 | 1143 | 10600 | 11728 | Brachionus falcatus chromosome 2 mitochondrion, complete sequence | blastn | 3620 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus falcatus |
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);;