contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3778554 | 3778554 | PRJNA814235_P_NODE_21243_length_415_cov_1.500000_g19881_i0 | PRJNA814235 | 21243 | 415 | 1.5 | 6.225 | Poikilolaimus | 96658 | Nematoda | Nematoda | 758 | 0 | NTclustered | gi|70609419|gb|DQ059057.1| | 96660 | g19881 | i0 | 99.758 | 14.3301204819277 | 413 | 1 | 99 | 0 | 3 | 415 | 542 | 130 | Poikilolaimus regenfussi strain SB199 28S large subunit ribosomal RNA gene, partial sequence | blastn | 5947 | 758 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus regenfussi | |
| 4645649 | 4645649 | PRJNA814235_P_NODE_202344_length_150_cov_1.681416_g200949_i0 | PRJNA814235 | 202344 | 150 | 1.681416 | 2.522124 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 261 | 1.86e-65 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g200949 | i0 | 98 | 100.66 | 150 | 3 | 100 | 0 | 1 | 150 | 2020 | 1871 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 15099 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 4647007 | 4647007 | PRJNA814235_P_NODE_81264_length_211_cov_1.528736_g79869_i0 | PRJNA814235 | 81264 | 211 | 1.528736 | 3.22563296 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 357 | 3.5099999999999996e-94 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g79869 | i0 | 97.156 | 100.943127962085 | 211 | 6 | 100 | 0 | 1 | 211 | 2583 | 2793 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 21299 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 16120259 | 16120259 | PRJNA814235_P_NODE_40513_length_300_cov_2.775665_g39122_i0 | PRJNA814235 | 40513 | 300 | 2.775665 | 8.326995 | Rotylenchulus reniformis | 239373 | Nematoda | Nematoda | 187 | 7.33e-43 | NTclustered | gi|264664697|gb|FJ905984.1| | 239373 | g39122 | i0 | 93.651 | 1.41 | 126 | 7 | 42 | 1 | 1 | 125 | 60 | 185 | Rotylenchulus reniformis clone 190 microsatellite sequence | blastn | 423 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Hoplolaimidae | Rotylenchulus | Rotylenchulus reniformis | |
| 21218841 | 21218841 | PRJNA814235_P_NODE_181317_length_152_cov_2.078261_g179922_i0 | PRJNA814235 | 181317 | 152 | 2.078261 | 3.15895672 | Poikilolaimus oxycercus | 96659 | Nematoda | Nematoda | 246 | 5.31e-61 | NTclustered | gi|158821920|gb|EU195984.1| | 96659 | g179922 | i0 | 96.622 | 3.03947368421053 | 148 | 5 | 97 | 0 | 5 | 152 | 1718 | 1865 | Poikilolaimus oxycercus strain SB200 28S ribosomal RNA gene, partial sequence | blastn | 462 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus oxycercus | |
| 21219640 | 21219640 | PRJNA814235_P_NODE_38317_length_309_cov_1.911765_g36927_i0 | PRJNA814235 | 38317 | 309 | 1.911765 | 5.90735385 | Poikilolaimus regenfussi | 96660 | Nematoda | Nematoda | 571 | 1.7899999999999995e-158 | NTclustered | gi|8515061|gb|AF083022.1| | 96660 | g36927 | i0 | 100 | 94.8349514563107 | 309 | 0 | 100 | 0 | 1 | 309 | 331 | 23 | Poikilolaimus regenfussi strain SB199 18S ribosomal RNA gene, partial sequence | blastn | 29304 | 571 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus regenfussi | |
| 25043582 | 25043582 | PRJNA814235_P_NODE_22580_length_402_cov_2.523288_g21216_i0 | PRJNA814235 | 22580 | 402 | 2.523288 | 10.14361776 | Poikilolaimus regenfussi | 96660 | Nematoda | Nematoda | 586 | 8.539999999999997e-163 | NTclustered | gi|1252285341|gb|MG051252.1| | 2042950 | g21216 | i0 | 99.688 | 93.9900497512438 | 320 | 1 | 80 | 0 | 83 | 402 | 1 | 320 | Poikilolaimus regenfussi KW-1C-12 large subunit ribosomal RNA gene, partial sequence | blastn | 37784 | 586 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Poikilolaimus | Poikilolaimus regenfussi |
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);;