contig_metadata
13 rows where bioproject = "PRJNA640143", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3161161 | 3161161 | PRJNA640143_S_NODE_7323_length_311_cov_7.003650_g7113_i0 | PRJNA640143 | 7323 | 311 | 7.00365 | 21.7813515 | Aporrectodea tuberculata | 565146 | Annelida | Annelida | 514 | 3.08e-141 | NTclustered | gi|238818303|gb|FJ967651.1| | 565146 | g7113 | i0 | 100 | 13.459807073955 | 278 | 0 | 89 | 0 | 1 | 278 | 541 | 264 | Aporrectodea tuberculata isolate MPL68 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 4186 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea tuberculata | |
| 3707024 | 3707024 | PRJNA640143_S_NODE_15163_length_224_cov_2.074866_g14953_i0 | PRJNA640143 | 15163 | 224 | 2.074866 | 4.64769984 | Aporrectodea | 27388 | Annelida | Annelida | 403 | 4.7699999999999995e-108 | NTclustered | gi|2307919705|ref|NC_066400.1| | 302032 | g14953 | i0 | 99.107 | 91.2589285714286 | 224 | 2 | 100 | 0 | 1 | 224 | 11700 | 11923 | Aporrectodea caliginosa isolate 420Ra mitochondrion, complete genome | blastn | 20442 | 403 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea caliginosa | |
| 4437813 | 4437813 | PRJNA640143_S_NODE_32364_length_151_cov_1.728070_g32154_i0 | PRJNA640143 | 32364 | 151 | 1.72807 | 2.6093857 | Aporrectodea tuberculata | 565146 | Annelida | Annelida | 252 | 1.13e-62 | NTclustered | gi|2312616639|ref|NC_066721.1| | 565146 | g32154 | i0 | 96.711 | 20.0927152317881 | 152 | 4 | 100 | 1 | 1 | 151 | 2996 | 3147 | Aporrectodea tuberculata mitochondrion, complete genome | blastn | 3034 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea tuberculata | |
| 6988723 | 6988723 | PRJNA640143_S_NODE_7026_length_317_cov_4.075000_g6816_i0 | PRJNA640143 | 7026 | 317 | 4.075 | 12.91775 | Platynereis dumerilii | 6359 | Annelida | Annelida | 520 | 6.769999999999999e-143 | NTclustered | gi|6137767|ref|NC_000931.1| | 6359 | g6816 | i0 | 99.648 | 7.42902208201893 | 284 | 1 | 90 | 0 | 34 | 317 | 10827 | 11110 | Platynereis dumerilii mitochondrion, complete genome | blastn | 2355 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 10814135 | 10814135 | PRJNA640143_S_NODE_23469_length_182_cov_1.524138_g23259_i0 | PRJNA640143 | 23469 | 182 | 1.524138 | 2.77393116 | Aporrectodea caliginosa | 302032 | Annelida | Annelida | 265 | 1.83e-66 | NTclustered | gi|2848912492|gb|PQ572751.1| | 302032 | g23259 | i0 | 98.026 | 36.3736263736264 | 152 | 3 | 84 | 0 | 1 | 152 | 9502 | 9351 | Aporrectodea caliginosa isolate Apc6 mitochondrion, complete genome | blastn | 6620 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea caliginosa | |
| 10814339 | 10814339 | PRJNA640143_S_NODE_3689_length_420_cov_5.375979_g3490_i0 | PRJNA640143 | 3689 | 420 | 5.375979 | 22.5791118 | Aporrectodea tuberculata | 565146 | Annelida | Annelida | 771 | 0 | NTclustered | gi|238818303|gb|FJ967651.1| | 565146 | g3490 | i0 | 99.762 | 96.3571428571429 | 421 | 0 | 100 | 1 | 1 | 420 | 541 | 121 | Aporrectodea tuberculata isolate MPL68 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 40470 | 771 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea tuberculata | |
| 18461862 | 18461862 | PRJNA640143_S_NODE_16875_length_213_cov_1.329545_g16665_i0 | PRJNA640143 | 16875 | 213 | 1.329545 | 2.83193085 | Aporrectodea tuberculata | 565146 | Annelida | Annelida | 388 | 1.26e-103 | NTclustered | gi|2299197605|gb|OM687885.1| | 565146 | g16665 | i0 | 99.531 | 16.2018779342723 | 213 | 1 | 100 | 0 | 1 | 213 | 2679 | 2891 | Aporrectodea tuberculata mitochondrion, complete genome | blastn | 3451 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea tuberculata | |
| 19736459 | 19736459 | PRJNA640143_S_NODE_14956_length_225_cov_8.648936_g14746_i0 | PRJNA640143 | 14956 | 225 | 8.648936 | 19.460106 | Octodrilus complanatus | 1046380 | Annelida | Annelida | 351 | 1.76e-92 | NTclustered | gi|341833250|gb|HQ728941.1| | 1046380 | g14746 | i0 | 100 | 111.68 | 190 | 0 | 84 | 0 | 1 | 190 | 2351 | 2162 | Octodrilus complanatus 28S large subunit ribosomal RNA gene, partial sequence | blastn | 25128 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Octodrilus | Octodrilus complanatus | |
| 22832764 | 22832764 | PRJNA640143_S_NODE_12058_length_249_cov_19.202830_g11848_i0 | PRJNA640143 | 12058 | 249 | 19.20283 | 47.8150467 | Clitellata | 42113 | Annelida | Annelida | 399 | 6.989999999999999e-107 | NTclustered | gi|674655913|gb|KJ911938.1| | 27389 | g11848 | i0 | 100 | 86.7469879518072 | 216 | 0 | 87 | 0 | 1 | 216 | 281 | 66 | Aporrectodea rosea isolate MPL245 18S ribosomal RNA gene, partial sequence | blastn | 21600 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea rosea | |
| 23562582 | 23562582 | PRJNA640143_S_NODE_25979_length_173_cov_1.720588_g25769_i0 | PRJNA640143 | 25979 | 173 | 1.720588 | 2.97661724 | Aporrectodea tuberculata | 565146 | Annelida | Annelida | 315 | 1.68e-81 | NTclustered | gi|238818481|gb|FJ967778.1| | 565146 | g25769 | i0 | 99.425 | 97.1791907514451 | 174 | 0 | 100 | 1 | 1 | 173 | 586 | 413 | Aporrectodea tuberculata isolate MPL68 tRNA-Asn gene, partial sequence; and cytochrome oxidase subunit II gene, partial cds; mitochondrial | blastn | 16812 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea tuberculata | |
| 24107427 | 24107427 | PRJNA640143_S_NODE_6399_length_330_cov_3.290102_g6189_i0 | PRJNA640143 | 6399 | 330 | 3.290102 | 10.8573366 | Aporrectodea | 27388 | Annelida | Annelida | 604 | 1.8999999999999996e-168 | NTclustered | gi|2307919705|ref|NC_066400.1| | 302032 | g6189 | i0 | 99.697 | 98.6242424242424 | 330 | 1 | 100 | 0 | 1 | 330 | 12000 | 12329 | Aporrectodea caliginosa isolate 420Ra mitochondrion, complete genome | blastn | 32546 | 610 | 0.99016393442623 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Aporrectodea | Aporrectodea caliginosa | |
| 27270613 | 27270613 | PRJNA640143_S_NODE_15143_length_224_cov_2.711230_g14933_i0 | PRJNA640143 | 15143 | 224 | 2.71123 | 6.0731552 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 44.7 | 0.00591 | NR | KAK2148997.1 | 53620 | g14933 | i0 | 36.7 | 0.803571428571429 | 60 | 36 | 79 | 2 | 3 | 179 | 203 | 261 | KAK2148997.1 hypothetical protein LSH36_472g02056 [Paralvinella palmiformis] | diamond | 180 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29935663 | 29935663 | PRJNA640143_S_NODE_6191_length_334_cov_178.148148_g5981_i0 | PRJNA640143 | 6191 | 334 | 178.148148 | 595.01481432 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 2.06e-4 | NR | ELU08071.1 | 283909 | g5981 | i0 | 31.7 | 2.20059880239521 | 82 | 56 | 73.7 | 0 | 38 | 283 | 344 | 425 | ELU08071.1 hypothetical protein CAPTEDRAFT_227744 [Capitella teleta] | diamond | 735 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta |
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);;