contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Tardigrada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7778930 | 7778930 | PRJEB64798_P_NODE_108127_length_210_cov_12.360248_g106361_i0 | PRJEB64798 | 108127 | 210 | 12.360248 | 25.9565208 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 99 | 2.33e-16 | NTclustered | gi|2493474571|ref|XM_055490644.1| | 2943436 | g106361 | i0 | 88.75 | 1.85238095238095 | 80 | 9 | 38 | 0 | 124 | 203 | 664 | 585 | PREDICTED: Paramacrobiotus metropolitanus GTP-binding nuclear protein Ran (LOC129594085), mRNA | blastn | 389 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 7780631 | 7780631 | PRJEB64798_P_NODE_223507_length_161_cov_4.258929_g221741_i0 | PRJEB64798 | 223507 | 161 | 4.258929 | 6.85687569 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 217 | 4.48e-52 | NTclustered | gi|2493507836|ref|XR_008692101.1| | 2943436 | g221741 | i0 | 91.667 | 22.3478260869565 | 156 | 13 | 97 | 0 | 1 | 156 | 3704 | 3549 | PREDICTED: Paramacrobiotus metropolitanus large subunit ribosomal RNA (LOC129600602), rRNA | blastn | 3598 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 11196682 | 11196682 | PRJEB64798_P_NODE_243149_length_154_cov_3.457143_g241383_i0 | PRJEB64798 | 243149 | 154 | 3.457143 | 5.32400022 | Parachela | 149990 | Tardigrada | other_Eukaryota | 172 | 9.3e-39 | NTclustered | gi|1519192605|gb|MH079509.1| | 459430 | g241383 | i0 | 87.919 | 84.8441558441558 | 149 | 14 | 96 | 3 | 3 | 150 | 1074 | 929 | Isohypsibius prosostomus isolate TarCPH14 28S ribosomal RNA gene, partial sequence | blastn | 13066 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Isohypsibiidae | Isohypsibius | Isohypsibius prosostomus | |
| 11196852 | 11196852 | PRJEB64798_P_NODE_43249_length_299_cov_22.668000_g41484_i0 | PRJEB64798 | 43249 | 299 | 22.668 | 67.77732 | Parachela | 149990 | Tardigrada | other_Eukaryota | 71.3 | 7.68e-8 | NTclustered | gi|1045522192|dbj|AP013349.1| | 947166 | g41484 | i0 | 97.561 | 1.2943143812709 | 41 | 1 | 14 | 0 | 192 | 232 | 10757 | 10717 | Ramazzottius varieornatus DNA, Fosmid clone: GRVF-025E17, complete sequence | blastn | 387 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 15021073 | 15021073 | PRJEB64798_P_NODE_210252_length_164_cov_142.434783_g208486_i0 | PRJEB64798 | 210252 | 164 | 142.434783 | 233.59304412 | Echiniscidae | 86847 | Tardigrada | other_Eukaryota | 99 | 1.73e-16 | NTclustered | gi|2806626681|gb|PQ350065.1| | 466947 | g208486 | i0 | 90.541 | 44.9268292682927 | 74 | 7 | 45 | 0 | 79 | 152 | 648 | 575 | Echiniscus blumi voucher Ech.blu-07337 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 7368 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Heterotardigrada | Echiniscoidea | Echiniscidae | Echiniscus | Echiniscus blumi | |
| 19254690 | 19254690 | PRJEB64798_P_NODE_51896_length_271_cov_1328.144144_g50131_i0 | PRJEB64798 | 51896 | 271 | 1328.144144 | 3599.27063024 | Tardigrada environmental sample | 554025 | Tardigrada | other_Eukaryota | 311 | 3.71e-80 | NTclustered | gi|76873296|emb|AM088113.1| | 554025 | g50131 | i0 | 97.79 | 107.73062730627301 | 181 | 3 | 99 | 1 | 90 | 269 | 1 | 181 | Uncultured tardigrade partial 18S rRNA gene, specimen voucher JM2004_JH26_nSSU | blastn | 29195 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Tardigrada environmental sample | |||||
| 23945910 | 23945910 | PRJEB64798_P_NODE_40919_length_308_cov_22.065637_g39154_i0 | PRJEB64798 | 40919 | 308 | 22.065637 | 67.96216196 | Parachela | 149990 | Tardigrada | other_Eukaryota | 71.3 | 7.94e-8 | NTclustered | gi|1045522192|dbj|AP013349.1| | 947166 | g39154 | i0 | 97.561 | 1.25649350649351 | 41 | 1 | 13 | 0 | 68 | 108 | 10717 | 10757 | Ramazzottius varieornatus DNA, Fosmid clone: GRVF-025E17, complete sequence | blastn | 387 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus |
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);;