contig_metadata
10 rows where bioproject = "PRJNA312107", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 377499 | 377499 | PRJNA312107_P_NODE_10221_length_226_cov_1.158192_g10055_i0 | PRJNA312107 | 10221 | 226 | 1.158192 | 2.61751392 | Basiria sp. SAN-2005 | 345476 | Nematoda | Nematoda | 335 | 1.7799999999999993e-87 | NTclustered | gi|76560594|gb|DQ145619.1| | 345476 | g10055 | i0 | 97.927 | 54.6371681415929 | 193 | 4 | 85 | 0 | 34 | 226 | 1 | 193 | Basiria sp. SAN-2005 28S ribosomal RNA gene, partial sequence | blastn | 12348 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Tylenchidae | Basiria | Basiria sp. SAN-2005 | |
| 1063645 | 1063645 | PRJNA312107_P_NODE_16981_length_177_cov_1.625000_g16815_i0 | PRJNA312107 | 16981 | 177 | 1.625 | 2.87625 | Rhabditis | 6244 | Nematoda | Nematoda | 326 | 7.98e-85 | NTclustered | gi|1116078226|gb|KY119482.1| | 293674 | g16815 | i0 | 100 | 99.2090395480226 | 176 | 0 | 99 | 0 | 1 | 176 | 182 | 7 | Rhabditis cf. terricola JH-2004 isolate L07_CgCONTROL6_ 18S ribosomal RNA gene, partial sequence | blastn | 17560 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhabditis | Rhabditis cf. terricola JH-2004 | |
| 7441572 | 7441572 | PRJNA312107_P_NODE_23686_length_164_cov_0.904348_g23520_i0 | PRJNA312107 | 23686 | 164 | 0.904348 | 1.48313072 | Rhabditida | 6236 | Nematoda | Nematoda | 111 | 2.23e-20 | NTclustered | gi|2547219|gb|AF023856.1|AF023856 | 6304 | g23520 | i0 | 94.444 | 42.2682926829268 | 72 | 4 | 44 | 0 | 9 | 80 | 420 | 491 | Meloidogyne arenaria | blastn | 6932 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne arenaria | |
| 9991802 | 9991802 | PRJNA312107_P_NODE_25928_length_162_cov_0.920354_g25762_i0 | PRJNA312107 | 25928 | 162 | 0.920354 | 1.49097348 | Oscheius | 42476 | Nematoda | Nematoda | 137 | 3.6199999999999997e-28 | NTclustered | gi|1689836140|gb|MN082311.1| | 2590334 | g25762 | i0 | 82.692 | 1.92592592592593 | 156 | 25 | 96 | 2 | 1 | 156 | 478 | 631 | Oscheius sp. 1 TWN2097 small subunit ribosomal RNA gene, partial sequence | blastn | 312 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius sp. 1 TWN2097 | |
| 10581618 | 10581618 | PRJNA312107_P_NODE_9629_length_231_cov_2.571429_g9463_i0 | PRJNA312107 | 9629 | 231 | 2.571429 | 5.94000099 | Mylonchulus sp. K628_SM1056 | 3025613 | Nematoda | Nematoda | 351 | 1.8199999999999998e-92 | NTclustered | gi|2439550342|gb|OQ377022.1| | 3025613 | g9463 | i0 | 94.323 | 12.8441558441558 | 229 | 13 | 99 | 0 | 3 | 231 | 288 | 60 | Mylonchulus sp. K628_SM1056 large subunit ribosomal RNA gene, partial sequence | blastn | 2967 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Mononchida | Mylonchulidae | Mylonchulus | Mylonchulus sp. K628_SM1056 | |
| 11266853 | 11266853 | PRJNA312107_P_NODE_7109_length_267_cov_2.811927_g6943_i0 | PRJNA312107 | 7109 | 267 | 2.811927 | 7.50784509 | Rhabditis | 6244 | Nematoda | Nematoda | 387 | 5.9e-103 | NTclustered | gi|675118772|gb|KJ877243.1| | 473155 | g6943 | i0 | 100 | 80.6404494382023 | 209 | 0 | 78 | 0 | 1 | 209 | 1644 | 1852 | Rhabditis brassicae strain RS5617 28S ribosomal RNA gene, partial sequence | blastn | 21531 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhabditis | Rhabditis brassicae | |
| 14406478 | 14406478 | PRJNA312107_P_NODE_14732_length_190_cov_1.943262_g14566_i0 | PRJNA312107 | 14732 | 190 | 1.943262 | 3.6921978 | Rhabditis sp. DF5059 | 479136 | Nematoda | Nematoda | 351 | 1.4399999999999997e-92 | NTclustered | gi|158821900|gb|EU195964.1| | 479136 | g14566 | i0 | 100 | 9.41578947368421 | 190 | 0 | 100 | 0 | 1 | 190 | 1354 | 1543 | Rhabditis sp. DF5059 28S ribosomal RNA gene, partial sequence | blastn | 1789 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhabditis | Rhabditis sp. DF5059 | |
| 14406609 | 14406609 | PRJNA312107_P_NODE_8872_length_240_cov_2.429319_g8706_i0 | PRJNA312107 | 8872 | 240 | 2.429319 | 5.8303656 | Cervidellus neftasiensis | 345484 | Nematoda | Nematoda | 145 | 3.46e-30 | NTclustered | gi|76560654|gb|DQ145679.1| | 345484 | g8706 | i0 | 81.967 | 39.525 | 183 | 22 | 73 | 8 | 66 | 240 | 554 | 375 | Cervidellus neftasiensis 28S ribosomal RNA gene, partial sequence | blastn | 9486 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Cephalobidae | Cervidellus | Cervidellus neftasiensis | |
| 20189701 | 20189701 | PRJNA312107_P_NODE_16696_length_179_cov_1.200000_g16530_i0 | PRJNA312107 | 16696 | 179 | 1.2 | 2.148 | Rhabditis | 6244 | Nematoda | Nematoda | 331 | 1.74e-86 | NTclustered | gi|34105849|gb|AY284653.1| | 293674 | g16530 | i0 | 100 | 98.4748603351955 | 179 | 0 | 100 | 0 | 1 | 179 | 704 | 882 | Rhabditis cf. terricola JH-2004 isolate RhabTerZ 18S small subunit ribosomal RNA gene, partial sequence | blastn | 17627 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhabditis | Rhabditis cf. terricola JH-2004 | |
| 29127171 | 29127171 | PRJNA312107_P_NODE_11049_length_218_cov_1.195266_g10883_i0 | PRJNA312107 | 11049 | 218 | 1.195266 | 2.60567988 | Trichinella nativa | 6335 | Nematoda | Nematoda | 48.1 | 1.53e-5 | NR | KRZ47273.1 | 6335 | g10883 | i0 | 92.3 | 0.357798165137615 | 26 | 2 | 35.8 | 0 | 33 | 110 | 8 | 33 | KRZ47273.1 hypothetical protein T02_1459 [Trichinella nativa] | diamond | 78 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella nativa |
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);;