contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB83711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5246509 | 5246509 | PRJEB83711_P_NODE_35065_length_305_cov_1.448276_g34799_i0 | PRJEB83711 | 35065 | 305 | 1.448276 | 4.4172418 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 564 | 2.95e-156 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g34799 | i0 | 100 | 86.3245901639344 | 305 | 0 | 100 | 0 | 1 | 305 | 345 | 41 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 26329 | 564 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 12897641 | 12897641 | PRJEB83711_P_NODE_46031_length_275_cov_1.376238_g45765_i0 | PRJEB83711 | 46031 | 275 | 1.376238 | 3.7846545 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 387 | 6.1e-103 | NTclustered | gi|188501553|gb|EU643478.1| | 104782 | g45765 | i0 | 92 | 1 | 275 | 22 | 100 | 0 | 1 | 275 | 42495 | 42769 | Adineta vaga clone Av_TEL_K_B retrotransposons Juno and Athenas, and mariner-like, complete sequence; hypothetical protein gene, complete cds; transposons piggyBac-like and hobo-like and retrotransposon Athena, complete sequence; kelch domain protein-like protein gene, complete cds; helicase conserved C-terminal domain containing protein-like protein pseudogene, transposons mariner-like, and kelch repeat containing protein-like protein pseudogene, complete sequence; NHL repeat containing cell surface protein-like protein gene, complete cds; transposons piggyBac-like and transposons, complete sequence; TPR repeat containing protein-like protein gene, complete cds; transposon mariner-like, complete sequence; putative S-isoprenylcysteine O-methyltransferase-like protein gene, complete cds; retrotransposon Athena, complete sequence; and unknown genes | blastn | 275 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 21400752 | 21400752 | PRJEB83711_P_NODE_41157_length_286_cov_1.427230_g40891_i0 | PRJEB83711 | 41157 | 286 | 1.42723 | 4.0818778 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 507 | 4.69e-139 | NTclustered | gi|2537903784|gb|KM043249.2| | 338310 | g40891 | i0 | 99.286 | 87.5174825174825 | 280 | 2 | 98 | 0 | 1 | 280 | 280 | 1 | Abrochtha meselsoni voucher Angl_1_1 18S ribosomal RNA gene, partial sequence | blastn | 25030 | 510 | 0.994117647058824 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinavida | Philodinavidae | Abrochtha | Abrochtha meselsoni | |
| 21820438 | 21820438 | PRJEB83711_P_NODE_28178_length_336_cov_3.064639_g27912_i0 | PRJEB83711 | 28178 | 336 | 3.064639 | 10.29718704 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 577 | 4.229999999999999e-160 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g27912 | i0 | 97.619 | 100.85119047619 | 336 | 8 | 100 | 0 | 1 | 336 | 524 | 859 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 33886 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola |
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);;