contig_metadata
8 rows where bioproject = "PRJNA193544", tax_clade = "Opisthokonta" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1640647 | 1640647 | PRJNA193544_S_NODE_1382_length_220_cov_4.115183_g1367_i0 | PRJNA193544 | 1382 | 220 | 4.115183 | 9.0534026 | Proceraea cornuta | 122240 | Annelida | Annelida | 97.1 | 8.87e-16 | NTclustered | gi|11494214|gb|AF212165.1|AF212165 | 122240 | g1367 | i0 | 87.805 | 12.7136363636364 | 82 | 10 | 37 | 0 | 2 | 83 | 3482 | 3563 | Proceraea cornuta internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 2797 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Syllidae | Proceraea | Proceraea cornuta | |
| 4192998 | 4192998 | PRJNA193544_S_NODE_444_length_327_cov_11810.281879_g429_i0 | PRJNA193544 | 444 | 327 | 11810.281879 | 38619.62174433 | Chloeia sp. r EEE-2022 | 2907852 | Annelida | Annelida | 276 | 1.6799999999999998e-69 | NTclustered | gi|2172937611|gb|OM135245.1| | 2907852 | g429 | i0 | 83.612 | 146.122324159021 | 299 | 43 | 90 | 6 | 1 | 294 | 6707 | 7004 | Chloeia sp. r EEE-2022 voucher UCNSCB-6857 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 47782 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Chloeia | Chloeia sp. r EEE-2022 | |
| 8019289 | 8019289 | PRJNA193544_S_NODE_727_length_282_cov_14702.063241_g712_i0 | PRJNA193544 | 727 | 282 | 14702.063241 | 41459.81833962 | Lumbriculus variegatus | 61662 | Annelida | Annelida | 346 | 1.07e-90 | NTclustered | gi|17999856|gb|AY040693.1| | 61662 | g712 | i0 | 91.7 | 88.9255319148936 | 253 | 16 | 88 | 5 | 1 | 249 | 2 | 253 | Lumbriculus variegatus 18S ribosomal RNA gene, partial sequence | blastn | 25077 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus variegatus | |
| 9983262 | 9983262 | PRJNA193544_S_NODE_1028_length_248_cov_637.652968_g1013_i0 | PRJNA193544 | 1028 | 248 | 637.652968 | 1581.37936064 | Aeolosoma | 55816 | Annelida | Annelida | 342 | 1.1899999999999999e-89 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g1013 | i0 | 94.954 | 76.9758064516129 | 218 | 11 | 88 | 0 | 29 | 246 | 262 | 45 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19090 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 16943135 | 16943135 | PRJNA193544_S_NODE_1274_length_226_cov_21.675127_g1259_i0 | PRJNA193544 | 1274 | 226 | 21.675127 | 48.98578702 | Aeolosoma sp. THS-2006 | 397537 | Annelida | Annelida | 324 | 3.86e-84 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g1259 | i0 | 92.511 | 101.29203539823 | 227 | 15 | 100 | 2 | 1 | 226 | 2870 | 2645 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22892 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 17632885 | 17632885 | PRJNA193544_S_NODE_814_length_271_cov_28.644628_g799_i0 | PRJNA193544 | 814 | 271 | 28.644628 | 77.62694188 | Naididae | 2109251 | Annelida | Annelida | 492 | 1.24e-134 | NTclustered | gi|94467835|gb|DQ459983.1| | 74736 | g799 | i0 | 99.628 | 99.8154981549816 | 269 | 1 | 99 | 0 | 3 | 271 | 1 | 269 | Nais elinguis 18S ribosomal RNA gene, partial sequence | blastn | 27050 | 496 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais elinguis | |
| 18217575 | 18217575 | PRJNA193544_S_NODE_1775_length_200_cov_23456.812865_g1760_i0 | PRJNA193544 | 1775 | 200 | 23456.812865 | 46913.62573 | Helobdella robusta | 6412 | Annelida | Annelida | 248 | 2.06e-61 | NTclustered | gi|675861809|ref|XM_009018217.1| | 6412 | g1760 | i0 | 93.413 | 75.6 | 167 | 11 | 84 | 0 | 1 | 167 | 311 | 477 | Helobdella robusta hypothetical protein mRNA | blastn | 15120 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 22732020 | 22732020 | PRJNA193544_S_NODE_698_length_286_cov_34.762646_g683_i0 | PRJNA193544 | 698 | 286 | 34.762646 | 99.42116756 | Lumbriculidae | 77569 | Annelida | Annelida | 412 | 1.0499999999999999e-110 | NTclustered | gi|9437495|gb|AF209457.1|AF209457 | 61662 | g683 | i0 | 92.982 | 100.34965034965 | 285 | 16 | 99 | 4 | 5 | 286 | 298 | 15 | Lumbriculus variegatus 18S ribosomal RNA gene, partial sequence | blastn | 28700 | 412 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Lumbriculida | Lumbriculidae | Lumbriculus | Lumbriculus variegatus |
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);;