contig_metadata
7 rows where bioproject = "PRJNA599208" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1141448 | 1141448 | PRJNA599208_P_NODE_3401_length_467_cov_3.918605_g3207_i0 | PRJNA599208 | 3401 | 467 | 3.918605 | 18.29988535 | Rhabditophanes | 114889 | Nematoda | Nematoda | 839 | 0 | NTclustered | gi|76560630|gb|DQ145655.1| | 114890 | g3207 | i0 | 98.929 | 51.0963597430407 | 467 | 5 | 100 | 0 | 1 | 467 | 604 | 138 | Rhabditophanes sp. KR3021 28S ribosomal RNA gene, partial sequence | blastn | 23862 | 846 | 0.991725768321513 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Alloionematidae | Rhabditophanes | Rhabditophanes sp. KR3021 | |
| 3692955 | 3692955 | PRJNA599208_P_NODE_4303_length_400_cov_3.327824_g4109_i0 | PRJNA599208 | 4303 | 400 | 3.327824 | 13.311296 | Rhabditophanes | 114889 | Nematoda | Nematoda | 701 | 0 | NTclustered | gi|76560678|gb|DQ145703.1| | 114890 | g4109 | i0 | 98.25 | 47.445 | 400 | 7 | 100 | 0 | 1 | 400 | 935 | 536 | Rhabditophanes sp. KR3021 28S ribosomal RNA gene, partial sequence | blastn | 18978 | 701 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Alloionematidae | Rhabditophanes | Rhabditophanes sp. KR3021 | |
| 8225353 | 8225353 | PRJNA599208_P_NODE_13387_length_175_cov_1.231884_g13191_i0 | PRJNA599208 | 13387 | 175 | 1.231884 | 2.155797 | Rhabditophanes sp. KR3021 | 114890 | Nematoda | Nematoda | 228 | 2.2799999999999996e-55 | NTclustered | gi|76560630|gb|DQ145655.1| | 114890 | g13191 | i0 | 100 | 42.2742857142857 | 123 | 0 | 70 | 0 | 1 | 123 | 123 | 1 | Rhabditophanes sp. KR3021 28S ribosomal RNA gene, partial sequence | blastn | 7398 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Alloionematidae | Rhabditophanes | Rhabditophanes sp. KR3021 | |
| 15169704 | 15169704 | PRJNA599208_P_NODE_4952_length_362_cov_3.532308_g4757_i0 | PRJNA599208 | 4952 | 362 | 3.532308 | 12.78695496 | Rhabditophanes | 114889 | Nematoda | Nematoda | 664 | 0 | NTclustered | gi|76560678|gb|DQ145703.1| | 114890 | g4757 | i0 | 100 | 100.091160220994 | 359 | 0 | 99 | 0 | 4 | 362 | 1444 | 1086 | Rhabditophanes sp. KR3021 28S ribosomal RNA gene, partial sequence | blastn | 36233 | 664 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Alloionematidae | Rhabditophanes | Rhabditophanes sp. KR3021 | |
| 15169735 | 15169735 | PRJNA599208_P_NODE_7712_length_262_cov_3.582222_g7516_i0 | PRJNA599208 | 7712 | 262 | 3.582222 | 9.38542164 | Rhabditophanes | 114889 | Nematoda | Nematoda | 484 | 1.99e-132 | NTclustered | gi|76560630|gb|DQ145655.1| | 114890 | g7516 | i0 | 100 | 61.5267175572519 | 262 | 0 | 100 | 0 | 1 | 262 | 900 | 639 | Rhabditophanes sp. KR3021 28S ribosomal RNA gene, partial sequence | blastn | 16120 | 484 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Alloionematidae | Rhabditophanes | Rhabditophanes sp. KR3021 | |
| 17149896 | 17149896 | PRJNA599208_P_NODE_5754_length_325_cov_2.937500_g5558_i0 | PRJNA599208 | 5754 | 325 | 2.9375 | 9.546875 | Rhabditophanes sp. AMS-2013 | 1352046 | Nematoda | Nematoda | 547 | 3.199999999999999e-151 | NTclustered | gi|516323920|gb|JX674037.1| | 1352046 | g5558 | i0 | 99.666 | 78.4276923076923 | 299 | 1 | 92 | 0 | 1 | 299 | 299 | 1 | Rhabditophanes sp. AMS-2013 isolate 57H6_57H7 18S small subunit ribosomal RNA gene, partial sequence | blastn | 25489 | 547 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Alloionematidae | Rhabditophanes | Rhabditophanes sp. AMS-2013 | |
| 20267891 | 20267891 | PRJNA599208_P_NODE_13316_length_175_cov_2.789855_g13120_i0 | PRJNA599208 | 13316 | 175 | 2.789855 | 4.88224625 | Rhabditophanes | 114889 | Nematoda | Nematoda | 318 | 1.32e-82 | NTclustered | gi|4099000|gb|U81580.1|PNU81580 | 55747 | g13120 | i0 | 99.429 | 81.8285714285714 | 175 | 1 | 100 | 0 | 1 | 175 | 574 | 748 | Panagrolaimoid nematode KR3021 18S small subunit ribosomal RNA gene, complete sequence | blastn | 14320 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | panagrolaimoid nematode KR3021 |
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);;