contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3657253 | 3657253 | PRJNA493827_P_NODE_77823_length_391_cov_1.641509_g75625_i0 | PRJNA493827 | 77823 | 391 | 1.641509 | 6.41830019 | Metazoa | 33208 | Rotifera | other_Eukaryota | 717 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g75625 | i0 | 99.744 | 51.5038363171356 | 391 | 1 | 100 | 0 | 1 | 391 | 2249 | 1859 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 20138 | 717 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 5576040 | 5576040 | PRJNA493827_P_NODE_24225_length_777_cov_5.924716_g22314_i0 | PRJNA493827 | 24225 | 777 | 5.924716 | 46.03504332 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 340 | 1.48e-88 | NTclustered | gi|477541870|gb|KC603851.1| | 1199090 | g22314 | i0 | 78.223 | 36.2702702702703 | 574 | 96 | 72 | 27 | 189 | 750 | 9615 | 10171 | Brachionus sp. 'koreanus' chromosome I mitochondrion, complete sequence | blastn | 28182 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 6847994 | 6847994 | PRJNA493827_P_NODE_142046_length_287_cov_1.079439_g139848_i0 | PRJNA493827 | 142046 | 287 | 1.079439 | 3.09798993 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 276 | 1.45e-69 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g139848 | i0 | 84.589 | 29.6689895470383 | 292 | 30 | 99 | 10 | 3 | 287 | 1744 | 2027 | Philodina citrina complete mitochondrial genome | blastn | 8515 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 14502679 | 14502679 | PRJNA493827_P_NODE_81592_length_381_cov_1.500000_g79394_i0 | PRJNA493827 | 81592 | 381 | 1.5 | 5.715 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 67.6 | 1.3e-6 | NTclustered | gi|1143271481|gb|KX822781.1| | 104777 | g79394 | i0 | 100 | 1.95800524934383 | 36 | 0 | 9 | 0 | 124 | 159 | 6959 | 6994 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 746 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 15774398 | 15774398 | PRJNA493827_P_NODE_206873_length_246_cov_1.335260_g204675_i0 | PRJNA493827 | 206873 | 246 | 1.33526 | 3.2847396 | Brachionus falcatus | 392765 | Rotifera | other_Eukaryota | 178 | 3.5099999999999993e-40 | NTclustered | gi|2615504964|gb|OR601541.1| | 392765 | g204675 | i0 | 82.547 | 37.5772357723577 | 212 | 27 | 85 | 10 | 21 | 228 | 10437 | 10232 | Brachionus falcatus chromosome 1 mitochondrion, complete sequence | blastn | 9244 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus falcatus | |
| 15776405 | 15776405 | PRJNA493827_P_NODE_73953_length_402_cov_30.981763_g71755_i0 | PRJNA493827 | 73953 | 402 | 30.981763 | 124.54668726 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 555 | 2.41e-153 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g71755 | i0 | 91.584 | 39.0845771144279 | 404 | 31 | 100 | 3 | 1 | 402 | 733 | 331 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 15712 | 555 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 22150785 | 22150785 | PRJNA493827_P_NODE_93398_length_355_cov_1.290780_g91200_i0 | PRJNA493827 | 93398 | 355 | 1.29078 | 4.582269 | Brachionus patulus | 160652 | Rotifera | other_Eukaryota | 263 | 1.43e-65 | NTclustered | gi|213959405|gb|FJ426639.1| | 160652 | g91200 | i0 | 80.609 | 27.2225352112676 | 361 | 52 | 99 | 14 | 2 | 355 | 29 | 378 | Brachionus patulus voucher S. H. Cheng 010 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 9664 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus patulus | |
| 24696379 | 24696379 | PRJNA493827_P_NODE_141420_length_287_cov_1.845794_g139222_i0 | PRJNA493827 | 141420 | 287 | 1.845794 | 5.29742878 | Keratella tropica | 885372 | Rotifera | other_Eukaryota | 259 | 1.46e-64 | NTclustered | gi|308156993|gb|GQ890458.1| | 885372 | g139222 | i0 | 84.307 | 9.198606271777 | 274 | 33 | 94 | 7 | 1 | 269 | 46 | 314 | Keratella tropica isolate DNA101 large subunit ribosomal RNA gene, partial sequence | blastn | 2640 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Keratella | Keratella tropica |
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);;